Schema Info

Schema Name: sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap

created: 2025-07-11 02:16:11
disabled: False
format: raw
id: 4253
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "molo_molopurchaseorderworkjobmap"
}

type: drivethrucsv

Schema Versions: 15

Version 1717683

created: 2026-04-17 03:06:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812
id: 1717683
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 162167665
updated: 2026-04-17 03:06:56

Version 1716380

created: 2026-04-16 03:06:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-16/1776326568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-16/1776326568
id: 1716380
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 162111785
updated: 2026-04-16 03:07:02

Version 1715207

created: 2026-04-15 03:05:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-15/1776240037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-15/1776240037
id: 1715207
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 162055920
updated: 2026-04-15 03:05:12

Version 1714036

created: 2026-04-14 03:06:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-14/1776153767'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-14/1776153767
id: 1714036
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 162000520
updated: 2026-04-14 03:07:02

Version 1712787

created: 2026-04-13 02:58:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-13/1776066960'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-13/1776066960
id: 1712787
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161941721
updated: 2026-04-13 02:59:10

Version 1711636

created: 2026-04-12 03:02:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-12/1775980674'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-12/1775980674
id: 1711636
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161892818
updated: 2026-04-12 03:02:16

Version 1710505

created: 2026-04-11 03:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-11/1775894434'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-11/1775894434
id: 1710505
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161841294
updated: 2026-04-11 03:08:43

Version 1709196

created: 2026-04-10 03:04:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-10/1775808192'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-10/1775808192
id: 1709196
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161785877
updated: 2026-04-10 03:04:27

Version 1708107

created: 2026-04-09 03:02:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-09/1775721531'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-09/1775721531
id: 1708107
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161730203
updated: 2026-04-09 03:02:52

Version 1706994

created: 2026-04-08 03:09:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-08/1775635358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-08/1775635358
id: 1706994
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161675651
updated: 2026-04-08 03:09:27

Version 1705732

created: 2026-04-07 02:58:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-07/1775548508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-07/1775548508
id: 1705732
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161618456
updated: 2026-04-07 02:58:25

Version 1704465

created: 2026-04-06 03:04:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-06/1775462475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-06/1775462475
id: 1704465
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161561538
updated: 2026-04-06 03:04:47

Version 1703389

created: 2026-04-05 03:08:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-05/1775376101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-05/1775376101
id: 1703389
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161514973
updated: 2026-04-05 03:08:55

Version 1702099

created: 2026-04-04 03:02:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-04/1775289584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-04/1775289584
id: 1702099
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161460172
updated: 2026-04-04 03:03:08

Version 1701066

created: 2026-04-03 03:15:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-03/1775203357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-03/1775203357
id: 1701066
processed: 1

raw_data:

{
    "CreatedAt": 5,
    "CreatedBy": 7,
    "Id": 0,
    "JobId": 4,
    "PurchaseOrderId": 1,
    "PurchaseOrderItemId": 2,
    "UpdatedAt": 6,
    "UpdatedBy": 8,
    "WorkOrderId": 3
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

schema_name_id: 4253
schema_scan_id: 161402059
updated: 2026-04-03 03:16:12

Schema Scans: 15

Last at 2026-04-17 03:06:45

Scan 162167665

duration: 0:00:11.679660

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162167665

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5261718602916381129,
        "service_name": "drive-thru",
        "span_id": 9044025401017856445,
        "trace_id": 9452079331658452439
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-17 03:06:45
success: True
trace_id: 9452079331658452439

Scan 162111785

duration: 0:00:11.741367

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162111785

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-16/1776326568",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-16/1776326568/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 298760822390937097,
        "service_name": "drive-thru",
        "span_id": 16975994104466998310,
        "trace_id": 5292872458063565954
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-16 03:06:50
success: True
trace_id: 5292872458063565954

Scan 162055920

duration: 0:00:11.815468

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162055920

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-15/1776240037",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-15/1776240037/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16148189798923797282,
        "service_name": "drive-thru",
        "span_id": 1026645744223591930,
        "trace_id": 4994525662444456151
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-15 03:05:01
success: True
trace_id: 4994525662444456151

Scan 162000520

duration: 0:00:11.634046

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162000520

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-14/1776153767",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-14/1776153767/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8947514615946987469,
        "service_name": "drive-thru",
        "span_id": 13356928801705156913,
        "trace_id": 3087344148764278828
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-14 03:06:51
success: True
trace_id: 3087344148764278828

Scan 161941721

duration: 0:00:14.356456

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161941721

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-13/1776066960",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-13/1776066960/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12808235097781150588,
        "service_name": "drive-thru",
        "span_id": 4194217714144165109,
        "trace_id": 5107087241892613753
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-13 02:58:55
success: True
trace_id: 5107087241892613753

Scan 161892818

duration: 0:00:14.580157

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161892818

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-12/1775980674",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-12/1775980674/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17924380183463962352,
        "service_name": "drive-thru",
        "span_id": 10699246790916833352,
        "trace_id": 18271987721058757180
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-12 03:02:02
success: True
trace_id: 18271987721058757180

Scan 161841294

duration: 0:00:11.852802

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161841294

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-11/1775894434",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-11/1775894434/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18254337786657772943,
        "service_name": "drive-thru",
        "span_id": 4407265685839799540,
        "trace_id": 16377758186097006863
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-11 03:08:31
success: True
trace_id: 16377758186097006863

Scan 161785877

duration: 0:00:11.678010

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161785877

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-10/1775808192",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-10/1775808192/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3990699254356335294,
        "service_name": "drive-thru",
        "span_id": 6185298644613145894,
        "trace_id": 18343395566568225939
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-10 03:04:15
success: True
trace_id: 18343395566568225939

Scan 161730203

duration: 0:00:11.790582

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161730203

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-09/1775721531",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-09/1775721531/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 524161585276029106,
        "service_name": "drive-thru",
        "span_id": 4545373632334557247,
        "trace_id": 8954406213593393658
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-09 03:02:41
success: True
trace_id: 8954406213593393658

Scan 161675651

duration: 0:00:11.719957

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161675651

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-08/1775635358",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-08/1775635358/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8264666867426199410,
        "service_name": "drive-thru",
        "span_id": 765102336635643363,
        "trace_id": 14295871572496055968
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-08 03:09:16
success: True
trace_id: 14295871572496055968

Scan 161618456

duration: 0:00:14.455470

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161618456

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-07/1775548508",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-07/1775548508/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1244127123557310991,
        "service_name": "drive-thru",
        "span_id": 6017917919302061283,
        "trace_id": 16568545161576391669
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-07 02:58:11
success: True
trace_id: 16568545161576391669

Scan 161561538

duration: 0:00:11.724775

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161561538

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-06/1775462475",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-06/1775462475/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1576160098146976885,
        "service_name": "drive-thru",
        "span_id": 14963936613647925205,
        "trace_id": 14384229804414797712
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-06 03:04:35
success: True
trace_id: 14384229804414797712

Scan 161514973

duration: 0:00:14.214199

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161514973

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-05/1775376101",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-05/1775376101/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13239733183705494335,
        "service_name": "drive-thru",
        "span_id": 11205658897505692137,
        "trace_id": 11770297922681238353
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-05 03:08:41
success: True
trace_id: 11770297922681238353

Scan 161460172

duration: 0:00:14.288849

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161460172

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-04/1775289584",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-04/1775289584/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12295437892010827773,
        "service_name": "drive-thru",
        "span_id": 9407048088827930890,
        "trace_id": 4977079656651045383
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-04 03:02:54
success: True
trace_id: 4977079656651045383

Scan 161402059

duration: 0:00:14.348689

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161402059

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-03/1775203357",
        "key": "raw/molo_moloPurchaseOrderWorkJobMap/2026-04-03/1775203357/PurchaseOrderWorkJobMap.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrderWorkJobMap",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13876786718543959831,
        "service_name": "drive-thru",
        "span_id": 2308714648443717458,
        "trace_id": 12421617936000682847
    }
}

running: False
schema_name_id: 4253
start_time: 2026-04-03 03:15:58
success: True
trace_id: 12421617936000682847

Partitions:

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

Schema:

attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Id": "string",
    "JobId": "string",
    "PurchaseOrderId": "string",
    "PurchaseOrderItemId": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "WorkOrderId": "string"
}

created: 2026-04-17 03:06:45

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-07-11 02:16:11",
        "disabled": false,
        "format": "raw",
        "id": 4253,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molopurchaseorderworkjobmap"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreatedAt": "string",
            "CreatedBy": "string",
            "Id": "string",
            "JobId": "string",
            "PurchaseOrderId": "string",
            "PurchaseOrderItemId": "string",
            "UpdatedAt": "string",
            "UpdatedBy": "string",
            "WorkOrderId": "string"
        },
        "created": "2026-04-17 03:06:45",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`\n(\n `Id`  string , `PurchaseOrderId`  string , `PurchaseOrderItemId`  string , `WorkOrderId`  string , `JobId`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrderWorkJobMap/2026-04-17/1776412812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorderworkjobmap"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}