Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloemailstatementauditset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717589

created: 2026-04-17 03:01:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-17/1776412702'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-17/1776412702
id: 1717589
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 162167254
updated: 2026-04-17 03:01:26

Version 1716334

created: 2026-04-16 03:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-16/1776326465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-16/1776326465
id: 1716334
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 162111693
updated: 2026-04-16 03:04:43

Version 1715161

created: 2026-04-15 03:02:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-15/1776239935'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-15/1776239935
id: 1715161
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 162055744
updated: 2026-04-15 03:02:34

Version 1714011

created: 2026-04-14 03:05:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-14/1776153661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-14/1776153661
id: 1714011
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 162000482
updated: 2026-04-14 03:05:55

Version 1712721

created: 2026-04-13 02:55:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-13/1776066854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-13/1776066854
id: 1712721
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161941496
updated: 2026-04-13 02:56:03

Version 1711544

created: 2026-04-12 02:58:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-12/1775980570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-12/1775980570
id: 1711544
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161892370
updated: 2026-04-12 02:58:43

Version 1710392

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-11/1775894331'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-11/1775894331
id: 1710392
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161841140
updated: 2026-04-11 03:04:20

Version 1709179

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-10/1775808086'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-10/1775808086
id: 1709179
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161785852
updated: 2026-04-10 03:03:43

Version 1708010

created: 2026-04-09 02:58:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-09/1775721425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-09/1775721425
id: 1708010
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161729723
updated: 2026-04-09 02:58:25

Version 1706893

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-08/1775635232'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-08/1775635232
id: 1706893
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161675509
updated: 2026-04-08 03:05:23

Version 1705692

created: 2026-04-07 02:56:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-07/1775548406'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-07/1775548406
id: 1705692
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161618387
updated: 2026-04-07 02:56:49

Version 1704504

created: 2026-04-06 03:06:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-06/1775462374'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-06/1775462374
id: 1704504
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161561594
updated: 2026-04-06 03:06:32

Version 1703199

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-05/1775375998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-05/1775375998
id: 1703199
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161514754
updated: 2026-04-05 03:01:16

Version 1702060

created: 2026-04-04 03:01:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-04/1775289481'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-04/1775289481
id: 1702060
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161459902
updated: 2026-04-04 03:01:17

Version 1700966

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-03/1775203254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailStatementAuditSet/2026-04-03/1775203254
id: 1700966
processed: 1

raw_data:

{
    "AutomaticChargingStatementsEnabled": 3,
    "ContactId": 2,
    "EmailPaymentTokenId": 5,
    "EmailStoreSetId": 4,
    "Id": 0,
    "MarinaLocationId": 1,
    "Result": 6
}

schema_attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

schema_name_id: 1600
schema_scan_id: 161401929
updated: 2026-04-03 03:11:00

Schema Scans: 15

Last at 2026-04-17 03:01:14

Scan 162167254

duration: 0:00:11.886266

exit_message:

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

id: 162167254

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_moloEmailStatementAuditSet/2026-04-17/1776412702",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-17/1776412702/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5427998174219538468,
        "service_name": "drive-thru",
        "span_id": 13627484577342418291,
        "trace_id": 14504143531677770896
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-17 03:01:14
success: True
trace_id: 14504143531677770896

Scan 162111693

duration: 0:00:14.490446

exit_message:

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

id: 162111693

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_moloEmailStatementAuditSet/2026-04-16/1776326465",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-16/1776326465/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9789144522588603610,
        "service_name": "drive-thru",
        "span_id": 13668751704808651989,
        "trace_id": 17877264365224937159
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-16 03:04:28
success: True
trace_id: 17877264365224937159

Scan 162055744

duration: 0:00:14.414708

exit_message:

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

id: 162055744

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_moloEmailStatementAuditSet/2026-04-15/1776239935",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-15/1776239935/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1098700686562941451,
        "service_name": "drive-thru",
        "span_id": 9496027823956163026,
        "trace_id": 15676944519726589416
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-15 03:02:19
success: True
trace_id: 15676944519726589416

Scan 162000482

duration: 0:00:11.872359

exit_message:

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

id: 162000482

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_moloEmailStatementAuditSet/2026-04-14/1776153661",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-14/1776153661/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17930643485143030156,
        "service_name": "drive-thru",
        "span_id": 5495710240215904206,
        "trace_id": 130773940370453581
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-14 03:05:43
success: True
trace_id: 130773940370453581

Scan 161941496

duration: 0:00:11.823361

exit_message:

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

id: 161941496

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_moloEmailStatementAuditSet/2026-04-13/1776066854",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-13/1776066854/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8697002043318192493,
        "service_name": "drive-thru",
        "span_id": 7027171588739818054,
        "trace_id": 1622529160057119620
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-13 02:55:51
success: True
trace_id: 1622529160057119620

Scan 161892370

duration: 0:00:11.731254

exit_message:

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

id: 161892370

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_moloEmailStatementAuditSet/2026-04-12/1775980570",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-12/1775980570/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4198095307657102501,
        "service_name": "drive-thru",
        "span_id": 4704149081092550652,
        "trace_id": 6705338590249144120
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-12 02:58:32
success: True
trace_id: 6705338590249144120

Scan 161841140

duration: 0:00:14.364993

exit_message:

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

id: 161841140

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_moloEmailStatementAuditSet/2026-04-11/1775894331",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-11/1775894331/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15979113020463994571,
        "service_name": "drive-thru",
        "span_id": 5512284657612576497,
        "trace_id": 8395221839435217576
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-11 03:04:05
success: True
trace_id: 8395221839435217576

Scan 161785852

duration: 0:00:11.843858

exit_message:

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

id: 161785852

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_moloEmailStatementAuditSet/2026-04-10/1775808086",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-10/1775808086/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1817440618988557698,
        "service_name": "drive-thru",
        "span_id": 14894102150317879722,
        "trace_id": 5453823968742067540
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-10 03:03:31
success: True
trace_id: 5453823968742067540

Scan 161729723

duration: 0:00:14.377041

exit_message:

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

id: 161729723

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_moloEmailStatementAuditSet/2026-04-09/1775721425",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-09/1775721425/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7519441645499564591,
        "service_name": "drive-thru",
        "span_id": 15601562672920062747,
        "trace_id": 6915211908934055248
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-09 02:58:10
success: True
trace_id: 6915211908934055248

Scan 161675509

duration: 0:00:14.411823

exit_message:

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

id: 161675509

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_moloEmailStatementAuditSet/2026-04-08/1775635232",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-08/1775635232/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12820331281362607816,
        "service_name": "drive-thru",
        "span_id": 14014490560804245256,
        "trace_id": 8890708916139111196
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-08 03:05:08
success: True
trace_id: 8890708916139111196

Scan 161618387

duration: 0:00:14.353821

exit_message:

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

id: 161618387

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_moloEmailStatementAuditSet/2026-04-07/1775548406",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-07/1775548406/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5475636962734447483,
        "service_name": "drive-thru",
        "span_id": 13441101788519582024,
        "trace_id": 1415289408835162530
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-07 02:56:35
success: True
trace_id: 1415289408835162530

Scan 161561594

duration: 0:00:14.407402

exit_message:

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

id: 161561594

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_moloEmailStatementAuditSet/2026-04-06/1775462374",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-06/1775462374/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9092662783256730482,
        "service_name": "drive-thru",
        "span_id": 14183424364044693143,
        "trace_id": 6504592003160818082
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-06 03:06:18
success: True
trace_id: 6504592003160818082

Scan 161514754

duration: 0:00:14.327076

exit_message:

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

id: 161514754

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_moloEmailStatementAuditSet/2026-04-05/1775375998",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-05/1775375998/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5416520694359929290,
        "service_name": "drive-thru",
        "span_id": 629167535380801706,
        "trace_id": 11321557893373779944
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-05 03:01:02
success: True
trace_id: 11321557893373779944

Scan 161459902

duration: 0:00:11.965636

exit_message:

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

id: 161459902

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_moloEmailStatementAuditSet/2026-04-04/1775289481",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-04/1775289481/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7843070558949123868,
        "service_name": "drive-thru",
        "span_id": 12893748822919919557,
        "trace_id": 10361996494086592227
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-04 03:01:05
success: True
trace_id: 10361996494086592227

Scan 161401929

duration: 0:00:11.757830

exit_message:

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

id: 161401929

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_moloEmailStatementAuditSet/2026-04-03/1775203254",
        "key": "raw/molo_moloEmailStatementAuditSet/2026-04-03/1775203254/EmailStatementAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailStatementAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6682059800070834538,
        "service_name": "drive-thru",
        "span_id": 10502541841965192908,
        "trace_id": 15934956080079033266
    }
}

running: False
schema_name_id: 1600
start_time: 2026-04-03 03:10:48
success: True
trace_id: 15934956080079033266

Partitions:

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

Schema:

attributes:

{
    "AutomaticChargingStatementsEnabled": "string",
    "ContactId": "string",
    "EmailPaymentTokenId": "string",
    "EmailStoreSetId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Result": "string"
}

created: 2026-04-17 03:01:15

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-17/1776412702'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
}

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:55:19",
        "disabled": false,
        "format": "raw",
        "id": 1600,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloemailstatementauditset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AutomaticChargingStatementsEnabled": "string",
            "ContactId": "string",
            "EmailPaymentTokenId": "string",
            "EmailStoreSetId": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "Result": "string"
        },
        "created": "2026-04-17 03:01:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailstatementauditset`\n(\n `Id`  string , `MarinaLocationId`  string , `ContactId`  string , `AutomaticChargingStatementsEnabled`  string , `EmailStoreSetId`  string , `EmailPaymentTokenId`  string , `Result`  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_moloEmailStatementAuditSet/2026-04-17/1776412702'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailstatementauditset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailstatementauditset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}