Schema Info

Schema Name: sfdl_prod_manual.genesys_wrapup_codes

created: 2023-03-15 01:10:46
disabled: False
format: raw
id: 1522
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 1717498

created: 2026-04-17 00:55:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-17/1776405284'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-17/1776405284
id: 1717498
processed: 1

raw_data:

{
    "_origin": "2026-04-17T00:54:45Z|raw/wrapup_codes/2026-04-16/1776405285/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 162163967
updated: 2026-04-17 00:55:22

Version 1716258

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-16/1776319037'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-16/1776319037
id: 1716258
processed: 1

raw_data:

{
    "_origin": "2026-04-16T00:57:18Z|raw/wrapup_codes/2026-04-15/1776319038/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 162108363
updated: 2026-04-16 00:57:40

Version 1715064

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-15/1776232697'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-15/1776232697
id: 1715064
processed: 1

raw_data:

{
    "_origin": "2026-04-15T00:58:17Z|raw/wrapup_codes/2026-04-14/1776232697/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 162052816
updated: 2026-04-15 00:59:08

Version 1713869

created: 2026-04-14 01:01:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-14/1776146460'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-14/1776146460
id: 1713869
processed: 1

raw_data:

{
    "_origin": "2026-04-14T01:01:00Z|raw/wrapup_codes/2026-04-13/1776146460/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161997491
updated: 2026-04-14 01:01:27

Version 1712645

created: 2026-04-13 01:04:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-13/1776060222'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-13/1776060222
id: 1712645
processed: 1

raw_data:

{
    "_origin": "2026-04-13T01:03:42Z|raw/wrapup_codes/2026-04-12/1776060222/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161940038
updated: 2026-04-13 01:04:16

Version 1711432

created: 2026-04-12 00:54:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-12/1775973268'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-12/1775973268
id: 1711432
processed: 1

raw_data:

{
    "_origin": "2026-04-12T00:54:29Z|raw/wrapup_codes/2026-04-11/1775973269/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161889204
updated: 2026-04-12 00:54:52

Version 1710244

created: 2026-04-11 00:54:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-11/1775886847'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-11/1775886847
id: 1710244
processed: 1

raw_data:

{
    "_origin": "2026-04-11T00:54:08Z|raw/wrapup_codes/2026-04-10/1775886848/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161837447
updated: 2026-04-11 00:54:47

Version 1709090

created: 2026-04-10 00:58:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-10/1775800627'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-10/1775800627
id: 1709090
processed: 1

raw_data:

{
    "_origin": "2026-04-10T00:57:08Z|raw/wrapup_codes/2026-04-09/1775800628/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161782379
updated: 2026-04-10 00:58:26

Version 1707964

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-09/1775714272'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-09/1775714272
id: 1707964
processed: 1

raw_data:

{
    "_origin": "2026-04-09T00:57:53Z|raw/wrapup_codes/2026-04-08/1775714273/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161727454
updated: 2026-04-09 00:59:19

Version 1706736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-08/1775627824'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-08/1775627824
id: 1706736
processed: 1

raw_data:

{
    "_origin": "2026-04-08T00:57:05Z|raw/wrapup_codes/2026-04-07/1775627825/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161671803
updated: 2026-04-08 00:58:19

Version 1705552

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-07/1775541436'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-07/1775541436
id: 1705552
processed: 1

raw_data:

{
    "_origin": "2026-04-07T00:57:16Z|raw/wrapup_codes/2026-04-06/1775541436/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161615836
updated: 2026-04-07 00:57:46

Version 1704325

created: 2026-04-06 01:02:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-06/1775455199'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-06/1775455199
id: 1704325
processed: 1

raw_data:

{
    "_origin": "2026-04-06T00:59:59Z|raw/wrapup_codes/2026-04-05/1775455199/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161558682
updated: 2026-04-06 01:03:00

Version 1703156

created: 2026-04-05 00:57:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-05/1775368625'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-05/1775368625
id: 1703156
processed: 1

raw_data:

{
    "_origin": "2026-04-05T00:57:06Z|raw/wrapup_codes/2026-04-04/1775368626/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161511652
updated: 2026-04-05 00:57:57

Version 1701979

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-04/1775282237'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-04/1775282237
id: 1701979
processed: 1

raw_data:

{
    "_origin": "2026-04-04T00:57:17Z|raw/wrapup_codes/2026-04-03/1775282237/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161456515
updated: 2026-04-04 00:58:28

Version 1700751

created: 2026-04-03 00:59:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-03/1775195841'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-03/1775195841
id: 1700751
processed: 1

raw_data:

{
    "_origin": "2026-04-03T00:57:21Z|raw/wrapup_codes/2026-04-02/1775195841/data.json.gz|airflow_genesys_prod",
    "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: 1522
schema_scan_id: 161397919
updated: 2026-04-03 00:59:20

Schema Scans: 15

Last at 2026-04-17 00:55:10

Scan 162163967
- duration: 0:00:11.886012
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162163967
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-17/1776405284",
        "key": "raw/wrapup_codes/2026-04-17/1776405284/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-17 00:55:10
- success: True
- trace_id: 6745673631291544261

Scan 162108363
- duration: 0:00:14.480525
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162108363
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-16/1776319037",
        "key": "raw/wrapup_codes/2026-04-16/1776319037/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-16 00:57:25
- success: True
- trace_id: 3406721985162965052

Scan 162052816
- duration: 0:00:11.923414
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162052816
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-15/1776232697",
        "key": "raw/wrapup_codes/2026-04-15/1776232697/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-15 00:58:56
- success: True
- trace_id: 6398040620159671915

Scan 161997491
- duration: 0:00:14.425283
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161997491
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-14/1776146460",
        "key": "raw/wrapup_codes/2026-04-14/1776146460/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-14 01:01:13
- success: True
- trace_id: 12114679472241274464

Scan 161940038
- duration: 0:00:11.897738
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161940038
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-13/1776060222",
        "key": "raw/wrapup_codes/2026-04-13/1776060222/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-13 01:04:04
- success: True
- trace_id: 10596914993130411376

Scan 161889204
- duration: 0:00:11.844551
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161889204
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-12/1775973268",
        "key": "raw/wrapup_codes/2026-04-12/1775973268/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-12 00:54:40
- success: True
- trace_id: 9195617609533648100

Scan 161837447
- duration: 0:00:11.881580
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161837447
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-11/1775886847",
        "key": "raw/wrapup_codes/2026-04-11/1775886847/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-11 00:54:35
- success: True
- trace_id: 6929077381628434607

Scan 161782379
- duration: 0:00:11.939496
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161782379
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-10/1775800627",
        "key": "raw/wrapup_codes/2026-04-10/1775800627/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-10 00:58:14
- success: True
- trace_id: 11991555983827130777

Scan 161727454
- duration: 0:00:14.429577
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161727454
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-09/1775714272",
        "key": "raw/wrapup_codes/2026-04-09/1775714272/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-09 00:59:04
- success: True
- trace_id: 2137244796958478498

Scan 161671803
- duration: 0:00:14.559796
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161671803
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-08/1775627824",
        "key": "raw/wrapup_codes/2026-04-08/1775627824/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-08 00:58:04
- success: True
- trace_id: 13912509240297874607

Scan 161615836
- duration: 0:00:14.405091
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161615836
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-07/1775541436",
        "key": "raw/wrapup_codes/2026-04-07/1775541436/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-07 00:57:32
- success: True
- trace_id: 1795862118943676743

Scan 161558682
- duration: 0:00:14.578243
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161558682
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-06/1775455199",
        "key": "raw/wrapup_codes/2026-04-06/1775455199/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-06 01:02:45
- success: True
- trace_id: 4952055862300909785

Scan 161511652
- duration: 0:00:14.384412
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161511652
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-05/1775368625",
        "key": "raw/wrapup_codes/2026-04-05/1775368625/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-05 00:57:42
- success: True
- trace_id: 2417879652856603771

Scan 161456515
- duration: 0:00:11.883272
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161456515
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-04/1775282237",
        "key": "raw/wrapup_codes/2026-04-04/1775282237/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-04 00:58:16
- success: True
- trace_id: 7058487716837355318

Scan 161397919
- duration: 0:00:14.503352
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161397919
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/wrapup_codes/2026-04-03/1775195841",
        "key": "raw/wrapup_codes/2026-04-03/1775195841/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1522
- start_time: 2026-04-03 00:59:06
- success: True
- trace_id: 9752351560497222236

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:55:11

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-17/1776405284'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-03-15 01:10:46",
        "disabled": false,
        "format": "raw",
        "id": 1522,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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:55:11",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/wrapup_codes/2026-04-17/1776405284'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_wrapup_codes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_wrapup_codes"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}