Schema Info
Schema Name: sfdl_prod_drivethru.molo_molopedestals
- created: 2023-10-17 01:59:57
- disabled: False
- format: raw
- id: 1731
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molopedestals" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717681
- created: 2026-04-17 03:06:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-17/1776412810'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-17/1776412810
- id: 1717681
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 162167664
- updated: 2026-04-17 03:06:55
-
Version 1716546
- created: 2026-04-16 03:13:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-16/1776326566'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-16/1776326566
- id: 1716546
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 162112001
- updated: 2026-04-16 03:13:38
-
Version 1715276
- created: 2026-04-15 03:07:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-15/1776240036'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-15/1776240036
- id: 1715276
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 162056026
- updated: 2026-04-15 03:08:05
-
Version 1714034
- created: 2026-04-14 03:06:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-14/1776153765'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-14/1776153765
- id: 1714034
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 162000518
- updated: 2026-04-14 03:06:58
-
Version 1712816
- created: 2026-04-13 02:59:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-13/1776066959'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-13/1776066959
- id: 1712816
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161941801
- updated: 2026-04-13 02:59:58
-
Version 1711606
- created: 2026-04-12 03:01:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-12/1775980672'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-12/1775980672
- id: 1711606
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161892713
- updated: 2026-04-12 03:01:24
-
Version 1710494
- created: 2026-04-11 03:08:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-11/1775894432'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-11/1775894432
- id: 1710494
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161841283
- updated: 2026-04-11 03:08:23
-
Version 1709346
- created: 2026-04-10 03:09:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-10/1775808190'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-10/1775808190
- id: 1709346
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161786044
- updated: 2026-04-10 03:10:09
-
Version 1708099
- created: 2026-04-09 03:02:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-09/1775721528'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-09/1775721528
- id: 1708099
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161730166
- updated: 2026-04-09 03:02:36
-
Version 1706989
- created: 2026-04-08 03:09:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-08/1775635357'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-08/1775635357
- id: 1706989
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161675645
- updated: 2026-04-08 03:09:17
-
Version 1705731
- created: 2026-04-07 02:58:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-07/1775548506'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-07/1775548506
- id: 1705731
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161618453
- updated: 2026-04-07 02:58:24
-
Version 1704457
- created: 2026-04-06 03:04:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-06/1775462473'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-06/1775462473
- id: 1704457
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161561522
- updated: 2026-04-06 03:04:18
-
Version 1703241
- created: 2026-04-05 03:02:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-05/1775376100'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-05/1775376100
- id: 1703241
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161514809
- updated: 2026-04-05 03:02:59
-
Version 1702097
- created: 2026-04-04 03:02:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-04/1775289582'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-04/1775289582
- id: 1702097
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161460154
- updated: 2026-04-04 03:03:01
-
Version 1700934
- created: 2026-04-03 03:09:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-03/1775203355'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloPedestals/2026-04-03/1775203355
- id: 1700934
- processed: 1
- raw_data:
{ "Amps150": 35, "Cable": 3, "Electricity": 20, "ElectricityConsumption": 15, "ElectricityMeterNumber": 14, "ElectricityReadOn": 17, "Id": 0, "InUse": 19, "MarineSyncDeviceId": 33, "MarineSyncElectricityDeviceId": 37, "MarineSyncWaterDeviceId": 38, "MeterTypeId": 43, "Name": 1, "SlipPlacementId": 26, "Telephone": 4, "V120240V100Amps": 24, "V120_15Amps": 34, "V120_208_100Amps": 9, "V120_208_100Amps3Phase": 21, "V120_208_50A_1P": 28, "V120_208_50A_3P": 29, "V120_20Amps": 23, "V120_240_100A": 36, "V120_240_100Amps": 8, "V120_240_50Amps": 7, "V120_30Amps": 5, "V120_50Amps": 6, "V208100AmpsSinglePhase": 32, "V20850AmpsSinglePhase": 31, "V20860Amps3Phase": 30, "V240200Amps": 25, "V240_16Amps_50h": 39, "V240_30Amps": 27, "V240_32Amps_3Phase": 41, "V240_32Amps_50h": 40, "V240_63Amps_3Phase": 42, "V408_3Phase": 10, "V480_200Amps3Phase": 22, "V480_SinglePhase": 11, "V480_ThreePhase": 12, "Water": 2, "WaterConsumption": 16, "WaterMeterNumber": 13, "WaterReadOn": 18 } - schema_attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - schema_name_id: 1731
- schema_scan_id: 161401887
- updated: 2026-04-03 03:09:41
Schema Scans: 15
Last at 2026-04-17 03:06:39
-
Scan 162167664
- duration: 0:00:15.359823
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167664
- 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_moloPedestals/2026-04-17/1776412810", "key": "raw/molo_moloPedestals/2026-04-17/1776412810/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14307174245845934285, "service_name": "drive-thru", "span_id": 5698069128411676134, "trace_id": 16763448464481664493 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-17 03:06:39
- success: True
- trace_id: 16763448464481664493
-
Scan 162112001
- duration: 0:00:15.566655
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112001
- 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_moloPedestals/2026-04-16/1776326566", "key": "raw/molo_moloPedestals/2026-04-16/1776326566/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8780019935982903959, "service_name": "drive-thru", "span_id": 14794679354589808352, "trace_id": 11368135457603366430 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-16 03:13:22
- success: True
- trace_id: 11368135457603366430
-
Scan 162056026
- duration: 0:00:15.348412
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056026
- 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_moloPedestals/2026-04-15/1776240036", "key": "raw/molo_moloPedestals/2026-04-15/1776240036/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11528949841326828448, "service_name": "drive-thru", "span_id": 6326080322834380911, "trace_id": 11880016336633471984 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-15 03:07:50
- success: True
- trace_id: 11880016336633471984
-
Scan 162000518
- duration: 0:00:15.518250
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000518
- 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_moloPedestals/2026-04-14/1776153765", "key": "raw/molo_moloPedestals/2026-04-14/1776153765/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18246796402172353218, "service_name": "drive-thru", "span_id": 2291698922774855983, "trace_id": 14503057373768414890 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-14 03:06:42
- success: True
- trace_id: 14503057373768414890
-
Scan 161941801
- duration: 0:00:12.609985
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941801
- 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_moloPedestals/2026-04-13/1776066959", "key": "raw/molo_moloPedestals/2026-04-13/1776066959/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2305594790926500964, "service_name": "drive-thru", "span_id": 8323601700730467151, "trace_id": 13710738164136771718 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-13 02:59:45
- success: True
- trace_id: 13710738164136771718
-
Scan 161892713
- duration: 0:00:12.853808
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892713
- 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_moloPedestals/2026-04-12/1775980672", "key": "raw/molo_moloPedestals/2026-04-12/1775980672/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10443366838815561472, "service_name": "drive-thru", "span_id": 8613290886799946761, "trace_id": 10294477580825751838 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-12 03:01:11
- success: True
- trace_id: 10294477580825751838
-
Scan 161841283
- duration: 0:00:12.902777
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841283
- 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_moloPedestals/2026-04-11/1775894432", "key": "raw/molo_moloPedestals/2026-04-11/1775894432/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14599434046674386725, "service_name": "drive-thru", "span_id": 13708449748426841044, "trace_id": 11504665535826565601 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-11 03:08:10
- success: True
- trace_id: 11504665535826565601
-
Scan 161786044
- duration: 0:00:15.263432
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786044
- 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_moloPedestals/2026-04-10/1775808190", "key": "raw/molo_moloPedestals/2026-04-10/1775808190/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5263291094332277961, "service_name": "drive-thru", "span_id": 16457811484027504835, "trace_id": 14613066602751442234 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-10 03:09:54
- success: True
- trace_id: 14613066602751442234
-
Scan 161730166
- duration: 0:00:15.481306
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730166
- 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_moloPedestals/2026-04-09/1775721528", "key": "raw/molo_moloPedestals/2026-04-09/1775721528/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4189797421609030910, "service_name": "drive-thru", "span_id": 16546774861389740278, "trace_id": 9452801958443329234 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-09 03:02:20
- success: True
- trace_id: 9452801958443329234
-
Scan 161675645
- duration: 0:00:15.563800
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675645
- 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_moloPedestals/2026-04-08/1775635357", "key": "raw/molo_moloPedestals/2026-04-08/1775635357/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16817751583697491618, "service_name": "drive-thru", "span_id": 4609215979830961646, "trace_id": 13886541479937828511 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-08 03:09:01
- success: True
- trace_id: 13886541479937828511
-
Scan 161618453
- duration: 0:00:15.313552
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618453
- 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_moloPedestals/2026-04-07/1775548506", "key": "raw/molo_moloPedestals/2026-04-07/1775548506/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13408041430140865220, "service_name": "drive-thru", "span_id": 5169709263289378080, "trace_id": 2397851912833468309 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-07 02:58:08
- success: True
- trace_id: 2397851912833468309
-
Scan 161561522
- duration: 0:00:12.930920
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561522
- 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_moloPedestals/2026-04-06/1775462473", "key": "raw/molo_moloPedestals/2026-04-06/1775462473/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17235755670948743789, "service_name": "drive-thru", "span_id": 7119976047765271437, "trace_id": 9690527759015345404 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-06 03:04:05
- success: True
- trace_id: 9690527759015345404
-
Scan 161514809
- duration: 0:00:15.577209
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514809
- 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_moloPedestals/2026-04-05/1775376100", "key": "raw/molo_moloPedestals/2026-04-05/1775376100/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3861573863431091331, "service_name": "drive-thru", "span_id": 14002090330604703870, "trace_id": 7497604729417637206 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-05 03:02:44
- success: True
- trace_id: 7497604729417637206
-
Scan 161460154
- duration: 0:00:12.856388
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460154
- 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_moloPedestals/2026-04-04/1775289582", "key": "raw/molo_moloPedestals/2026-04-04/1775289582/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1911643116729105340, "service_name": "drive-thru", "span_id": 1625612912199770318, "trace_id": 8452321264175420557 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-04 03:02:48
- success: True
- trace_id: 8452321264175420557
-
Scan 161401887
- duration: 0:00:13.022612
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401887
- 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_moloPedestals/2026-04-03/1775203355", "key": "raw/molo_moloPedestals/2026-04-03/1775203355/Pedestals.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloPedestals", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11224568981124767131, "service_name": "drive-thru", "span_id": 15621892241801423637, "trace_id": 14257687465827485733 } } - running: False
- schema_name_id: 1731
- start_time: 2026-04-03 03:09:28
- success: True
- trace_id: 14257687465827485733
- attributes:
{ "Amps150": "string", "Cable": "string", "Electricity": "string", "ElectricityConsumption": "string", "ElectricityMeterNumber": "string", "ElectricityReadOn": "string", "Id": "string", "InUse": "string", "MarineSyncDeviceId": "string", "MarineSyncElectricityDeviceId": "string", "MarineSyncWaterDeviceId": "string", "MeterTypeId": "string", "Name": "string", "SlipPlacementId": "string", "Telephone": "string", "V120240V100Amps": "string", "V120_15Amps": "string", "V120_208_100Amps": "string", "V120_208_100Amps3Phase": "string", "V120_208_50A_1P": "string", "V120_208_50A_3P": "string", "V120_20Amps": "string", "V120_240_100A": "string", "V120_240_100Amps": "string", "V120_240_50Amps": "string", "V120_30Amps": "string", "V120_50Amps": "string", "V208100AmpsSinglePhase": "string", "V20850AmpsSinglePhase": "string", "V20860Amps3Phase": "string", "V240200Amps": "string", "V240_16Amps_50h": "string", "V240_30Amps": "string", "V240_32Amps_3Phase": "string", "V240_32Amps_50h": "string", "V240_63Amps_3Phase": "string", "V408_3Phase": "string", "V480_200Amps3Phase": "string", "V480_SinglePhase": "string", "V480_ThreePhase": "string", "Water": "string", "WaterConsumption": "string", "WaterMeterNumber": "string", "WaterReadOn": "string" } - created: 2026-04-17 03:06:41
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-17/1776412810'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 01:59:57",
"disabled": false,
"format": "raw",
"id": 1731,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molopedestals"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Amps150": "string",
"Cable": "string",
"Electricity": "string",
"ElectricityConsumption": "string",
"ElectricityMeterNumber": "string",
"ElectricityReadOn": "string",
"Id": "string",
"InUse": "string",
"MarineSyncDeviceId": "string",
"MarineSyncElectricityDeviceId": "string",
"MarineSyncWaterDeviceId": "string",
"MeterTypeId": "string",
"Name": "string",
"SlipPlacementId": "string",
"Telephone": "string",
"V120240V100Amps": "string",
"V120_15Amps": "string",
"V120_208_100Amps": "string",
"V120_208_100Amps3Phase": "string",
"V120_208_50A_1P": "string",
"V120_208_50A_3P": "string",
"V120_20Amps": "string",
"V120_240_100A": "string",
"V120_240_100Amps": "string",
"V120_240_50Amps": "string",
"V120_30Amps": "string",
"V120_50Amps": "string",
"V208100AmpsSinglePhase": "string",
"V20850AmpsSinglePhase": "string",
"V20860Amps3Phase": "string",
"V240200Amps": "string",
"V240_16Amps_50h": "string",
"V240_30Amps": "string",
"V240_32Amps_3Phase": "string",
"V240_32Amps_50h": "string",
"V240_63Amps_3Phase": "string",
"V408_3Phase": "string",
"V480_200Amps3Phase": "string",
"V480_SinglePhase": "string",
"V480_ThreePhase": "string",
"Water": "string",
"WaterConsumption": "string",
"WaterMeterNumber": "string",
"WaterReadOn": "string"
},
"created": "2026-04-17 03:06:41",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molopedestals`\n(\n `Id` string , `Name` string , `Water` string , `Cable` string , `Telephone` string , `V120_30Amps` string , `V120_50Amps` string , `V120_240_50Amps` string , `V120_240_100Amps` string , `V120_208_100Amps` string , `V408_3Phase` string , `V480_SinglePhase` string , `V480_ThreePhase` string , `WaterMeterNumber` string , `ElectricityMeterNumber` string , `ElectricityConsumption` string , `WaterConsumption` string , `ElectricityReadOn` string , `WaterReadOn` string , `InUse` string , `Electricity` string , `V120_208_100Amps3Phase` string , `V480_200Amps3Phase` string , `V120_20Amps` string , `V120240V100Amps` string , `V240200Amps` string , `SlipPlacementId` string , `V240_30Amps` string , `V120_208_50A_1P` string , `V120_208_50A_3P` string , `V20860Amps3Phase` string , `V20850AmpsSinglePhase` string , `V208100AmpsSinglePhase` string , `MarineSyncDeviceId` string , `V120_15Amps` string , `Amps150` string , `V120_240_100A` string , `MarineSyncElectricityDeviceId` string , `MarineSyncWaterDeviceId` string , `V240_16Amps_50h` string , `V240_32Amps_50h` string , `V240_32Amps_3Phase` string , `V240_63Amps_3Phase` string , `MeterTypeId` 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_moloPedestals/2026-04-17/1776412810'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molopedestals`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molopedestals"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}