Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripefeeset

created: 2023-10-17 02:01:50
disabled: False
format: raw
id: 1782
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717774

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-17/1776412991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-17/1776412991
id: 1717774
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 162167797
updated: 2026-04-17 03:10:40

Version 1716598

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-16/1776326691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-16/1776326691
id: 1716598
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 162112062
updated: 2026-04-16 03:15:27

Version 1715400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-15/1776240179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-15/1776240179
id: 1715400
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 162056212
updated: 2026-04-15 03:14:19

Version 1714213

created: 2026-04-14 03:13:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-14/1776154122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-14/1776154122
id: 1714213
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 162000737
updated: 2026-04-14 03:13:51

Version 1712960

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-13/1776067124'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-13/1776067124
id: 1712960
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161942769
updated: 2026-04-13 03:06:43

Version 1711786

created: 2026-04-12 03:15:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-12/1775980818'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-12/1775980818
id: 1711786
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161893533
updated: 2026-04-12 03:16:02

Version 1710574

created: 2026-04-11 03:11:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-11/1775894589'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-11/1775894589
id: 1710574
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161841381
updated: 2026-04-11 03:11:51

Version 1709424

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-10/1775808350'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-10/1775808350
id: 1709424
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161786132
updated: 2026-04-10 03:13:24

Version 1708151

created: 2026-04-09 03:04:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-09/1775721677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-09/1775721677
id: 1708151
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161730337
updated: 2026-04-09 03:04:48

Version 1707081

created: 2026-04-08 03:13:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-08/1775635512'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-08/1775635512
id: 1707081
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161675760
updated: 2026-04-08 03:13:25

Version 1705852

created: 2026-04-07 03:03:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-07/1775548677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-07/1775548677
id: 1705852
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161619358
updated: 2026-04-07 03:03:47

Version 1704515

created: 2026-04-06 03:06:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-06/1775462625'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-06/1775462625
id: 1704515
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161561610
updated: 2026-04-06 03:06:58

Version 1703455

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-05/1775376252'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-05/1775376252
id: 1703455
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161515045
updated: 2026-04-05 03:11:22

Version 1702207

created: 2026-04-04 03:07:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-04/1775289738'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-04/1775289738
id: 1702207
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161460489
updated: 2026-04-04 03:08:07

Version 1701049

created: 2026-04-03 03:14:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-03/1775203505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeFeeSet/2026-04-03/1775203505
id: 1701049
processed: 1

raw_data:

{
    "ActivityAt": 6,
    "ActivityEndDate": 17,
    "ActivityIntervalType": 15,
    "ActivityStartDate": 16,
    "Amount": 8,
    "BalanceTransactionComponent": 4,
    "BalanceTransactionCreatedAt": 2,
    "BalanceTransactionDescription": 5,
    "BalanceTransactionId": 1,
    "BalanceTransactionReportingCategory": 3,
    "CardBrand": 20,
    "CardCountry": 22,
    "CardFunding": 21,
    "ChargeId": 9,
    "Currency": 7,
    "CustomerFacingCurrency": 14,
    "DestinationAccountId": 12,
    "EventType": 13,
    "FeeId": 11,
    "Id": 0,
    "InvoiceId": 10,
    "PaymentIntentId": 18,
    "PaymentMethodType": 19
}

schema_attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

schema_name_id: 1782
schema_scan_id: 161402032
updated: 2026-04-03 03:14:52

Schema Scans: 15

Last at 2026-04-17 03:10:27

Scan 162167797

duration: 0:00:12.560952

exit_message:

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

id: 162167797

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_moloStripeFeeSet/2026-04-17/1776412991",
        "key": "raw/molo_moloStripeFeeSet/2026-04-17/1776412991/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9129822970286915132,
        "service_name": "drive-thru",
        "span_id": 8938153304233150224,
        "trace_id": 4519198976459853844
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-17 03:10:27
success: True
trace_id: 4519198976459853844

Scan 162112062

duration: 0:00:12.276032

exit_message:

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

id: 162112062

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_moloStripeFeeSet/2026-04-16/1776326691",
        "key": "raw/molo_moloStripeFeeSet/2026-04-16/1776326691/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3345553919364915206,
        "service_name": "drive-thru",
        "span_id": 1390458538278508523,
        "trace_id": 15107117645951653330
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-16 03:15:15
success: True
trace_id: 15107117645951653330

Scan 162056212

duration: 0:00:14.794375

exit_message:

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

id: 162056212

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_moloStripeFeeSet/2026-04-15/1776240179",
        "key": "raw/molo_moloStripeFeeSet/2026-04-15/1776240179/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2801318178137483423,
        "service_name": "drive-thru",
        "span_id": 5959366388922521162,
        "trace_id": 15121826183837626691
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-15 03:14:04
success: True
trace_id: 15121826183837626691

Scan 162000737

duration: 0:00:14.781178

exit_message:

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

id: 162000737

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_moloStripeFeeSet/2026-04-14/1776154122",
        "key": "raw/molo_moloStripeFeeSet/2026-04-14/1776154122/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9064588773735009695,
        "service_name": "drive-thru",
        "span_id": 12643549964043073159,
        "trace_id": 16765437331218097979
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-14 03:13:37
success: True
trace_id: 16765437331218097979

Scan 161942769

duration: 0:00:14.887161

exit_message:

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

id: 161942769

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_moloStripeFeeSet/2026-04-13/1776067124",
        "key": "raw/molo_moloStripeFeeSet/2026-04-13/1776067124/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2069819197870798335,
        "service_name": "drive-thru",
        "span_id": 17034282168925344158,
        "trace_id": 14645148470175668835
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-13 03:06:28
success: True
trace_id: 14645148470175668835

Scan 161893533

duration: 0:00:14.820287

exit_message:

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

id: 161893533

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_moloStripeFeeSet/2026-04-12/1775980818",
        "key": "raw/molo_moloStripeFeeSet/2026-04-12/1775980818/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11480049917175037432,
        "service_name": "drive-thru",
        "span_id": 407540057026173840,
        "trace_id": 8965498975761760463
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-12 03:15:47
success: True
trace_id: 8965498975761760463

Scan 161841381

duration: 0:00:14.919882

exit_message:

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

id: 161841381

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_moloStripeFeeSet/2026-04-11/1775894589",
        "key": "raw/molo_moloStripeFeeSet/2026-04-11/1775894589/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11723407820940978198,
        "service_name": "drive-thru",
        "span_id": 1837608558860726967,
        "trace_id": 16129920607450988463
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-11 03:11:36
success: True
trace_id: 16129920607450988463

Scan 161786132

duration: 0:00:15.015177

exit_message:

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

id: 161786132

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_moloStripeFeeSet/2026-04-10/1775808350",
        "key": "raw/molo_moloStripeFeeSet/2026-04-10/1775808350/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7483045112058042956,
        "service_name": "drive-thru",
        "span_id": 2215020744329112403,
        "trace_id": 16526001526298529116
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-10 03:13:09
success: True
trace_id: 16526001526298529116

Scan 161730337

duration: 0:00:12.308467

exit_message:

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

id: 161730337

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_moloStripeFeeSet/2026-04-09/1775721677",
        "key": "raw/molo_moloStripeFeeSet/2026-04-09/1775721677/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12001699686414626247,
        "service_name": "drive-thru",
        "span_id": 17695600898090623799,
        "trace_id": 2561559733457449180
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-09 03:04:36
success: True
trace_id: 2561559733457449180

Scan 161675760

duration: 0:00:12.250432

exit_message:

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

id: 161675760

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_moloStripeFeeSet/2026-04-08/1775635512",
        "key": "raw/molo_moloStripeFeeSet/2026-04-08/1775635512/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 465856612289722714,
        "service_name": "drive-thru",
        "span_id": 1407354897406017781,
        "trace_id": 7342700053028420770
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-08 03:13:13
success: True
trace_id: 7342700053028420770

Scan 161619358

duration: 0:00:14.823914

exit_message:

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

id: 161619358

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_moloStripeFeeSet/2026-04-07/1775548677",
        "key": "raw/molo_moloStripeFeeSet/2026-04-07/1775548677/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3236645654087114994,
        "service_name": "drive-thru",
        "span_id": 9154668023373101662,
        "trace_id": 17622004162393004171
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-07 03:03:32
success: True
trace_id: 17622004162393004171

Scan 161561610

duration: 0:00:14.835446

exit_message:

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

id: 161561610

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_moloStripeFeeSet/2026-04-06/1775462625",
        "key": "raw/molo_moloStripeFeeSet/2026-04-06/1775462625/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7540084955236896864,
        "service_name": "drive-thru",
        "span_id": 1720631506277781423,
        "trace_id": 10630458528340152142
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-06 03:06:43
success: True
trace_id: 10630458528340152142

Scan 161515045

duration: 0:00:14.914289

exit_message:

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

id: 161515045

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_moloStripeFeeSet/2026-04-05/1775376252",
        "key": "raw/molo_moloStripeFeeSet/2026-04-05/1775376252/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3721732557206377550,
        "service_name": "drive-thru",
        "span_id": 7937019106173400867,
        "trace_id": 13732558143506343909
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-05 03:11:07
success: True
trace_id: 13732558143506343909

Scan 161460489

duration: 0:00:14.797941

exit_message:

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

id: 161460489

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_moloStripeFeeSet/2026-04-04/1775289738",
        "key": "raw/molo_moloStripeFeeSet/2026-04-04/1775289738/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7624015969574912110,
        "service_name": "drive-thru",
        "span_id": 11281056386682309942,
        "trace_id": 3901993412003289073
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-04 03:07:52
success: True
trace_id: 3901993412003289073

Scan 161402032

duration: 0:00:14.863639

exit_message:

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

id: 161402032

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_moloStripeFeeSet/2026-04-03/1775203505",
        "key": "raw/molo_moloStripeFeeSet/2026-04-03/1775203505/StripeFeeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeFeeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14971398647439826760,
        "service_name": "drive-thru",
        "span_id": 10288464073672823976,
        "trace_id": 246880409284470389
    }
}

running: False
schema_name_id: 1782
start_time: 2026-04-03 03:14:37
success: True
trace_id: 246880409284470389

Partitions:

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

Schema:

attributes:

{
    "ActivityAt": "string",
    "ActivityEndDate": "string",
    "ActivityIntervalType": "string",
    "ActivityStartDate": "string",
    "Amount": "string",
    "BalanceTransactionComponent": "string",
    "BalanceTransactionCreatedAt": "string",
    "BalanceTransactionDescription": "string",
    "BalanceTransactionId": "string",
    "BalanceTransactionReportingCategory": "string",
    "CardBrand": "string",
    "CardCountry": "string",
    "CardFunding": "string",
    "ChargeId": "string",
    "Currency": "string",
    "CustomerFacingCurrency": "string",
    "DestinationAccountId": "string",
    "EventType": "string",
    "FeeId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "PaymentIntentId": "string",
    "PaymentMethodType": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-17/1776412991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:01:50",
        "disabled": false,
        "format": "raw",
        "id": 1782,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molostripefeeset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ActivityAt": "string",
            "ActivityEndDate": "string",
            "ActivityIntervalType": "string",
            "ActivityStartDate": "string",
            "Amount": "string",
            "BalanceTransactionComponent": "string",
            "BalanceTransactionCreatedAt": "string",
            "BalanceTransactionDescription": "string",
            "BalanceTransactionId": "string",
            "BalanceTransactionReportingCategory": "string",
            "CardBrand": "string",
            "CardCountry": "string",
            "CardFunding": "string",
            "ChargeId": "string",
            "Currency": "string",
            "CustomerFacingCurrency": "string",
            "DestinationAccountId": "string",
            "EventType": "string",
            "FeeId": "string",
            "Id": "string",
            "InvoiceId": "string",
            "PaymentIntentId": "string",
            "PaymentMethodType": "string"
        },
        "created": "2026-04-17 03:10:29",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripefeeset`\n(\n `Id`  string , `BalanceTransactionId`  string , `BalanceTransactionCreatedAt`  string , `BalanceTransactionReportingCategory`  string , `BalanceTransactionComponent`  string , `BalanceTransactionDescription`  string , `ActivityAt`  string , `Currency`  string , `Amount`  string , `ChargeId`  string , `InvoiceId`  string , `FeeId`  string , `DestinationAccountId`  string , `EventType`  string , `CustomerFacingCurrency`  string , `ActivityIntervalType`  string , `ActivityStartDate`  string , `ActivityEndDate`  string , `PaymentIntentId`  string , `PaymentMethodType`  string , `CardBrand`  string , `CardFunding`  string , `CardCountry`  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_moloStripeFeeSet/2026-04-17/1776412991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripefeeset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripefeeset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}