Schema Info
Schema Name: sfdl_prod_drivethru.molo_molostripetransactiondataset
- created: 2023-10-17 02:01:45
- disabled: False
- format: raw
- id: 1780
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molostripetransactiondataset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717759
- created: 2026-04-17 03:09:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-17/1776412994
- id: 1717759
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 162167772
- updated: 2026-04-17 03:10:03
-
Version 1716581
- created: 2026-04-16 03:14:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-16/1776326693'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-16/1776326693
- id: 1716581
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 162112044
- updated: 2026-04-16 03:14:56
-
Version 1715326
- created: 2026-04-15 03:10:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-15/1776240183'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-15/1776240183
- id: 1715326
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 162056118
- updated: 2026-04-15 03:10:29
-
Version 1714149
- created: 2026-04-14 03:11:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-14/1776154134'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-14/1776154134
- id: 1714149
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 162000669
- updated: 2026-04-14 03:11:23
-
Version 1712880
- created: 2026-04-13 03:02:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-13/1776067130'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-13/1776067130
- id: 1712880
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161942406
- updated: 2026-04-13 03:02:52
-
Version 1711674
- created: 2026-04-12 03:03:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-12/1775980825'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-12/1775980825
- id: 1711674
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161893159
- updated: 2026-04-12 03:04:09
-
Version 1710561
- created: 2026-04-11 03:10:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-11/1775894595'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-11/1775894595
- id: 1710561
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161841366
- updated: 2026-04-11 03:11:10
-
Version 1709395
- created: 2026-04-10 03:11:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-10/1775808358'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-10/1775808358
- id: 1709395
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161786098
- updated: 2026-04-10 03:12:03
-
Version 1708246
- created: 2026-04-09 03:08:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-09/1775721684'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-09/1775721684
- id: 1708246
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161730513
- updated: 2026-04-09 03:09:02
-
Version 1706941
- created: 2026-04-08 03:07:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-08/1775635519'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-08/1775635519
- id: 1706941
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161675585
- updated: 2026-04-08 03:07:28
-
Version 1705821
- created: 2026-04-07 03:02:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-07/1775548683'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-07/1775548683
- id: 1705821
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161619214
- updated: 2026-04-07 03:02:21
-
Version 1704585
- created: 2026-04-06 03:09:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-06/1775462633'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-06/1775462633
- id: 1704585
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161561723
- updated: 2026-04-06 03:09:50
-
Version 1703379
- created: 2026-04-05 03:08:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-05/1775376261'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-05/1775376261
- id: 1703379
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161514961
- updated: 2026-04-05 03:08:28
-
Version 1702294
- created: 2026-04-04 03:11:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-04/1775289746'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-04/1775289746
- id: 1702294
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161460623
- updated: 2026-04-04 03:12:03
-
Version 1701053
- created: 2026-04-03 03:14:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-03/1775203513'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeTransactionDataSet/2026-04-03/1775203513
- id: 1701053
- processed: 1
- raw_data:
{ "ACHFeeAmount": 55, "Amount": 2, "AmountRefunded": 3, "Application": 4, "ApplicationFee": 5, "AvailableOn": 37, "BalanceTransaction": 6, "CCInfo": 50, "Captured": 7, "CreatedDateTime": 8, "CreationUser_Id": 33, "Currencies_Id": 34, "Currency": 38, "Customer": 9, "Description": 10, "Destination": 11, "Dispute": 12, "ExchangeRate": 39, "FailedACHFee": 56, "FailureCode": 13, "FailureMessage": 14, "Fee": 40, "FeeAmount": 41, "FeeApplication": 42, "FeeCurrency": 43, "FeeDescription": 44, "FeeType": 45, "FlatCCFee": 52, "Funding": 57, "Id": 0, "IsCardPresent": 58, "LiveMode": 15, "MoloFee": 47, "Net": 46, "Object": 1, "OnBehalfOf": 16, "Order": 17, "OutcomeNetworkStatus": 18, "OutcomeReason": 19, "OutcomeRiskLevel": 20, "OutcomeRule": 21, "OutcomeSellerMessage": 22, "OutcomeType": 23, "Paid": 24, "PaymentIntentId": 49, "PercentACHFee": 54, "PercentCCFee": 53, "ReceiptNumber": 25, "Refunded": 26, "Source": 27, "SourceTransfer": 28, "StatementDescriptor": 29, "Status": 30, "StripeAuthorizations_Id": 51, "StripeBatchId": 35, "StripeFeeBatchId": 48, "Transaction_Id": 36, "Transfer": 31, "TransferGroup": 32 } - schema_attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - schema_name_id: 1780
- schema_scan_id: 161402042
- updated: 2026-04-03 03:15:09
Schema Scans: 15
Last at 2026-04-17 03:09:50
-
Scan 162167772
- duration: 0:00:13.182266
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167772
- 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_moloStripeTransactionDataSet/2026-04-17/1776412994", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-17/1776412994/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6117578158034222898, "service_name": "drive-thru", "span_id": 13452253704287246569, "trace_id": 8651346194548602976 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-17 03:09:50
- success: True
- trace_id: 8651346194548602976
-
Scan 162112044
- duration: 0:00:15.975398
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112044
- 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_moloStripeTransactionDataSet/2026-04-16/1776326693", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-16/1776326693/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4864658916410743812, "service_name": "drive-thru", "span_id": 9555715999824110420, "trace_id": 5141555654653927734 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-16 03:14:40
- success: True
- trace_id: 5141555654653927734
-
Scan 162056118
- duration: 0:00:15.868256
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056118
- 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_moloStripeTransactionDataSet/2026-04-15/1776240183", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-15/1776240183/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16513748986899656792, "service_name": "drive-thru", "span_id": 8248102043129589214, "trace_id": 12095331047047610758 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-15 03:10:13
- success: True
- trace_id: 12095331047047610758
-
Scan 162000669
- duration: 0:00:13.134345
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000669
- 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_moloStripeTransactionDataSet/2026-04-14/1776154134", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-14/1776154134/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9719306253709195994, "service_name": "drive-thru", "span_id": 16116401455095674674, "trace_id": 854100374490783159 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-14 03:11:10
- success: True
- trace_id: 854100374490783159
-
Scan 161942406
- duration: 0:00:15.978931
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942406
- 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_moloStripeTransactionDataSet/2026-04-13/1776067130", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-13/1776067130/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12093493032718009333, "service_name": "drive-thru", "span_id": 13747671370626891654, "trace_id": 2032294944160084373 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-13 03:02:36
- success: True
- trace_id: 2032294944160084373
-
Scan 161893159
- duration: 0:00:15.766554
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893159
- 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_moloStripeTransactionDataSet/2026-04-12/1775980825", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-12/1775980825/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18251622453113200391, "service_name": "drive-thru", "span_id": 14085093204168277085, "trace_id": 3961709885024547915 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-12 03:03:53
- success: True
- trace_id: 3961709885024547915
-
Scan 161841366
- duration: 0:00:15.684348
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841366
- 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_moloStripeTransactionDataSet/2026-04-11/1775894595", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-11/1775894595/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1003762280156385779, "service_name": "drive-thru", "span_id": 1722658450273712407, "trace_id": 8188943432221882934 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-11 03:10:54
- success: True
- trace_id: 8188943432221882934
-
Scan 161786098
- duration: 0:00:13.137734
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786098
- 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_moloStripeTransactionDataSet/2026-04-10/1775808358", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-10/1775808358/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13139177482330246986, "service_name": "drive-thru", "span_id": 4615309172239244140, "trace_id": 5051035595759393426 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-10 03:11:50
- success: True
- trace_id: 5051035595759393426
-
Scan 161730513
- duration: 0:00:13.344723
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730513
- 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_moloStripeTransactionDataSet/2026-04-09/1775721684", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-09/1775721684/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2690301388728344925, "service_name": "drive-thru", "span_id": 6955617720019219545, "trace_id": 17941318285199592748 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-09 03:08:48
- success: True
- trace_id: 17941318285199592748
-
Scan 161675585
- duration: 0:00:13.355107
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675585
- 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_moloStripeTransactionDataSet/2026-04-08/1775635519", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-08/1775635519/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1228290696464987457, "service_name": "drive-thru", "span_id": 14523483678384201391, "trace_id": 10570956620877165151 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-08 03:07:14
- success: True
- trace_id: 10570956620877165151
-
Scan 161619214
- duration: 0:00:15.922550
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619214
- 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_moloStripeTransactionDataSet/2026-04-07/1775548683", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-07/1775548683/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14342759122944801263, "service_name": "drive-thru", "span_id": 8268193077672890646, "trace_id": 1441238229270787823 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-07 03:02:05
- success: True
- trace_id: 1441238229270787823
-
Scan 161561723
- duration: 0:00:15.659013
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561723
- 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_moloStripeTransactionDataSet/2026-04-06/1775462633", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-06/1775462633/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11076486149748410374, "service_name": "drive-thru", "span_id": 2078130053825524916, "trace_id": 16004045665149716307 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-06 03:09:34
- success: True
- trace_id: 16004045665149716307
-
Scan 161514961
- duration: 0:00:13.113189
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514961
- 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_moloStripeTransactionDataSet/2026-04-05/1775376261", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-05/1775376261/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17241012278641862044, "service_name": "drive-thru", "span_id": 9728446956714018995, "trace_id": 10553523299289751258 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-05 03:08:15
- success: True
- trace_id: 10553523299289751258
-
Scan 161460623
- duration: 0:00:15.820142
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460623
- 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_moloStripeTransactionDataSet/2026-04-04/1775289746", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-04/1775289746/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14707979700674115896, "service_name": "drive-thru", "span_id": 16367717346625184878, "trace_id": 17076953370718698829 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-04 03:11:47
- success: True
- trace_id: 17076953370718698829
-
Scan 161402042
- duration: 0:00:13.272533
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402042
- 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_moloStripeTransactionDataSet/2026-04-03/1775203513", "key": "raw/molo_moloStripeTransactionDataSet/2026-04-03/1775203513/StripeTransactionDataSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeTransactionDataSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 852516019165086163, "service_name": "drive-thru", "span_id": 13620872293362384806, "trace_id": 11957758407241218442 } } - running: False
- schema_name_id: 1780
- start_time: 2026-04-03 03:14:56
- success: True
- trace_id: 11957758407241218442
- attributes:
{ "ACHFeeAmount": "string", "Amount": "string", "AmountRefunded": "string", "Application": "string", "ApplicationFee": "string", "AvailableOn": "string", "BalanceTransaction": "string", "CCInfo": "string", "Captured": "string", "CreatedDateTime": "string", "CreationUser_Id": "string", "Currencies_Id": "string", "Currency": "string", "Customer": "string", "Description": "string", "Destination": "string", "Dispute": "string", "ExchangeRate": "string", "FailedACHFee": "string", "FailureCode": "string", "FailureMessage": "string", "Fee": "string", "FeeAmount": "string", "FeeApplication": "string", "FeeCurrency": "string", "FeeDescription": "string", "FeeType": "string", "FlatCCFee": "string", "Funding": "string", "Id": "string", "IsCardPresent": "string", "LiveMode": "string", "MoloFee": "string", "Net": "string", "Object": "string", "OnBehalfOf": "string", "Order": "string", "OutcomeNetworkStatus": "string", "OutcomeReason": "string", "OutcomeRiskLevel": "string", "OutcomeRule": "string", "OutcomeSellerMessage": "string", "OutcomeType": "string", "Paid": "string", "PaymentIntentId": "string", "PercentACHFee": "string", "PercentCCFee": "string", "ReceiptNumber": "string", "Refunded": "string", "Source": "string", "SourceTransfer": "string", "StatementDescriptor": "string", "Status": "string", "StripeAuthorizations_Id": "string", "StripeBatchId": "string", "StripeFeeBatchId": "string", "Transaction_Id": "string", "Transfer": "string", "TransferGroup": "string" } - created: 2026-04-17 03:09:52
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 02:01:45",
"disabled": false,
"format": "raw",
"id": 1780,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molostripetransactiondataset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"ACHFeeAmount": "string",
"Amount": "string",
"AmountRefunded": "string",
"Application": "string",
"ApplicationFee": "string",
"AvailableOn": "string",
"BalanceTransaction": "string",
"CCInfo": "string",
"Captured": "string",
"CreatedDateTime": "string",
"CreationUser_Id": "string",
"Currencies_Id": "string",
"Currency": "string",
"Customer": "string",
"Description": "string",
"Destination": "string",
"Dispute": "string",
"ExchangeRate": "string",
"FailedACHFee": "string",
"FailureCode": "string",
"FailureMessage": "string",
"Fee": "string",
"FeeAmount": "string",
"FeeApplication": "string",
"FeeCurrency": "string",
"FeeDescription": "string",
"FeeType": "string",
"FlatCCFee": "string",
"Funding": "string",
"Id": "string",
"IsCardPresent": "string",
"LiveMode": "string",
"MoloFee": "string",
"Net": "string",
"Object": "string",
"OnBehalfOf": "string",
"Order": "string",
"OutcomeNetworkStatus": "string",
"OutcomeReason": "string",
"OutcomeRiskLevel": "string",
"OutcomeRule": "string",
"OutcomeSellerMessage": "string",
"OutcomeType": "string",
"Paid": "string",
"PaymentIntentId": "string",
"PercentACHFee": "string",
"PercentCCFee": "string",
"ReceiptNumber": "string",
"Refunded": "string",
"Source": "string",
"SourceTransfer": "string",
"StatementDescriptor": "string",
"Status": "string",
"StripeAuthorizations_Id": "string",
"StripeBatchId": "string",
"StripeFeeBatchId": "string",
"Transaction_Id": "string",
"Transfer": "string",
"TransferGroup": "string"
},
"created": "2026-04-17 03:09:52",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripetransactiondataset`\n(\n `Id` string , `Object` string , `Amount` string , `AmountRefunded` string , `Application` string , `ApplicationFee` string , `BalanceTransaction` string , `Captured` string , `CreatedDateTime` string , `Customer` string , `Description` string , `Destination` string , `Dispute` string , `FailureCode` string , `FailureMessage` string , `LiveMode` string , `OnBehalfOf` string , `Order` string , `OutcomeNetworkStatus` string , `OutcomeReason` string , `OutcomeRiskLevel` string , `OutcomeRule` string , `OutcomeSellerMessage` string , `OutcomeType` string , `Paid` string , `ReceiptNumber` string , `Refunded` string , `Source` string , `SourceTransfer` string , `StatementDescriptor` string , `Status` string , `Transfer` string , `TransferGroup` string , `CreationUser_Id` string , `Currencies_Id` string , `StripeBatchId` string , `Transaction_Id` string , `AvailableOn` string , `Currency` string , `ExchangeRate` string , `Fee` string , `FeeAmount` string , `FeeApplication` string , `FeeCurrency` string , `FeeDescription` string , `FeeType` string , `Net` string , `MoloFee` string , `StripeFeeBatchId` string , `PaymentIntentId` string , `CCInfo` string , `StripeAuthorizations_Id` string , `FlatCCFee` string , `PercentCCFee` string , `PercentACHFee` string , `ACHFeeAmount` string , `FailedACHFee` string , `Funding` string , `IsCardPresent` 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_moloStripeTransactionDataSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripetransactiondataset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripetransactiondataset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}