Schema Info

Schema Name: sfdl_prod_drivethru.molo_molovendorbill

created: 2025-07-16 02:23:33
disabled: False
format: raw
id: 4267
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717745

created: 2026-04-17 03:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-17/1776413271
id: 1717745
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 162167753
updated: 2026-04-17 03:09:28

Version 1716514

created: 2026-04-16 03:12:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-16/1776326748'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-16/1776326748
id: 1716514
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 162111961
updated: 2026-04-16 03:12:25

Version 1715388

created: 2026-04-15 03:13:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-15/1776240209'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-15/1776240209
id: 1715388
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 162056196
updated: 2026-04-15 03:13:36

Version 1714197

created: 2026-04-14 03:13:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-14/1776154173'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-14/1776154173
id: 1714197
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 162000721
updated: 2026-04-14 03:13:15

Version 1712973

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-13/1776067167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-13/1776067167
id: 1712973
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161942835
updated: 2026-04-13 03:07:26

Version 1711736

created: 2026-04-12 03:07:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-12/1775980868'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-12/1775980868
id: 1711736
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161893426
updated: 2026-04-12 03:07:33

Version 1710480

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-11/1775894645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-11/1775894645
id: 1710480
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161841269
updated: 2026-04-11 03:07:53

Version 1709371

created: 2026-04-10 03:10:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-10/1775808401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-10/1775808401
id: 1709371
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161786071
updated: 2026-04-10 03:11:10

Version 1708264

created: 2026-04-09 03:09:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-09/1775721730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-09/1775721730
id: 1708264
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161730547
updated: 2026-04-09 03:09:55

Version 1706953

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-08/1775635559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-08/1775635559
id: 1706953
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161675599
updated: 2026-04-08 03:07:53

Version 1705884

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-07/1775548719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-07/1775548719
id: 1705884
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161619487
updated: 2026-04-07 03:05:36

Version 1704511

created: 2026-04-06 03:06:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-06/1775462672'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-06/1775462672
id: 1704511
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161561602
updated: 2026-04-06 03:06:45

Version 1703397

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-05/1775376300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-05/1775376300
id: 1703397
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161514982
updated: 2026-04-05 03:09:09

Version 1702257

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-04/1775289786'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-04/1775289786
id: 1702257
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161460557
updated: 2026-04-04 03:10:14

Version 1700947

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-03/1775203550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBill/2026-04-03/1775203550
id: 1700947
processed: 1

raw_data:

{
    "BillDate": 19,
    "ContactId": 2,
    "CreatedAt": 15,
    "CreatedBy": 17,
    "DeliveryAddressCity": 8,
    "DeliveryAddressCountry": 11,
    "DeliveryAddressState": 9,
    "DeliveryAddressStreet": 7,
    "DeliveryAddressZipCode": 10,
    "DueDate": 20,
    "ExpectedDeliveryDate": 12,
    "Id": 0,
    "IsCredit": 5,
    "MarinaLocationId": 1,
    "Notes": 13,
    "NotesToVendor": 14,
    "PurchaseOrderId": 4,
    "QuickbooksBillId": 21,
    "ReferenceNumber": 6,
    "Status": 3,
    "TotalAmount": 22,
    "UpdatedAt": 16,
    "UpdatedBy": 18,
    "XeroInvoiceId": 23
}

schema_attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

schema_name_id: 4267
schema_scan_id: 161401905
updated: 2026-04-03 03:10:18

Schema Scans: 15

Last at 2026-04-17 03:09:13

Scan 162167753

duration: 0:00:14.727141

exit_message:

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

id: 162167753

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_moloVendorBill/2026-04-17/1776413271",
        "key": "raw/molo_moloVendorBill/2026-04-17/1776413271/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2900582251500955870,
        "service_name": "drive-thru",
        "span_id": 17637730737285859378,
        "trace_id": 2808609873020964429
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-17 03:09:13
success: True
trace_id: 2808609873020964429

Scan 162111961

duration: 0:00:14.956146

exit_message:

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

id: 162111961

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_moloVendorBill/2026-04-16/1776326748",
        "key": "raw/molo_moloVendorBill/2026-04-16/1776326748/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11879166931417616444,
        "service_name": "drive-thru",
        "span_id": 5286127873456385555,
        "trace_id": 16583731392441432315
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-16 03:12:10
success: True
trace_id: 16583731392441432315

Scan 162056196

duration: 0:00:12.309831

exit_message:

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

id: 162056196

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_moloVendorBill/2026-04-15/1776240209",
        "key": "raw/molo_moloVendorBill/2026-04-15/1776240209/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12978336613812907804,
        "service_name": "drive-thru",
        "span_id": 3280482728020693320,
        "trace_id": 11395789688740014351
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-15 03:13:24
success: True
trace_id: 11395789688740014351

Scan 162000721

duration: 0:00:14.911415

exit_message:

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

id: 162000721

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_moloVendorBill/2026-04-14/1776154173",
        "key": "raw/molo_moloVendorBill/2026-04-14/1776154173/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5752064962919662793,
        "service_name": "drive-thru",
        "span_id": 16806890697735316060,
        "trace_id": 8453256815047253163
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-14 03:13:00
success: True
trace_id: 8453256815047253163

Scan 161942835

duration: 0:00:12.359484

exit_message:

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

id: 161942835

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_moloVendorBill/2026-04-13/1776067167",
        "key": "raw/molo_moloVendorBill/2026-04-13/1776067167/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10581811232912359155,
        "service_name": "drive-thru",
        "span_id": 13201486187429044135,
        "trace_id": 844959780269782776
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-13 03:07:14
success: True
trace_id: 844959780269782776

Scan 161893426

duration: 0:00:14.806779

exit_message:

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

id: 161893426

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_moloVendorBill/2026-04-12/1775980868",
        "key": "raw/molo_moloVendorBill/2026-04-12/1775980868/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16027422944606278693,
        "service_name": "drive-thru",
        "span_id": 3626260912566849145,
        "trace_id": 822140798587918869
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-12 03:07:18
success: True
trace_id: 822140798587918869

Scan 161841269

duration: 0:00:14.706177

exit_message:

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

id: 161841269

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_moloVendorBill/2026-04-11/1775894645",
        "key": "raw/molo_moloVendorBill/2026-04-11/1775894645/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 380653492630381267,
        "service_name": "drive-thru",
        "span_id": 516163631461911267,
        "trace_id": 4250802268910903208
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-11 03:07:39
success: True
trace_id: 4250802268910903208

Scan 161786071

duration: 0:00:14.801887

exit_message:

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

id: 161786071

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_moloVendorBill/2026-04-10/1775808401",
        "key": "raw/molo_moloVendorBill/2026-04-10/1775808401/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11463281204890951741,
        "service_name": "drive-thru",
        "span_id": 9715981994516659049,
        "trace_id": 8007098498319273594
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-10 03:10:55
success: True
trace_id: 8007098498319273594

Scan 161730547

duration: 0:00:12.252216

exit_message:

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

id: 161730547

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_moloVendorBill/2026-04-09/1775721730",
        "key": "raw/molo_moloVendorBill/2026-04-09/1775721730/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14160584670089395551,
        "service_name": "drive-thru",
        "span_id": 15840416891889166731,
        "trace_id": 9633389737223305125
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-09 03:09:42
success: True
trace_id: 9633389737223305125

Scan 161675599

duration: 0:00:12.149540

exit_message:

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

id: 161675599

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_moloVendorBill/2026-04-08/1775635559",
        "key": "raw/molo_moloVendorBill/2026-04-08/1775635559/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2673911350930472482,
        "service_name": "drive-thru",
        "span_id": 11393711876051096745,
        "trace_id": 12570959081128848060
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-08 03:07:41
success: True
trace_id: 12570959081128848060

Scan 161619487

duration: 0:00:14.748100

exit_message:

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

id: 161619487

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_moloVendorBill/2026-04-07/1775548719",
        "key": "raw/molo_moloVendorBill/2026-04-07/1775548719/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16997439840213608988,
        "service_name": "drive-thru",
        "span_id": 11395104941103785636,
        "trace_id": 11466693829567686942
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-07 03:05:21
success: True
trace_id: 11466693829567686942

Scan 161561602

duration: 0:00:12.327133

exit_message:

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

id: 161561602

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_moloVendorBill/2026-04-06/1775462672",
        "key": "raw/molo_moloVendorBill/2026-04-06/1775462672/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6948925224980183171,
        "service_name": "drive-thru",
        "span_id": 11444596331580389282,
        "trace_id": 7647823103452263131
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-06 03:06:33
success: True
trace_id: 7647823103452263131

Scan 161514982

duration: 0:00:12.166113

exit_message:

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

id: 161514982

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_moloVendorBill/2026-04-05/1775376300",
        "key": "raw/molo_moloVendorBill/2026-04-05/1775376300/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9852722713608366129,
        "service_name": "drive-thru",
        "span_id": 16760973048959731113,
        "trace_id": 4824547539724290356
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-05 03:08:57
success: True
trace_id: 4824547539724290356

Scan 161460557

duration: 0:00:12.208978

exit_message:

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

id: 161460557

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_moloVendorBill/2026-04-04/1775289786",
        "key": "raw/molo_moloVendorBill/2026-04-04/1775289786/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7276311735578198067,
        "service_name": "drive-thru",
        "span_id": 3781109122178555200,
        "trace_id": 5924059962709784492
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-04 03:10:02
success: True
trace_id: 5924059962709784492

Scan 161401905

duration: 0:00:14.813973

exit_message:

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

id: 161401905

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_moloVendorBill/2026-04-03/1775203550",
        "key": "raw/molo_moloVendorBill/2026-04-03/1775203550/VendorBill.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBill",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4915496969231519599,
        "service_name": "drive-thru",
        "span_id": 1365280545041191931,
        "trace_id": 16535402026203570547
    }
}

running: False
schema_name_id: 4267
start_time: 2026-04-03 03:10:03
success: True
trace_id: 16535402026203570547

Partitions:

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

Schema:

attributes:

{
    "BillDate": "string",
    "ContactId": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "DeliveryAddressCity": "string",
    "DeliveryAddressCountry": "string",
    "DeliveryAddressState": "string",
    "DeliveryAddressStreet": "string",
    "DeliveryAddressZipCode": "string",
    "DueDate": "string",
    "ExpectedDeliveryDate": "string",
    "Id": "string",
    "IsCredit": "string",
    "MarinaLocationId": "string",
    "Notes": "string",
    "NotesToVendor": "string",
    "PurchaseOrderId": "string",
    "QuickbooksBillId": "string",
    "ReferenceNumber": "string",
    "Status": "string",
    "TotalAmount": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "XeroInvoiceId": "string"
}

created: 2026-04-17 03:09:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbill`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `Status`  string , `PurchaseOrderId`  string , `IsCredit`  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 , `BillDate`  string , `DueDate`  string , `QuickbooksBillId`  string , `TotalAmount`  string , `XeroInvoiceId`  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_moloVendorBill/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbill`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbill"
}

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