Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxeroinvoiceset

created: 2023-10-17 02:00:52
disabled: False
format: raw
id: 1758
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717742

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-17/1776413275'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-17/1776413275
id: 1717742
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 162167747
updated: 2026-04-17 03:09:21

Version 1716596

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-16/1776326752'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-16/1776326752
id: 1716596
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 162112060
updated: 2026-04-16 03:15:27

Version 1715379

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-15/1776240213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-15/1776240213
id: 1715379
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 162056182
updated: 2026-04-15 03:13:11

Version 1714175

created: 2026-04-14 03:12:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-14/1776154176'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-14/1776154176
id: 1714175
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 162000699
updated: 2026-04-14 03:12:25

Version 1712953

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-13/1776067169'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-13/1776067169
id: 1712953
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161942756
updated: 2026-04-13 03:06:23

Version 1711737

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-12/1775980872'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-12/1775980872
id: 1711737
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161893427
updated: 2026-04-12 03:07:34

Version 1710570

created: 2026-04-11 03:11:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-11/1775894649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-11/1775894649
id: 1710570
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161841377
updated: 2026-04-11 03:11:37

Version 1709420

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-10/1775808404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-10/1775808404
id: 1709420
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161786128
updated: 2026-04-10 03:13:17

Version 1708254

created: 2026-04-09 03:09:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-09/1775721734'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-09/1775721734
id: 1708254
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161730527
updated: 2026-04-09 03:09:29

Version 1707048

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-08/1775635562'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-08/1775635562
id: 1707048
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161675716
updated: 2026-04-08 03:11:41

Version 1705897

created: 2026-04-07 03:06:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-07/1775548722'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-07/1775548722
id: 1705897
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161619570
updated: 2026-04-07 03:06:32

Version 1704647

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-06/1775462675'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-06/1775462675
id: 1704647
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161561796
updated: 2026-04-06 03:12:07

Version 1703439

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-05/1775376304'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-05/1775376304
id: 1703439
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161515028
updated: 2026-04-05 03:10:45

Version 1702250

created: 2026-04-04 03:09:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-04/1775289788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-04/1775289788
id: 1702250
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161460548
updated: 2026-04-04 03:09:59

Version 1701013

created: 2026-04-03 03:12:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-03/1775203553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroInvoiceSet/2026-04-03/1775203553
id: 1701013
processed: 1

raw_data:

{
    "AmountCredited": 20,
    "AmountDue": 17,
    "AmountPaid": 18,
    "CurrencyCode": 6,
    "CurrencyRate": 7,
    "Date": 1,
    "DueDate": 2,
    "ExpectedPaymentDate": 9,
    "FullyPaidOnDate": 19,
    "HasAttachments": 16,
    "Id": 0,
    "InvoiceID": 15,
    "InvoiceNumber": 3,
    "PlannedPaymentDate": 10,
    "Reference": 4,
    "SentToContact": 8,
    "SubTotal": 11,
    "Total": 13,
    "TotalDiscount": 14,
    "TotalTax": 12,
    "Url": 5,
    "XeroContact_Id": 23,
    "XeroId": 21,
    "XeroInvoiceType_Id": 22
}

schema_attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

schema_name_id: 1758
schema_scan_id: 161401987
updated: 2026-04-03 03:12:58

Schema Scans: 15

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

Scan 162167747

duration: 0:00:14.810487

exit_message:

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

id: 162167747

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_moloXeroInvoiceSet/2026-04-17/1776413275",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-17/1776413275/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7420205364352148668,
        "service_name": "drive-thru",
        "span_id": 9369797903619208392,
        "trace_id": 4650797745788402657
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-17 03:09:06
success: True
trace_id: 4650797745788402657

Scan 162112060

duration: 0:00:15.031490

exit_message:

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

id: 162112060

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_moloXeroInvoiceSet/2026-04-16/1776326752",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-16/1776326752/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7561341910571237416,
        "service_name": "drive-thru",
        "span_id": 16019558813091025611,
        "trace_id": 11869977689580565030
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-16 03:15:12
success: True
trace_id: 11869977689580565030

Scan 162056182

duration: 0:00:12.422506

exit_message:

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

id: 162056182

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_moloXeroInvoiceSet/2026-04-15/1776240213",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-15/1776240213/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14677747985551628616,
        "service_name": "drive-thru",
        "span_id": 12747867914708039138,
        "trace_id": 2153464208152218764
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-15 03:12:59
success: True
trace_id: 2153464208152218764

Scan 162000699

duration: 0:00:12.190313

exit_message:

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

id: 162000699

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_moloXeroInvoiceSet/2026-04-14/1776154176",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-14/1776154176/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 903675899663802005,
        "service_name": "drive-thru",
        "span_id": 14391056025996717192,
        "trace_id": 14773639519510987313
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-14 03:12:13
success: True
trace_id: 14773639519510987313

Scan 161942756

duration: 0:00:12.320572

exit_message:

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

id: 161942756

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_moloXeroInvoiceSet/2026-04-13/1776067169",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-13/1776067169/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8751968188929824708,
        "service_name": "drive-thru",
        "span_id": 5649249108124781552,
        "trace_id": 393576969982861178
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-13 03:06:11
success: True
trace_id: 393576969982861178

Scan 161893427

duration: 0:00:12.159037

exit_message:

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

id: 161893427

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_moloXeroInvoiceSet/2026-04-12/1775980872",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-12/1775980872/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6821890004275685866,
        "service_name": "drive-thru",
        "span_id": 9072197464372966509,
        "trace_id": 14225787407752123806
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-12 03:07:22
success: True
trace_id: 14225787407752123806

Scan 161841377

duration: 0:00:14.812589

exit_message:

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

id: 161841377

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_moloXeroInvoiceSet/2026-04-11/1775894649",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-11/1775894649/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15844321439037088014,
        "service_name": "drive-thru",
        "span_id": 2445771702781747230,
        "trace_id": 9523627788431636119
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-11 03:11:22
success: True
trace_id: 9523627788431636119

Scan 161786128

duration: 0:00:12.251235

exit_message:

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

id: 161786128

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_moloXeroInvoiceSet/2026-04-10/1775808404",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-10/1775808404/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7352895523909237336,
        "service_name": "drive-thru",
        "span_id": 12668856037951886610,
        "trace_id": 3351053726685536965
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-10 03:13:05
success: True
trace_id: 3351053726685536965

Scan 161730527

duration: 0:00:12.285183

exit_message:

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

id: 161730527

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_moloXeroInvoiceSet/2026-04-09/1775721734",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-09/1775721734/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16494544155019322521,
        "service_name": "drive-thru",
        "span_id": 1000519577864231662,
        "trace_id": 6947147088011098785
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-09 03:09:17
success: True
trace_id: 6947147088011098785

Scan 161675716

duration: 0:00:12.178395

exit_message:

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

id: 161675716

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_moloXeroInvoiceSet/2026-04-08/1775635562",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-08/1775635562/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8112674228459644624,
        "service_name": "drive-thru",
        "span_id": 10327571621790879395,
        "trace_id": 2253205811767700293
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-08 03:11:29
success: True
trace_id: 2253205811767700293

Scan 161619570

duration: 0:00:12.339341

exit_message:

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

id: 161619570

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_moloXeroInvoiceSet/2026-04-07/1775548722",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-07/1775548722/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5777753358372076383,
        "service_name": "drive-thru",
        "span_id": 12783538316348302075,
        "trace_id": 11386792327192069766
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-07 03:06:20
success: True
trace_id: 11386792327192069766

Scan 161561796

duration: 0:00:12.280452

exit_message:

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

id: 161561796

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_moloXeroInvoiceSet/2026-04-06/1775462675",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-06/1775462675/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7375665472440870485,
        "service_name": "drive-thru",
        "span_id": 10064168061684671196,
        "trace_id": 3964165922226021763
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-06 03:11:54
success: True
trace_id: 3964165922226021763

Scan 161515028

duration: 0:00:14.738197

exit_message:

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

id: 161515028

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_moloXeroInvoiceSet/2026-04-05/1775376304",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-05/1775376304/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4991375347763148752,
        "service_name": "drive-thru",
        "span_id": 2880719658749623229,
        "trace_id": 3165128097733507037
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-05 03:10:31
success: True
trace_id: 3165128097733507037

Scan 161460548

duration: 0:00:14.911177

exit_message:

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

id: 161460548

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_moloXeroInvoiceSet/2026-04-04/1775289788",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-04/1775289788/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11094044832283233020,
        "service_name": "drive-thru",
        "span_id": 12212315433965910863,
        "trace_id": 3084618597347350709
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-04 03:09:44
success: True
trace_id: 3084618597347350709

Scan 161401987

duration: 0:00:14.933035

exit_message:

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

id: 161401987

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_moloXeroInvoiceSet/2026-04-03/1775203553",
        "key": "raw/molo_moloXeroInvoiceSet/2026-04-03/1775203553/XeroInvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13764006711226668921,
        "service_name": "drive-thru",
        "span_id": 14534587701512772749,
        "trace_id": 7934860650510120935
    }
}

running: False
schema_name_id: 1758
start_time: 2026-04-03 03:12:43
success: True
trace_id: 7934860650510120935

Partitions:

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

Schema:

attributes:

{
    "AmountCredited": "string",
    "AmountDue": "string",
    "AmountPaid": "string",
    "CurrencyCode": "string",
    "CurrencyRate": "string",
    "Date": "string",
    "DueDate": "string",
    "ExpectedPaymentDate": "string",
    "FullyPaidOnDate": "string",
    "HasAttachments": "string",
    "Id": "string",
    "InvoiceID": "string",
    "InvoiceNumber": "string",
    "PlannedPaymentDate": "string",
    "Reference": "string",
    "SentToContact": "string",
    "SubTotal": "string",
    "Total": "string",
    "TotalDiscount": "string",
    "TotalTax": "string",
    "Url": "string",
    "XeroContact_Id": "string",
    "XeroId": "string",
    "XeroInvoiceType_Id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-17/1776413275'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:00:52",
        "disabled": false,
        "format": "raw",
        "id": 1758,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloxeroinvoiceset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AmountCredited": "string",
            "AmountDue": "string",
            "AmountPaid": "string",
            "CurrencyCode": "string",
            "CurrencyRate": "string",
            "Date": "string",
            "DueDate": "string",
            "ExpectedPaymentDate": "string",
            "FullyPaidOnDate": "string",
            "HasAttachments": "string",
            "Id": "string",
            "InvoiceID": "string",
            "InvoiceNumber": "string",
            "PlannedPaymentDate": "string",
            "Reference": "string",
            "SentToContact": "string",
            "SubTotal": "string",
            "Total": "string",
            "TotalDiscount": "string",
            "TotalTax": "string",
            "Url": "string",
            "XeroContact_Id": "string",
            "XeroId": "string",
            "XeroInvoiceType_Id": "string"
        },
        "created": "2026-04-17 03:09:07",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxeroinvoiceset`\n(\n `Id`  string , `Date`  string , `DueDate`  string , `InvoiceNumber`  string , `Reference`  string , `Url`  string , `CurrencyCode`  string , `CurrencyRate`  string , `SentToContact`  string , `ExpectedPaymentDate`  string , `PlannedPaymentDate`  string , `SubTotal`  string , `TotalTax`  string , `Total`  string , `TotalDiscount`  string , `InvoiceID`  string , `HasAttachments`  string , `AmountDue`  string , `AmountPaid`  string , `FullyPaidOnDate`  string , `AmountCredited`  string , `XeroId`  string , `XeroInvoiceType_Id`  string , `XeroContact_Id`  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_moloXeroInvoiceSet/2026-04-17/1776413275'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxeroinvoiceset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxeroinvoiceset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}