Schema Info

Schema Name: sfdl_prod_drivethru.molo_molovendorbillitem

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717744

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 162167752
updated: 2026-04-17 03:09:25

Version 1716589

created: 2026-04-16 03:14:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-16/1776326749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-16/1776326749
id: 1716589
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 162112053
updated: 2026-04-16 03:15:09

Version 1715358

created: 2026-04-15 03:12:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-15/1776240209'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 162056156
updated: 2026-04-15 03:12:15

Version 1714130

created: 2026-04-14 03:10:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-14/1776154173'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 162000647
updated: 2026-04-14 03:10:42

Version 1712970

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-13/1776067167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161942834
updated: 2026-04-13 03:07:25

Version 1711727

created: 2026-04-12 03:06:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-12/1775980869'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-12/1775980869
id: 1711727
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161893410
updated: 2026-04-12 03:07:11

Version 1710584

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-11/1775894646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-11/1775894646
id: 1710584
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161841395
updated: 2026-04-11 03:12:23

Version 1709338

created: 2026-04-10 03:09:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-10/1775808401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161786037
updated: 2026-04-10 03:09:51

Version 1708263

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-09/1775721730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161730546
updated: 2026-04-09 03:09:55

Version 1707042

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-08/1775635559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161675708
updated: 2026-04-08 03:11:23

Version 1705893

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-07/1775548719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161619540
updated: 2026-04-07 03:06:13

Version 1704646

created: 2026-04-06 03:11:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-06/1775462671'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-06/1775462671
id: 1704646
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161561795
updated: 2026-04-06 03:12:06

Version 1703401

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-05/1775376300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

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

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161514986
updated: 2026-04-05 03:09:19

Version 1702267

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-04/1775289785'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-04/1775289785
id: 1702267
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161460574
updated: 2026-04-04 03:10:38

Version 1701025

created: 2026-04-03 03:13:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-03/1775203551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloVendorBillItem/2026-04-03/1775203551
id: 1701025
processed: 1

raw_data:

{
    "CreatedAt": 6,
    "CreatedBy": 8,
    "ExpectedQuantity": 10,
    "ExpectedSalesPrice": 4,
    "Id": 0,
    "InventoryAuditTrailSetId": 11,
    "InventoryId": 2,
    "PurchasePrice": 3,
    "QuantityReceived": 5,
    "RemoveFromInventory": 12,
    "UpdatedAt": 7,
    "UpdatedBy": 9,
    "VendorBillId": 1
}

schema_attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "string"
}

schema_name_id: 4268
schema_scan_id: 161402002
updated: 2026-04-03 03:13:40

Schema Scans: 15

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

Scan 162167752

duration: 0:00:11.953144

exit_message:

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

id: 162167752

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_moloVendorBillItem/2026-04-17/1776413271",
        "key": "raw/molo_moloVendorBillItem/2026-04-17/1776413271/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6691360737647687724,
        "service_name": "drive-thru",
        "span_id": 16421847820009212563,
        "trace_id": 14312578071717503743
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-17 03:09:13
success: True
trace_id: 14312578071717503743

Scan 162112053

duration: 0:00:12.167599

exit_message:

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

id: 162112053

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_moloVendorBillItem/2026-04-16/1776326749",
        "key": "raw/molo_moloVendorBillItem/2026-04-16/1776326749/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15307175605069588959,
        "service_name": "drive-thru",
        "span_id": 6514878974560463770,
        "trace_id": 6560825150618756542
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-16 03:14:57
success: True
trace_id: 6560825150618756542

Scan 162056156

duration: 0:00:11.993857

exit_message:

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

id: 162056156

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_moloVendorBillItem/2026-04-15/1776240209",
        "key": "raw/molo_moloVendorBillItem/2026-04-15/1776240209/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7749754953185283715,
        "service_name": "drive-thru",
        "span_id": 9157655659777941607,
        "trace_id": 14811535376941822906
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-15 03:12:03
success: True
trace_id: 14811535376941822906

Scan 162000647

duration: 0:00:14.436075

exit_message:

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

id: 162000647

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_moloVendorBillItem/2026-04-14/1776154173",
        "key": "raw/molo_moloVendorBillItem/2026-04-14/1776154173/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14440826252590973081,
        "service_name": "drive-thru",
        "span_id": 2650293971874288468,
        "trace_id": 626972457084302518
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-14 03:10:28
success: True
trace_id: 626972457084302518

Scan 161942834

duration: 0:00:11.964871

exit_message:

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

id: 161942834

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_moloVendorBillItem/2026-04-13/1776067167",
        "key": "raw/molo_moloVendorBillItem/2026-04-13/1776067167/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8101350292428096520,
        "service_name": "drive-thru",
        "span_id": 471341016469375395,
        "trace_id": 14035782494518045657
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-13 03:07:13
success: True
trace_id: 14035782494518045657

Scan 161893410

duration: 0:00:14.496895

exit_message:

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

id: 161893410

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_moloVendorBillItem/2026-04-12/1775980869",
        "key": "raw/molo_moloVendorBillItem/2026-04-12/1775980869/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13579456253002057074,
        "service_name": "drive-thru",
        "span_id": 15852159662702898978,
        "trace_id": 14218296781625703549
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-12 03:06:56
success: True
trace_id: 14218296781625703549

Scan 161841395

duration: 0:00:14.603248

exit_message:

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

id: 161841395

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_moloVendorBillItem/2026-04-11/1775894646",
        "key": "raw/molo_moloVendorBillItem/2026-04-11/1775894646/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4106589464330145829,
        "service_name": "drive-thru",
        "span_id": 13783041582289596345,
        "trace_id": 10672080383670565126
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-11 03:12:08
success: True
trace_id: 10672080383670565126

Scan 161786037

duration: 0:00:12.139281

exit_message:

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

id: 161786037

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_moloVendorBillItem/2026-04-10/1775808401",
        "key": "raw/molo_moloVendorBillItem/2026-04-10/1775808401/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13174545542947954246,
        "service_name": "drive-thru",
        "span_id": 1120033473610379803,
        "trace_id": 10153518909249888035
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-10 03:09:39
success: True
trace_id: 10153518909249888035

Scan 161730546

duration: 0:00:14.490450

exit_message:

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

id: 161730546

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_moloVendorBillItem/2026-04-09/1775721730",
        "key": "raw/molo_moloVendorBillItem/2026-04-09/1775721730/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12999415063184881928,
        "service_name": "drive-thru",
        "span_id": 13799214524429665207,
        "trace_id": 9073762476537562632
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-09 03:09:41
success: True
trace_id: 9073762476537562632

Scan 161675708

duration: 0:00:11.900705

exit_message:

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

id: 161675708

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_moloVendorBillItem/2026-04-08/1775635559",
        "key": "raw/molo_moloVendorBillItem/2026-04-08/1775635559/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2923541765579049963,
        "service_name": "drive-thru",
        "span_id": 1493107096253009341,
        "trace_id": 2790273716492467192
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-08 03:11:11
success: True
trace_id: 2790273716492467192

Scan 161619540

duration: 0:00:14.566039

exit_message:

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

id: 161619540

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_moloVendorBillItem/2026-04-07/1775548719",
        "key": "raw/molo_moloVendorBillItem/2026-04-07/1775548719/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16399207329001724265,
        "service_name": "drive-thru",
        "span_id": 4704125451722716622,
        "trace_id": 6390072962323989841
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-07 03:05:59
success: True
trace_id: 6390072962323989841

Scan 161561795

duration: 0:00:12.004068

exit_message:

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

id: 161561795

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_moloVendorBillItem/2026-04-06/1775462671",
        "key": "raw/molo_moloVendorBillItem/2026-04-06/1775462671/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10520783180931738380,
        "service_name": "drive-thru",
        "span_id": 3563466951578872750,
        "trace_id": 881060395106229101
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-06 03:11:54
success: True
trace_id: 881060395106229101

Scan 161514986

duration: 0:00:11.873908

exit_message:

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

id: 161514986

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_moloVendorBillItem/2026-04-05/1775376300",
        "key": "raw/molo_moloVendorBillItem/2026-04-05/1775376300/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7673173675640275822,
        "service_name": "drive-thru",
        "span_id": 1630072322208912292,
        "trace_id": 11377292255619679389
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-05 03:09:07
success: True
trace_id: 11377292255619679389

Scan 161460574

duration: 0:00:11.895400

exit_message:

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

id: 161460574

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_moloVendorBillItem/2026-04-04/1775289785",
        "key": "raw/molo_moloVendorBillItem/2026-04-04/1775289785/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16106583026472824576,
        "service_name": "drive-thru",
        "span_id": 6336995502136698085,
        "trace_id": 17097921449427735889
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-04 03:10:26
success: True
trace_id: 17097921449427735889

Scan 161402002

duration: 0:00:12.105225

exit_message:

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

id: 161402002

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_moloVendorBillItem/2026-04-03/1775203551",
        "key": "raw/molo_moloVendorBillItem/2026-04-03/1775203551/VendorBillItem.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVendorBillItem",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2516586688609486708,
        "service_name": "drive-thru",
        "span_id": 15641727134644712025,
        "trace_id": 5266309744212969547
    }
}

running: False
schema_name_id: 4268
start_time: 2026-04-03 03:13:28
success: True
trace_id: 5266309744212969547

Partitions:

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

Schema:

attributes:

{
    "CreatedAt": "string",
    "CreatedBy": "string",
    "ExpectedQuantity": "string",
    "ExpectedSalesPrice": "string",
    "Id": "string",
    "InventoryAuditTrailSetId": "string",
    "InventoryId": "string",
    "PurchasePrice": "string",
    "QuantityReceived": "string",
    "RemoveFromInventory": "string",
    "UpdatedAt": "string",
    "UpdatedBy": "string",
    "VendorBillId": "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_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
}

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:50",
        "disabled": false,
        "format": "raw",
        "id": 4268,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molovendorbillitem"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreatedAt": "string",
            "CreatedBy": "string",
            "ExpectedQuantity": "string",
            "ExpectedSalesPrice": "string",
            "Id": "string",
            "InventoryAuditTrailSetId": "string",
            "InventoryId": "string",
            "PurchasePrice": "string",
            "QuantityReceived": "string",
            "RemoveFromInventory": "string",
            "UpdatedAt": "string",
            "UpdatedBy": "string",
            "VendorBillId": "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_molovendorbillitem`\n(\n `Id`  string , `VendorBillId`  string , `InventoryId`  string , `PurchasePrice`  string , `ExpectedSalesPrice`  string , `QuantityReceived`  string , `CreatedAt`  string , `UpdatedAt`  string , `CreatedBy`  string , `UpdatedBy`  string , `ExpectedQuantity`  string , `InventoryAuditTrailSetId`  string , `RemoveFromInventory`  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_moloVendorBillItem/2026-04-17/1776413271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovendorbillitem`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovendorbillitem"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}