Schema Info

Schema Name: sfdl_prod_drivethru.molo_molorecurringinvoiceauditset

created: 2023-10-17 01:59:39
disabled: False
format: raw
id: 1721
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717650

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-17/1776412840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-17/1776412840
id: 1717650
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 162167612
updated: 2026-04-17 03:05:22

Version 1716508

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-16/1776326595'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-16/1776326595
id: 1716508
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 162111953
updated: 2026-04-16 03:12:07

Version 1715303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-15/1776240065'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-15/1776240065
id: 1715303
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 162056084
updated: 2026-04-15 03:09:22

Version 1713986

created: 2026-04-14 03:04:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-14/1776153825'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-14/1776153825
id: 1713986
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 162000427
updated: 2026-04-14 03:04:51

Version 1712860

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-13/1776066988'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-13/1776066988
id: 1712860
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161941976
updated: 2026-04-13 03:01:13

Version 1711672

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-12/1775980700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-12/1775980700
id: 1711672
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161893132
updated: 2026-04-12 03:03:59

Version 1710426

created: 2026-04-11 03:05:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-11/1775894467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-11/1775894467
id: 1710426
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161841209
updated: 2026-04-11 03:05:46

Version 1709301

created: 2026-04-10 03:08:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-10/1775808225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-10/1775808225
id: 1709301
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161785996
updated: 2026-04-10 03:08:29

Version 1708245

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-09/1775721558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-09/1775721558
id: 1708245
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161730514
updated: 2026-04-09 03:09:04

Version 1707001

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-08/1775635386'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-08/1775635386
id: 1707001
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161675659
updated: 2026-04-08 03:09:45

Version 1705785

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-07/1775548541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-07/1775548541
id: 1705785
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161618722
updated: 2026-04-07 03:00:20

Version 1704559

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-06/1775462503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-06/1775462503
id: 1704559
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161561675
updated: 2026-04-06 03:08:44

Version 1703307

created: 2026-04-05 03:05:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-05/1775376129'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-05/1775376129
id: 1703307
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161514885
updated: 2026-04-05 03:05:38

Version 1702153

created: 2026-04-04 03:05:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-04/1775289612'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-04/1775289612
id: 1702153
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161460347
updated: 2026-04-04 03:05:16

Version 1701029

created: 2026-04-03 03:13:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-03/1775203385'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringInvoiceAuditSet/2026-04-03/1775203385
id: 1701029
processed: 1

raw_data:

{
    "ContactHashId": 3,
    "DateTime": 1,
    "Id": 0,
    "InvoiceDate": 7,
    "InvoiceId": 8,
    "MarinaLocationId": 2,
    "Reason": 6,
    "ReservationHashId": 4,
    "Result": 5
}

schema_attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

schema_name_id: 1721
schema_scan_id: 161402008
updated: 2026-04-03 03:13:55

Schema Scans: 15

Last at 2026-04-17 03:05:07

Scan 162167612

duration: 0:00:14.470916

exit_message:

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

id: 162167612

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_moloRecurringInvoiceAuditSet/2026-04-17/1776412840",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-17/1776412840/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13235244438573228229,
        "service_name": "drive-thru",
        "span_id": 5581993326902935659,
        "trace_id": 6388423680250258691
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-17 03:05:07
success: True
trace_id: 6388423680250258691

Scan 162111953

duration: 0:00:11.878633

exit_message:

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

id: 162111953

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_moloRecurringInvoiceAuditSet/2026-04-16/1776326595",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-16/1776326595/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11171814075377590078,
        "service_name": "drive-thru",
        "span_id": 14316792560695907171,
        "trace_id": 8979419164516195431
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-16 03:11:55
success: True
trace_id: 8979419164516195431

Scan 162056084

duration: 0:00:11.809041

exit_message:

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

id: 162056084

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_moloRecurringInvoiceAuditSet/2026-04-15/1776240065",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-15/1776240065/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11754351730245165709,
        "service_name": "drive-thru",
        "span_id": 3595605106594244291,
        "trace_id": 2760040810690450815
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-15 03:09:10
success: True
trace_id: 2760040810690450815

Scan 162000427

duration: 0:00:11.899193

exit_message:

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

id: 162000427

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_moloRecurringInvoiceAuditSet/2026-04-14/1776153825",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-14/1776153825/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12920718528869230801,
        "service_name": "drive-thru",
        "span_id": 12534741436686411699,
        "trace_id": 9594540564479699133
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-14 03:04:40
success: True
trace_id: 9594540564479699133

Scan 161941976

duration: 0:00:14.428816

exit_message:

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

id: 161941976

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_moloRecurringInvoiceAuditSet/2026-04-13/1776066988",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-13/1776066988/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9144480348227080840,
        "service_name": "drive-thru",
        "span_id": 17155492712802249635,
        "trace_id": 7157106174545590181
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-13 03:00:59
success: True
trace_id: 7157106174545590181

Scan 161893132

duration: 0:00:14.457217

exit_message:

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

id: 161893132

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_moloRecurringInvoiceAuditSet/2026-04-12/1775980700",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-12/1775980700/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6174024559173726537,
        "service_name": "drive-thru",
        "span_id": 13201415306011870366,
        "trace_id": 3618880004571870227
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-12 03:03:45
success: True
trace_id: 3618880004571870227

Scan 161841209

duration: 0:00:11.860573

exit_message:

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

id: 161841209

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_moloRecurringInvoiceAuditSet/2026-04-11/1775894467",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-11/1775894467/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16975954487736575630,
        "service_name": "drive-thru",
        "span_id": 11715583670007380207,
        "trace_id": 13520571462126152755
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-11 03:05:34
success: True
trace_id: 13520571462126152755

Scan 161785996

duration: 0:00:14.428983

exit_message:

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

id: 161785996

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_moloRecurringInvoiceAuditSet/2026-04-10/1775808225",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-10/1775808225/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13790343684868457381,
        "service_name": "drive-thru",
        "span_id": 13515087084116958713,
        "trace_id": 1571424039140295603
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-10 03:08:15
success: True
trace_id: 1571424039140295603

Scan 161730514

duration: 0:00:14.463934

exit_message:

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

id: 161730514

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_moloRecurringInvoiceAuditSet/2026-04-09/1775721558",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-09/1775721558/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9339444526497886813,
        "service_name": "drive-thru",
        "span_id": 731593676155068395,
        "trace_id": 2128477476338877738
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-09 03:08:49
success: True
trace_id: 2128477476338877738

Scan 161675659

duration: 0:00:14.515741

exit_message:

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

id: 161675659

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_moloRecurringInvoiceAuditSet/2026-04-08/1775635386",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-08/1775635386/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13621388028713575754,
        "service_name": "drive-thru",
        "span_id": 358503120486524666,
        "trace_id": 7594490119480528549
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-08 03:09:30
success: True
trace_id: 7594490119480528549

Scan 161618722

duration: 0:00:14.393190

exit_message:

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

id: 161618722

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_moloRecurringInvoiceAuditSet/2026-04-07/1775548541",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-07/1775548541/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4191088000447250311,
        "service_name": "drive-thru",
        "span_id": 16695901820697216393,
        "trace_id": 3069424755263678418
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-07 03:00:06
success: True
trace_id: 3069424755263678418

Scan 161561675

duration: 0:00:11.881857

exit_message:

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

id: 161561675

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_moloRecurringInvoiceAuditSet/2026-04-06/1775462503",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-06/1775462503/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16056106467271857811,
        "service_name": "drive-thru",
        "span_id": 10449515776136593992,
        "trace_id": 11858364454010392542
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-06 03:08:33
success: True
trace_id: 11858364454010392542

Scan 161514885

duration: 0:00:14.431599

exit_message:

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

id: 161514885

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_moloRecurringInvoiceAuditSet/2026-04-05/1775376129",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-05/1775376129/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15529958194947004272,
        "service_name": "drive-thru",
        "span_id": 11628743813646828732,
        "trace_id": 10685104114517160019
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-05 03:05:24
success: True
trace_id: 10685104114517160019

Scan 161460347

duration: 0:00:14.452328

exit_message:

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

id: 161460347

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_moloRecurringInvoiceAuditSet/2026-04-04/1775289612",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-04/1775289612/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17837533831660236828,
        "service_name": "drive-thru",
        "span_id": 12268521403071610616,
        "trace_id": 5602629038554438977
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-04 03:05:02
success: True
trace_id: 5602629038554438977

Scan 161402008

duration: 0:00:11.920174

exit_message:

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

id: 161402008

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_moloRecurringInvoiceAuditSet/2026-04-03/1775203385",
        "key": "raw/molo_moloRecurringInvoiceAuditSet/2026-04-03/1775203385/RecurringInvoiceAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringInvoiceAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5762207229779694796,
        "service_name": "drive-thru",
        "span_id": 11582489237297857430,
        "trace_id": 14139099714936063715
    }
}

running: False
schema_name_id: 1721
start_time: 2026-04-03 03:13:43
success: True
trace_id: 14139099714936063715

Partitions:

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

Schema:

attributes:

{
    "ContactHashId": "string",
    "DateTime": "string",
    "Id": "string",
    "InvoiceDate": "string",
    "InvoiceId": "string",
    "MarinaLocationId": "string",
    "Reason": "string",
    "ReservationHashId": "string",
    "Result": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-17/1776412840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
}

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:59:39",
        "disabled": false,
        "format": "raw",
        "id": 1721,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molorecurringinvoiceauditset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ContactHashId": "string",
            "DateTime": "string",
            "Id": "string",
            "InvoiceDate": "string",
            "InvoiceId": "string",
            "MarinaLocationId": "string",
            "Reason": "string",
            "ReservationHashId": "string",
            "Result": "string"
        },
        "created": "2026-04-17 03:05:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`\n(\n `Id`  string , `DateTime`  string , `MarinaLocationId`  string , `ContactHashId`  string , `ReservationHashId`  string , `Result`  string , `Reason`  string , `InvoiceDate`  string , `InvoiceId`  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_moloRecurringInvoiceAuditSet/2026-04-17/1776412840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringinvoiceauditset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringinvoiceauditset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}