Schema Info

Schema Name: sfdl_stage_drivethru.stellar_imsstyles
  • created: 2023-01-31 12:07:35
  • disabled: False
  • format: raw
  • id: 1769
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_drivethru",
    "table": "stellar_imsstyles"
}
  • type: drivethrucsv
Schema Versions: 3
    • created: 2023-02-06 01:52:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  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 , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  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-stage/raw/stellar_imsstyles/2023-02-06/1675669795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-06/1675669795
    • id: 496007
    • processed: 1
    • raw_data: 
      {
    "backend_display": 5,
    "backend_hourly_enabled": 28,
    "backend_multi_day_disabled": 25,
    "backend_nightly_discount_amount": 55,
    "backend_nightly_discount_days": 53,
    "backend_nightly_discount_type": 54,
    "backend_nightly_enabled": 48,
    "backend_nightly_end": 52,
    "backend_nightly_max_nights": 50,
    "backend_nightly_min_nights": 49,
    "backend_nightly_start": 51,
    "billable_unit_type": 111,
    "brand": 73,
    "created_at": 112,
    "deposit_amount": 8,
    "description": 76,
    "dockmaster_part_number": 108,
    "dockmaster_tax_code": 109,
    "draft": 71,
    "end_hours": 110,
    "engine_type": 68,
    "frontend_display": 17,
    "frontend_hourly_enabled": 35,
    "frontend_min_hours_advance_departure": 27,
    "frontend_name": 18,
    "frontend_nightly_discount_amount": 63,
    "frontend_nightly_discount_days": 61,
    "frontend_nightly_discount_type": 62,
    "frontend_nightly_enabled": 56,
    "frontend_nightly_end": 60,
    "frontend_nightly_max_nights": 58,
    "frontend_nightly_min_nights": 57,
    "frontend_nightly_start": 59,
    "frontend_partial_payment_amount": 24,
    "frontend_partial_payment_type": 23,
    "frontend_position": 19,
    "frontend_qty_limit": 21,
    "frontend_type": 20,
    "frontend_unit_selector": 22,
    "fuel": 72,
    "fuel_burn_ratio": 10,
    "holiday_backend_hourly_max_hours": 34,
    "holiday_backend_hourly_min_hours": 33,
    "holiday_frontend_hourly_length_increment": 47,
    "holiday_frontend_hourly_max_hours": 45,
    "holiday_frontend_hourly_min_hours": 44,
    "holiday_frontend_hourly_time_increment": 46,
    "horsepower": 67,
    "id": 1,
    "image": 64,
    "insurance_enabled": 13,
    "insurance_first_day_price": 16,
    "insurance_pricing_rate": 15,
    "insurance_pricing_type": 14,
    "length": 69,
    "local_video_link": 107,
    "location_id": 2,
    "max_same_style_per_booking": 26,
    "model": 74,
    "notes": 78,
    "paperless_image_placeholders": 79,
    "passengers": 65,
    "position": 6,
    "preauth_amount": 9,
    "slideshow_1": 80,
    "slideshow_10": 89,
    "slideshow_11": 90,
    "slideshow_12": 91,
    "slideshow_13": 92,
    "slideshow_14": 93,
    "slideshow_15": 94,
    "slideshow_16": 95,
    "slideshow_17": 96,
    "slideshow_18": 97,
    "slideshow_19": 98,
    "slideshow_2": 81,
    "slideshow_20": 99,
    "slideshow_21": 100,
    "slideshow_22": 101,
    "slideshow_23": 102,
    "slideshow_24": 103,
    "slideshow_25": 104,
    "slideshow_3": 82,
    "slideshow_4": 83,
    "slideshow_5": 84,
    "slideshow_6": 85,
    "slideshow_7": 86,
    "slideshow_8": 87,
    "slideshow_9": 88,
    "smartwaiver_waiver_link": 106,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 77,
    "tax_1_rate": 11,
    "tax_2_rate": 12,
    "tenant": 0,
    "title": 75,
    "turnaround_time": 7,
    "updated_at": 113,
    "video_link": 105,
    "weekday_backend_hourly_max_hours": 30,
    "weekday_backend_hourly_min_hours": 29,
    "weekday_frontend_hourly_length_increment": 39,
    "weekday_frontend_hourly_max_hours": 37,
    "weekday_frontend_hourly_min_hours": 36,
    "weekday_frontend_hourly_time_increment": 38,
    "weekend_backend_hourly_max_hours": 32,
    "weekend_backend_hourly_min_hours": 31,
    "weekend_frontend_hourly_length_increment": 43,
    "weekend_frontend_hourly_max_hours": 41,
    "weekend_frontend_hourly_min_hours": 40,
    "weekend_frontend_hourly_time_increment": 42,
    "weight": 66,
    "width": 70
}
    • schema_attributes: 
      {
    "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_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_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",
    "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",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "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: 1769
    • schema_scan_id: 4595676
    • updated: 2023-02-06 01:52:37
    • created: 2023-02-05 01:49:09
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  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 , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  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-stage/raw/stellar_imsstyles/2023-02-05/1675583106'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-05/1675583106
    • id: 495359
    • processed: 1
    • raw_data: 
      {
    "backend_display": 5,
    "backend_hourly_enabled": 28,
    "backend_multi_day_disabled": 25,
    "backend_nightly_discount_amount": 55,
    "backend_nightly_discount_days": 53,
    "backend_nightly_discount_type": 54,
    "backend_nightly_enabled": 48,
    "backend_nightly_end": 52,
    "backend_nightly_max_nights": 50,
    "backend_nightly_min_nights": 49,
    "backend_nightly_start": 51,
    "billable_unit_type": 111,
    "brand": 73,
    "created_at": 112,
    "deposit_amount": 8,
    "description": 76,
    "dockmaster_part_number": 108,
    "dockmaster_tax_code": 109,
    "draft": 71,
    "end_hours": 110,
    "engine_type": 68,
    "frontend_display": 17,
    "frontend_hourly_enabled": 35,
    "frontend_min_hours_advance_departure": 27,
    "frontend_name": 18,
    "frontend_nightly_discount_amount": 63,
    "frontend_nightly_discount_days": 61,
    "frontend_nightly_discount_type": 62,
    "frontend_nightly_enabled": 56,
    "frontend_nightly_end": 60,
    "frontend_nightly_max_nights": 58,
    "frontend_nightly_min_nights": 57,
    "frontend_nightly_start": 59,
    "frontend_partial_payment_amount": 24,
    "frontend_partial_payment_type": 23,
    "frontend_position": 19,
    "frontend_qty_limit": 21,
    "frontend_type": 20,
    "frontend_unit_selector": 22,
    "fuel": 72,
    "fuel_burn_ratio": 10,
    "holiday_backend_hourly_max_hours": 34,
    "holiday_backend_hourly_min_hours": 33,
    "holiday_frontend_hourly_length_increment": 47,
    "holiday_frontend_hourly_max_hours": 45,
    "holiday_frontend_hourly_min_hours": 44,
    "holiday_frontend_hourly_time_increment": 46,
    "horsepower": 67,
    "id": 1,
    "image": 64,
    "insurance_enabled": 13,
    "insurance_first_day_price": 16,
    "insurance_pricing_rate": 15,
    "insurance_pricing_type": 14,
    "length": 69,
    "local_video_link": 107,
    "location_id": 2,
    "max_same_style_per_booking": 26,
    "model": 74,
    "notes": 78,
    "paperless_image_placeholders": 79,
    "passengers": 65,
    "position": 6,
    "preauth_amount": 9,
    "slideshow_1": 80,
    "slideshow_10": 89,
    "slideshow_11": 90,
    "slideshow_12": 91,
    "slideshow_13": 92,
    "slideshow_14": 93,
    "slideshow_15": 94,
    "slideshow_16": 95,
    "slideshow_17": 96,
    "slideshow_18": 97,
    "slideshow_19": 98,
    "slideshow_2": 81,
    "slideshow_20": 99,
    "slideshow_21": 100,
    "slideshow_22": 101,
    "slideshow_23": 102,
    "slideshow_24": 103,
    "slideshow_25": 104,
    "slideshow_3": 82,
    "slideshow_4": 83,
    "slideshow_5": 84,
    "slideshow_6": 85,
    "slideshow_7": 86,
    "slideshow_8": 87,
    "slideshow_9": 88,
    "smartwaiver_waiver_link": 106,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 77,
    "tax_1_rate": 11,
    "tax_2_rate": 12,
    "tenant": 0,
    "title": 75,
    "turnaround_time": 7,
    "updated_at": 113,
    "video_link": 105,
    "weekday_backend_hourly_max_hours": 30,
    "weekday_backend_hourly_min_hours": 29,
    "weekday_frontend_hourly_length_increment": 39,
    "weekday_frontend_hourly_max_hours": 37,
    "weekday_frontend_hourly_min_hours": 36,
    "weekday_frontend_hourly_time_increment": 38,
    "weekend_backend_hourly_max_hours": 32,
    "weekend_backend_hourly_min_hours": 31,
    "weekend_frontend_hourly_length_increment": 43,
    "weekend_frontend_hourly_max_hours": 41,
    "weekend_frontend_hourly_min_hours": 40,
    "weekend_frontend_hourly_time_increment": 42,
    "weight": 66,
    "width": 70
}
    • schema_attributes: 
      {
    "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_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_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",
    "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",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "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: 1769
    • schema_scan_id: 4592910
    • updated: 2023-02-05 01:49:20
    • created: 2023-02-04 01:49:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsstyles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  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 , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  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-stage/raw/stellar_imsstyles/2023-02-04/1675496668'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsstyles"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-04/1675496668
    • id: 494702
    • processed: 1
    • raw_data: 
      {
    "backend_display": 5,
    "backend_hourly_enabled": 28,
    "backend_multi_day_disabled": 25,
    "backend_nightly_discount_amount": 55,
    "backend_nightly_discount_days": 53,
    "backend_nightly_discount_type": 54,
    "backend_nightly_enabled": 48,
    "backend_nightly_end": 52,
    "backend_nightly_max_nights": 50,
    "backend_nightly_min_nights": 49,
    "backend_nightly_start": 51,
    "billable_unit_type": 111,
    "brand": 73,
    "created_at": 112,
    "deposit_amount": 8,
    "description": 76,
    "dockmaster_part_number": 108,
    "dockmaster_tax_code": 109,
    "draft": 71,
    "end_hours": 110,
    "engine_type": 68,
    "frontend_display": 17,
    "frontend_hourly_enabled": 35,
    "frontend_min_hours_advance_departure": 27,
    "frontend_name": 18,
    "frontend_nightly_discount_amount": 63,
    "frontend_nightly_discount_days": 61,
    "frontend_nightly_discount_type": 62,
    "frontend_nightly_enabled": 56,
    "frontend_nightly_end": 60,
    "frontend_nightly_max_nights": 58,
    "frontend_nightly_min_nights": 57,
    "frontend_nightly_start": 59,
    "frontend_partial_payment_amount": 24,
    "frontend_partial_payment_type": 23,
    "frontend_position": 19,
    "frontend_qty_limit": 21,
    "frontend_type": 20,
    "frontend_unit_selector": 22,
    "fuel": 72,
    "fuel_burn_ratio": 10,
    "holiday_backend_hourly_max_hours": 34,
    "holiday_backend_hourly_min_hours": 33,
    "holiday_frontend_hourly_length_increment": 47,
    "holiday_frontend_hourly_max_hours": 45,
    "holiday_frontend_hourly_min_hours": 44,
    "holiday_frontend_hourly_time_increment": 46,
    "horsepower": 67,
    "id": 1,
    "image": 64,
    "insurance_enabled": 13,
    "insurance_first_day_price": 16,
    "insurance_pricing_rate": 15,
    "insurance_pricing_type": 14,
    "length": 69,
    "local_video_link": 107,
    "location_id": 2,
    "max_same_style_per_booking": 26,
    "model": 74,
    "notes": 78,
    "paperless_image_placeholders": 79,
    "passengers": 65,
    "position": 6,
    "preauth_amount": 9,
    "slideshow_1": 80,
    "slideshow_10": 89,
    "slideshow_11": 90,
    "slideshow_12": 91,
    "slideshow_13": 92,
    "slideshow_14": 93,
    "slideshow_15": 94,
    "slideshow_16": 95,
    "slideshow_17": 96,
    "slideshow_18": 97,
    "slideshow_19": 98,
    "slideshow_2": 81,
    "slideshow_20": 99,
    "slideshow_21": 100,
    "slideshow_22": 101,
    "slideshow_23": 102,
    "slideshow_24": 103,
    "slideshow_25": 104,
    "slideshow_3": 82,
    "slideshow_4": 83,
    "slideshow_5": 84,
    "slideshow_6": 85,
    "slideshow_7": 86,
    "slideshow_8": 87,
    "slideshow_9": 88,
    "smartwaiver_waiver_link": 106,
    "style_group_id": 3,
    "style_name": 4,
    "summary": 77,
    "tax_1_rate": 11,
    "tax_2_rate": 12,
    "tenant": 0,
    "title": 75,
    "turnaround_time": 7,
    "updated_at": 113,
    "video_link": 105,
    "weekday_backend_hourly_max_hours": 30,
    "weekday_backend_hourly_min_hours": 29,
    "weekday_frontend_hourly_length_increment": 39,
    "weekday_frontend_hourly_max_hours": 37,
    "weekday_frontend_hourly_min_hours": 36,
    "weekday_frontend_hourly_time_increment": 38,
    "weekend_backend_hourly_max_hours": 32,
    "weekend_backend_hourly_min_hours": 31,
    "weekend_frontend_hourly_length_increment": 43,
    "weekend_frontend_hourly_max_hours": 41,
    "weekend_frontend_hourly_min_hours": 40,
    "weekend_frontend_hourly_time_increment": 42,
    "weight": 66,
    "width": 70
}
    • schema_attributes: 
      {
    "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_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_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",
    "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",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "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: 1769
    • schema_scan_id: 4589872
    • updated: 2023-02-04 01:49:52
Schema Scans: 3
Last at 2023-02-06 01:52:22
    • duration: 0:00:14.707333
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 4595676
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-06/1675669795",
        "key": "raw/stellar_imsstyles/2023-02-06/1675669795/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5729984165086469981,
        "service_name": "drive-thru",
        "span_id": 391957152743562382,
        "trace_id": 16755174692585592451
    }
}
    • running: False
    • schema_name_id: 1769
    • start_time: 2023-02-06 01:52:22
    • success: True
    • trace_id: 16755174692585592451
    • duration: 0:00:14.196194
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 4592910
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-05/1675583106",
        "key": "raw/stellar_imsstyles/2023-02-05/1675583106/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14272503004856007242,
        "service_name": "drive-thru",
        "span_id": 756079977818660855,
        "trace_id": 5156859831240876100
    }
}
    • running: False
    • schema_name_id: 1769
    • start_time: 2023-02-05 01:49:06
    • success: True
    • trace_id: 5156859831240876100
    • duration: 0:00:14.373639
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 4589872
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsstyles/2023-02-04/1675496668",
        "key": "raw/stellar_imsstyles/2023-02-04/1675496668/styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsstyles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14897053862044939531,
        "service_name": "drive-thru",
        "span_id": 14745724854357946461,
        "trace_id": 13855548863137936106
    }
}
    • running: False
    • schema_name_id: 1769
    • start_time: 2023-02-04 01:49:38
    • success: True
    • trace_id: 13855548863137936106
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "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_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_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",
    "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",
    "notes": "string",
    "paperless_image_placeholders": "string",
    "passengers": "string",
    "position": "string",
    "preauth_amount": "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: 2023-02-06 01:52:26
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  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 , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  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-stage/raw/stellar_imsstyles/2023-02-06/1675669795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsstyles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsstyles"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-01-31 12:07:35",
        "disabled": false,
        "format": "raw",
        "id": 1769,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "stellar_imsstyles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "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_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_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",
            "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",
            "notes": "string",
            "paperless_image_placeholders": "string",
            "passengers": "string",
            "position": "string",
            "preauth_amount": "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": "2023-02-06 01:52:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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_max_nights`  string , `frontend_nightly_start`  string , `frontend_nightly_end`  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 , `local_video_link`  string , `dockmaster_part_number`  string , `dockmaster_tax_code`  string , `end_hours`  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-stage/raw/stellar_imsstyles/2023-02-06/1675669795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsstyles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsstyles"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform