Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloslips
  • created: 2023-10-17 01:58:16
  • disabled: False
  • format: raw
  • id: 1683
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "molo_moloslips"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 03:09:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-17/1776412852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-17/1776412852
    • id: 1717747
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 162167755
    • updated: 2026-04-17 03:09:36
    • created: 2026-04-16 03:12:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-16/1776326606'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-16/1776326606
    • id: 1716521
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 162111969
    • updated: 2026-04-16 03:12:40
    • created: 2026-04-15 03:09:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-15/1776240075'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-15/1776240075
    • id: 1715308
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 162056094
    • updated: 2026-04-15 03:09:36
    • created: 2026-04-14 03:09:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-14/1776153841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-14/1776153841
    • id: 1714109
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 162000622
    • updated: 2026-04-14 03:09:52
    • created: 2026-04-13 03:00:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-13/1776067000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-13/1776067000
    • id: 1712854
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161941936
    • updated: 2026-04-13 03:00:58
    • created: 2026-04-12 03:03:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-12/1775980711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-12/1775980711
    • id: 1711668
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161893060
    • updated: 2026-04-12 03:03:39
    • created: 2026-04-11 03:07:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-11/1775894479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-11/1775894479
    • id: 1710479
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161841268
    • updated: 2026-04-11 03:07:47
    • created: 2026-04-10 03:11:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-10/1775808237'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-10/1775808237
    • id: 1709383
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161786084
    • updated: 2026-04-10 03:11:36
    • created: 2026-04-09 03:07:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-09/1775721568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-09/1775721568
    • id: 1708206
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161730452
    • updated: 2026-04-09 03:07:26
    • created: 2026-04-08 03:05:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-08/1775635397'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-08/1775635397
    • id: 1706892
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161675499
    • updated: 2026-04-08 03:05:16
    • created: 2026-04-07 03:00:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-07/1775548553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-07/1775548553
    • id: 1705787
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161618736
    • updated: 2026-04-07 03:00:25
    • created: 2026-04-06 03:08:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-06/1775462513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-06/1775462513
    • id: 1704550
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161561661
    • updated: 2026-04-06 03:08:18
    • created: 2026-04-05 03:06:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-05/1775376139'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-05/1775376139
    • id: 1703334
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161514915
    • updated: 2026-04-05 03:06:48
    • created: 2026-04-04 03:03:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-04/1775289623'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-04/1775289623
    • id: 1702116
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161460259
    • updated: 2026-04-04 03:03:46
    • created: 2026-04-03 03:10:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-03/1775203395'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlips/2026-04-03/1775203395
    • id: 1700959
    • processed: 1
    • raw_data: 
      {
    "Active": 17,
    "AllowDoubleBooking": 38,
    "Assessment": 30,
    "CreationDateTime": 18,
    "CreationUser": 19,
    "DoNotCountInOccupancy": 16,
    "EnableMinimumForRecurringRate": 42,
    "EnableMinimumForSeasonalRate": 41,
    "EnableMinimumForTimeBasedRate": 40,
    "EnableSpaceMinimum": 39,
    "EndDate": 15,
    "HashID": 27,
    "Id": 0,
    "Loan": 31,
    "MaintenanceFee": 28,
    "ManagementFee": 22,
    "ManagementFeeType_Id": 25,
    "MarinaLocationId": 11,
    "MaxRevenue": 35,
    "MaxWeight": 34,
    "MaximumAirDraft": 10,
    "MaximumBeam": 8,
    "MaximumDraft": 9,
    "MaximumLOA": 7,
    "MinimumBillableValue": 53,
    "MinimumRecurringRate_Id": 47,
    "MinimumSeasonalRate_Id": 48,
    "MinimumTimeBasedRate_Id": 46,
    "Name": 1,
    "Order": 32,
    "OverrideOccupancyLOA": 26,
    "Owner_Id": 23,
    "PaymentProcessingFee": 21,
    "PaymentProcessingFeeType_Id": 24,
    "Pier_Id": 12,
    "RecomendedAirDraft": 6,
    "RecomendedBeam": 4,
    "RecomendedDraft": 5,
    "RecomendedLOA": 3,
    "RecurringAmount": 45,
    "RecurringChargeMethod_Id": 50,
    "SVGId": 29,
    "SeasonalAmount": 44,
    "SeasonalChargeMethod_Id": 51,
    "SeasonalPriceId": 37,
    "SignName": 33,
    "SlipType_Id": 20,
    "StartDate": 14,
    "Status": 13,
    "TimeBasedAmount": 43,
    "TimeBasedChargeMethod_Id": 49,
    "TransientPriceId": 36,
    "Type": 2,
    "UseMinimumBillableLength": 52
}
    • schema_attributes: 
      {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
    • schema_name_id: 1683
    • schema_scan_id: 161401919
    • updated: 2026-04-03 03:10:48
Schema Scans: 15
Last at 2026-04-17 03:09:20
    • duration: 0:00:15.624313
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162167755
    • 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_moloSlips/2026-04-17/1776412852",
        "key": "raw/molo_moloSlips/2026-04-17/1776412852/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5249446687545485914,
        "service_name": "drive-thru",
        "span_id": 8000594767586017025,
        "trace_id": 10030637275782254459
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-17 03:09:20
    • success: True
    • trace_id: 10030637275782254459
    • duration: 0:00:15.573089
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162111969
    • 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_moloSlips/2026-04-16/1776326606",
        "key": "raw/molo_moloSlips/2026-04-16/1776326606/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5009892869942304295,
        "service_name": "drive-thru",
        "span_id": 13427782503454316052,
        "trace_id": 10274047846843649141
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-16 03:12:25
    • success: True
    • trace_id: 10274047846843649141
    • duration: 0:00:13.272908
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162056094
    • 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_moloSlips/2026-04-15/1776240075",
        "key": "raw/molo_moloSlips/2026-04-15/1776240075/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10919956041215850622,
        "service_name": "drive-thru",
        "span_id": 18425155932109569885,
        "trace_id": 8557562177458389153
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-15 03:09:23
    • success: True
    • trace_id: 8557562177458389153
    • duration: 0:00:13.071864
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162000622
    • 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_moloSlips/2026-04-14/1776153841",
        "key": "raw/molo_moloSlips/2026-04-14/1776153841/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7816703663705884676,
        "service_name": "drive-thru",
        "span_id": 12569049592593121397,
        "trace_id": 8778500075337432151
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-14 03:09:39
    • success: True
    • trace_id: 8778500075337432151
    • duration: 0:00:13.184297
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161941936
    • 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_moloSlips/2026-04-13/1776067000",
        "key": "raw/molo_moloSlips/2026-04-13/1776067000/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10377586798969301445,
        "service_name": "drive-thru",
        "span_id": 15164675375466395350,
        "trace_id": 9765422868264253215
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-13 03:00:45
    • success: True
    • trace_id: 9765422868264253215
    • duration: 0:00:15.621492
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161893060
    • 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_moloSlips/2026-04-12/1775980711",
        "key": "raw/molo_moloSlips/2026-04-12/1775980711/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 152423742313332885,
        "service_name": "drive-thru",
        "span_id": 592248149017490628,
        "trace_id": 15983164399773497155
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-12 03:03:23
    • success: True
    • trace_id: 15983164399773497155
    • duration: 0:00:13.035932
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161841268
    • 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_moloSlips/2026-04-11/1775894479",
        "key": "raw/molo_moloSlips/2026-04-11/1775894479/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7560949257778752630,
        "service_name": "drive-thru",
        "span_id": 839820500568415905,
        "trace_id": 1887960405996353945
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-11 03:07:34
    • success: True
    • trace_id: 1887960405996353945
    • duration: 0:00:13.359280
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161786084
    • 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_moloSlips/2026-04-10/1775808237",
        "key": "raw/molo_moloSlips/2026-04-10/1775808237/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17256593552573293838,
        "service_name": "drive-thru",
        "span_id": 6239155247416055310,
        "trace_id": 2114253082075131852
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-10 03:11:22
    • success: True
    • trace_id: 2114253082075131852
    • duration: 0:00:15.700114
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161730452
    • 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_moloSlips/2026-04-09/1775721568",
        "key": "raw/molo_moloSlips/2026-04-09/1775721568/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12026938112656768492,
        "service_name": "drive-thru",
        "span_id": 4890591730659223876,
        "trace_id": 7133839537943210668
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-09 03:07:11
    • success: True
    • trace_id: 7133839537943210668
    • duration: 0:00:15.865750
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161675499
    • 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_moloSlips/2026-04-08/1775635397",
        "key": "raw/molo_moloSlips/2026-04-08/1775635397/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5823811917090386540,
        "service_name": "drive-thru",
        "span_id": 16004417322062949517,
        "trace_id": 14062676099196974357
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-08 03:05:01
    • success: True
    • trace_id: 14062676099196974357
    • duration: 0:00:15.764328
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161618736
    • 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_moloSlips/2026-04-07/1775548553",
        "key": "raw/molo_moloSlips/2026-04-07/1775548553/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8247792390386385353,
        "service_name": "drive-thru",
        "span_id": 10475779793431628484,
        "trace_id": 1696316071729014970
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-07 03:00:09
    • success: True
    • trace_id: 1696316071729014970
    • duration: 0:00:13.174205
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161561661
    • 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_moloSlips/2026-04-06/1775462513",
        "key": "raw/molo_moloSlips/2026-04-06/1775462513/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7638429770740817791,
        "service_name": "drive-thru",
        "span_id": 10227705439543798341,
        "trace_id": 4006624548332586791
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-06 03:08:05
    • success: True
    • trace_id: 4006624548332586791
    • duration: 0:00:15.482533
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161514915
    • 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_moloSlips/2026-04-05/1775376139",
        "key": "raw/molo_moloSlips/2026-04-05/1775376139/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7182865977979229081,
        "service_name": "drive-thru",
        "span_id": 6946364430168325749,
        "trace_id": 4731987990300820034
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-05 03:06:33
    • success: True
    • trace_id: 4731987990300820034
    • duration: 0:00:13.257845
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161460259
    • 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_moloSlips/2026-04-04/1775289623",
        "key": "raw/molo_moloSlips/2026-04-04/1775289623/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6942883143837648963,
        "service_name": "drive-thru",
        "span_id": 8337408778069031515,
        "trace_id": 17037091994313433559
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-04 03:03:33
    • success: True
    • trace_id: 17037091994313433559
    • duration: 0:00:15.728543
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161401919
    • 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_moloSlips/2026-04-03/1775203395",
        "key": "raw/molo_moloSlips/2026-04-03/1775203395/Slips.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlips",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1811533043275737927,
        "service_name": "drive-thru",
        "span_id": 9821814294244992738,
        "trace_id": 4351077456971977988
    }
}
    • running: False
    • schema_name_id: 1683
    • start_time: 2026-04-03 03:10:32
    • success: True
    • trace_id: 4351077456971977988
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "Active": "string",
    "AllowDoubleBooking": "string",
    "Assessment": "string",
    "CreationDateTime": "string",
    "CreationUser": "string",
    "DoNotCountInOccupancy": "string",
    "EnableMinimumForRecurringRate": "string",
    "EnableMinimumForSeasonalRate": "string",
    "EnableMinimumForTimeBasedRate": "string",
    "EnableSpaceMinimum": "string",
    "EndDate": "string",
    "HashID": "string",
    "Id": "string",
    "Loan": "string",
    "MaintenanceFee": "string",
    "ManagementFee": "string",
    "ManagementFeeType_Id": "string",
    "MarinaLocationId": "string",
    "MaxRevenue": "string",
    "MaxWeight": "string",
    "MaximumAirDraft": "string",
    "MaximumBeam": "string",
    "MaximumDraft": "string",
    "MaximumLOA": "string",
    "MinimumBillableValue": "string",
    "MinimumRecurringRate_Id": "string",
    "MinimumSeasonalRate_Id": "string",
    "MinimumTimeBasedRate_Id": "string",
    "Name": "string",
    "Order": "string",
    "OverrideOccupancyLOA": "string",
    "Owner_Id": "string",
    "PaymentProcessingFee": "string",
    "PaymentProcessingFeeType_Id": "string",
    "Pier_Id": "string",
    "RecomendedAirDraft": "string",
    "RecomendedBeam": "string",
    "RecomendedDraft": "string",
    "RecomendedLOA": "string",
    "RecurringAmount": "string",
    "RecurringChargeMethod_Id": "string",
    "SVGId": "string",
    "SeasonalAmount": "string",
    "SeasonalChargeMethod_Id": "string",
    "SeasonalPriceId": "string",
    "SignName": "string",
    "SlipType_Id": "string",
    "StartDate": "string",
    "Status": "string",
    "TimeBasedAmount": "string",
    "TimeBasedChargeMethod_Id": "string",
    "TransientPriceId": "string",
    "Type": "string",
    "UseMinimumBillableLength": "string"
}
  • created: 2026-04-17 03:09:22
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-17/1776412852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
}
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:58:16",
        "disabled": false,
        "format": "raw",
        "id": 1683,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloslips"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Active": "string",
            "AllowDoubleBooking": "string",
            "Assessment": "string",
            "CreationDateTime": "string",
            "CreationUser": "string",
            "DoNotCountInOccupancy": "string",
            "EnableMinimumForRecurringRate": "string",
            "EnableMinimumForSeasonalRate": "string",
            "EnableMinimumForTimeBasedRate": "string",
            "EnableSpaceMinimum": "string",
            "EndDate": "string",
            "HashID": "string",
            "Id": "string",
            "Loan": "string",
            "MaintenanceFee": "string",
            "ManagementFee": "string",
            "ManagementFeeType_Id": "string",
            "MarinaLocationId": "string",
            "MaxRevenue": "string",
            "MaxWeight": "string",
            "MaximumAirDraft": "string",
            "MaximumBeam": "string",
            "MaximumDraft": "string",
            "MaximumLOA": "string",
            "MinimumBillableValue": "string",
            "MinimumRecurringRate_Id": "string",
            "MinimumSeasonalRate_Id": "string",
            "MinimumTimeBasedRate_Id": "string",
            "Name": "string",
            "Order": "string",
            "OverrideOccupancyLOA": "string",
            "Owner_Id": "string",
            "PaymentProcessingFee": "string",
            "PaymentProcessingFeeType_Id": "string",
            "Pier_Id": "string",
            "RecomendedAirDraft": "string",
            "RecomendedBeam": "string",
            "RecomendedDraft": "string",
            "RecomendedLOA": "string",
            "RecurringAmount": "string",
            "RecurringChargeMethod_Id": "string",
            "SVGId": "string",
            "SeasonalAmount": "string",
            "SeasonalChargeMethod_Id": "string",
            "SeasonalPriceId": "string",
            "SignName": "string",
            "SlipType_Id": "string",
            "StartDate": "string",
            "Status": "string",
            "TimeBasedAmount": "string",
            "TimeBasedChargeMethod_Id": "string",
            "TransientPriceId": "string",
            "Type": "string",
            "UseMinimumBillableLength": "string"
        },
        "created": "2026-04-17 03:09:22",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslips`\n(\n `Id`  string , `Name`  string , `Type`  string , `RecomendedLOA`  string , `RecomendedBeam`  string , `RecomendedDraft`  string , `RecomendedAirDraft`  string , `MaximumLOA`  string , `MaximumBeam`  string , `MaximumDraft`  string , `MaximumAirDraft`  string , `MarinaLocationId`  string , `Pier_Id`  string , `Status`  string , `StartDate`  string , `EndDate`  string , `DoNotCountInOccupancy`  string , `Active`  string , `CreationDateTime`  string , `CreationUser`  string , `SlipType_Id`  string , `PaymentProcessingFee`  string , `ManagementFee`  string , `Owner_Id`  string , `PaymentProcessingFeeType_Id`  string , `ManagementFeeType_Id`  string , `OverrideOccupancyLOA`  string , `HashID`  string , `MaintenanceFee`  string , `SVGId`  string , `Assessment`  string , `Loan`  string , `Order`  string , `SignName`  string , `MaxWeight`  string , `MaxRevenue`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `AllowDoubleBooking`  string , `EnableSpaceMinimum`  string , `EnableMinimumForTimeBasedRate`  string , `EnableMinimumForSeasonalRate`  string , `EnableMinimumForRecurringRate`  string , `TimeBasedAmount`  string , `SeasonalAmount`  string , `RecurringAmount`  string , `MinimumTimeBasedRate_Id`  string , `MinimumRecurringRate_Id`  string , `MinimumSeasonalRate_Id`  string , `TimeBasedChargeMethod_Id`  string , `RecurringChargeMethod_Id`  string , `SeasonalChargeMethod_Id`  string , `UseMinimumBillableLength`  string , `MinimumBillableValue`  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_moloSlips/2026-04-17/1776412852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslips`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslips"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform