Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloequipmentset

created: 2023-10-17 01:55:32
disabled: False
format: raw
id: 1606
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717614

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-17/1776412729
id: 1717614
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 162167420
updated: 2026-04-17 03:03:10

Version 1716335

created: 2026-04-16 03:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-16/1776326487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-16/1776326487
id: 1716335
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 162111691
updated: 2026-04-16 03:04:43

Version 1715163

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-15/1776239957'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-15/1776239957
id: 1715163
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 162055759
updated: 2026-04-15 03:02:43

Version 1714020

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-14/1776153682'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-14/1776153682
id: 1714020
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 162000503
updated: 2026-04-14 03:06:23

Version 1712744

created: 2026-04-13 02:56:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-13/1776066876'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-13/1776066876
id: 1712744
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161941539
updated: 2026-04-13 02:57:00

Version 1711555

created: 2026-04-12 02:59:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-12/1775980591'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-12/1775980591
id: 1711555
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161892426
updated: 2026-04-12 02:59:31

Version 1710405

created: 2026-04-11 03:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-11/1775894353'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-11/1775894353
id: 1710405
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161841177
updated: 2026-04-11 03:05:00

Version 1709304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-10/1775808109'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-10/1775808109
id: 1709304
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161786000
updated: 2026-04-10 03:08:31

Version 1708067

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-09/1775721446'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-09/1775721446
id: 1708067
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161730032
updated: 2026-04-09 03:01:21

Version 1706810

created: 2026-04-08 03:01:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-08/1775635255'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-08/1775635255
id: 1706810
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161675338
updated: 2026-04-08 03:01:46

Version 1705663

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-07/1775548428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-07/1775548428
id: 1705663
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161618344
updated: 2026-04-07 02:55:39

Version 1704551

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-06/1775462397'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-06/1775462397
id: 1704551
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161561662
updated: 2026-04-06 03:08:20

Version 1703232

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-05/1775376020'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-05/1775376020
id: 1703232
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161514798
updated: 2026-04-05 03:02:38

Version 1702086

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-04/1775289503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-04/1775289503
id: 1702086
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161460020
updated: 2026-04-04 03:02:17

Version 1700908

created: 2026-04-03 03:08:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-03/1775203276'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentSet/2026-04-03/1775203276
id: 1700908
processed: 1

raw_data:

{
    "BallDiameter": 20,
    "Capacity": 14,
    "CodeCombination": 21,
    "CreationDate": 33,
    "CreationUser": 32,
    "DeletionAspNetUser_Id": 31,
    "DeletionDateTime": 29,
    "Displacement": 8,
    "EquipmentFuelType_Id": 25,
    "EquipmentType_Id": 23,
    "HashId": 1,
    "Height": 12,
    "Id": 0,
    "Length": 10,
    "LicensePlate": 28,
    "MarinaLocation_Id": 27,
    "Material": 15,
    "MaxLengthCapacity": 17,
    "Model": 2,
    "Notes": 22,
    "NumberOfAxles": 16,
    "NumberOfBrakes": 19,
    "NumberOfCylinders": 7,
    "NumberPosition": 6,
    "Output": 9,
    "RecordStatus_Id": 30,
    "SV_Manufacturer_Id": 26,
    "SerialNumber": 3,
    "TireSize": 18,
    "VesselEngineClass_Id": 24,
    "Weight": 13,
    "Width": 11,
    "YearOfManufacture": 4,
    "YearOfRebuildRefit": 5
}

schema_attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

schema_name_id: 1606
schema_scan_id: 161401856
updated: 2026-04-03 03:08:45

Schema Scans: 15

Last at 2026-04-17 03:02:55

Scan 162167420

duration: 0:00:15.186870

exit_message:

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

id: 162167420

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_moloEquipmentSet/2026-04-17/1776412729",
        "key": "raw/molo_moloEquipmentSet/2026-04-17/1776412729/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12514258018767756974,
        "service_name": "drive-thru",
        "span_id": 10973998481357651287,
        "trace_id": 5371440035313759524
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-17 03:02:55
success: True
trace_id: 5371440035313759524

Scan 162111691

duration: 0:00:15.189227

exit_message:

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

id: 162111691

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_moloEquipmentSet/2026-04-16/1776326487",
        "key": "raw/molo_moloEquipmentSet/2026-04-16/1776326487/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6132342602226695612,
        "service_name": "drive-thru",
        "span_id": 14355337356590945719,
        "trace_id": 11649187062027994425
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-16 03:04:28
success: True
trace_id: 11649187062027994425

Scan 162055759

duration: 0:00:15.031738

exit_message:

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

id: 162055759

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_moloEquipmentSet/2026-04-15/1776239957",
        "key": "raw/molo_moloEquipmentSet/2026-04-15/1776239957/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2403258826849167564,
        "service_name": "drive-thru",
        "span_id": 14708384958006352705,
        "trace_id": 15435763618651934097
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-15 03:02:28
success: True
trace_id: 15435763618651934097

Scan 162000503

duration: 0:00:12.520780

exit_message:

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

id: 162000503

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_moloEquipmentSet/2026-04-14/1776153682",
        "key": "raw/molo_moloEquipmentSet/2026-04-14/1776153682/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13128318549736698013,
        "service_name": "drive-thru",
        "span_id": 12936814977468278421,
        "trace_id": 13695314728422419563
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-14 03:06:10
success: True
trace_id: 13695314728422419563

Scan 161941539

duration: 0:00:12.455260

exit_message:

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

id: 161941539

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_moloEquipmentSet/2026-04-13/1776066876",
        "key": "raw/molo_moloEquipmentSet/2026-04-13/1776066876/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3631502149956534640,
        "service_name": "drive-thru",
        "span_id": 1095293154772266282,
        "trace_id": 12404352299855063152
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-13 02:56:47
success: True
trace_id: 12404352299855063152

Scan 161892426

duration: 0:00:15.037738

exit_message:

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

id: 161892426

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_moloEquipmentSet/2026-04-12/1775980591",
        "key": "raw/molo_moloEquipmentSet/2026-04-12/1775980591/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1148043703877043023,
        "service_name": "drive-thru",
        "span_id": 14547588726289679462,
        "trace_id": 12605085446198937071
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-12 02:59:16
success: True
trace_id: 12605085446198937071

Scan 161841177

duration: 0:00:12.591186

exit_message:

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

id: 161841177

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_moloEquipmentSet/2026-04-11/1775894353",
        "key": "raw/molo_moloEquipmentSet/2026-04-11/1775894353/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13009741403470136734,
        "service_name": "drive-thru",
        "span_id": 16783523366376435452,
        "trace_id": 9419305405221661956
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-11 03:04:47
success: True
trace_id: 9419305405221661956

Scan 161786000

duration: 0:00:12.806342

exit_message:

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

id: 161786000

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_moloEquipmentSet/2026-04-10/1775808109",
        "key": "raw/molo_moloEquipmentSet/2026-04-10/1775808109/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1657411737870207397,
        "service_name": "drive-thru",
        "span_id": 2604939622786820259,
        "trace_id": 12901593660181710299
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-10 03:08:18
success: True
trace_id: 12901593660181710299

Scan 161730032

duration: 0:00:12.690824

exit_message:

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

id: 161730032

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_moloEquipmentSet/2026-04-09/1775721446",
        "key": "raw/molo_moloEquipmentSet/2026-04-09/1775721446/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9170050083396578066,
        "service_name": "drive-thru",
        "span_id": 15850391598563228805,
        "trace_id": 18252123352867318169
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-09 03:01:09
success: True
trace_id: 18252123352867318169

Scan 161675338

duration: 0:00:12.487567

exit_message:

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

id: 161675338

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_moloEquipmentSet/2026-04-08/1775635255",
        "key": "raw/molo_moloEquipmentSet/2026-04-08/1775635255/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8447389409889648285,
        "service_name": "drive-thru",
        "span_id": 17705850118381284183,
        "trace_id": 6384406496499801013
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-08 03:01:34
success: True
trace_id: 6384406496499801013

Scan 161618344

duration: 0:00:12.650559

exit_message:

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

id: 161618344

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_moloEquipmentSet/2026-04-07/1775548428",
        "key": "raw/molo_moloEquipmentSet/2026-04-07/1775548428/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12299980377592645660,
        "service_name": "drive-thru",
        "span_id": 16101119665293762328,
        "trace_id": 15819021762671188019
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-07 02:55:26
success: True
trace_id: 15819021762671188019

Scan 161561662

duration: 0:00:12.741333

exit_message:

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

id: 161561662

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_moloEquipmentSet/2026-04-06/1775462397",
        "key": "raw/molo_moloEquipmentSet/2026-04-06/1775462397/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17964188484610381687,
        "service_name": "drive-thru",
        "span_id": 15484203482139472637,
        "trace_id": 10777755713018645645
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-06 03:08:08
success: True
trace_id: 10777755713018645645

Scan 161514798

duration: 0:00:15.043519

exit_message:

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

id: 161514798

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_moloEquipmentSet/2026-04-05/1775376020",
        "key": "raw/molo_moloEquipmentSet/2026-04-05/1775376020/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5542616948376870963,
        "service_name": "drive-thru",
        "span_id": 14247593044610790102,
        "trace_id": 4303183433934938643
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-05 03:02:23
success: True
trace_id: 4303183433934938643

Scan 161460020

duration: 0:00:15.087880

exit_message:

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

id: 161460020

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_moloEquipmentSet/2026-04-04/1775289503",
        "key": "raw/molo_moloEquipmentSet/2026-04-04/1775289503/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8890277171612293852,
        "service_name": "drive-thru",
        "span_id": 15524278663166263625,
        "trace_id": 17766804401948418907
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-04 03:02:02
success: True
trace_id: 17766804401948418907

Scan 161401856

duration: 0:00:15.257845

exit_message:

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

id: 161401856

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_moloEquipmentSet/2026-04-03/1775203276",
        "key": "raw/molo_moloEquipmentSet/2026-04-03/1775203276/EquipmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEquipmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7939593802735120799,
        "service_name": "drive-thru",
        "span_id": 15682412905724612204,
        "trace_id": 12414679932831590315
    }
}

running: False
schema_name_id: 1606
start_time: 2026-04-03 03:08:30
success: True
trace_id: 12414679932831590315

Partitions:

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

Schema:

attributes:

{
    "BallDiameter": "string",
    "Capacity": "string",
    "CodeCombination": "string",
    "CreationDate": "string",
    "CreationUser": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "Displacement": "string",
    "EquipmentFuelType_Id": "string",
    "EquipmentType_Id": "string",
    "HashId": "string",
    "Height": "string",
    "Id": "string",
    "Length": "string",
    "LicensePlate": "string",
    "MarinaLocation_Id": "string",
    "Material": "string",
    "MaxLengthCapacity": "string",
    "Model": "string",
    "Notes": "string",
    "NumberOfAxles": "string",
    "NumberOfBrakes": "string",
    "NumberOfCylinders": "string",
    "NumberPosition": "string",
    "Output": "string",
    "RecordStatus_Id": "string",
    "SV_Manufacturer_Id": "string",
    "SerialNumber": "string",
    "TireSize": "string",
    "VesselEngineClass_Id": "string",
    "Weight": "string",
    "Width": "string",
    "YearOfManufacture": "string",
    "YearOfRebuildRefit": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:55:32",
        "disabled": false,
        "format": "raw",
        "id": 1606,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloequipmentset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "BallDiameter": "string",
            "Capacity": "string",
            "CodeCombination": "string",
            "CreationDate": "string",
            "CreationUser": "string",
            "DeletionAspNetUser_Id": "string",
            "DeletionDateTime": "string",
            "Displacement": "string",
            "EquipmentFuelType_Id": "string",
            "EquipmentType_Id": "string",
            "HashId": "string",
            "Height": "string",
            "Id": "string",
            "Length": "string",
            "LicensePlate": "string",
            "MarinaLocation_Id": "string",
            "Material": "string",
            "MaxLengthCapacity": "string",
            "Model": "string",
            "Notes": "string",
            "NumberOfAxles": "string",
            "NumberOfBrakes": "string",
            "NumberOfCylinders": "string",
            "NumberPosition": "string",
            "Output": "string",
            "RecordStatus_Id": "string",
            "SV_Manufacturer_Id": "string",
            "SerialNumber": "string",
            "TireSize": "string",
            "VesselEngineClass_Id": "string",
            "Weight": "string",
            "Width": "string",
            "YearOfManufacture": "string",
            "YearOfRebuildRefit": "string"
        },
        "created": "2026-04-17 03:02:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentset`\n(\n `Id`  string , `HashId`  string , `Model`  string , `SerialNumber`  string , `YearOfManufacture`  string , `YearOfRebuildRefit`  string , `NumberPosition`  string , `NumberOfCylinders`  string , `Displacement`  string , `Output`  string , `Length`  string , `Width`  string , `Height`  string , `Weight`  string , `Capacity`  string , `Material`  string , `NumberOfAxles`  string , `MaxLengthCapacity`  string , `TireSize`  string , `NumberOfBrakes`  string , `BallDiameter`  string , `CodeCombination`  string , `Notes`  string , `EquipmentType_Id`  string , `VesselEngineClass_Id`  string , `EquipmentFuelType_Id`  string , `SV_Manufacturer_Id`  string , `MarinaLocation_Id`  string , `LicensePlate`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `CreationUser`  string , `CreationDate`  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_moloEquipmentSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}