Schema Info

Schema Name: sfdl_stage_manual.genesys_wrapup_codes

created: 2023-03-18 01:09:38
disabled: False
format: raw
id: 1791
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_manual",
    "table": "genesys_wrapup_codes"
}

type: manual

Schema Versions: 15

Version 906592

created: 2026-04-17 00:58:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-17/1776405483'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-17/1776405483
id: 906592
processed: 1

raw_data:

{
    "_origin": "2026-04-17T00:58:04Z|raw/wrapup_codes/2026-04-16/1776405484/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6415160
updated: 2026-04-17 00:58:29

Version 906378

created: 2026-04-16 00:57:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-16/1776319040'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-16/1776319040
id: 906378
processed: 1

raw_data:

{
    "_origin": "2026-04-16T00:57:21Z|raw/wrapup_codes/2026-04-15/1776319041/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6414617
updated: 2026-04-16 00:57:51

Version 906166

created: 2026-04-15 01:01:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-15/1776232819'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-15/1776232819
id: 906166
processed: 1

raw_data:

{
    "_origin": "2026-04-15T01:00:20Z|raw/wrapup_codes/2026-04-14/1776232820/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6414132
updated: 2026-04-15 01:01:11

Version 905951

created: 2026-04-14 01:01:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-14/1776146458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-14/1776146458
id: 905951
processed: 1

raw_data:

{
    "_origin": "2026-04-14T01:00:58Z|raw/wrapup_codes/2026-04-13/1776146458/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6413620
updated: 2026-04-14 01:01:32

Version 905734

created: 2026-04-13 01:05:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-13/1776060331'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-13/1776060331
id: 905734
processed: 1

raw_data:

{
    "_origin": "2026-04-13T01:05:32Z|raw/wrapup_codes/2026-04-12/1776060332/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6413079
updated: 2026-04-13 01:05:51

Version 905534

created: 2026-04-12 00:58:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-12/1775973487'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-12/1775973487
id: 905534
processed: 1

raw_data:

{
    "_origin": "2026-04-12T00:58:08Z|raw/wrapup_codes/2026-04-11/1775973488/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6412688
updated: 2026-04-12 00:58:50

Version 905331

created: 2026-04-11 00:56:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-11/1775886966'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-11/1775886966
id: 905331
processed: 1

raw_data:

{
    "_origin": "2026-04-11T00:56:07Z|raw/wrapup_codes/2026-04-10/1775886967/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6412304
updated: 2026-04-11 00:56:43

Version 905117

created: 2026-04-10 00:57:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-10/1775800641'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-10/1775800641
id: 905117
processed: 1

raw_data:

{
    "_origin": "2026-04-10T00:57:21Z|raw/wrapup_codes/2026-04-09/1775800641/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6411807
updated: 2026-04-10 00:57:58

Version 904902

created: 2026-04-09 00:59:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-09/1775714339'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-09/1775714339
id: 904902
processed: 1

raw_data:

{
    "_origin": "2026-04-09T00:58:59Z|raw/wrapup_codes/2026-04-08/1775714339/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6411289
updated: 2026-04-09 00:59:38

Version 904688

created: 2026-04-08 00:58:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-08/1775627900'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-08/1775627900
id: 904688
processed: 1

raw_data:

{
    "_origin": "2026-04-08T00:58:20Z|raw/wrapup_codes/2026-04-07/1775627900/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6410791
updated: 2026-04-08 00:58:43

Version 904475

created: 2026-04-07 00:57:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-07/1775541458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-07/1775541458
id: 904475
processed: 1

raw_data:

{
    "_origin": "2026-04-07T00:57:39Z|raw/wrapup_codes/2026-04-06/1775541459/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6410279
updated: 2026-04-07 00:58:10

Version 904262

created: 2026-04-06 00:58:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-06/1775455100'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-06/1775455100
id: 904262
processed: 1

raw_data:

{
    "_origin": "2026-04-06T00:58:21Z|raw/wrapup_codes/2026-04-05/1775455101/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6409747
updated: 2026-04-06 00:59:09

Version 904058

created: 2026-04-05 00:58:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-05/1775368677'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-05/1775368677
id: 904058
processed: 1

raw_data:

{
    "_origin": "2026-04-05T00:57:57Z|raw/wrapup_codes/2026-04-04/1775368677/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6409354
updated: 2026-04-05 00:58:32

Version 903858

created: 2026-04-04 00:57:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-04/1775282225'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-04/1775282225
id: 903858
processed: 1

raw_data:

{
    "_origin": "2026-04-04T00:57:05Z|raw/wrapup_codes/2026-04-03/1775282225/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6408975
updated: 2026-04-04 00:57:47

Version 903642

created: 2026-04-03 00:57:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-03/1775195865'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-03/1775195865
id: 903642
processed: 1

raw_data:

{
    "_origin": "2026-04-03T00:57:46Z|raw/wrapup_codes/2026-04-02/1775195866/data.json.gz|airflow_genesys_stage",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2025-11-25T18:13:09.575Z",
    "dateModified": "2025-12-03T18:38:09.348Z",
    "description": "",
    "division": {
        "id": "f59a31a3-3a6e-402f-8ef8-658486543e13",
        "name": "Sparefoot Marketplace Sales",
        "selfUri": "/api/v2/authorization/divisions/f59a31a3-3a6e-402f-8ef8-658486543e13"
    },
    "id": "5454c6ae-e4dd-4516-b4fd-cb8c0a25ad93",
    "modifiedBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "name": "Auction Inquiries",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 1791
schema_scan_id: 6408480
updated: 2026-04-03 00:58:08

Schema Scans: 15

Last at 2026-04-17 00:58:17

Scan 6415160
- duration: 0:00:11.939558
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415160
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-17/1776405483",
        "key": "raw/wrapup_codes/2026-04-17/1776405483/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-17 00:58:17
- success: True
- trace_id: 576529764941980686

Scan 6414617
- duration: 0:00:12.001064
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414617
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-16/1776319040",
        "key": "raw/wrapup_codes/2026-04-16/1776319040/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-16 00:57:39
- success: True
- trace_id: 10162939713113331049

Scan 6414132
- duration: 0:00:12.156908
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414132
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-15/1776232819",
        "key": "raw/wrapup_codes/2026-04-15/1776232819/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-15 01:00:59
- success: True
- trace_id: 14238713948164203311

Scan 6413620
- duration: 0:00:14.590408
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6413620
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-14/1776146458",
        "key": "raw/wrapup_codes/2026-04-14/1776146458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-14 01:01:17
- success: True
- trace_id: 6319773501589432213

Scan 6413079
- duration: 0:00:14.627843
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6413079
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-13/1776060331",
        "key": "raw/wrapup_codes/2026-04-13/1776060331/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-13 01:05:37
- success: True
- trace_id: 8394638055795800094

Scan 6412688
- duration: 0:00:14.563493
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6412688
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-12/1775973487",
        "key": "raw/wrapup_codes/2026-04-12/1775973487/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-12 00:58:35
- success: True
- trace_id: 3584055957414579661

Scan 6412304
- duration: 0:00:14.448871
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6412304
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-11/1775886966",
        "key": "raw/wrapup_codes/2026-04-11/1775886966/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-11 00:56:28
- success: True
- trace_id: 16233178322359474861

Scan 6411807
- duration: 0:00:14.616816
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6411807
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-10/1775800641",
        "key": "raw/wrapup_codes/2026-04-10/1775800641/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-10 00:57:43
- success: True
- trace_id: 4227650971509935175

Scan 6411289
- duration: 0:00:14.438311
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6411289
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-09/1775714339",
        "key": "raw/wrapup_codes/2026-04-09/1775714339/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-09 00:59:24
- success: True
- trace_id: 6165705318531554880

Scan 6410791
- duration: 0:00:14.526161
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6410791
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-08/1775627900",
        "key": "raw/wrapup_codes/2026-04-08/1775627900/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-08 00:58:29
- success: True
- trace_id: 10143427176263517278

Scan 6410279
- duration: 0:00:11.967027
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6410279
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-07/1775541458",
        "key": "raw/wrapup_codes/2026-04-07/1775541458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-07 00:57:58
- success: True
- trace_id: 9880575983443162134

Scan 6409747
- duration: 0:00:11.998830
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6409747
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-06/1775455100",
        "key": "raw/wrapup_codes/2026-04-06/1775455100/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-06 00:58:57
- success: True
- trace_id: 16983111799584525080

Scan 6409354
- duration: 0:00:14.512350
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6409354
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-05/1775368677",
        "key": "raw/wrapup_codes/2026-04-05/1775368677/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-05 00:58:18
- success: True
- trace_id: 4047310548610466508

Scan 6408975
- duration: 0:00:14.626665
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6408975
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-04/1775282225",
        "key": "raw/wrapup_codes/2026-04-04/1775282225/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-04 00:57:33
- success: True
- trace_id: 17933716904242803846

Scan 6408480
- duration: 0:00:12.227918
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6408480
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-03/1775195865",
        "key": "raw/wrapup_codes/2026-04-03/1775195865/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1791
- start_time: 2026-04-03 00:57:56
- success: True
- trace_id: 10240031627056510965

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

created: 2026-04-17 00:58:18

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-17/1776405483'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-03-18 01:09:38",
        "disabled": false,
        "format": "raw",
        "id": 1791,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_manual",
            "table": "genesys_wrapup_codes"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "createdBy": "string",
            "dateCreated": "string",
            "dateModified": "string",
            "description": "string",
            "division.id": "string",
            "division.name": "string",
            "division.selfUri": "string",
            "id": "string",
            "modifiedBy": "string",
            "name": "string",
            "selfUri": "string"
        },
        "created": "2026-04-17 00:58:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`description`STRING,`dateModified`STRING,`modifiedBy`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/wrapup_codes/2026-04-17/1776405483'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_wrapup_codes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_wrapup_codes"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}