Schema Info
Schema Name: sfdl_prod_drivethru.molo_molotransactions
- created: 2023-10-17 02:03:14
- disabled: False
- format: raw
- id: 1812
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molotransactions" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717765
- created: 2026-04-17 03:10:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-17/1776413222
- id: 1717765
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 162167783
- updated: 2026-04-17 03:10:19
-
Version 1716594
- created: 2026-04-16 03:15:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-16/1776326745'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-16/1776326745
- id: 1716594
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 162112057
- updated: 2026-04-16 03:15:21
-
Version 1715402
- created: 2026-04-15 03:14:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-15/1776240205'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-15/1776240205
- id: 1715402
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 162056214
- updated: 2026-04-15 03:14:22
-
Version 1714147
- created: 2026-04-14 03:11:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-14/1776154171'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-14/1776154171
- id: 1714147
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 162000667
- updated: 2026-04-14 03:11:21
-
Version 1712962
- created: 2026-04-13 03:06:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-13/1776067164'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-13/1776067164
- id: 1712962
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161942778
- updated: 2026-04-13 03:06:47
-
Version 1711739
- created: 2026-04-12 03:07:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-12/1775980867'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-12/1775980867
- id: 1711739
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161893429
- updated: 2026-04-12 03:07:39
-
Version 1710586
- created: 2026-04-11 03:12:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-11/1775894641'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-11/1775894641
- id: 1710586
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161841397
- updated: 2026-04-11 03:12:36
-
Version 1709410
- created: 2026-04-10 03:12:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-10/1775808398'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-10/1775808398
- id: 1709410
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161786114
- updated: 2026-04-10 03:12:45
-
Version 1708221
- created: 2026-04-09 03:07:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-09/1775721728'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-09/1775721728
- id: 1708221
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161730476
- updated: 2026-04-09 03:08:00
-
Version 1707082
- created: 2026-04-08 03:13:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-08/1775635557'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-08/1775635557
- id: 1707082
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161675759
- updated: 2026-04-08 03:13:25
-
Version 1705827
- created: 2026-04-07 03:02:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-07/1775548718'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-07/1775548718
- id: 1705827
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161619243
- updated: 2026-04-07 03:02:36
-
Version 1704666
- created: 2026-04-06 03:12:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-06/1775462668'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-06/1775462668
- id: 1704666
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161561820
- updated: 2026-04-06 03:12:49
-
Version 1703459
- created: 2026-04-05 03:11:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-05/1775376299'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-05/1775376299
- id: 1703459
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161515052
- updated: 2026-04-05 03:11:29
-
Version 1702281
- created: 2026-04-04 03:11:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-04/1775289782'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-04/1775289782
- id: 1702281
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161460595
- updated: 2026-04-04 03:11:17
-
Version 1701031
- created: 2026-04-03 03:13:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-03/1775203547'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransactions/2026-04-03/1775203547
- id: 1701031
- processed: 1
- raw_data:
{ "AccountTransaction_Transaction_Id": 20, "AmountRefunded": 28, "AspNetUser_Id": 23, "Aux": 11, "BankName": 41, "CCType": 13, "CheckNumber": 12, "CreatedOnMobile": 36, "CreationDate": 22, "CreationTime": 2, "CustomTransactionMethodsId": 25, "CustomerDevice": 9, "CustomerIPAddress": 8, "FullyRefunded": 46, "HashID": 24, "Id": 0, "InvoiceId": 3, "InvoiceItemId": 14, "IsRefunded": 7, "IsVoid": 27, "Last4": 42, "LastUpdated": 47, "MarinaLocationId": 1, "OnlineFeeAmount": 38, "OnlinePaymentFee_Id": 40, "OnlinePercentFee": 37, "OverpaymentID": 16, "PartOfOverpayment": 18, "PaymentCollectedOffline": 17, "PaymentIntentId": 30, "PaymentSource": 48, "Payment_Id": 21, "PrepaymentID": 19, "Reference": 26, "RefundReason": 10, "RoutingNumber": 45, "ScheduledForOnlineFeeCron": 39, "SentToPayout": 31, "SentToXero": 15, "StripeAuthorizations_Id": 32, "StripeBankAccountId": 43, "StripeBatchId": 44, "StripeReaderSerialNumber": 34, "StripeResponse_Id": 33, "StripeTerminalId": 35, "StripeTransactionDataId": 29, "TransactionMethodId": 5, "TransactionTypeId": 4, "Value": 6 } - schema_attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - schema_name_id: 1812
- schema_scan_id: 161402010
- updated: 2026-04-03 03:14:00
Schema Scans: 15
Last at 2026-04-17 03:10:04
-
Scan 162167783
- duration: 0:00:15.465181
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167783
- 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_moloTransactions/2026-04-17/1776413222", "key": "raw/molo_moloTransactions/2026-04-17/1776413222/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12997913023493891752, "service_name": "drive-thru", "span_id": 14155814878554098120, "trace_id": 16139889919152820899 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-17 03:10:04
- success: True
- trace_id: 16139889919152820899
-
Scan 162112057
- duration: 0:00:12.866991
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112057
- 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_moloTransactions/2026-04-16/1776326745", "key": "raw/molo_moloTransactions/2026-04-16/1776326745/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5202919712692188307, "service_name": "drive-thru", "span_id": 6671898474217608483, "trace_id": 17795331854718079147 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-16 03:15:08
- success: True
- trace_id: 17795331854718079147
-
Scan 162056214
- duration: 0:00:15.668963
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056214
- 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_moloTransactions/2026-04-15/1776240205", "key": "raw/molo_moloTransactions/2026-04-15/1776240205/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17350352627818008578, "service_name": "drive-thru", "span_id": 5716006424199293991, "trace_id": 14824715566999131414 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-15 03:14:06
- success: True
- trace_id: 14824715566999131414
-
Scan 162000667
- duration: 0:00:15.624132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000667
- 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_moloTransactions/2026-04-14/1776154171", "key": "raw/molo_moloTransactions/2026-04-14/1776154171/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10118099965345678660, "service_name": "drive-thru", "span_id": 11846001819773266889, "trace_id": 12512438832945189509 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-14 03:11:05
- success: True
- trace_id: 12512438832945189509
-
Scan 161942778
- duration: 0:00:12.997289
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942778
- 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_moloTransactions/2026-04-13/1776067164", "key": "raw/molo_moloTransactions/2026-04-13/1776067164/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10252448088214948952, "service_name": "drive-thru", "span_id": 13493458115689761976, "trace_id": 11197764433567278251 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-13 03:06:34
- success: True
- trace_id: 11197764433567278251
-
Scan 161893429
- duration: 0:00:15.567570
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893429
- 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_moloTransactions/2026-04-12/1775980867", "key": "raw/molo_moloTransactions/2026-04-12/1775980867/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3368109920437273364, "service_name": "drive-thru", "span_id": 16808850159450082507, "trace_id": 7319803178530276737 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-12 03:07:24
- success: True
- trace_id: 7319803178530276737
-
Scan 161841397
- duration: 0:00:15.527960
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841397
- 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_moloTransactions/2026-04-11/1775894641", "key": "raw/molo_moloTransactions/2026-04-11/1775894641/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11404772238082209494, "service_name": "drive-thru", "span_id": 1619953824620720884, "trace_id": 16485631137918084882 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-11 03:12:21
- success: True
- trace_id: 16485631137918084882
-
Scan 161786114
- duration: 0:00:13.127335
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786114
- 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_moloTransactions/2026-04-10/1775808398", "key": "raw/molo_moloTransactions/2026-04-10/1775808398/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3657319001103796779, "service_name": "drive-thru", "span_id": 15049978554703138126, "trace_id": 16449564988272568793 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-10 03:12:32
- success: True
- trace_id: 16449564988272568793
-
Scan 161730476
- duration: 0:00:15.606808
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730476
- 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_moloTransactions/2026-04-09/1775721728", "key": "raw/molo_moloTransactions/2026-04-09/1775721728/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7184891178868831283, "service_name": "drive-thru", "span_id": 17805678726956796661, "trace_id": 17053904572322820928 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-09 03:07:45
- success: True
- trace_id: 17053904572322820928
-
Scan 161675759
- duration: 0:00:13.007406
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675759
- 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_moloTransactions/2026-04-08/1775635557", "key": "raw/molo_moloTransactions/2026-04-08/1775635557/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10434637962787914399, "service_name": "drive-thru", "span_id": 10779375674150398168, "trace_id": 8698368443192319063 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-08 03:13:13
- success: True
- trace_id: 8698368443192319063
-
Scan 161619243
- duration: 0:00:15.301703
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619243
- 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_moloTransactions/2026-04-07/1775548718", "key": "raw/molo_moloTransactions/2026-04-07/1775548718/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12897962731548827297, "service_name": "drive-thru", "span_id": 10234048130717627316, "trace_id": 2339694413886102056 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-07 03:02:21
- success: True
- trace_id: 2339694413886102056
-
Scan 161561820
- duration: 0:00:13.054659
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561820
- 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_moloTransactions/2026-04-06/1775462668", "key": "raw/molo_moloTransactions/2026-04-06/1775462668/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2069299457910280532, "service_name": "drive-thru", "span_id": 9400052887041867929, "trace_id": 16342987782774985077 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-06 03:12:36
- success: True
- trace_id: 16342987782774985077
-
Scan 161515052
- duration: 0:00:13.001156
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161515052
- 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_moloTransactions/2026-04-05/1775376299", "key": "raw/molo_moloTransactions/2026-04-05/1775376299/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 172868711652848819, "service_name": "drive-thru", "span_id": 16022249890852599587, "trace_id": 16311704832392920319 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-05 03:11:16
- success: True
- trace_id: 16311704832392920319
-
Scan 161460595
- duration: 0:00:13.071563
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460595
- 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_moloTransactions/2026-04-04/1775289782", "key": "raw/molo_moloTransactions/2026-04-04/1775289782/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11876942205759980659, "service_name": "drive-thru", "span_id": 7982086295600062913, "trace_id": 5411615274674778227 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-04 03:11:04
- success: True
- trace_id: 5411615274674778227
-
Scan 161402010
- duration: 0:00:13.216929
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402010
- 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_moloTransactions/2026-04-03/1775203547", "key": "raw/molo_moloTransactions/2026-04-03/1775203547/Transactions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTransactions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17888573633682578709, "service_name": "drive-thru", "span_id": 3816795414455018238, "trace_id": 6570516876943284454 } } - running: False
- schema_name_id: 1812
- start_time: 2026-04-03 03:13:46
- success: True
- trace_id: 6570516876943284454
- attributes:
{ "AccountTransaction_Transaction_Id": "string", "AmountRefunded": "string", "AspNetUser_Id": "string", "Aux": "string", "BankName": "string", "CCType": "string", "CheckNumber": "string", "CreatedOnMobile": "string", "CreationDate": "string", "CreationTime": "string", "CustomTransactionMethodsId": "string", "CustomerDevice": "string", "CustomerIPAddress": "string", "FullyRefunded": "string", "HashID": "string", "Id": "string", "InvoiceId": "string", "InvoiceItemId": "string", "IsRefunded": "string", "IsVoid": "string", "Last4": "string", "LastUpdated": "string", "MarinaLocationId": "string", "OnlineFeeAmount": "string", "OnlinePaymentFee_Id": "string", "OnlinePercentFee": "string", "OverpaymentID": "string", "PartOfOverpayment": "string", "PaymentCollectedOffline": "string", "PaymentIntentId": "string", "PaymentSource": "string", "Payment_Id": "string", "PrepaymentID": "string", "Reference": "string", "RefundReason": "string", "RoutingNumber": "string", "ScheduledForOnlineFeeCron": "string", "SentToPayout": "string", "SentToXero": "string", "StripeAuthorizations_Id": "string", "StripeBankAccountId": "string", "StripeBatchId": "string", "StripeReaderSerialNumber": "string", "StripeResponse_Id": "string", "StripeTerminalId": "string", "StripeTransactionDataId": "string", "TransactionMethodId": "string", "TransactionTypeId": "string", "Value": "string" } - created: 2026-04-17 03:10:05
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions" }
- 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:03:14",
"disabled": false,
"format": "raw",
"id": 1812,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molotransactions"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"AccountTransaction_Transaction_Id": "string",
"AmountRefunded": "string",
"AspNetUser_Id": "string",
"Aux": "string",
"BankName": "string",
"CCType": "string",
"CheckNumber": "string",
"CreatedOnMobile": "string",
"CreationDate": "string",
"CreationTime": "string",
"CustomTransactionMethodsId": "string",
"CustomerDevice": "string",
"CustomerIPAddress": "string",
"FullyRefunded": "string",
"HashID": "string",
"Id": "string",
"InvoiceId": "string",
"InvoiceItemId": "string",
"IsRefunded": "string",
"IsVoid": "string",
"Last4": "string",
"LastUpdated": "string",
"MarinaLocationId": "string",
"OnlineFeeAmount": "string",
"OnlinePaymentFee_Id": "string",
"OnlinePercentFee": "string",
"OverpaymentID": "string",
"PartOfOverpayment": "string",
"PaymentCollectedOffline": "string",
"PaymentIntentId": "string",
"PaymentSource": "string",
"Payment_Id": "string",
"PrepaymentID": "string",
"Reference": "string",
"RefundReason": "string",
"RoutingNumber": "string",
"ScheduledForOnlineFeeCron": "string",
"SentToPayout": "string",
"SentToXero": "string",
"StripeAuthorizations_Id": "string",
"StripeBankAccountId": "string",
"StripeBatchId": "string",
"StripeReaderSerialNumber": "string",
"StripeResponse_Id": "string",
"StripeTerminalId": "string",
"StripeTransactionDataId": "string",
"TransactionMethodId": "string",
"TransactionTypeId": "string",
"Value": "string"
},
"created": "2026-04-17 03:10:05",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransactions`\n(\n `Id` string , `MarinaLocationId` string , `CreationTime` string , `InvoiceId` string , `TransactionTypeId` string , `TransactionMethodId` string , `Value` string , `IsRefunded` string , `CustomerIPAddress` string , `CustomerDevice` string , `RefundReason` string , `Aux` string , `CheckNumber` string , `CCType` string , `InvoiceItemId` string , `SentToXero` string , `OverpaymentID` string , `PaymentCollectedOffline` string , `PartOfOverpayment` string , `PrepaymentID` string , `AccountTransaction_Transaction_Id` string , `Payment_Id` string , `CreationDate` string , `AspNetUser_Id` string , `HashID` string , `CustomTransactionMethodsId` string , `Reference` string , `IsVoid` string , `AmountRefunded` string , `StripeTransactionDataId` string , `PaymentIntentId` string , `SentToPayout` string , `StripeAuthorizations_Id` string , `StripeResponse_Id` string , `StripeReaderSerialNumber` string , `StripeTerminalId` string , `CreatedOnMobile` string , `OnlinePercentFee` string , `OnlineFeeAmount` string , `ScheduledForOnlineFeeCron` string , `OnlinePaymentFee_Id` string , `BankName` string , `Last4` string , `StripeBankAccountId` string , `StripeBatchId` string , `RoutingNumber` string , `FullyRefunded` string , `LastUpdated` string , `PaymentSource` 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_moloTransactions/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransactions`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransactions"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}