Schema Info

Schema Name: sfdl_prod_drivethru.molo_molopurchaseorder

created: 2025-07-11 02:18:07
disabled: False
format: raw
id: 4259
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717686

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-17/1776412811
id: 1717686
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 162167670
updated: 2026-04-17 03:07:07

Version 1716378

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-16/1776326568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 162111782
updated: 2026-04-16 03:07:00

Version 1715259

created: 2026-04-15 03:07:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-15/1776240037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 162056004
updated: 2026-04-15 03:07:22

Version 1714040

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-14/1776153766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-14/1776153766
id: 1714040
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 162000524
updated: 2026-04-14 03:07:10

Version 1712832

created: 2026-04-13 03:00:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-13/1776066960'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161941849
updated: 2026-04-13 03:00:22

Version 1711597

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-12/1775980673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-12/1775980673
id: 1711597
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161892690
updated: 2026-04-12 03:01:12

Version 1710345

created: 2026-04-11 03:02:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-11/1775894433'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-11/1775894433
id: 1710345
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161841035
updated: 2026-04-11 03:02:15

Version 1709230

created: 2026-04-10 03:05:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-10/1775808191'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-10/1775808191
id: 1709230
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161785914
updated: 2026-04-10 03:05:44

Version 1708169

created: 2026-04-09 03:05:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-09/1775721529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-09/1775721529
id: 1708169
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161730385
updated: 2026-04-09 03:05:47

Version 1706865

created: 2026-04-08 03:03:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-08/1775635358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161675449
updated: 2026-04-08 03:04:05

Version 1705743

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-07/1775548508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161618494
updated: 2026-04-07 02:58:50

Version 1704501

created: 2026-04-06 03:06:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-06/1775462474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-06/1775462474
id: 1704501
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161561591
updated: 2026-04-06 03:06:26

Version 1703367

created: 2026-04-05 03:07:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-05/1775376101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161514950
updated: 2026-04-05 03:08:02

Version 1702144

created: 2026-04-04 03:04:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-04/1775289585'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPurchaseOrder/2026-04-04/1775289585
id: 1702144
processed: 1

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161460328
updated: 2026-04-04 03:04:52

Version 1700917

created: 2026-04-03 03:08:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-03/1775203357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
]

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

raw_data:

{
    "ContactId": 2,
    "CreatedAt": 14,
    "CreatedBy": 16,
    "DeliveryAddressCity": 7,
    "DeliveryAddressCountry": 10,
    "DeliveryAddressState": 8,
    "DeliveryAddressStreet": 6,
    "DeliveryAddressZipCode": 9,
    "ExpectedDeliveryDate": 11,
    "Id": 0,
    "MarinaLocationId": 1,
    "Notes": 12,
    "NotesToVendor": 13,
    "ReferenceNumber": 5,
    "ScheduledDate": 18,
    "Status": 4,
    "TotalAmount": 19,
    "UpdatedAt": 15,
    "UpdatedBy": 17,
    "VendorBillId": 3
}

schema_attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4259
schema_scan_id: 161401870
updated: 2026-04-03 03:09:09

Schema Scans: 15

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

Scan 162167670

duration: 0:00:12.103784

exit_message:

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

id: 162167670

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_moloPurchaseOrder/2026-04-17/1776412811",
        "key": "raw/molo_moloPurchaseOrder/2026-04-17/1776412811/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4413328252478806112,
        "service_name": "drive-thru",
        "span_id": 10931460393761999800,
        "trace_id": 7405981018862764655
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-17 03:06:55
success: True
trace_id: 7405981018862764655

Scan 162111782

duration: 0:00:14.791866

exit_message:

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

id: 162111782

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_moloPurchaseOrder/2026-04-16/1776326568",
        "key": "raw/molo_moloPurchaseOrder/2026-04-16/1776326568/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8646914199604503532,
        "service_name": "drive-thru",
        "span_id": 2091099590727156962,
        "trace_id": 4442949424105413702
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-16 03:06:45
success: True
trace_id: 4442949424105413702

Scan 162056004

duration: 0:00:12.146811

exit_message:

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

id: 162056004

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_moloPurchaseOrder/2026-04-15/1776240037",
        "key": "raw/molo_moloPurchaseOrder/2026-04-15/1776240037/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4015770658342566490,
        "service_name": "drive-thru",
        "span_id": 12059594758609767609,
        "trace_id": 15503591265440224607
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-15 03:07:10
success: True
trace_id: 15503591265440224607

Scan 162000524

duration: 0:00:12.167359

exit_message:

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

id: 162000524

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_moloPurchaseOrder/2026-04-14/1776153766",
        "key": "raw/molo_moloPurchaseOrder/2026-04-14/1776153766/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9851908245645989744,
        "service_name": "drive-thru",
        "span_id": 10368508775206690033,
        "trace_id": 2085784450625212410
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-14 03:06:58
success: True
trace_id: 2085784450625212410

Scan 161941849

duration: 0:00:14.567068

exit_message:

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

id: 161941849

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_moloPurchaseOrder/2026-04-13/1776066960",
        "key": "raw/molo_moloPurchaseOrder/2026-04-13/1776066960/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17020245568470274983,
        "service_name": "drive-thru",
        "span_id": 10285437702813994931,
        "trace_id": 2663071779636604638
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-13 03:00:08
success: True
trace_id: 2663071779636604638

Scan 161892690

duration: 0:00:14.626260

exit_message:

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

id: 161892690

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_moloPurchaseOrder/2026-04-12/1775980673",
        "key": "raw/molo_moloPurchaseOrder/2026-04-12/1775980673/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12296654220575581436,
        "service_name": "drive-thru",
        "span_id": 10052201263460623815,
        "trace_id": 4954618228615562692
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-12 03:00:58
success: True
trace_id: 4954618228615562692

Scan 161841035

duration: 0:00:12.297907

exit_message:

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

id: 161841035

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_moloPurchaseOrder/2026-04-11/1775894433",
        "key": "raw/molo_moloPurchaseOrder/2026-04-11/1775894433/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5983500867528254105,
        "service_name": "drive-thru",
        "span_id": 14753721462689051877,
        "trace_id": 14192390764491358266
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-11 03:02:03
success: True
trace_id: 14192390764491358266

Scan 161785914

duration: 0:00:12.169420

exit_message:

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

id: 161785914

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_moloPurchaseOrder/2026-04-10/1775808191",
        "key": "raw/molo_moloPurchaseOrder/2026-04-10/1775808191/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4222408909264537941,
        "service_name": "drive-thru",
        "span_id": 9717488665942046655,
        "trace_id": 7799448922162602442
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-10 03:05:32
success: True
trace_id: 7799448922162602442

Scan 161730385

duration: 0:00:14.701576

exit_message:

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

id: 161730385

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_moloPurchaseOrder/2026-04-09/1775721529",
        "key": "raw/molo_moloPurchaseOrder/2026-04-09/1775721529/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7826553742285549082,
        "service_name": "drive-thru",
        "span_id": 2747172727465247169,
        "trace_id": 9423432497911244547
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-09 03:05:32
success: True
trace_id: 9423432497911244547

Scan 161675449

duration: 0:00:14.655384

exit_message:

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

id: 161675449

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_moloPurchaseOrder/2026-04-08/1775635358",
        "key": "raw/molo_moloPurchaseOrder/2026-04-08/1775635358/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6360930605593981559,
        "service_name": "drive-thru",
        "span_id": 17830067839961142401,
        "trace_id": 3099002249768207039
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-08 03:03:50
success: True
trace_id: 3099002249768207039

Scan 161618494

duration: 0:00:14.734482

exit_message:

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

id: 161618494

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_moloPurchaseOrder/2026-04-07/1775548508",
        "key": "raw/molo_moloPurchaseOrder/2026-04-07/1775548508/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13700611350725593793,
        "service_name": "drive-thru",
        "span_id": 418944867759283813,
        "trace_id": 6919836778595978992
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-07 02:58:36
success: True
trace_id: 6919836778595978992

Scan 161561591

duration: 0:00:14.705001

exit_message:

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

id: 161561591

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_moloPurchaseOrder/2026-04-06/1775462474",
        "key": "raw/molo_moloPurchaseOrder/2026-04-06/1775462474/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2297088182750917493,
        "service_name": "drive-thru",
        "span_id": 13806962414060706924,
        "trace_id": 8426989162962879037
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-06 03:06:12
success: True
trace_id: 8426989162962879037

Scan 161514950

duration: 0:00:12.209736

exit_message:

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

id: 161514950

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_moloPurchaseOrder/2026-04-05/1775376101",
        "key": "raw/molo_moloPurchaseOrder/2026-04-05/1775376101/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16807762011264653206,
        "service_name": "drive-thru",
        "span_id": 2810292086807442529,
        "trace_id": 6590059632141570696
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-05 03:07:49
success: True
trace_id: 6590059632141570696

Scan 161460328

duration: 0:00:14.720803

exit_message:

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

id: 161460328

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_moloPurchaseOrder/2026-04-04/1775289585",
        "key": "raw/molo_moloPurchaseOrder/2026-04-04/1775289585/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17365178011137948617,
        "service_name": "drive-thru",
        "span_id": 7570526569409913587,
        "trace_id": 1104183853985134829
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-04 03:04:37
success: True
trace_id: 1104183853985134829

Scan 161401870

duration: 0:00:14.618518

exit_message:

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

id: 161401870

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_moloPurchaseOrder/2026-04-03/1775203357",
        "key": "raw/molo_moloPurchaseOrder/2026-04-03/1775203357/PurchaseOrder.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloPurchaseOrder",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15150173190495798992,
        "service_name": "drive-thru",
        "span_id": 11701486814765344065,
        "trace_id": 7268558543880984590
    }
}

running: False
schema_name_id: 4259
start_time: 2026-04-03 03:08:54
success: True
trace_id: 7268558543880984590

Partitions:

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

Schema:

attributes:

{
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "ReferenceNumber": "string",
    "ScheduledDate": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
}

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:18:07",
        "disabled": false,
        "format": "raw",
        "id": 4259,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molopurchaseorder"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ContactId": "string",
            "CreatedAt": "string",
            "CreatedBy": "string",
            "DeliveryAddressCity": "string",
            "DeliveryAddressCountry": "string",
            "DeliveryAddressState": "string",
            "DeliveryAddressStreet": "string",
            "DeliveryAddressZipCode": "string",
            "ExpectedDeliveryDate": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "Notes": "string",
            "NotesToVendor": "string",
            "ReferenceNumber": "string",
            "ScheduledDate": "string",
            "Status": "string",
            "TotalAmount": "string",
            "UpdatedAt": "string",
            "UpdatedBy": "string",
            "VendorBillId": "string"
        },
        "created": "2026-04-17 03:06:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopurchaseorder`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `VendorBillId`  string , `Status`  string , `ReferenceNumber`  string , `DeliveryAddressStreet`  string , `DeliveryAddressCity`  string , `DeliveryAddressState`  string , `DeliveryAddressZipCode`  string , `DeliveryAddressCountry`  string , `ExpectedDeliveryDate`  string , `Notes`  string , `NotesToVendor`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ScheduledDate`  string , `TotalAmount`  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_moloPurchaseOrder/2026-04-17/1776412811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopurchaseorder`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopurchaseorder"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}