Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_boats
  • created: 2023-02-07 01:45:36
  • disabled: False
  • format: raw
  • id: 1440
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imsbooking_boats"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 04:57:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-17/1776419645
    • id: 1717982
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 162169320
    • updated: 2026-04-17 04:57:37
    • created: 2026-04-16 05:17:05
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-16/1776334546
    • id: 1716720
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 162114389
    • updated: 2026-04-16 05:17:16
    • created: 2026-04-15 03:41:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-15/1776242357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-15/1776242357
    • id: 1715494
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 162056377
    • updated: 2026-04-15 03:41:44
    • created: 2026-04-14 05:00:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-14/1776160753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-14/1776160753
    • id: 1714311
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 162002946
    • updated: 2026-04-14 05:01:03
    • created: 2026-04-13 05:10:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-13/1776074798
    • id: 1713150
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161945357
    • updated: 2026-04-13 05:10:23
    • created: 2026-04-12 05:03:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-12/1775988155
    • id: 1711889
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161896327
    • updated: 2026-04-12 05:03:51
    • created: 2026-04-11 05:16:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-11/1775902572'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-11/1775902572
    • id: 1710689
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161843908
    • updated: 2026-04-11 05:17:12
    • created: 2026-04-10 05:00:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-10/1775815211'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-10/1775815211
    • id: 1709510
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161788546
    • updated: 2026-04-10 05:01:05
    • created: 2026-04-09 05:03:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-09/1775728837
    • id: 1708427
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161732986
    • updated: 2026-04-09 05:03:33
    • created: 2026-04-08 05:14:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-08/1775642999
    • id: 1707250
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161678409
    • updated: 2026-04-08 05:15:03
    • created: 2026-04-07 05:19:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-07/1775556856
    • id: 1706087
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161622180
    • updated: 2026-04-07 05:19:18
    • created: 2026-04-06 05:18:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-06/1775470527
    • id: 1704828
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161564303
    • updated: 2026-04-06 05:19:06
    • created: 2026-04-05 04:57:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-05/1775382942'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-05/1775382942
    • id: 1703566
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161516548
    • updated: 2026-04-05 04:57:30
    • created: 2026-04-04 04:58:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-04/1775296467
    • id: 1702475
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161462187
    • updated: 2026-04-04 04:58:28
    • created: 2026-04-03 05:13:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-03/1775211033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boats/2026-04-03/1775211033
    • id: 1701249
    • processed: 1
    • raw_data: 
      {
    "accessories_migrated": 46,
    "addl_driver_names": 45,
    "addl_drivers": 44,
    "attendant_queue_admin_id": 41,
    "attendant_water_admin_id": 42,
    "boat_assigned": 43,
    "boat_departure": 9,
    "boat_id": 4,
    "boat_return": 10,
    "booking_id": 2,
    "checkin_cleaning": 30,
    "checkin_date": 20,
    "checkin_deposit": 25,
    "checkin_diesel": 34,
    "checkin_diesel_gallons": 33,
    "checkin_engine_hours": 23,
    "checkin_equipment": 21,
    "checkin_fuel": 32,
    "checkin_gallons": 31,
    "checkin_hours": 24,
    "checkin_late": 27,
    "checkin_miscnontax": 28,
    "checkin_misctax": 29,
    "checkin_notes": 22,
    "checkin_tax_1": 36,
    "checkin_tax_2": 37,
    "checkin_tip": 35,
    "checkin_total": 38,
    "checkin_weather": 26,
    "checkout_date": 16,
    "checkout_engine_hours": 19,
    "checkout_equipment": 17,
    "checkout_notes": 18,
    "contract_pdf": 55,
    "contract_return_pdf": 54,
    "created_at": 56,
    "deleted_at": 58,
    "dob": 53,
    "emergencyname": 51,
    "emergencyphone": 52,
    "hours_duration": 11,
    "id": 1,
    "main_boat": 7,
    "num_passengers": 8,
    "price": 13,
    "price_override": 14,
    "price_rule_difference": 50,
    "price_rule_dynamic_price": 49,
    "price_rule_id": 47,
    "price_rule_original_price": 48,
    "queue_admin_id": 39,
    "queue_date": 40,
    "signature_date": 15,
    "status": 12,
    "style_id": 3,
    "tenant": 0,
    "time_id": 5,
    "timeframe_id": 6,
    "updated_at": 57
}
    • schema_attributes: 
      {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
    • schema_name_id: 1440
    • schema_scan_id: 161404846
    • updated: 2026-04-03 05:13:19
Schema Scans: 15
Last at 2026-04-17 04:57:24
    • duration: 0:00:13.197162
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162169320
    • 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/stellar_imsbooking_boats/2026-04-17/1776419645",
        "key": "raw/stellar_imsbooking_boats/2026-04-17/1776419645/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1027989906869525091,
        "service_name": "drive-thru",
        "span_id": 18441531713318027269,
        "trace_id": 10619682157817185871
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-17 04:57:24
    • success: True
    • trace_id: 10619682157817185871
    • duration: 0:00:13.354893
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162114389
    • 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/stellar_imsbooking_boats/2026-04-16/1776334546",
        "key": "raw/stellar_imsbooking_boats/2026-04-16/1776334546/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3641711043028591883,
        "service_name": "drive-thru",
        "span_id": 4367206960757281247,
        "trace_id": 12259545883156810381
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-16 05:17:03
    • success: True
    • trace_id: 12259545883156810381
    • duration: 0:00:15.708091
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162056377
    • 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/stellar_imsbooking_boats/2026-04-15/1776242357",
        "key": "raw/stellar_imsbooking_boats/2026-04-15/1776242357/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3813772588747555217,
        "service_name": "drive-thru",
        "span_id": 13798952884208567145,
        "trace_id": 8244419234741472905
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-15 03:41:29
    • success: True
    • trace_id: 8244419234741472905
    • duration: 0:00:15.945138
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162002946
    • 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/stellar_imsbooking_boats/2026-04-14/1776160753",
        "key": "raw/stellar_imsbooking_boats/2026-04-14/1776160753/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6196907846033033723,
        "service_name": "drive-thru",
        "span_id": 15717283941650394879,
        "trace_id": 15754257404667106460
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-14 05:00:48
    • success: True
    • trace_id: 15754257404667106460
    • duration: 0:00:13.097148
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161945357
    • 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/stellar_imsbooking_boats/2026-04-13/1776074798",
        "key": "raw/stellar_imsbooking_boats/2026-04-13/1776074798/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11071874779044020071,
        "service_name": "drive-thru",
        "span_id": 5371443874281747530,
        "trace_id": 8866792479042068189
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-13 05:10:10
    • success: True
    • trace_id: 8866792479042068189
    • duration: 0:00:15.858614
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161896327
    • 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/stellar_imsbooking_boats/2026-04-12/1775988155",
        "key": "raw/stellar_imsbooking_boats/2026-04-12/1775988155/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8608607042980507473,
        "service_name": "drive-thru",
        "span_id": 2612670462179620134,
        "trace_id": 6290041072703690727
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-12 05:03:35
    • success: True
    • trace_id: 6290041072703690727
    • duration: 0:00:15.725676
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161843908
    • 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/stellar_imsbooking_boats/2026-04-11/1775902572",
        "key": "raw/stellar_imsbooking_boats/2026-04-11/1775902572/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2522022471224705171,
        "service_name": "drive-thru",
        "span_id": 2689852622923348265,
        "trace_id": 9189039972926909626
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-11 05:16:57
    • success: True
    • trace_id: 9189039972926909626
    • duration: 0:00:15.624263
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161788546
    • 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/stellar_imsbooking_boats/2026-04-10/1775815211",
        "key": "raw/stellar_imsbooking_boats/2026-04-10/1775815211/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1196884128335046074,
        "service_name": "drive-thru",
        "span_id": 15643307252662247018,
        "trace_id": 8317674199930479338
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-10 05:00:50
    • success: True
    • trace_id: 8317674199930479338
    • duration: 0:00:13.275875
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161732986
    • 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/stellar_imsbooking_boats/2026-04-09/1775728837",
        "key": "raw/stellar_imsbooking_boats/2026-04-09/1775728837/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16385830206558921634,
        "service_name": "drive-thru",
        "span_id": 4784042555062264240,
        "trace_id": 17837774109383808902
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-09 05:03:20
    • success: True
    • trace_id: 17837774109383808902
    • duration: 0:00:15.896350
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161678409
    • 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/stellar_imsbooking_boats/2026-04-08/1775642999",
        "key": "raw/stellar_imsbooking_boats/2026-04-08/1775642999/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3013495722947211138,
        "service_name": "drive-thru",
        "span_id": 11755081604188688080,
        "trace_id": 2734605019034700019
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-08 05:14:47
    • success: True
    • trace_id: 2734605019034700019
    • duration: 0:00:15.726829
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161622180
    • 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/stellar_imsbooking_boats/2026-04-07/1775556856",
        "key": "raw/stellar_imsbooking_boats/2026-04-07/1775556856/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13364243910777655105,
        "service_name": "drive-thru",
        "span_id": 1189420478987787787,
        "trace_id": 16457386011430077487
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-07 05:19:02
    • success: True
    • trace_id: 16457386011430077487
    • duration: 0:00:13.320432
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161564303
    • 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/stellar_imsbooking_boats/2026-04-06/1775470527",
        "key": "raw/stellar_imsbooking_boats/2026-04-06/1775470527/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8542033132389761847,
        "service_name": "drive-thru",
        "span_id": 11508721094229645266,
        "trace_id": 16314844396079936864
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-06 05:18:53
    • success: True
    • trace_id: 16314844396079936864
    • duration: 0:00:13.231605
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161516548
    • 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/stellar_imsbooking_boats/2026-04-05/1775382942",
        "key": "raw/stellar_imsbooking_boats/2026-04-05/1775382942/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5756680239100577526,
        "service_name": "drive-thru",
        "span_id": 1154188056994411811,
        "trace_id": 16677703230439254164
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-05 04:57:17
    • success: True
    • trace_id: 16677703230439254164
    • duration: 0:00:26.636567
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161462187
    • 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/stellar_imsbooking_boats/2026-04-04/1775296467",
        "key": "raw/stellar_imsbooking_boats/2026-04-04/1775296467/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11369714848814129901,
        "service_name": "drive-thru",
        "span_id": 13652492426686448640,
        "trace_id": 2696720817344616383
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-04 04:58:02
    • success: True
    • trace_id: 2696720817344616383
    • duration: 0:00:13.121415
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161404846
    • 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/stellar_imsbooking_boats/2026-04-03/1775211033",
        "key": "raw/stellar_imsbooking_boats/2026-04-03/1775211033/booking_boats.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boats",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11080644315828920862,
        "service_name": "drive-thru",
        "span_id": 4816793337786603854,
        "trace_id": 10919697932165387853
    }
}
    • running: False
    • schema_name_id: 1440
    • start_time: 2026-04-03 05:13:06
    • success: True
    • trace_id: 10919697932165387853
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "accessories_migrated": "string",
    "addl_driver_names": "string",
    "addl_drivers": "string",
    "attendant_queue_admin_id": "string",
    "attendant_water_admin_id": "string",
    "boat_assigned": "string",
    "boat_departure": "string",
    "boat_id": "string",
    "boat_return": "string",
    "booking_id": "string",
    "checkin_cleaning": "string",
    "checkin_date": "string",
    "checkin_deposit": "string",
    "checkin_diesel": "string",
    "checkin_diesel_gallons": "string",
    "checkin_engine_hours": "string",
    "checkin_equipment": "string",
    "checkin_fuel": "string",
    "checkin_gallons": "string",
    "checkin_hours": "string",
    "checkin_late": "string",
    "checkin_miscnontax": "string",
    "checkin_misctax": "string",
    "checkin_notes": "string",
    "checkin_tax_1": "string",
    "checkin_tax_2": "string",
    "checkin_tip": "string",
    "checkin_total": "string",
    "checkin_weather": "string",
    "checkout_date": "string",
    "checkout_engine_hours": "string",
    "checkout_equipment": "string",
    "checkout_notes": "string",
    "contract_pdf": "string",
    "contract_return_pdf": "string",
    "created_at": "string",
    "deleted_at": "string",
    "dob": "string",
    "emergencyname": "string",
    "emergencyphone": "string",
    "hours_duration": "string",
    "id": "string",
    "main_boat": "string",
    "num_passengers": "string",
    "price": "string",
    "price_override": "string",
    "price_rule_difference": "string",
    "price_rule_dynamic_price": "string",
    "price_rule_id": "string",
    "price_rule_original_price": "string",
    "queue_admin_id": "string",
    "queue_date": "string",
    "signature_date": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "time_id": "string",
    "timeframe_id": "string",
    "updated_at": "string"
}
  • created: 2026-04-17 04:57:26
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
}
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-02-07 01:45:36",
        "disabled": false,
        "format": "raw",
        "id": 1440,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_boats"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accessories_migrated": "string",
            "addl_driver_names": "string",
            "addl_drivers": "string",
            "attendant_queue_admin_id": "string",
            "attendant_water_admin_id": "string",
            "boat_assigned": "string",
            "boat_departure": "string",
            "boat_id": "string",
            "boat_return": "string",
            "booking_id": "string",
            "checkin_cleaning": "string",
            "checkin_date": "string",
            "checkin_deposit": "string",
            "checkin_diesel": "string",
            "checkin_diesel_gallons": "string",
            "checkin_engine_hours": "string",
            "checkin_equipment": "string",
            "checkin_fuel": "string",
            "checkin_gallons": "string",
            "checkin_hours": "string",
            "checkin_late": "string",
            "checkin_miscnontax": "string",
            "checkin_misctax": "string",
            "checkin_notes": "string",
            "checkin_tax_1": "string",
            "checkin_tax_2": "string",
            "checkin_tip": "string",
            "checkin_total": "string",
            "checkin_weather": "string",
            "checkout_date": "string",
            "checkout_engine_hours": "string",
            "checkout_equipment": "string",
            "checkout_notes": "string",
            "contract_pdf": "string",
            "contract_return_pdf": "string",
            "created_at": "string",
            "deleted_at": "string",
            "dob": "string",
            "emergencyname": "string",
            "emergencyphone": "string",
            "hours_duration": "string",
            "id": "string",
            "main_boat": "string",
            "num_passengers": "string",
            "price": "string",
            "price_override": "string",
            "price_rule_difference": "string",
            "price_rule_dynamic_price": "string",
            "price_rule_id": "string",
            "price_rule_original_price": "string",
            "queue_admin_id": "string",
            "queue_date": "string",
            "signature_date": "string",
            "status": "string",
            "style_id": "string",
            "tenant": "string",
            "time_id": "string",
            "timeframe_id": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:57:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boats`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `style_id`  string , `boat_id`  string , `time_id`  string , `timeframe_id`  string , `main_boat`  string , `num_passengers`  string , `boat_departure`  string , `boat_return`  string , `hours_duration`  string , `status`  string , `price`  string , `price_override`  string , `signature_date`  string , `checkout_date`  string , `checkout_equipment`  string , `checkout_notes`  string , `checkout_engine_hours`  string , `checkin_date`  string , `checkin_equipment`  string , `checkin_notes`  string , `checkin_engine_hours`  string , `checkin_hours`  string , `checkin_deposit`  string , `checkin_weather`  string , `checkin_late`  string , `checkin_miscnontax`  string , `checkin_misctax`  string , `checkin_cleaning`  string , `checkin_gallons`  string , `checkin_fuel`  string , `checkin_diesel_gallons`  string , `checkin_diesel`  string , `checkin_tip`  string , `checkin_tax_1`  string , `checkin_tax_2`  string , `checkin_total`  string , `queue_admin_id`  string , `queue_date`  string , `attendant_queue_admin_id`  string , `attendant_water_admin_id`  string , `boat_assigned`  string , `addl_drivers`  string , `addl_driver_names`  string , `accessories_migrated`  string , `price_rule_id`  string , `price_rule_original_price`  string , `price_rule_dynamic_price`  string , `price_rule_difference`  string , `emergencyname`  string , `emergencyphone`  string , `dob`  string , `contract_return_pdf`  string , `contract_pdf`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imsbooking_boats/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boats`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boats"
        }
    },
    "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