Schema Info

Schema Name: sfdl_prod_drivethru.molo_molofinancechargeauditset

created: 2023-10-17 01:54:55
disabled: False
format: raw
id: 1586
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717606

created: 2026-04-17 03:02:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-17/1776412731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-17/1776412731
id: 1717606
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 162167376
updated: 2026-04-17 03:02:34

Version 1716373

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-16/1776326490'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-16/1776326490
id: 1716373
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 162111773
updated: 2026-04-16 03:06:42

Version 1715175

created: 2026-04-15 03:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-15/1776239959'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-15/1776239959
id: 1715175
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 162055830
updated: 2026-04-15 03:03:28

Version 1713963

created: 2026-04-14 03:03:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-14/1776153685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-14/1776153685
id: 1713963
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 162000392
updated: 2026-04-14 03:03:55

Version 1712749

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-13/1776066879'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-13/1776066879
id: 1712749
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161941554
updated: 2026-04-13 02:57:17

Version 1711568

created: 2026-04-12 02:59:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-12/1775980593'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-12/1775980593
id: 1711568
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161892541
updated: 2026-04-12 03:00:19

Version 1710323

created: 2026-04-11 03:00:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-11/1775894355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-11/1775894355
id: 1710323
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161840967
updated: 2026-04-11 03:01:10

Version 1709175

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-10/1775808110'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-10/1775808110
id: 1709175
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161785842
updated: 2026-04-10 03:03:35

Version 1708051

created: 2026-04-09 03:00:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-09/1775721449'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-09/1775721449
id: 1708051
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161729922
updated: 2026-04-09 03:00:37

Version 1706883

created: 2026-04-08 03:04:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-08/1775635257'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-08/1775635257
id: 1706883
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161675482
updated: 2026-04-08 03:04:51

Version 1705669

created: 2026-04-07 02:55:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-07/1775548430'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-07/1775548430
id: 1705669
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161618351
updated: 2026-04-07 02:55:51

Version 1704424

created: 2026-04-06 03:02:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-06/1775462398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-06/1775462398
id: 1704424
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161561436
updated: 2026-04-06 03:02:47

Version 1703242

created: 2026-04-05 03:02:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-05/1775376022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-05/1775376022
id: 1703242
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161514810
updated: 2026-04-05 03:03:00

Version 1702069

created: 2026-04-04 03:01:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-04/1775289505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-04/1775289505
id: 1702069
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161459940
updated: 2026-04-04 03:01:41

Version 1700911

created: 2026-04-03 03:08:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-03/1775203278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFinanceChargeAuditSet/2026-04-03/1775203278
id: 1700911
processed: 1

raw_data:

{
    "ActionTaken": 3,
    "Contact_Id": 7,
    "CreationDateTime": 1,
    "CreationUser_Id": 5,
    "Id": 0,
    "InvoiceAgingDate": 2,
    "Invoice_Id": 6,
    "MarinaLocation_Id": 4
}

schema_attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

schema_name_id: 1586
schema_scan_id: 161401862
updated: 2026-04-03 03:08:54

Schema Scans: 15

Last at 2026-04-17 03:02:20

Scan 162167376

duration: 0:00:14.334483

exit_message:

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

id: 162167376

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_moloFinanceChargeAuditSet/2026-04-17/1776412731",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-17/1776412731/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5532333923483400186,
        "service_name": "drive-thru",
        "span_id": 6757748695984639247,
        "trace_id": 5659095210463558395
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-17 03:02:20
success: True
trace_id: 5659095210463558395

Scan 162111773

duration: 0:00:11.912680

exit_message:

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

id: 162111773

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_moloFinanceChargeAuditSet/2026-04-16/1776326490",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-16/1776326490/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6927994234113047483,
        "service_name": "drive-thru",
        "span_id": 16200117717366768859,
        "trace_id": 4400778312722217396
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-16 03:06:31
success: True
trace_id: 4400778312722217396

Scan 162055830

duration: 0:00:14.409107

exit_message:

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

id: 162055830

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_moloFinanceChargeAuditSet/2026-04-15/1776239959",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-15/1776239959/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4749830161129947615,
        "service_name": "drive-thru",
        "span_id": 1490566196885149142,
        "trace_id": 9403943476909472071
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-15 03:03:14
success: True
trace_id: 9403943476909472071

Scan 162000392

duration: 0:00:14.405164

exit_message:

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

id: 162000392

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_moloFinanceChargeAuditSet/2026-04-14/1776153685",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-14/1776153685/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4054096537258026236,
        "service_name": "drive-thru",
        "span_id": 18003204700654942081,
        "trace_id": 7276877890284149983
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-14 03:03:41
success: True
trace_id: 7276877890284149983

Scan 161941554

duration: 0:00:14.363273

exit_message:

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

id: 161941554

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_moloFinanceChargeAuditSet/2026-04-13/1776066879",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-13/1776066879/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13472369569945575165,
        "service_name": "drive-thru",
        "span_id": 4798562827059380262,
        "trace_id": 10030947954083591473
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-13 02:57:03
success: True
trace_id: 10030947954083591473

Scan 161892541

duration: 0:00:22.221556

exit_message:

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

id: 161892541

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_moloFinanceChargeAuditSet/2026-04-12/1775980593",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-12/1775980593/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14464034943879651798,
        "service_name": "drive-thru",
        "span_id": 8526881031297367003,
        "trace_id": 6516449056811320819
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-12 02:59:57
success: True
trace_id: 6516449056811320819

Scan 161840967

duration: 0:00:14.269422

exit_message:

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

id: 161840967

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_moloFinanceChargeAuditSet/2026-04-11/1775894355",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-11/1775894355/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7779172405064238291,
        "service_name": "drive-thru",
        "span_id": 15573173352138772300,
        "trace_id": 2783962476562798666
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-11 03:00:55
success: True
trace_id: 2783962476562798666

Scan 161785842

duration: 0:00:11.961271

exit_message:

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

id: 161785842

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_moloFinanceChargeAuditSet/2026-04-10/1775808110",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-10/1775808110/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9727982400579328378,
        "service_name": "drive-thru",
        "span_id": 3506838719154416852,
        "trace_id": 7380748968325078407
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-10 03:03:23
success: True
trace_id: 7380748968325078407

Scan 161729922

duration: 0:00:14.462510

exit_message:

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

id: 161729922

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_moloFinanceChargeAuditSet/2026-04-09/1775721449",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-09/1775721449/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16333235374643199769,
        "service_name": "drive-thru",
        "span_id": 16198703710608226513,
        "trace_id": 2382391087744735552
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-09 03:00:23
success: True
trace_id: 2382391087744735552

Scan 161675482

duration: 0:00:14.477722

exit_message:

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

id: 161675482

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_moloFinanceChargeAuditSet/2026-04-08/1775635257",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-08/1775635257/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8281970447800959529,
        "service_name": "drive-thru",
        "span_id": 9627843904340928713,
        "trace_id": 10416892664633585563
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-08 03:04:37
success: True
trace_id: 10416892664633585563

Scan 161618351

duration: 0:00:11.802777

exit_message:

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

id: 161618351

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_moloFinanceChargeAuditSet/2026-04-07/1775548430",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-07/1775548430/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6683979853008144177,
        "service_name": "drive-thru",
        "span_id": 12166542476676680059,
        "trace_id": 414730386339239983
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-07 02:55:39
success: True
trace_id: 414730386339239983

Scan 161561436

duration: 0:00:14.320000

exit_message:

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

id: 161561436

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_moloFinanceChargeAuditSet/2026-04-06/1775462398",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-06/1775462398/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10422367811440837961,
        "service_name": "drive-thru",
        "span_id": 18299338369294572542,
        "trace_id": 16980688113147341296
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-06 03:02:32
success: True
trace_id: 16980688113147341296

Scan 161514810

duration: 0:00:14.544050

exit_message:

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

id: 161514810

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_moloFinanceChargeAuditSet/2026-04-05/1775376022",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-05/1775376022/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2343868585968301983,
        "service_name": "drive-thru",
        "span_id": 6069287448479532587,
        "trace_id": 8164310671421312753
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-05 03:02:46
success: True
trace_id: 8164310671421312753

Scan 161459940

duration: 0:00:14.425620

exit_message:

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

id: 161459940

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_moloFinanceChargeAuditSet/2026-04-04/1775289505",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-04/1775289505/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14522125232905395556,
        "service_name": "drive-thru",
        "span_id": 6601703691004059107,
        "trace_id": 10783428243984926588
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-04 03:01:26
success: True
trace_id: 10783428243984926588

Scan 161401862

duration: 0:00:11.822084

exit_message:

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

id: 161401862

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_moloFinanceChargeAuditSet/2026-04-03/1775203278",
        "key": "raw/molo_moloFinanceChargeAuditSet/2026-04-03/1775203278/FinanceChargeAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFinanceChargeAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18279212334290349617,
        "service_name": "drive-thru",
        "span_id": 3605280172021334172,
        "trace_id": 11752916590665500102
    }
}

running: False
schema_name_id: 1586
start_time: 2026-04-03 03:08:42
success: True
trace_id: 11752916590665500102

Partitions:

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

Schema:

attributes:

{
    "ActionTaken": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Id": "string",
    "InvoiceAgingDate": "string",
    "Invoice_Id": "string",
    "MarinaLocation_Id": "string"
}

created: 2026-04-17 03:02:21

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-17/1776412731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
}

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 01:54:55",
        "disabled": false,
        "format": "raw",
        "id": 1586,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molofinancechargeauditset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ActionTaken": "string",
            "Contact_Id": "string",
            "CreationDateTime": "string",
            "CreationUser_Id": "string",
            "Id": "string",
            "InvoiceAgingDate": "string",
            "Invoice_Id": "string",
            "MarinaLocation_Id": "string"
        },
        "created": "2026-04-17 03:02:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofinancechargeauditset`\n(\n `Id`  string , `CreationDateTime`  string , `InvoiceAgingDate`  string , `ActionTaken`  string , `MarinaLocation_Id`  string , `CreationUser_Id`  string , `Invoice_Id`  string , `Contact_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_moloFinanceChargeAuditSet/2026-04-17/1776412731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofinancechargeauditset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofinancechargeauditset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}