Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripefeebatchset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717669

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-17/1776412861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-17/1776412861
id: 1717669
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 162167648
updated: 2026-04-17 03:06:20

Version 1716458

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-16/1776326615'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-16/1776326615
id: 1716458
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 162111893
updated: 2026-04-16 03:10:12

Version 1715329

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-15/1776240085'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-15/1776240085
id: 1715329
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 162056121
updated: 2026-04-15 03:10:42

Version 1713990

created: 2026-04-14 03:04:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-14/1776153856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-14/1776153856
id: 1713990
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 162000434
updated: 2026-04-14 03:05:03

Version 1712844

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-13/1776067010'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-13/1776067010
id: 1712844
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161941914
updated: 2026-04-13 03:00:44

Version 1711677

created: 2026-04-12 03:04:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-12/1775980719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-12/1775980719
id: 1711677
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161893177
updated: 2026-04-12 03:04:14

Version 1710443

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-11/1775894487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-11/1775894487
id: 1710443
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161841229
updated: 2026-04-11 03:06:28

Version 1709399

created: 2026-04-10 03:12:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-10/1775808246'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-10/1775808246
id: 1709399
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161786103
updated: 2026-04-10 03:12:13

Version 1708214

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-09/1775721577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-09/1775721577
id: 1708214
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161730463
updated: 2026-04-09 03:07:39

Version 1707027

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-08/1775635407'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-08/1775635407
id: 1707027
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161675691
updated: 2026-04-08 03:10:42

Version 1705790

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-07/1775548566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-07/1775548566
id: 1705790
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161618813
updated: 2026-04-07 03:00:42

Version 1704609

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-06/1775462522'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-06/1775462522
id: 1704609
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161561756
updated: 2026-04-06 03:10:47

Version 1703308

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-05/1775376148'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-05/1775376148
id: 1703308
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161514886
updated: 2026-04-05 03:05:39

Version 1702129

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-04/1775289633'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-04/1775289633
id: 1702129
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161460304
updated: 2026-04-04 03:04:14

Version 1701080

created: 2026-04-03 03:17:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-03/1775203404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeBatchSet/2026-04-03/1775203404
id: 1701080
processed: 1

raw_data:

{
    "ACHCreationDateTime": 3,
    "ACHSuccess": 4,
    "ChargedSuccessfully": 6,
    "CreationDateTime": 1,
    "FeeTotal": 2,
    "Id": 0,
    "MarinaLocation_Id": 5,
    "StripeChargeId": 7
}

schema_attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

schema_name_id: 1717
schema_scan_id: 161402079
updated: 2026-04-03 03:17:59

Schema Scans: 15

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

Scan 162167648

duration: 0:00:14.309438

exit_message:

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

id: 162167648

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_moloStripeFeeBatchSet/2026-04-17/1776412861",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-17/1776412861/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7053670475835782580,
        "service_name": "drive-thru",
        "span_id": 18064548664638078474,
        "trace_id": 6681137680150143846
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-17 03:06:06
success: True
trace_id: 6681137680150143846

Scan 162111893

duration: 0:00:14.274249

exit_message:

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

id: 162111893

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_moloStripeFeeBatchSet/2026-04-16/1776326615",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-16/1776326615/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7241715202440675462,
        "service_name": "drive-thru",
        "span_id": 14113223286796401708,
        "trace_id": 8950418870862920716
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-16 03:09:58
success: True
trace_id: 8950418870862920716

Scan 162056121

duration: 0:00:14.431510

exit_message:

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

id: 162056121

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_moloStripeFeeBatchSet/2026-04-15/1776240085",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-15/1776240085/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 386005645256193786,
        "service_name": "drive-thru",
        "span_id": 5193736654448031438,
        "trace_id": 3478399401631652314
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-15 03:10:28
success: True
trace_id: 3478399401631652314

Scan 162000434

duration: 0:00:14.226883

exit_message:

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

id: 162000434

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_moloStripeFeeBatchSet/2026-04-14/1776153856",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-14/1776153856/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15341221337400071529,
        "service_name": "drive-thru",
        "span_id": 7781032515617435998,
        "trace_id": 2924327693172126321
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-14 03:04:49
success: True
trace_id: 2924327693172126321

Scan 161941914

duration: 0:00:11.775385

exit_message:

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

id: 161941914

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_moloStripeFeeBatchSet/2026-04-13/1776067010",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-13/1776067010/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12831308397629716583,
        "service_name": "drive-thru",
        "span_id": 3892007237275927848,
        "trace_id": 1020822768796238049
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-13 03:00:32
success: True
trace_id: 1020822768796238049

Scan 161893177

duration: 0:00:14.378521

exit_message:

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

id: 161893177

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_moloStripeFeeBatchSet/2026-04-12/1775980719",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-12/1775980719/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4697903479049540972,
        "service_name": "drive-thru",
        "span_id": 13418572273317263404,
        "trace_id": 14980989250151188252
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-12 03:03:59
success: True
trace_id: 14980989250151188252

Scan 161841229

duration: 0:00:14.222201

exit_message:

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

id: 161841229

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_moloStripeFeeBatchSet/2026-04-11/1775894487",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-11/1775894487/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9153963807590859489,
        "service_name": "drive-thru",
        "span_id": 14302496932988065337,
        "trace_id": 4947493830060145422
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-11 03:06:14
success: True
trace_id: 4947493830060145422

Scan 161786103

duration: 0:00:11.976686

exit_message:

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

id: 161786103

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_moloStripeFeeBatchSet/2026-04-10/1775808246",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-10/1775808246/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16741912330976750809,
        "service_name": "drive-thru",
        "span_id": 3089017836353796261,
        "trace_id": 12834229235104356960
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-10 03:12:02
success: True
trace_id: 12834229235104356960

Scan 161730463

duration: 0:00:11.863041

exit_message:

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

id: 161730463

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_moloStripeFeeBatchSet/2026-04-09/1775721577",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-09/1775721577/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15032798142227335438,
        "service_name": "drive-thru",
        "span_id": 4719193163630533803,
        "trace_id": 14603605690212044877
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-09 03:07:28
success: True
trace_id: 14603605690212044877

Scan 161675691

duration: 0:00:14.279626

exit_message:

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

id: 161675691

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_moloStripeFeeBatchSet/2026-04-08/1775635407",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-08/1775635407/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18070400400568228510,
        "service_name": "drive-thru",
        "span_id": 10784118437191927119,
        "trace_id": 12859250295052500251
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-08 03:10:28
success: True
trace_id: 12859250295052500251

Scan 161618813

duration: 0:00:14.309539

exit_message:

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

id: 161618813

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_moloStripeFeeBatchSet/2026-04-07/1775548566",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-07/1775548566/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1668970759728277439,
        "service_name": "drive-thru",
        "span_id": 8354948394685677415,
        "trace_id": 8587392074255395145
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-07 03:00:27
success: True
trace_id: 8587392074255395145

Scan 161561756

duration: 0:00:14.334369

exit_message:

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

id: 161561756

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_moloStripeFeeBatchSet/2026-04-06/1775462522",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-06/1775462522/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12195275789745458310,
        "service_name": "drive-thru",
        "span_id": 15101991526444732264,
        "trace_id": 11341774052810537701
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-06 03:10:33
success: True
trace_id: 11341774052810537701

Scan 161514886

duration: 0:00:14.269713

exit_message:

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

id: 161514886

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_moloStripeFeeBatchSet/2026-04-05/1775376148",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-05/1775376148/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7916628213435792,
        "service_name": "drive-thru",
        "span_id": 11267747526197136827,
        "trace_id": 6221367970321421902
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-05 03:05:25
success: True
trace_id: 6221367970321421902

Scan 161460304

duration: 0:00:11.663775

exit_message:

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

id: 161460304

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_moloStripeFeeBatchSet/2026-04-04/1775289633",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-04/1775289633/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7801513803638824829,
        "service_name": "drive-thru",
        "span_id": 7886613938535109722,
        "trace_id": 728080445159255111
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-04 03:04:03
success: True
trace_id: 728080445159255111

Scan 161402079

duration: 0:00:14.350862

exit_message:

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

id: 161402079

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_moloStripeFeeBatchSet/2026-04-03/1775203404",
        "key": "raw/molo_moloStripeFeeBatchSet/2026-04-03/1775203404/StripeFeeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11090801504782818792,
        "service_name": "drive-thru",
        "span_id": 4459479897129139181,
        "trace_id": 8410267665628914058
    }
}

running: False
schema_name_id: 1717
start_time: 2026-04-03 03:17:45
success: True
trace_id: 8410267665628914058

Partitions:

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

Schema:

attributes:

{
    "ACHCreationDateTime": "string",
    "ACHSuccess": "string",
    "ChargedSuccessfully": "string",
    "CreationDateTime": "string",
    "FeeTotal": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "StripeChargeId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-17/1776412861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
}

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:28",
        "disabled": false,
        "format": "raw",
        "id": 1717,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molostripefeebatchset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ACHCreationDateTime": "string",
            "ACHSuccess": "string",
            "ChargedSuccessfully": "string",
            "CreationDateTime": "string",
            "FeeTotal": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "StripeChargeId": "string"
        },
        "created": "2026-04-17 03:06:07",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeebatchset`\n(\n `Id`  string , `CreationDateTime`  string , `FeeTotal`  string , `ACHCreationDateTime`  string , `ACHSuccess`  string , `MarinaLocation_Id`  string , `ChargedSuccessfully`  string , `StripeChargeId`  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_moloStripeFeeBatchSet/2026-04-17/1776412861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeebatchset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeebatchset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}