Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyles
  • created: 2023-02-07 01:46:59
  • disabled: False
  • format: raw
  • id: 1469
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imsstyles"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 04:57:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-17/1776419654
    • id: 1717986
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 162169323
    • updated: 2026-04-17 04:57:46
    • created: 2026-04-16 05:19:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-16/1776334554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-16/1776334554
    • id: 1716781
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 162114451
    • updated: 2026-04-16 05:19:37
    • created: 2026-04-15 03:44:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-15/1776242368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-15/1776242368
    • id: 1715561
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 162056450
    • updated: 2026-04-15 03:44:25
    • created: 2026-04-14 05:01:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-14/1776160763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-14/1776160763
    • id: 1714336
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 162003001
    • updated: 2026-04-14 05:02:06
    • created: 2026-04-13 05:11:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-13/1776074809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-13/1776074809
    • id: 1713170
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161945378
    • updated: 2026-04-13 05:11:17
    • created: 2026-04-12 05:05:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-12/1775988166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-12/1775988166
    • id: 1711931
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161896380
    • updated: 2026-04-12 05:06:02
    • created: 2026-04-11 05:18:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-11/1775902581'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-11/1775902581
    • id: 1710727
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161843945
    • updated: 2026-04-11 05:18:39
    • created: 2026-04-10 05:03:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-10/1775815221
    • id: 1709582
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161788629
    • updated: 2026-04-10 05:03:53
    • created: 2026-04-09 05:04:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-09/1775728844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-09/1775728844
    • id: 1708464
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161733029
    • updated: 2026-04-09 05:05:06
    • created: 2026-04-08 05:11:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-08/1775642993'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-08/1775642993
    • id: 1707182
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161678341
    • updated: 2026-04-08 05:11:47
    • created: 2026-04-07 05:17:58
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-07/1775556863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-07/1775556863
    • id: 1706062
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161622143
    • updated: 2026-04-07 05:18:09
    • created: 2026-04-06 05:19:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-06/1775470539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-06/1775470539
    • id: 1704836
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161564309
    • updated: 2026-04-06 05:19:25
    • created: 2026-04-05 05:00:01
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-05/1775382951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-05/1775382951
    • id: 1703646
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161516709
    • updated: 2026-04-05 05:00:14
    • created: 2026-04-04 04:57:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-04/1775296474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-04/1775296474
    • id: 1702458
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161462162
    • updated: 2026-04-04 04:57:50
    • created: 2026-04-03 05:14:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-03/1775211041'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyles/2026-04-03/1775211041
    • id: 1701285
    • processed: 1
    • raw_data: 
      {
    "accounting_item_id": 113,
    "accounting_tax_category_id": 114,
    "backend_display": 5,
    "backend_hourly_enabled": 32,
    "backend_multi_day_disabled": 29,
    "backend_nightly_discount_amount": 59,
    "backend_nightly_discount_days": 57,
    "backend_nightly_discount_type": 58,
    "backend_nightly_enabled": 52,
    "backend_nightly_end": 56,
    "backend_nightly_max_nights": 54,
    "backend_nightly_min_nights": 53,
    "backend_nightly_start": 55,
    "billable_unit_type": 123,
    "brand": 79,
    "created_at": 124,
    "deposit_amount": 8,
    "description": 82,
    "dockmaster_part_number": 116,
    "dockmaster_tax_code": 117,
    "draft": 77,
    "end_hours": 118,
    "engine_type": 74,
    "frontend_display": 21,
    "frontend_hourly_enabled": 39,
    "frontend_min_hours_advance_departure": 31,
    "frontend_name": 22,
    "frontend_nightly_addl_times": 66,
    "frontend_nightly_discount_amount": 69,
    "frontend_nightly_discount_days": 67,
    "frontend_nightly_discount_type": 68,
    "frontend_nightly_enabled": 60,
    "frontend_nightly_end": 65,
    "frontend_nightly_max_nights": 63,
    "frontend_nightly_min_nights": 61,
    "frontend_nightly_min_nights_peak": 62,
    "frontend_nightly_start": 64,
    "frontend_partial_payment_amount": 28,
    "frontend_partial_payment_type": 27,
    "frontend_position": 23,
    "frontend_qty_limit": 25,
    "frontend_type": 24,
    "frontend_unit_selector": 26,
    "fuel": 78,
    "fuel_burn_ratio": 11,
    "gratuity_enabled": 18,
    "gratuity_pricing_rate": 19,
    "holiday_backend_hourly_max_hours": 38,
    "holiday_backend_hourly_min_hours": 37,
    "holiday_frontend_hourly_length_increment": 51,
    "holiday_frontend_hourly_max_hours": 49,
    "holiday_frontend_hourly_min_hours": 48,
    "holiday_frontend_hourly_time_increment": 50,
    "horsepower": 73,
    "id": 1,
    "image": 70,
    "insurance_enabled": 14,
    "insurance_first_day_price": 17,
    "insurance_pricing_rate": 16,
    "insurance_pricing_type": 15,
    "length": 75,
    "local_video_link": 115,
    "location_id": 2,
    "max_same_style_per_booking": 30,
    "model": 80,
    "multiday_deposit_amount": 9,
    "notes": 84,
    "paperless_image_placeholders": 85,
    "parking_qty_multiplier": 20,
    "passengers": 71,
    "position": 6,
    "preauth_amount": 10,
    "seasonal_buffer_default_lower": 119,
    "seasonal_buffer_default_upper": 120,
    "seasonal_buffer_peak_lower": 121,
    "seasonal_buffer_peak_upper": 122,
    "slideshow_1": 86,
    "slideshow_10": 95,
    "slideshow_11": 96,
    "slideshow_12": 97,
    "slideshow_13": 98,
    "slideshow_14": 99,
    "slideshow_15": 100,
    "slideshow_16": 101,
    "slideshow_17": 102,
    "slideshow_18": 103,
    "slideshow_19": 104,
    "slideshow_2": 87,
    "slideshow_20": 105,
    "slideshow_21": 106,
    "slideshow_22": 107,
    "slideshow_23": 108,
    "slideshow_24": 109,
    "slideshow_25": 110,
    "slideshow_3": 88,
    "slideshow_4": 89,
    "slideshow_5": 90,
    "slideshow_6": 91,
    "slideshow_7": 92,
    "slideshow_8": 93,
    "slideshow_9": 94,
    "smartwaiver_waiver_link": 112,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 83,
    "tax_1_rate": 12,
    "tax_2_rate": 13,
    "tenant": 0,
    "title": 81,
    "turnaround_time": 7,
    "updated_at": 125,
    "video_link": 111,
    "weekday_backend_hourly_max_hours": 34,
    "weekday_backend_hourly_min_hours": 33,
    "weekday_frontend_hourly_length_increment": 43,
    "weekday_frontend_hourly_max_hours": 41,
    "weekday_frontend_hourly_min_hours": 40,
    "weekday_frontend_hourly_time_increment": 42,
    "weekend_backend_hourly_max_hours": 36,
    "weekend_backend_hourly_min_hours": 35,
    "weekend_frontend_hourly_length_increment": 47,
    "weekend_frontend_hourly_max_hours": 45,
    "weekend_frontend_hourly_min_hours": 44,
    "weekend_frontend_hourly_time_increment": 46,
    "weight": 72,
    "width": 76
}
    • schema_attributes: 
      {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
    • schema_name_id: 1469
    • schema_scan_id: 161404882
    • updated: 2026-04-03 05:14:44
Schema Scans: 15
Last at 2026-04-17 04:57:31
    • duration: 0:00:15.415425
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162169323
    • 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_imsstyles/2026-04-17/1776419654",
        "key": "raw/stellar_imsstyles/2026-04-17/1776419654/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14926525207697641765,
        "service_name": "drive-thru",
        "span_id": 12681852245766525728,
        "trace_id": 1918341224829436673
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-17 04:57:31
    • success: True
    • trace_id: 1918341224829436673
    • duration: 0:00:15.324383
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162114451
    • 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_imsstyles/2026-04-16/1776334554",
        "key": "raw/stellar_imsstyles/2026-04-16/1776334554/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17435985465431462988,
        "service_name": "drive-thru",
        "span_id": 17739139317809757145,
        "trace_id": 11527768432057303175
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-16 05:19:22
    • success: True
    • trace_id: 11527768432057303175
    • duration: 0:00:14.793233
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162056450
    • 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_imsstyles/2026-04-15/1776242368",
        "key": "raw/stellar_imsstyles/2026-04-15/1776242368/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5025076921841759782,
        "service_name": "drive-thru",
        "span_id": 3909928451315612049,
        "trace_id": 7844716086015803760
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-15 03:44:10
    • success: True
    • trace_id: 7844716086015803760
    • duration: 0:00:17.387116
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162003001
    • 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_imsstyles/2026-04-14/1776160763",
        "key": "raw/stellar_imsstyles/2026-04-14/1776160763/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7060147568255940846,
        "service_name": "drive-thru",
        "span_id": 16344209339524579260,
        "trace_id": 3539388694011624069
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-14 05:01:49
    • success: True
    • trace_id: 3539388694011624069
    • duration: 0:00:18.237371
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161945378
    • 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_imsstyles/2026-04-13/1776074809",
        "key": "raw/stellar_imsstyles/2026-04-13/1776074809/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 827146166405067968,
        "service_name": "drive-thru",
        "span_id": 9549607874639831762,
        "trace_id": 15888866535865066486
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-13 05:10:59
    • success: True
    • trace_id: 15888866535865066486
    • duration: 0:00:17.369803
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161896380
    • 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_imsstyles/2026-04-12/1775988166",
        "key": "raw/stellar_imsstyles/2026-04-12/1775988166/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 845007517168018339,
        "service_name": "drive-thru",
        "span_id": 7055358925107186547,
        "trace_id": 1135180761138564452
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-12 05:05:45
    • success: True
    • trace_id: 1135180761138564452
    • duration: 0:00:17.374629
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161843945
    • 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_imsstyles/2026-04-11/1775902581",
        "key": "raw/stellar_imsstyles/2026-04-11/1775902581/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15194517439251404042,
        "service_name": "drive-thru",
        "span_id": 14961971771767159479,
        "trace_id": 10236848920390233669
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-11 05:18:22
    • success: True
    • trace_id: 10236848920390233669
    • duration: 0:00:17.317017
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161788629
    • 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_imsstyles/2026-04-10/1775815221",
        "key": "raw/stellar_imsstyles/2026-04-10/1775815221/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6338835845013952101,
        "service_name": "drive-thru",
        "span_id": 16016693056433848664,
        "trace_id": 17546577403576839644
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-10 05:03:36
    • success: True
    • trace_id: 17546577403576839644
    • duration: 0:00:14.725833
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161733029
    • 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_imsstyles/2026-04-09/1775728844",
        "key": "raw/stellar_imsstyles/2026-04-09/1775728844/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18086005226503545125,
        "service_name": "drive-thru",
        "span_id": 15269362275054072075,
        "trace_id": 6347498587258158145
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-09 05:04:51
    • success: True
    • trace_id: 6347498587258158145
    • duration: 0:00:14.815231
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161678341
    • 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_imsstyles/2026-04-08/1775642993",
        "key": "raw/stellar_imsstyles/2026-04-08/1775642993/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1998926715318955905,
        "service_name": "drive-thru",
        "span_id": 3413548635252286973,
        "trace_id": 11799694619225128052
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-08 05:11:32
    • success: True
    • trace_id: 11799694619225128052
    • duration: 0:00:15.102617
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161622143
    • 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_imsstyles/2026-04-07/1775556863",
        "key": "raw/stellar_imsstyles/2026-04-07/1775556863/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8539759199483137100,
        "service_name": "drive-thru",
        "span_id": 4083205238496206384,
        "trace_id": 7927501492898172594
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-07 05:17:54
    • success: True
    • trace_id: 7927501492898172594
    • duration: 0:00:17.438124
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161564309
    • 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_imsstyles/2026-04-06/1775470539",
        "key": "raw/stellar_imsstyles/2026-04-06/1775470539/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2665815528343586534,
        "service_name": "drive-thru",
        "span_id": 8154600455452465255,
        "trace_id": 491999766092402632
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-06 05:19:08
    • success: True
    • trace_id: 491999766092402632
    • duration: 0:00:18.144857
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161516709
    • 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_imsstyles/2026-04-05/1775382951",
        "key": "raw/stellar_imsstyles/2026-04-05/1775382951/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10901365002210416082,
        "service_name": "drive-thru",
        "span_id": 15874704359673041742,
        "trace_id": 13218840140967950708
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-05 04:59:56
    • success: True
    • trace_id: 13218840140967950708
    • duration: 0:00:14.893256
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161462162
    • 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_imsstyles/2026-04-04/1775296474",
        "key": "raw/stellar_imsstyles/2026-04-04/1775296474/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2350842301137513989,
        "service_name": "drive-thru",
        "span_id": 10663306907319826726,
        "trace_id": 11499159681448893554
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-04 04:57:35
    • success: True
    • trace_id: 11499159681448893554
    • duration: 0:00:17.867460
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161404882
    • 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_imsstyles/2026-04-03/1775211041",
        "key": "raw/stellar_imsstyles/2026-04-03/1775211041/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6423127714377362957,
        "service_name": "drive-thru",
        "span_id": 10391077135849455180,
        "trace_id": 1421819011027229279
    }
}
    • running: False
    • schema_name_id: 1469
    • start_time: 2026-04-03 05:14:27
    • success: True
    • trace_id: 1421819011027229279
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "accounting_item_id": "string",
    "accounting_tax_category_id": "string",
    "backend_display": "string",
    "backend_hourly_enabled": "string",
    "backend_multi_day_disabled": "string",
    "backend_nightly_discount_amount": "string",
    "backend_nightly_discount_days": "string",
    "backend_nightly_discount_type": "string",
    "backend_nightly_enabled": "string",
    "backend_nightly_end": "string",
    "backend_nightly_max_nights": "string",
    "backend_nightly_min_nights": "string",
    "backend_nightly_start": "string",
    "billable_unit_type": "string",
    "brand": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "dockmaster_part_number": "string",
    "dockmaster_tax_code": "string",
    "draft": "string",
    "end_hours": "string",
    "engine_type": "string",
    "frontend_display": "string",
    "frontend_hourly_enabled": "string",
    "frontend_min_hours_advance_departure": "string",
    "frontend_name": "string",
    "frontend_nightly_addl_times": "string",
    "frontend_nightly_discount_amount": "string",
    "frontend_nightly_discount_days": "string",
    "frontend_nightly_discount_type": "string",
    "frontend_nightly_enabled": "string",
    "frontend_nightly_end": "string",
    "frontend_nightly_max_nights": "string",
    "frontend_nightly_min_nights": "string",
    "frontend_nightly_min_nights_peak": "string",
    "frontend_nightly_start": "string",
    "frontend_partial_payment_amount": "string",
    "frontend_partial_payment_type": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "frontend_type": "string",
    "frontend_unit_selector": "string",
    "fuel": "string",
    "fuel_burn_ratio": "string",
    "gratuity_enabled": "string",
    "gratuity_pricing_rate": "string",
    "holiday_backend_hourly_max_hours": "string",
    "holiday_backend_hourly_min_hours": "string",
    "holiday_frontend_hourly_length_increment": "string",
    "holiday_frontend_hourly_max_hours": "string",
    "holiday_frontend_hourly_min_hours": "string",
    "holiday_frontend_hourly_time_increment": "string",
    "horsepower": "string",
    "id": "string",
    "image": "string",
    "insurance_enabled": "string",
    "insurance_first_day_price": "string",
    "insurance_pricing_rate": "string",
    "insurance_pricing_type": "string",
    "length": "string",
    "local_video_link": "string",
    "location_id": "string",
    "max_same_style_per_booking": "string",
    "model": "string",
    "multiday_deposit_amount": "string",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "parking_qty_multiplier": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "string",
    "seasonal_buffer_default_lower": "string",
    "seasonal_buffer_default_upper": "string",
    "seasonal_buffer_peak_lower": "string",
    "seasonal_buffer_peak_upper": "string",
    "slideshow_1": "string",
    "slideshow_10": "string",
    "slideshow_11": "string",
    "slideshow_12": "string",
    "slideshow_13": "string",
    "slideshow_14": "string",
    "slideshow_15": "string",
    "slideshow_16": "string",
    "slideshow_17": "string",
    "slideshow_18": "string",
    "slideshow_19": "string",
    "slideshow_2": "string",
    "slideshow_20": "string",
    "slideshow_21": "string",
    "slideshow_22": "string",
    "slideshow_23": "string",
    "slideshow_24": "string",
    "slideshow_25": "string",
    "slideshow_3": "string",
    "slideshow_4": "string",
    "slideshow_5": "string",
    "slideshow_6": "string",
    "slideshow_7": "string",
    "slideshow_8": "string",
    "slideshow_9": "string",
    "smartwaiver_waiver_link": "string",
    "style_group_id": "string",
    "style_name": "string",
    "summary": "string",
    "tax_1_rate": "string",
    "tax_2_rate": "string",
    "tenant": "string",
    "title": "string",
    "turnaround_time": "string",
    "updated_at": "string",
    "video_link": "string",
    "weekday_backend_hourly_max_hours": "string",
    "weekday_backend_hourly_min_hours": "string",
    "weekday_frontend_hourly_length_increment": "string",
    "weekday_frontend_hourly_max_hours": "string",
    "weekday_frontend_hourly_min_hours": "string",
    "weekday_frontend_hourly_time_increment": "string",
    "weekend_backend_hourly_max_hours": "string",
    "weekend_backend_hourly_min_hours": "string",
    "weekend_frontend_hourly_length_increment": "string",
    "weekend_frontend_hourly_max_hours": "string",
    "weekend_frontend_hourly_min_hours": "string",
    "weekend_frontend_hourly_time_increment": "string",
    "weight": "string",
    "width": "string"
}
  • created: 2026-04-17 04:57:35
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
}
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:46:59",
        "disabled": false,
        "format": "raw",
        "id": 1469,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accounting_item_id": "string",
            "accounting_tax_category_id": "string",
            "backend_display": "string",
            "backend_hourly_enabled": "string",
            "backend_multi_day_disabled": "string",
            "backend_nightly_discount_amount": "string",
            "backend_nightly_discount_days": "string",
            "backend_nightly_discount_type": "string",
            "backend_nightly_enabled": "string",
            "backend_nightly_end": "string",
            "backend_nightly_max_nights": "string",
            "backend_nightly_min_nights": "string",
            "backend_nightly_start": "string",
            "billable_unit_type": "string",
            "brand": "string",
            "created_at": "string",
            "deposit_amount": "string",
            "description": "string",
            "dockmaster_part_number": "string",
            "dockmaster_tax_code": "string",
            "draft": "string",
            "end_hours": "string",
            "engine_type": "string",
            "frontend_display": "string",
            "frontend_hourly_enabled": "string",
            "frontend_min_hours_advance_departure": "string",
            "frontend_name": "string",
            "frontend_nightly_addl_times": "string",
            "frontend_nightly_discount_amount": "string",
            "frontend_nightly_discount_days": "string",
            "frontend_nightly_discount_type": "string",
            "frontend_nightly_enabled": "string",
            "frontend_nightly_end": "string",
            "frontend_nightly_max_nights": "string",
            "frontend_nightly_min_nights": "string",
            "frontend_nightly_min_nights_peak": "string",
            "frontend_nightly_start": "string",
            "frontend_partial_payment_amount": "string",
            "frontend_partial_payment_type": "string",
            "frontend_position": "string",
            "frontend_qty_limit": "string",
            "frontend_type": "string",
            "frontend_unit_selector": "string",
            "fuel": "string",
            "fuel_burn_ratio": "string",
            "gratuity_enabled": "string",
            "gratuity_pricing_rate": "string",
            "holiday_backend_hourly_max_hours": "string",
            "holiday_backend_hourly_min_hours": "string",
            "holiday_frontend_hourly_length_increment": "string",
            "holiday_frontend_hourly_max_hours": "string",
            "holiday_frontend_hourly_min_hours": "string",
            "holiday_frontend_hourly_time_increment": "string",
            "horsepower": "string",
            "id": "string",
            "image": "string",
            "insurance_enabled": "string",
            "insurance_first_day_price": "string",
            "insurance_pricing_rate": "string",
            "insurance_pricing_type": "string",
            "length": "string",
            "local_video_link": "string",
            "location_id": "string",
            "max_same_style_per_booking": "string",
            "model": "string",
            "multiday_deposit_amount": "string",
            "notes": "string",
            "paperless_image_placeholders": "string",
            "parking_qty_multiplier": "string",
            "passengers": "string",
            "position": "string",
            "preauth_amount": "string",
            "seasonal_buffer_default_lower": "string",
            "seasonal_buffer_default_upper": "string",
            "seasonal_buffer_peak_lower": "string",
            "seasonal_buffer_peak_upper": "string",
            "slideshow_1": "string",
            "slideshow_10": "string",
            "slideshow_11": "string",
            "slideshow_12": "string",
            "slideshow_13": "string",
            "slideshow_14": "string",
            "slideshow_15": "string",
            "slideshow_16": "string",
            "slideshow_17": "string",
            "slideshow_18": "string",
            "slideshow_19": "string",
            "slideshow_2": "string",
            "slideshow_20": "string",
            "slideshow_21": "string",
            "slideshow_22": "string",
            "slideshow_23": "string",
            "slideshow_24": "string",
            "slideshow_25": "string",
            "slideshow_3": "string",
            "slideshow_4": "string",
            "slideshow_5": "string",
            "slideshow_6": "string",
            "slideshow_7": "string",
            "slideshow_8": "string",
            "slideshow_9": "string",
            "smartwaiver_waiver_link": "string",
            "style_group_id": "string",
            "style_name": "string",
            "summary": "string",
            "tax_1_rate": "string",
            "tax_2_rate": "string",
            "tenant": "string",
            "title": "string",
            "turnaround_time": "string",
            "updated_at": "string",
            "video_link": "string",
            "weekday_backend_hourly_max_hours": "string",
            "weekday_backend_hourly_min_hours": "string",
            "weekday_frontend_hourly_length_increment": "string",
            "weekday_frontend_hourly_max_hours": "string",
            "weekday_frontend_hourly_min_hours": "string",
            "weekday_frontend_hourly_time_increment": "string",
            "weekend_backend_hourly_max_hours": "string",
            "weekend_backend_hourly_min_hours": "string",
            "weekend_frontend_hourly_length_increment": "string",
            "weekend_frontend_hourly_max_hours": "string",
            "weekend_frontend_hourly_min_hours": "string",
            "weekend_frontend_hourly_time_increment": "string",
            "weight": "string",
            "width": "string"
        },
        "created": "2026-04-17 04:57:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyles`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `style_name`  string , `backend_display`  string , `position`  string , `turnaround_time`  string , `deposit_amount`  string , `multiday_deposit_amount`  string , `preauth_amount`  string , `fuel_burn_ratio`  string , `tax_1_rate`  string , `tax_2_rate`  string , `insurance_enabled`  string , `insurance_pricing_type`  string , `insurance_pricing_rate`  string , `insurance_first_day_price`  string , `gratuity_enabled`  string , `gratuity_pricing_rate`  string , `parking_qty_multiplier`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `frontend_type`  string , `frontend_qty_limit`  string , `frontend_unit_selector`  string , `frontend_partial_payment_type`  string , `frontend_partial_payment_amount`  string , `backend_multi_day_disabled`  string , `max_same_style_per_booking`  string , `frontend_min_hours_advance_departure`  string , `backend_hourly_enabled`  string , `weekday_backend_hourly_min_hours`  string , `weekday_backend_hourly_max_hours`  string , `weekend_backend_hourly_min_hours`  string , `weekend_backend_hourly_max_hours`  string , `holiday_backend_hourly_min_hours`  string , `holiday_backend_hourly_max_hours`  string , `frontend_hourly_enabled`  string , `weekday_frontend_hourly_min_hours`  string , `weekday_frontend_hourly_max_hours`  string , `weekday_frontend_hourly_time_increment`  string , `weekday_frontend_hourly_length_increment`  string , `weekend_frontend_hourly_min_hours`  string , `weekend_frontend_hourly_max_hours`  string , `weekend_frontend_hourly_time_increment`  string , `weekend_frontend_hourly_length_increment`  string , `holiday_frontend_hourly_min_hours`  string , `holiday_frontend_hourly_max_hours`  string , `holiday_frontend_hourly_time_increment`  string , `holiday_frontend_hourly_length_increment`  string , `backend_nightly_enabled`  string , `backend_nightly_min_nights`  string , `backend_nightly_max_nights`  string , `backend_nightly_start`  string , `backend_nightly_end`  string , `backend_nightly_discount_days`  string , `backend_nightly_discount_type`  string , `backend_nightly_discount_amount`  string , `frontend_nightly_enabled`  string , `frontend_nightly_min_nights`  string , `frontend_nightly_min_nights_peak`  string , `frontend_nightly_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  string , `frontend_nightly_addl_times`  string , `frontend_nightly_discount_days`  string , `frontend_nightly_discount_type`  string , `frontend_nightly_discount_amount`  string , `image`  string , `passengers`  string , `weight`  string , `horsepower`  string , `engine_type`  string , `length`  string , `width`  string , `draft`  string , `fuel`  string , `brand`  string , `model`  string , `title`  string , `description`  string , `summary`  string , `notes`  string , `paperless_image_placeholders`  string , `slideshow_1`  string , `slideshow_2`  string , `slideshow_3`  string , `slideshow_4`  string , `slideshow_5`  string , `slideshow_6`  string , `slideshow_7`  string , `slideshow_8`  string , `slideshow_9`  string , `slideshow_10`  string , `slideshow_11`  string , `slideshow_12`  string , `slideshow_13`  string , `slideshow_14`  string , `slideshow_15`  string , `slideshow_16`  string , `slideshow_17`  string , `slideshow_18`  string , `slideshow_19`  string , `slideshow_20`  string , `slideshow_21`  string , `slideshow_22`  string , `slideshow_23`  string , `slideshow_24`  string , `slideshow_25`  string , `video_link`  string , `smartwaiver_waiver_link`  string , `accounting_item_id`  string , `accounting_tax_category_id`  string , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  string , `seasonal_buffer_default_lower`  string , `seasonal_buffer_default_upper`  string , `seasonal_buffer_peak_lower`  string , `seasonal_buffer_peak_upper`  string , `billable_unit_type`  string , `created_at`  string , `updated_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_imsstyles/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyles"
        }
    },
    "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