Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripebatchset

created: 2023-10-17 01:57:54
disabled: False
format: raw
id: 1673
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717756

created: 2026-04-17 03:09:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-17/1776412853'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-17/1776412853
id: 1717756
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 162167767
updated: 2026-04-17 03:09:53

Version 1716410

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-16/1776326607'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-16/1776326607
id: 1716410
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 162111841
updated: 2026-04-16 03:08:27

Version 1715314

created: 2026-04-15 03:09:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-15/1776240077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-15/1776240077
id: 1715314
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 162056101
updated: 2026-04-15 03:09:55

Version 1714161

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-14/1776153843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-14/1776153843
id: 1714161
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 162000681
updated: 2026-04-14 03:11:50

Version 1712867

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-13/1776067001'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-13/1776067001
id: 1712867
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161942015
updated: 2026-04-13 03:01:28

Version 1711670

created: 2026-04-12 03:03:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-12/1775980712'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-12/1775980712
id: 1711670
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161893094
updated: 2026-04-12 03:03:47

Version 1710537

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-11/1775894480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-11/1775894480
id: 1710537
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161841336
updated: 2026-04-11 03:10:09

Version 1709398

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-10/1775808238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-10/1775808238
id: 1709398
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161786101
updated: 2026-04-10 03:12:13

Version 1708250

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-09/1775721570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-09/1775721570
id: 1708250
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161730519
updated: 2026-04-09 03:09:14

Version 1707024

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-08/1775635399'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-08/1775635399
id: 1707024
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161675689
updated: 2026-04-08 03:10:37

Version 1705782

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-07/1775548555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-07/1775548555
id: 1705782
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161618702
updated: 2026-04-07 03:00:12

Version 1704570

created: 2026-04-06 03:09:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-06/1775462514'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-06/1775462514
id: 1704570
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161561692
updated: 2026-04-06 03:09:13

Version 1703303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-05/1775376141'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-05/1775376141
id: 1703303
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161514880
updated: 2026-04-05 03:05:25

Version 1702190

created: 2026-04-04 03:06:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-04/1775289625'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-04/1775289625
id: 1702190
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161460438
updated: 2026-04-04 03:06:56

Version 1700967

created: 2026-04-03 03:10:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-03/1775203396'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeBatchSet/2026-04-03/1775203396
id: 1700967
processed: 1

raw_data:

{
    "BalanceTransactionId": 14,
    "DateTimeCreated": 6,
    "DestinationAccount": 17,
    "EstimatedArrivalDate": 12,
    "FailureCode": 18,
    "FailureMessage": 19,
    "Fee": 21,
    "HashID": 7,
    "Id": 0,
    "MarinaLocationId": 9,
    "NetPayout": 3,
    "PayoutId": 13,
    "PayoutMethod": 20,
    "PayoutSource": 15,
    "PayoutType": 16,
    "RunAgain": 10,
    "SuccessDateTime": 11,
    "TotalAdjustments": 23,
    "TotalMoloFees": 5,
    "TotalPayments": 1,
    "TotalRefunds": 2,
    "TotalStripeFees": 4,
    "TransactionCount": 8,
    "Type": 22
}

schema_attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

schema_name_id: 1673
schema_scan_id: 161401932
updated: 2026-04-03 03:11:03

Schema Scans: 15

Last at 2026-04-17 03:09:41

Scan 162167767

duration: 0:00:12.116093

exit_message:

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

id: 162167767

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_moloStripeBatchSet/2026-04-17/1776412853",
        "key": "raw/molo_moloStripeBatchSet/2026-04-17/1776412853/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2277441075557907065,
        "service_name": "drive-thru",
        "span_id": 11292316272641234263,
        "trace_id": 14454597905171676156
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-17 03:09:41
success: True
trace_id: 14454597905171676156

Scan 162111841

duration: 0:00:14.813554

exit_message:

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

id: 162111841

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_moloStripeBatchSet/2026-04-16/1776326607",
        "key": "raw/molo_moloStripeBatchSet/2026-04-16/1776326607/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1520930272846756195,
        "service_name": "drive-thru",
        "span_id": 16065511210899815878,
        "trace_id": 9666299740255001161
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-16 03:08:13
success: True
trace_id: 9666299740255001161

Scan 162056101

duration: 0:00:12.303649

exit_message:

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

id: 162056101

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_moloStripeBatchSet/2026-04-15/1776240077",
        "key": "raw/molo_moloStripeBatchSet/2026-04-15/1776240077/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9772266352449491996,
        "service_name": "drive-thru",
        "span_id": 13500700229598558139,
        "trace_id": 9453671095430315530
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-15 03:09:42
success: True
trace_id: 9453671095430315530

Scan 162000681

duration: 0:00:14.857403

exit_message:

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

id: 162000681

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_moloStripeBatchSet/2026-04-14/1776153843",
        "key": "raw/molo_moloStripeBatchSet/2026-04-14/1776153843/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9093714816814741919,
        "service_name": "drive-thru",
        "span_id": 16114071046452611969,
        "trace_id": 15891449733296308190
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-14 03:11:35
success: True
trace_id: 15891449733296308190

Scan 161942015

duration: 0:00:14.752232

exit_message:

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

id: 161942015

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_moloStripeBatchSet/2026-04-13/1776067001",
        "key": "raw/molo_moloStripeBatchSet/2026-04-13/1776067001/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12162369116216782860,
        "service_name": "drive-thru",
        "span_id": 16678066801189452787,
        "trace_id": 8469691346956768827
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-13 03:01:13
success: True
trace_id: 8469691346956768827

Scan 161893094

duration: 0:00:14.796663

exit_message:

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

id: 161893094

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_moloStripeBatchSet/2026-04-12/1775980712",
        "key": "raw/molo_moloStripeBatchSet/2026-04-12/1775980712/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17536752574335171723,
        "service_name": "drive-thru",
        "span_id": 17006263056970818850,
        "trace_id": 6947584532777163545
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-12 03:03:33
success: True
trace_id: 6947584532777163545

Scan 161841336

duration: 0:00:12.471529

exit_message:

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

id: 161841336

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_moloStripeBatchSet/2026-04-11/1775894480",
        "key": "raw/molo_moloStripeBatchSet/2026-04-11/1775894480/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5876759384472695150,
        "service_name": "drive-thru",
        "span_id": 9754441691198080453,
        "trace_id": 5377082071433246333
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-11 03:09:57
success: True
trace_id: 5377082071433246333

Scan 161786101

duration: 0:00:12.501051

exit_message:

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

id: 161786101

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_moloStripeBatchSet/2026-04-10/1775808238",
        "key": "raw/molo_moloStripeBatchSet/2026-04-10/1775808238/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5940760957312153080,
        "service_name": "drive-thru",
        "span_id": 13696312632411046272,
        "trace_id": 12971739196929793559
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-10 03:12:00
success: True
trace_id: 12971739196929793559

Scan 161730519

duration: 0:00:12.241358

exit_message:

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

id: 161730519

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_moloStripeBatchSet/2026-04-09/1775721570",
        "key": "raw/molo_moloStripeBatchSet/2026-04-09/1775721570/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14272095635584484396,
        "service_name": "drive-thru",
        "span_id": 14288933382550979779,
        "trace_id": 18023135263814576882
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-09 03:09:02
success: True
trace_id: 18023135263814576882

Scan 161675689

duration: 0:00:12.357214

exit_message:

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

id: 161675689

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_moloStripeBatchSet/2026-04-08/1775635399",
        "key": "raw/molo_moloStripeBatchSet/2026-04-08/1775635399/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4718647270321728474,
        "service_name": "drive-thru",
        "span_id": 10334256793528702014,
        "trace_id": 13355522399661909025
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-08 03:10:24
success: True
trace_id: 13355522399661909025

Scan 161618702

duration: 0:00:12.994586

exit_message:

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

id: 161618702

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_moloStripeBatchSet/2026-04-07/1775548555",
        "key": "raw/molo_moloStripeBatchSet/2026-04-07/1775548555/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1909627079089225142,
        "service_name": "drive-thru",
        "span_id": 757252273084918828,
        "trace_id": 17006027914855788056
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-07 02:59:59
success: True
trace_id: 17006027914855788056

Scan 161561692

duration: 0:00:14.931670

exit_message:

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

id: 161561692

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_moloStripeBatchSet/2026-04-06/1775462514",
        "key": "raw/molo_moloStripeBatchSet/2026-04-06/1775462514/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5412442068201068035,
        "service_name": "drive-thru",
        "span_id": 3098325871940045788,
        "trace_id": 2471537704684959626
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-06 03:08:58
success: True
trace_id: 2471537704684959626

Scan 161514880

duration: 0:00:14.997142

exit_message:

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

id: 161514880

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_moloStripeBatchSet/2026-04-05/1775376141",
        "key": "raw/molo_moloStripeBatchSet/2026-04-05/1775376141/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3042508697617023730,
        "service_name": "drive-thru",
        "span_id": 3688794222541791710,
        "trace_id": 8053588044727986775
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-05 03:05:10
success: True
trace_id: 8053588044727986775

Scan 161460438

duration: 0:00:12.368834

exit_message:

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

id: 161460438

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_moloStripeBatchSet/2026-04-04/1775289625",
        "key": "raw/molo_moloStripeBatchSet/2026-04-04/1775289625/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14208904507241780103,
        "service_name": "drive-thru",
        "span_id": 17816275700133815496,
        "trace_id": 11263803433354199004
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-04 03:06:44
success: True
trace_id: 11263803433354199004

Scan 161401932

duration: 0:00:12.192916

exit_message:

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

id: 161401932

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_moloStripeBatchSet/2026-04-03/1775203396",
        "key": "raw/molo_moloStripeBatchSet/2026-04-03/1775203396/StripeBatchSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeBatchSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18255186330850242944,
        "service_name": "drive-thru",
        "span_id": 3874116633902847923,
        "trace_id": 1846574953169495123
    }
}

running: False
schema_name_id: 1673
start_time: 2026-04-03 03:10:51
success: True
trace_id: 1846574953169495123

Partitions:

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

Schema:

attributes:

{
    "BalanceTransactionId": "string",
    "DateTimeCreated": "string",
    "DestinationAccount": "string",
    "EstimatedArrivalDate": "string",
    "FailureCode": "string",
    "FailureMessage": "string",
    "Fee": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NetPayout": "string",
    "PayoutId": "string",
    "PayoutMethod": "string",
    "PayoutSource": "string",
    "PayoutType": "string",
    "RunAgain": "string",
    "SuccessDateTime": "string",
    "TotalAdjustments": "string",
    "TotalMoloFees": "string",
    "TotalPayments": "string",
    "TotalRefunds": "string",
    "TotalStripeFees": "string",
    "TransactionCount": "string",
    "Type": "string"
}

created: 2026-04-17 03:09:42

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-17/1776412853'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:57:54",
        "disabled": false,
        "format": "raw",
        "id": 1673,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molostripebatchset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "BalanceTransactionId": "string",
            "DateTimeCreated": "string",
            "DestinationAccount": "string",
            "EstimatedArrivalDate": "string",
            "FailureCode": "string",
            "FailureMessage": "string",
            "Fee": "string",
            "HashID": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "NetPayout": "string",
            "PayoutId": "string",
            "PayoutMethod": "string",
            "PayoutSource": "string",
            "PayoutType": "string",
            "RunAgain": "string",
            "SuccessDateTime": "string",
            "TotalAdjustments": "string",
            "TotalMoloFees": "string",
            "TotalPayments": "string",
            "TotalRefunds": "string",
            "TotalStripeFees": "string",
            "TransactionCount": "string",
            "Type": "string"
        },
        "created": "2026-04-17 03:09:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripebatchset`\n(\n `Id`  string , `TotalPayments`  string , `TotalRefunds`  string , `NetPayout`  string , `TotalStripeFees`  string , `TotalMoloFees`  string , `DateTimeCreated`  string , `HashID`  string , `TransactionCount`  string , `MarinaLocationId`  string , `RunAgain`  string , `SuccessDateTime`  string , `EstimatedArrivalDate`  string , `PayoutId`  string , `BalanceTransactionId`  string , `PayoutSource`  string , `PayoutType`  string , `DestinationAccount`  string , `FailureCode`  string , `FailureMessage`  string , `PayoutMethod`  string , `Fee`  string , `Type`  string , `TotalAdjustments`  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_moloStripeBatchSet/2026-04-17/1776412853'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripebatchset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripebatchset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}