Schema Info

Schema Name: sfdl_prod_drivethru.molo_molofuelcloudtransactionsset

created: 2023-10-17 01:56:41
disabled: False
format: raw
id: 1638
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717616

created: 2026-04-17 03:03:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-17/1776412732
id: 1717616
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 162167432
updated: 2026-04-17 03:03:13

Version 1716382

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-16/1776326491'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-16/1776326491
id: 1716382
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 162111790
updated: 2026-04-16 03:07:14

Version 1715188

created: 2026-04-15 03:04:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-15/1776239960'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-15/1776239960
id: 1715188
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 162055877
updated: 2026-04-15 03:04:11

Version 1714000

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-14/1776153686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-14/1776153686
id: 1714000
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 162000453
updated: 2026-04-14 03:05:32

Version 1712756

created: 2026-04-13 02:57:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-13/1776066880'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-13/1776066880
id: 1712756
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161941563
updated: 2026-04-13 02:57:30

Version 1711543

created: 2026-04-12 02:58:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-12/1775980594'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-12/1775980594
id: 1711543
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161892367
updated: 2026-04-12 02:58:42

Version 1710414

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-11/1775894357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-11/1775894357
id: 1710414
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161841192
updated: 2026-04-11 03:05:19

Version 1709203

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-10/1775808111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-10/1775808111
id: 1709203
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161785883
updated: 2026-04-10 03:04:40

Version 1708018

created: 2026-04-09 02:58:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-09/1775721449'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-09/1775721449
id: 1708018
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161729788
updated: 2026-04-09 02:58:55

Version 1706884

created: 2026-04-08 03:04:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-08/1775635258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-08/1775635258
id: 1706884
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161675483
updated: 2026-04-08 03:04:53

Version 1705667

created: 2026-04-07 02:55:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-07/1775548432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-07/1775548432
id: 1705667
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161618349
updated: 2026-04-07 02:55:52

Version 1704430

created: 2026-04-06 03:02:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-06/1775462398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-06/1775462398
id: 1704430
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161561444
updated: 2026-04-06 03:03:01

Version 1703290

created: 2026-04-05 03:04:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-05/1775376022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-05/1775376022
id: 1703290
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161514867
updated: 2026-04-05 03:04:52

Version 1702070

created: 2026-04-04 03:01:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-04/1775289506'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-04/1775289506
id: 1702070
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161459941
updated: 2026-04-04 03:01:39

Version 1701011

created: 2026-04-03 03:12:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-03/1775203279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloFuelCloudTransactionsSet/2026-04-03/1775203279
id: 1701011
processed: 1

raw_data:

{
    "Created": 19,
    "Driver_Id": 14,
    "Driver_Type": 17,
    "Ending_Inches": 13,
    "Id": 0,
    "Inventory": 8,
    "InvoiceAspNetUser": 24,
    "InvoiceDateTime": 25,
    "InvoiceId": 23,
    "Invoiced": 22,
    "Label": 2,
    "Location_Id": 6,
    "MarinaLocationId": 21,
    "Payment_Account_Number": 20,
    "Percent": 10,
    "Pin": 16,
    "Price": 11,
    "Product_Id": 7,
    "RemovedDate": 26,
    "Starting_Inches": 12,
    "Tank_Id": 5,
    "Taxed": 18,
    "TransactionNumber": 1,
    "Transaction_Id": 3,
    "Transaction_Type": 4,
    "Vehicle_Id": 15,
    "Volume": 9
}

schema_attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

schema_name_id: 1638
schema_scan_id: 161401985
updated: 2026-04-03 03:12:55

Schema Scans: 15

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

Scan 162167432

duration: 0:00:12.560460

exit_message:

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

id: 162167432

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_moloFuelCloudTransactionsSet/2026-04-17/1776412732",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-17/1776412732/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13781450164160644179,
        "service_name": "drive-thru",
        "span_id": 9875618750800734443,
        "trace_id": 2578725929948912653
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-17 03:03:01
success: True
trace_id: 2578725929948912653

Scan 162111790

duration: 0:00:15.154732

exit_message:

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

id: 162111790

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_moloFuelCloudTransactionsSet/2026-04-16/1776326491",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-16/1776326491/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10934036719710119040,
        "service_name": "drive-thru",
        "span_id": 5812933350210518049,
        "trace_id": 2775116449085777460
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-16 03:06:58
success: True
trace_id: 2775116449085777460

Scan 162055877

duration: 0:00:12.822128

exit_message:

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

id: 162055877

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_moloFuelCloudTransactionsSet/2026-04-15/1776239960",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-15/1776239960/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4692816008570988449,
        "service_name": "drive-thru",
        "span_id": 14379259941376871635,
        "trace_id": 12513843781589919677
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-15 03:03:59
success: True
trace_id: 12513843781589919677

Scan 162000453

duration: 0:00:14.778646

exit_message:

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

id: 162000453

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_moloFuelCloudTransactionsSet/2026-04-14/1776153686",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-14/1776153686/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14204971888956421570,
        "service_name": "drive-thru",
        "span_id": 17094916097086528666,
        "trace_id": 3138194074167462685
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-14 03:05:17
success: True
trace_id: 3138194074167462685

Scan 161941563

duration: 0:00:14.840935

exit_message:

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

id: 161941563

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_moloFuelCloudTransactionsSet/2026-04-13/1776066880",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-13/1776066880/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7816492414673419964,
        "service_name": "drive-thru",
        "span_id": 9515410459325056698,
        "trace_id": 1902016146821971122
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-13 02:57:15
success: True
trace_id: 1902016146821971122

Scan 161892367

duration: 0:00:14.829046

exit_message:

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

id: 161892367

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_moloFuelCloudTransactionsSet/2026-04-12/1775980594",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-12/1775980594/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10628651266926633150,
        "service_name": "drive-thru",
        "span_id": 14132831565524729412,
        "trace_id": 9014633088316016197
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-12 02:58:28
success: True
trace_id: 9014633088316016197

Scan 161841192

duration: 0:00:12.353730

exit_message:

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

id: 161841192

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_moloFuelCloudTransactionsSet/2026-04-11/1775894357",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-11/1775894357/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5400153040072083007,
        "service_name": "drive-thru",
        "span_id": 6461450691108266411,
        "trace_id": 10183017117842937350
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-11 03:05:06
success: True
trace_id: 10183017117842937350

Scan 161785883

duration: 0:00:12.670500

exit_message:

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

id: 161785883

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_moloFuelCloudTransactionsSet/2026-04-10/1775808111",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-10/1775808111/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11929847069721876589,
        "service_name": "drive-thru",
        "span_id": 17423589769711801569,
        "trace_id": 943776826458513747
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-10 03:04:28
success: True
trace_id: 943776826458513747

Scan 161729788

duration: 0:00:12.386899

exit_message:

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

id: 161729788

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_moloFuelCloudTransactionsSet/2026-04-09/1775721449",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-09/1775721449/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9785717065018458370,
        "service_name": "drive-thru",
        "span_id": 11139864244850593331,
        "trace_id": 5649070895620291325
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-09 02:58:43
success: True
trace_id: 5649070895620291325

Scan 161675483

duration: 0:00:15.075608

exit_message:

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

id: 161675483

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_moloFuelCloudTransactionsSet/2026-04-08/1775635258",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-08/1775635258/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 365914517161594294,
        "service_name": "drive-thru",
        "span_id": 4394234899772543620,
        "trace_id": 16435686432135086185
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-08 03:04:38
success: True
trace_id: 16435686432135086185

Scan 161618349

duration: 0:00:14.842761

exit_message:

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

id: 161618349

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_moloFuelCloudTransactionsSet/2026-04-07/1775548432",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-07/1775548432/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15288931436242494740,
        "service_name": "drive-thru",
        "span_id": 15465855686150135457,
        "trace_id": 18335108146527314637
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-07 02:55:37
success: True
trace_id: 18335108146527314637

Scan 161561444

duration: 0:00:14.845543

exit_message:

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

id: 161561444

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_moloFuelCloudTransactionsSet/2026-04-06/1775462398",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-06/1775462398/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1903892094132887718,
        "service_name": "drive-thru",
        "span_id": 926001094438773117,
        "trace_id": 15469054349215342549
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-06 03:02:46
success: True
trace_id: 15469054349215342549

Scan 161514867

duration: 0:00:12.465095

exit_message:

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

id: 161514867

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_moloFuelCloudTransactionsSet/2026-04-05/1775376022",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-05/1775376022/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16053034785824301161,
        "service_name": "drive-thru",
        "span_id": 7344129229155613396,
        "trace_id": 5894804664367450029
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-05 03:04:40
success: True
trace_id: 5894804664367450029

Scan 161459941

duration: 0:00:12.492676

exit_message:

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

id: 161459941

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_moloFuelCloudTransactionsSet/2026-04-04/1775289506",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-04/1775289506/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15462089602911422545,
        "service_name": "drive-thru",
        "span_id": 5466308144571597007,
        "trace_id": 13443808733717145817
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-04 03:01:26
success: True
trace_id: 13443808733717145817

Scan 161401985

duration: 0:00:15.008528

exit_message:

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

id: 161401985

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_moloFuelCloudTransactionsSet/2026-04-03/1775203279",
        "key": "raw/molo_moloFuelCloudTransactionsSet/2026-04-03/1775203279/FuelCloudTransactionsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloFuelCloudTransactionsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5532639099183928702,
        "service_name": "drive-thru",
        "span_id": 17651650690012610118,
        "trace_id": 4163181968673233642
    }
}

running: False
schema_name_id: 1638
start_time: 2026-04-03 03:12:40
success: True
trace_id: 4163181968673233642

Partitions:

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

Schema:

attributes:

{
    "Created": "string",
    "Driver_Id": "string",
    "Driver_Type": "string",
    "Ending_Inches": "string",
    "Id": "string",
    "Inventory": "string",
    "InvoiceAspNetUser": "string",
    "InvoiceDateTime": "string",
    "InvoiceId": "string",
    "Invoiced": "string",
    "Label": "string",
    "Location_Id": "string",
    "MarinaLocationId": "string",
    "Payment_Account_Number": "string",
    "Percent": "string",
    "Pin": "string",
    "Price": "string",
    "Product_Id": "string",
    "RemovedDate": "string",
    "Starting_Inches": "string",
    "Tank_Id": "string",
    "Taxed": "string",
    "TransactionNumber": "string",
    "Transaction_Id": "string",
    "Transaction_Type": "string",
    "Vehicle_Id": "string",
    "Volume": "string"
}

created: 2026-04-17 03:03:02

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
}

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:56:41",
        "disabled": false,
        "format": "raw",
        "id": 1638,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molofuelcloudtransactionsset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Created": "string",
            "Driver_Id": "string",
            "Driver_Type": "string",
            "Ending_Inches": "string",
            "Id": "string",
            "Inventory": "string",
            "InvoiceAspNetUser": "string",
            "InvoiceDateTime": "string",
            "InvoiceId": "string",
            "Invoiced": "string",
            "Label": "string",
            "Location_Id": "string",
            "MarinaLocationId": "string",
            "Payment_Account_Number": "string",
            "Percent": "string",
            "Pin": "string",
            "Price": "string",
            "Product_Id": "string",
            "RemovedDate": "string",
            "Starting_Inches": "string",
            "Tank_Id": "string",
            "Taxed": "string",
            "TransactionNumber": "string",
            "Transaction_Id": "string",
            "Transaction_Type": "string",
            "Vehicle_Id": "string",
            "Volume": "string"
        },
        "created": "2026-04-17 03:03:02",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`\n(\n `Id`  string , `TransactionNumber`  string , `Label`  string , `Transaction_Id`  string , `Transaction_Type`  string , `Tank_Id`  string , `Location_Id`  string , `Product_Id`  string , `Inventory`  string , `Volume`  string , `Percent`  string , `Price`  string , `Starting_Inches`  string , `Ending_Inches`  string , `Driver_Id`  string , `Vehicle_Id`  string , `Pin`  string , `Driver_Type`  string , `Taxed`  string , `Created`  string , `Payment_Account_Number`  string , `MarinaLocationId`  string , `Invoiced`  string , `InvoiceId`  string , `InvoiceAspNetUser`  string , `InvoiceDateTime`  string , `RemovedDate`  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_moloFuelCloudTransactionsSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molofuelcloudtransactionsset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molofuelcloudtransactionsset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}