Schema Info

Schema Name: sfdl_prod_drivethru.molo_molometerauditset

created: 2023-10-17 02:00:40
disabled: False
format: raw
id: 1750
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717661

created: 2026-04-17 03:05:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-17/1776412808
id: 1717661
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 162167635
updated: 2026-04-17 03:05:56

Version 1716400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-16/1776326560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-16/1776326560
id: 1716400
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 162111825
updated: 2026-04-16 03:08:01

Version 1715206

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-15/1776240029'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-15/1776240029
id: 1715206
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 162055919
updated: 2026-04-15 03:05:14

Version 1714047

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-14/1776153757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-14/1776153757
id: 1714047
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 162000534
updated: 2026-04-14 03:07:27

Version 1712802

created: 2026-04-13 02:59:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-13/1776066953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-13/1776066953
id: 1712802
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161941753
updated: 2026-04-13 02:59:35

Version 1711593

created: 2026-04-12 03:00:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-12/1775980665'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-12/1775980665
id: 1711593
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161892667
updated: 2026-04-12 03:01:05

Version 1710462

created: 2026-04-11 03:06:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-11/1775894426'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-11/1775894426
id: 1710462
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161841251
updated: 2026-04-11 03:07:08

Version 1709190

created: 2026-04-10 03:04:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-10/1775808183'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-10/1775808183
id: 1709190
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161785871
updated: 2026-04-10 03:04:16

Version 1708086

created: 2026-04-09 03:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-09/1775721523'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-09/1775721523
id: 1708086
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161730104
updated: 2026-04-09 03:02:03

Version 1706972

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-08/1775635351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-08/1775635351
id: 1706972
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161675627
updated: 2026-04-08 03:08:36

Version 1705713

created: 2026-04-07 02:57:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-07/1775548500'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-07/1775548500
id: 1705713
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161618419
updated: 2026-04-07 02:57:39

Version 1704433

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-06/1775462467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-06/1775462467
id: 1704433
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161561452
updated: 2026-04-06 03:03:13

Version 1703235

created: 2026-04-05 03:02:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-05/1775376093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-05/1775376093
id: 1703235
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161514803
updated: 2026-04-05 03:02:44

Version 1702130

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-04/1775289576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-04/1775289576
id: 1702130
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161460305
updated: 2026-04-04 03:04:17

Version 1700970

created: 2026-04-03 03:10:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-03/1775203349'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMeterAuditSet/2026-04-03/1775203349
id: 1700970
processed: 1

raw_data:

{
    "DateTime": 2,
    "Id": 0,
    "InvoiceID": 8,
    "NewElectricValue": 4,
    "NewWaterValue": 6,
    "Pedestal_Id": 10,
    "PriorElectricValue": 3,
    "PriorWaterValue": 5,
    "ReservationID": 7,
    "Source": 9,
    "UserId": 1
}

schema_attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

schema_name_id: 1750
schema_scan_id: 161401937
updated: 2026-04-03 03:11:09

Schema Scans: 15

Last at 2026-04-17 03:05:44

Scan 162167635

duration: 0:00:12.034125

exit_message:

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

id: 162167635

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_moloMeterAuditSet/2026-04-17/1776412808",
        "key": "raw/molo_moloMeterAuditSet/2026-04-17/1776412808/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1488091458686096513,
        "service_name": "drive-thru",
        "span_id": 9993635999997604702,
        "trace_id": 15682376709651020068
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-17 03:05:44
success: True
trace_id: 15682376709651020068

Scan 162111825

duration: 0:00:14.682432

exit_message:

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

id: 162111825

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_moloMeterAuditSet/2026-04-16/1776326560",
        "key": "raw/molo_moloMeterAuditSet/2026-04-16/1776326560/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7604010516130953948,
        "service_name": "drive-thru",
        "span_id": 16655575735796118442,
        "trace_id": 5353700069804470195
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-16 03:07:46
success: True
trace_id: 5353700069804470195

Scan 162055919

duration: 0:00:14.497240

exit_message:

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

id: 162055919

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_moloMeterAuditSet/2026-04-15/1776240029",
        "key": "raw/molo_moloMeterAuditSet/2026-04-15/1776240029/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3971558243821098857,
        "service_name": "drive-thru",
        "span_id": 5460690573189016898,
        "trace_id": 500776972320966818
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-15 03:05:00
success: True
trace_id: 500776972320966818

Scan 162000534

duration: 0:00:12.001634

exit_message:

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

id: 162000534

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_moloMeterAuditSet/2026-04-14/1776153757",
        "key": "raw/molo_moloMeterAuditSet/2026-04-14/1776153757/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11191630207021054987,
        "service_name": "drive-thru",
        "span_id": 501873490068968854,
        "trace_id": 6715908166663300653
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-14 03:07:15
success: True
trace_id: 6715908166663300653

Scan 161941753

duration: 0:00:14.434733

exit_message:

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

id: 161941753

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_moloMeterAuditSet/2026-04-13/1776066953",
        "key": "raw/molo_moloMeterAuditSet/2026-04-13/1776066953/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3073369055633119666,
        "service_name": "drive-thru",
        "span_id": 6745241020538434129,
        "trace_id": 16660834476098348855
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-13 02:59:21
success: True
trace_id: 16660834476098348855

Scan 161892667

duration: 0:00:14.483048

exit_message:

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

id: 161892667

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_moloMeterAuditSet/2026-04-12/1775980665",
        "key": "raw/molo_moloMeterAuditSet/2026-04-12/1775980665/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1921062366655199569,
        "service_name": "drive-thru",
        "span_id": 7068048746499276116,
        "trace_id": 3301573768541037548
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-12 03:00:51
success: True
trace_id: 3301573768541037548

Scan 161841251

duration: 0:00:11.915627

exit_message:

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

id: 161841251

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_moloMeterAuditSet/2026-04-11/1775894426",
        "key": "raw/molo_moloMeterAuditSet/2026-04-11/1775894426/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 358318643531320871,
        "service_name": "drive-thru",
        "span_id": 11139686427491818541,
        "trace_id": 5371092390597066538
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-11 03:06:56
success: True
trace_id: 5371092390597066538

Scan 161785871

duration: 0:00:14.562381

exit_message:

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

id: 161785871

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_moloMeterAuditSet/2026-04-10/1775808183",
        "key": "raw/molo_moloMeterAuditSet/2026-04-10/1775808183/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4132358739968181976,
        "service_name": "drive-thru",
        "span_id": 8797697689671264014,
        "trace_id": 14587370381719035773
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-10 03:04:02
success: True
trace_id: 14587370381719035773

Scan 161730104

duration: 0:00:14.464411

exit_message:

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

id: 161730104

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_moloMeterAuditSet/2026-04-09/1775721523",
        "key": "raw/molo_moloMeterAuditSet/2026-04-09/1775721523/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15937538204278916438,
        "service_name": "drive-thru",
        "span_id": 7859836921320897753,
        "trace_id": 12190342124991794100
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-09 03:01:48
success: True
trace_id: 12190342124991794100

Scan 161675627

duration: 0:00:11.930672

exit_message:

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

id: 161675627

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_moloMeterAuditSet/2026-04-08/1775635351",
        "key": "raw/molo_moloMeterAuditSet/2026-04-08/1775635351/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10860553607515298952,
        "service_name": "drive-thru",
        "span_id": 10963778999895940533,
        "trace_id": 8156817383518017086
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-08 03:08:24
success: True
trace_id: 8156817383518017086

Scan 161618419

duration: 0:00:14.414766

exit_message:

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

id: 161618419

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_moloMeterAuditSet/2026-04-07/1775548500",
        "key": "raw/molo_moloMeterAuditSet/2026-04-07/1775548500/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15558416708489445402,
        "service_name": "drive-thru",
        "span_id": 8382618148959543381,
        "trace_id": 4462327576456128520
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-07 02:57:25
success: True
trace_id: 4462327576456128520

Scan 161561452

duration: 0:00:14.398636

exit_message:

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

id: 161561452

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_moloMeterAuditSet/2026-04-06/1775462467",
        "key": "raw/molo_moloMeterAuditSet/2026-04-06/1775462467/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6086166717126975793,
        "service_name": "drive-thru",
        "span_id": 15460987047976342034,
        "trace_id": 4504817252728595586
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-06 03:02:59
success: True
trace_id: 4504817252728595586

Scan 161514803

duration: 0:00:14.323682

exit_message:

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

id: 161514803

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_moloMeterAuditSet/2026-04-05/1775376093",
        "key": "raw/molo_moloMeterAuditSet/2026-04-05/1775376093/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11614035036664772631,
        "service_name": "drive-thru",
        "span_id": 17815265154256935746,
        "trace_id": 8769397729480948803
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-05 03:02:29
success: True
trace_id: 8769397729480948803

Scan 161460305

duration: 0:00:14.390242

exit_message:

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

id: 161460305

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_moloMeterAuditSet/2026-04-04/1775289576",
        "key": "raw/molo_moloMeterAuditSet/2026-04-04/1775289576/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1388045443184326388,
        "service_name": "drive-thru",
        "span_id": 16503232803128234850,
        "trace_id": 9898130720099536286
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-04 03:04:03
success: True
trace_id: 9898130720099536286

Scan 161401937

duration: 0:00:14.668348

exit_message:

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

id: 161401937

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_moloMeterAuditSet/2026-04-03/1775203349",
        "key": "raw/molo_moloMeterAuditSet/2026-04-03/1775203349/MeterAuditSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMeterAuditSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16583274699273224252,
        "service_name": "drive-thru",
        "span_id": 13538732822497854465,
        "trace_id": 9854091366423861330
    }
}

running: False
schema_name_id: 1750
start_time: 2026-04-03 03:10:54
success: True
trace_id: 9854091366423861330

Partitions:

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

Schema:

attributes:

{
    "DateTime": "string",
    "Id": "string",
    "InvoiceID": "string",
    "NewElectricValue": "string",
    "NewWaterValue": "string",
    "Pedestal_Id": "string",
    "PriorElectricValue": "string",
    "PriorWaterValue": "string",
    "ReservationID": "string",
    "Source": "string",
    "UserId": "string"
}

created: 2026-04-17 03:05:45

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:00:40",
        "disabled": false,
        "format": "raw",
        "id": 1750,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molometerauditset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "DateTime": "string",
            "Id": "string",
            "InvoiceID": "string",
            "NewElectricValue": "string",
            "NewWaterValue": "string",
            "Pedestal_Id": "string",
            "PriorElectricValue": "string",
            "PriorWaterValue": "string",
            "ReservationID": "string",
            "Source": "string",
            "UserId": "string"
        },
        "created": "2026-04-17 03:05:45",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molometerauditset`\n(\n `Id`  string , `UserId`  string , `DateTime`  string , `PriorElectricValue`  string , `NewElectricValue`  string , `PriorWaterValue`  string , `NewWaterValue`  string , `ReservationID`  string , `InvoiceID`  string , `Source`  string , `Pedestal_Id`  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_moloMeterAuditSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molometerauditset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molometerauditset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}