Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsaccessories

created: 2023-02-07 01:45:00
disabled: False
format: raw
id: 1428
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717960

created: 2026-04-17 04:56:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-17/1776419647
id: 1717960
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 162169297
updated: 2026-04-17 04:56:48

Version 1716709

created: 2026-04-16 05:16:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-16/1776334541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-16/1776334541
id: 1716709
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 162114378
updated: 2026-04-16 05:16:54

Version 1715495

created: 2026-04-15 03:41:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-15/1776242355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-15/1776242355
id: 1715495
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 162056378
updated: 2026-04-15 03:41:45

Version 1714317

created: 2026-04-14 05:01:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-14/1776160750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-14/1776160750
id: 1714317
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 162002962
updated: 2026-04-14 05:01:16

Version 1713083

created: 2026-04-13 05:07:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-13/1776074797
id: 1713083
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161945289
updated: 2026-04-13 05:07:48

Version 1711877

created: 2026-04-12 05:02:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-12/1775988155
id: 1711877
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161896310
updated: 2026-04-12 05:03:06

Version 1710686

created: 2026-04-11 05:16:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-11/1775902572'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-11/1775902572
id: 1710686
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161843905
updated: 2026-04-11 05:17:08

Version 1709502

created: 2026-04-10 05:00:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-10/1775815208'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-10/1775815208
id: 1709502
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161788535
updated: 2026-04-10 05:00:44

Version 1708466

created: 2026-04-09 05:04:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-09/1775728847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-09/1775728847
id: 1708466
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161733031
updated: 2026-04-09 05:05:09

Version 1707238

created: 2026-04-08 05:14:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-08/1775642999
id: 1707238
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161678397
updated: 2026-04-08 05:14:32

Version 1705979

created: 2026-04-07 05:14:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-07/1775556855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-07/1775556855
id: 1705979
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161622057
updated: 2026-04-07 05:15:03

Version 1704758

created: 2026-04-06 05:16:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-06/1775470524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-06/1775470524
id: 1704758
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161564228
updated: 2026-04-06 05:16:31

Version 1703608

created: 2026-04-05 04:58:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-05/1775382954'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-05/1775382954
id: 1703608
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161516613
updated: 2026-04-05 04:59:06

Version 1702419

created: 2026-04-04 04:56:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-04/1775296468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-04/1775296468
id: 1702419
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161462120
updated: 2026-04-04 04:56:22

Version 1701191

created: 2026-04-03 05:10:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-03/1775211028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessories/2026-04-03/1775211028
id: 1701191
processed: 1

raw_data:

{
    "abbreviation": 7,
    "accessory_name": 3,
    "backend_available_days": 40,
    "created_at": 44,
    "deposit_amount": 35,
    "description": 42,
    "frontend_available_days": 41,
    "frontend_position": 5,
    "frontend_qty_limit": 38,
    "id": 1,
    "image": 8,
    "location_id": 2,
    "max_overlapping_rentals": 37,
    "max_same_departures": 43,
    "position": 4,
    "price": 34,
    "short_name": 6,
    "slideshow_1": 9,
    "slideshow_10": 18,
    "slideshow_11": 19,
    "slideshow_12": 20,
    "slideshow_13": 21,
    "slideshow_14": 22,
    "slideshow_15": 23,
    "slideshow_16": 24,
    "slideshow_17": 25,
    "slideshow_18": 26,
    "slideshow_19": 27,
    "slideshow_2": 10,
    "slideshow_20": 28,
    "slideshow_21": 29,
    "slideshow_22": 30,
    "slideshow_23": 31,
    "slideshow_24": 32,
    "slideshow_25": 33,
    "slideshow_3": 11,
    "slideshow_4": 12,
    "slideshow_5": 13,
    "slideshow_6": 14,
    "slideshow_7": 15,
    "slideshow_8": 16,
    "slideshow_9": 17,
    "tax_exempt": 36,
    "tenant": 0,
    "updated_at": 45,
    "use_striped_background": 39
}

schema_attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

schema_name_id: 1428
schema_scan_id: 161404789
updated: 2026-04-03 05:11:08

Schema Scans: 15

Last at 2026-04-17 04:56:35

Scan 162169297

duration: 0:00:13.297063

exit_message:

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

id: 162169297

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_imsaccessories/2026-04-17/1776419647",
        "key": "raw/stellar_imsaccessories/2026-04-17/1776419647/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14235519504442313159,
        "service_name": "drive-thru",
        "span_id": 14822718528871762863,
        "trace_id": 16255672530153672769
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-17 04:56:35
success: True
trace_id: 16255672530153672769

Scan 162114378

duration: 0:00:16.264107

exit_message:

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

id: 162114378

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_imsaccessories/2026-04-16/1776334541",
        "key": "raw/stellar_imsaccessories/2026-04-16/1776334541/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5159148900183807473,
        "service_name": "drive-thru",
        "span_id": 897364165455669367,
        "trace_id": 12010932820722672161
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-16 05:16:38
success: True
trace_id: 12010932820722672161

Scan 162056378

duration: 0:00:15.958028

exit_message:

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

id: 162056378

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_imsaccessories/2026-04-15/1776242355",
        "key": "raw/stellar_imsaccessories/2026-04-15/1776242355/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 583723108897360521,
        "service_name": "drive-thru",
        "span_id": 9274888978148080990,
        "trace_id": 11821024274688739999
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-15 03:41:29
success: True
trace_id: 11821024274688739999

Scan 162002962

duration: 0:00:13.398090

exit_message:

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

id: 162002962

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_imsaccessories/2026-04-14/1776160750",
        "key": "raw/stellar_imsaccessories/2026-04-14/1776160750/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2507884115342679286,
        "service_name": "drive-thru",
        "span_id": 5961810479917385894,
        "trace_id": 7816340099372292890
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-14 05:01:03
success: True
trace_id: 7816340099372292890

Scan 161945289

duration: 0:00:13.290968

exit_message:

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

id: 161945289

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_imsaccessories/2026-04-13/1776074797",
        "key": "raw/stellar_imsaccessories/2026-04-13/1776074797/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 289084489386704385,
        "service_name": "drive-thru",
        "span_id": 9766407649624471455,
        "trace_id": 12815444997900759587
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-13 05:07:34
success: True
trace_id: 12815444997900759587

Scan 161896310

duration: 0:00:15.925285

exit_message:

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

id: 161896310

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_imsaccessories/2026-04-12/1775988155",
        "key": "raw/stellar_imsaccessories/2026-04-12/1775988155/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17727454020022465699,
        "service_name": "drive-thru",
        "span_id": 8583231583855988675,
        "trace_id": 2489714564089952542
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-12 05:02:50
success: True
trace_id: 2489714564089952542

Scan 161843905

duration: 0:00:15.833594

exit_message:

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

id: 161843905

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_imsaccessories/2026-04-11/1775902572",
        "key": "raw/stellar_imsaccessories/2026-04-11/1775902572/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9729939998866822812,
        "service_name": "drive-thru",
        "span_id": 1137309891668734063,
        "trace_id": 10638650105255111773
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-11 05:16:53
success: True
trace_id: 10638650105255111773

Scan 161788535

duration: 0:00:16.166708

exit_message:

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

id: 161788535

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_imsaccessories/2026-04-10/1775815208",
        "key": "raw/stellar_imsaccessories/2026-04-10/1775815208/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8200958402306231017,
        "service_name": "drive-thru",
        "span_id": 8463152638409546663,
        "trace_id": 14865069438109752790
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-10 05:00:27
success: True
trace_id: 14865069438109752790

Scan 161733031

duration: 0:00:13.339419

exit_message:

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

id: 161733031

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_imsaccessories/2026-04-09/1775728847",
        "key": "raw/stellar_imsaccessories/2026-04-09/1775728847/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14143951956686641217,
        "service_name": "drive-thru",
        "span_id": 9842276625497199298,
        "trace_id": 6789425130709217837
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-09 05:04:56
success: True
trace_id: 6789425130709217837

Scan 161678397

duration: 0:00:16.161994

exit_message:

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

id: 161678397

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_imsaccessories/2026-04-08/1775642999",
        "key": "raw/stellar_imsaccessories/2026-04-08/1775642999/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17032163416420786677,
        "service_name": "drive-thru",
        "span_id": 698582476370888832,
        "trace_id": 3074354627922225589
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-08 05:14:16
success: True
trace_id: 3074354627922225589

Scan 161622057

duration: 0:00:16.161849

exit_message:

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

id: 161622057

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_imsaccessories/2026-04-07/1775556855",
        "key": "raw/stellar_imsaccessories/2026-04-07/1775556855/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 55795194276923864,
        "service_name": "drive-thru",
        "span_id": 16085417538982732467,
        "trace_id": 14765921745000147502
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-07 05:14:47
success: True
trace_id: 14765921745000147502

Scan 161564228

duration: 0:00:16.214219

exit_message:

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

id: 161564228

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_imsaccessories/2026-04-06/1775470524",
        "key": "raw/stellar_imsaccessories/2026-04-06/1775470524/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3290471098855399144,
        "service_name": "drive-thru",
        "span_id": 1139496766626041217,
        "trace_id": 3550492174447025221
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-06 05:16:15
success: True
trace_id: 3550492174447025221

Scan 161516613

duration: 0:00:13.296779

exit_message:

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

id: 161516613

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_imsaccessories/2026-04-05/1775382954",
        "key": "raw/stellar_imsaccessories/2026-04-05/1775382954/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12179772546900443353,
        "service_name": "drive-thru",
        "span_id": 13624619611647086586,
        "trace_id": 1494369687896040824
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-05 04:58:53
success: True
trace_id: 1494369687896040824

Scan 161462120

duration: 0:00:13.339492

exit_message:

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

id: 161462120

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_imsaccessories/2026-04-04/1775296468",
        "key": "raw/stellar_imsaccessories/2026-04-04/1775296468/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9487944174714960330,
        "service_name": "drive-thru",
        "span_id": 11924184835960468599,
        "trace_id": 5325905038937750663
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-04 04:56:09
success: True
trace_id: 5325905038937750663

Scan 161404789

duration: 0:00:15.966642

exit_message:

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

id: 161404789

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_imsaccessories/2026-04-03/1775211028",
        "key": "raw/stellar_imsaccessories/2026-04-03/1775211028/accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8610420614207481206,
        "service_name": "drive-thru",
        "span_id": 5192604938881655264,
        "trace_id": 17651944722386075805
    }
}

running: False
schema_name_id: 1428
start_time: 2026-04-03 05:10:52
success: True
trace_id: 17651944722386075805

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "2022_03_14_07_04_55": "string",
    "2022_03_14_07_04_55_2": "string",
    "2022_03_14_07_05_06": "string",
    "2022_03_14_07_05_06_3": "string",
    "2022_03_14_07_05_12": "string",
    "2022_03_14_07_05_12_4": "string",
    "2022_03_14_07_05_21": "string",
    "2022_03_14_07_05_21_5": "string",
    "2022_03_18_07_58_09": "string",
    "2022_03_18_07_58_09_6": "string",
    "2022_03_18_08_09_32": "string",
    "2022_03_18_08_09_59_7": "string",
    "2022_06_01_19_44_50": "string",
    "2022_06_01_19_45_14": "string",
    "2022_06_01_19_45_51": "string",
    "2022_06_08_12_36_08_8": "string",
    "2022_06_08_12_39_26_10": "string",
    "2022_06_08_12_39_43_9": "string",
    "2022_06_14_11_07_23": "string",
    "2022_06_14_11_07_34": "string",
    "2022_06_14_11_07_41": "string",
    "2022_06_14_11_07_52": "string",
    "2022_06_14_11_11_04": "string",
    "2022_06_14_11_11_09_13": "string",
    "2022_06_14_11_11_13_12": "string",
    "2022_06_14_11_11_17_11": "string",
    "Delivery": "string",
    "Delivery_to_Bass_Lake": "string",
    "Delivery_to_Millerton": "string",
    "Delivery_to_Pineflat": "string",
    "Delivery_to_Shaver_Lake": "string",
    "Fuel": "string",
    "How_many_adult_life_jackets_do_you_need_": "string",
    "How_many_children_life_jackets_do_you_need_": "string",
    "Kneeboard": "string",
    "No": "string",
    "Pickup": "string",
    "Skis": "string",
    "Tubes": "string",
    "Wakeboard": "string",
    "Yes": "string",
    "abbreviation": "string",
    "accessory_name": "string",
    "backend_available_days": "string",
    "created_at": "string",
    "deposit_amount": "string",
    "description": "string",
    "frontend_available_days": "string",
    "frontend_position": "string",
    "frontend_qty_limit": "string",
    "id": "string",
    "image": "string",
    "location_id": "string",
    "max_overlapping_rentals": "string",
    "max_same_departures": "string",
    "position": "string",
    "price": "string",
    "short_name": "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",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "use_striped_background": "string"
}

created: 2026-04-17 04:56:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:45:00",
        "disabled": false,
        "format": "raw",
        "id": 1428,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsaccessories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "2022_03_14_07_04_55": "string",
            "2022_03_14_07_04_55_2": "string",
            "2022_03_14_07_05_06": "string",
            "2022_03_14_07_05_06_3": "string",
            "2022_03_14_07_05_12": "string",
            "2022_03_14_07_05_12_4": "string",
            "2022_03_14_07_05_21": "string",
            "2022_03_14_07_05_21_5": "string",
            "2022_03_18_07_58_09": "string",
            "2022_03_18_07_58_09_6": "string",
            "2022_03_18_08_09_32": "string",
            "2022_03_18_08_09_59_7": "string",
            "2022_06_01_19_44_50": "string",
            "2022_06_01_19_45_14": "string",
            "2022_06_01_19_45_51": "string",
            "2022_06_08_12_36_08_8": "string",
            "2022_06_08_12_39_26_10": "string",
            "2022_06_08_12_39_43_9": "string",
            "2022_06_14_11_07_23": "string",
            "2022_06_14_11_07_34": "string",
            "2022_06_14_11_07_41": "string",
            "2022_06_14_11_07_52": "string",
            "2022_06_14_11_11_04": "string",
            "2022_06_14_11_11_09_13": "string",
            "2022_06_14_11_11_13_12": "string",
            "2022_06_14_11_11_17_11": "string",
            "Delivery": "string",
            "Delivery_to_Bass_Lake": "string",
            "Delivery_to_Millerton": "string",
            "Delivery_to_Pineflat": "string",
            "Delivery_to_Shaver_Lake": "string",
            "Fuel": "string",
            "How_many_adult_life_jackets_do_you_need_": "string",
            "How_many_children_life_jackets_do_you_need_": "string",
            "Kneeboard": "string",
            "No": "string",
            "Pickup": "string",
            "Skis": "string",
            "Tubes": "string",
            "Wakeboard": "string",
            "Yes": "string",
            "abbreviation": "string",
            "accessory_name": "string",
            "backend_available_days": "string",
            "created_at": "string",
            "deposit_amount": "string",
            "description": "string",
            "frontend_available_days": "string",
            "frontend_position": "string",
            "frontend_qty_limit": "string",
            "id": "string",
            "image": "string",
            "location_id": "string",
            "max_overlapping_rentals": "string",
            "max_same_departures": "string",
            "position": "string",
            "price": "string",
            "short_name": "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",
            "tax_exempt": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_1": "string",
            "use_striped_background": "string"
        },
        "created": "2026-04-17 04:56:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `accessory_name`  string , `position`  string , `frontend_position`  string , `short_name`  string , `abbreviation`  string , `image`  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 , `price`  string , `deposit_amount`  string , `tax_exempt`  string , `max_overlapping_rentals`  string , `frontend_qty_limit`  string , `use_striped_background`  string , `backend_available_days`  string , `frontend_available_days`  string , `description`  string , `max_same_departures`  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_imsaccessories/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}