Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsstyle_boats
- created: 2023-02-07 01:48:44
- disabled: False
- format: raw
- id: 1503
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsstyle_boats" } - type: drivethrucsv
Schema Versions: 15
-
Version 1718020
- created: 2026-04-17 04:58:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-17/1776419653
- id: 1718020
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 162169374
- updated: 2026-04-17 04:59:06
-
Version 1716743
- created: 2026-04-16 05:17:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-16/1776334553'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-16/1776334553
- id: 1716743
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 162114411
- updated: 2026-04-16 05:18:04
-
Version 1715546
- created: 2026-04-15 03:43:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-15/1776242366'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-15/1776242366
- id: 1715546
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 162056433
- updated: 2026-04-15 03:43:44
-
Version 1714341
- created: 2026-04-14 05:02:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-14/1776160761'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-14/1776160761
- id: 1714341
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 162003018
- updated: 2026-04-14 05:02:24
-
Version 1713118
- created: 2026-04-13 05:08:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-13/1776074807'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-13/1776074807
- id: 1713118
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161945322
- updated: 2026-04-13 05:09:06
-
Version 1711987
- created: 2026-04-12 05:08:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-12/1775988164'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-12/1775988164
- id: 1711987
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161896449
- updated: 2026-04-12 05:09:12
-
Version 1710754
- created: 2026-04-11 05:19:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-11/1775902580'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-11/1775902580
- id: 1710754
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161843973
- updated: 2026-04-11 05:19:42
-
Version 1709548
- created: 2026-04-10 05:02:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-10/1775815220
- id: 1709548
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161788587
- updated: 2026-04-10 05:02:31
-
Version 1708435
- created: 2026-04-09 05:03:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-09/1775728842'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-09/1775728842
- id: 1708435
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161732992
- updated: 2026-04-09 05:03:55
-
Version 1707217
- created: 2026-04-08 05:13:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-08/1775642998
- id: 1707217
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161678376
- updated: 2026-04-08 05:13:35
-
Version 1706043
- created: 2026-04-07 05:17:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-07/1775556861'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-07/1775556861
- id: 1706043
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161622120
- updated: 2026-04-07 05:17:21
-
Version 1704824
- created: 2026-04-06 05:18:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-06/1775470537'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-06/1775470537
- id: 1704824
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161564299
- updated: 2026-04-06 05:18:57
-
Version 1703555
- created: 2026-04-05 04:56:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-05/1775382950'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-05/1775382950
- id: 1703555
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161516532
- updated: 2026-04-05 04:57:02
-
Version 1702410
- created: 2026-04-04 04:55:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-04/1775296465'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-04/1775296465
- id: 1702410
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161462111
- updated: 2026-04-04 04:56:01
-
Version 1701255
- created: 2026-04-03 05:13:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-03/1775211039'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_boats/2026-04-03/1775211039
- id: 1701255
- processed: 1
- raw_data:
{ "backend_display": 30, "boat_number": 3, "boat_year_model": 24, "buoy_insurance_status": 37, "clean_status": 35, "club_location": 19, "created_at": 38, "cylinders": 11, "dealer_city": 21, "dealer_name": 20, "dealer_state": 22, "engine_purchased_cost": 29, "hp": 12, "hull_number": 9, "id": 1, "in_fleet": 8, "insurance_reg_no": 36, "manufacturer": 6, "model": 13, "motor": 5, "motor_manufacturer_model": 26, "motor_year_model": 25, "paperless_number": 4, "po_number": 23, "position": 31, "purchased_cost": 16, "purchased_date": 15, "sale_date": 17, "sale_price": 18, "serial": 7, "service_end": 34, "service_start": 33, "state_number": 10, "state_reg_date": 27, "state_reg_exp_date": 28, "status": 32, "style_id": 2, "tenant": 0, "type": 14, "updated_at": 39 } - schema_attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - schema_name_id: 1503
- schema_scan_id: 161404852
- updated: 2026-04-03 05:13:36
Schema Scans: 15
Last at 2026-04-17 04:58:49
-
Scan 162169374
- duration: 0:00:16.289253
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169374
- 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_imsstyle_boats/2026-04-17/1776419653", "key": "raw/stellar_imsstyle_boats/2026-04-17/1776419653/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11576959424053730335, "service_name": "drive-thru", "span_id": 12672105760277406574, "trace_id": 2002372210970902271 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-17 04:58:49
- success: True
- trace_id: 2002372210970902271
-
Scan 162114411
- duration: 0:00:14.012218
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114411
- 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_imsstyle_boats/2026-04-16/1776334553", "key": "raw/stellar_imsstyle_boats/2026-04-16/1776334553/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17001516179206628595, "service_name": "drive-thru", "span_id": 836672137616481811, "trace_id": 15479141166348288755 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-16 05:17:50
- success: True
- trace_id: 15479141166348288755
-
Scan 162056433
- duration: 0:00:16.570287
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056433
- 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_imsstyle_boats/2026-04-15/1776242366", "key": "raw/stellar_imsstyle_boats/2026-04-15/1776242366/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8373204769568944477, "service_name": "drive-thru", "span_id": 8664253965143275133, "trace_id": 16950597308649501811 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-15 03:43:27
- success: True
- trace_id: 16950597308649501811
-
Scan 162003018
- duration: 0:00:16.388191
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003018
- 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_imsstyle_boats/2026-04-14/1776160761", "key": "raw/stellar_imsstyle_boats/2026-04-14/1776160761/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12738242362832866338, "service_name": "drive-thru", "span_id": 11916443572387262480, "trace_id": 15336103519416303353 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-14 05:02:08
- success: True
- trace_id: 15336103519416303353
-
Scan 161945322
- duration: 0:00:13.744179
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945322
- 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_imsstyle_boats/2026-04-13/1776074807", "key": "raw/stellar_imsstyle_boats/2026-04-13/1776074807/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7845331928223400983, "service_name": "drive-thru", "span_id": 18091063221807720405, "trace_id": 4727352726980795044 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-13 05:08:53
- success: True
- trace_id: 4727352726980795044
-
Scan 161896449
- duration: 0:00:16.570689
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896449
- 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_imsstyle_boats/2026-04-12/1775988164", "key": "raw/stellar_imsstyle_boats/2026-04-12/1775988164/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2003319274674549025, "service_name": "drive-thru", "span_id": 8634129024950025234, "trace_id": 3697836950957936792 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-12 05:08:56
- success: True
- trace_id: 3697836950957936792
-
Scan 161843973
- duration: 0:00:13.774545
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843973
- 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_imsstyle_boats/2026-04-11/1775902580", "key": "raw/stellar_imsstyle_boats/2026-04-11/1775902580/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1830877730423024390, "service_name": "drive-thru", "span_id": 7817391872822820389, "trace_id": 6207137175642824869 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-11 05:19:28
- success: True
- trace_id: 6207137175642824869
-
Scan 161788587
- duration: 0:00:16.354019
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788587
- 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_imsstyle_boats/2026-04-10/1775815220", "key": "raw/stellar_imsstyle_boats/2026-04-10/1775815220/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6258258887141656212, "service_name": "drive-thru", "span_id": 9559538573976128198, "trace_id": 16267721108618675812 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-10 05:02:15
- success: True
- trace_id: 16267721108618675812
-
Scan 161732992
- duration: 0:00:19.033015
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732992
- 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_imsstyle_boats/2026-04-09/1775728842", "key": "raw/stellar_imsstyle_boats/2026-04-09/1775728842/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7484183138624237199, "service_name": "drive-thru", "span_id": 6123903688329150941, "trace_id": 3809639991708084259 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-09 05:03:36
- success: True
- trace_id: 3809639991708084259
-
Scan 161678376
- duration: 0:00:14.004164
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678376
- 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_imsstyle_boats/2026-04-08/1775642998", "key": "raw/stellar_imsstyle_boats/2026-04-08/1775642998/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 256152036968378455, "service_name": "drive-thru", "span_id": 9501106908313955773, "trace_id": 5715433895126509863 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-08 05:13:21
- success: True
- trace_id: 5715433895126509863
-
Scan 161622120
- duration: 0:00:16.456390
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622120
- 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_imsstyle_boats/2026-04-07/1775556861", "key": "raw/stellar_imsstyle_boats/2026-04-07/1775556861/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16874269871253762658, "service_name": "drive-thru", "span_id": 679721395684115213, "trace_id": 3822333045642016228 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-07 05:17:04
- success: True
- trace_id: 3822333045642016228
-
Scan 161564299
- duration: 0:00:16.482581
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564299
- 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_imsstyle_boats/2026-04-06/1775470537", "key": "raw/stellar_imsstyle_boats/2026-04-06/1775470537/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1302169024906367632, "service_name": "drive-thru", "span_id": 9201036321154772340, "trace_id": 8975312954848808200 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-06 05:18:41
- success: True
- trace_id: 8975312954848808200
-
Scan 161516532
- duration: 0:00:13.950193
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516532
- 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_imsstyle_boats/2026-04-05/1775382950", "key": "raw/stellar_imsstyle_boats/2026-04-05/1775382950/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6709748805598506261, "service_name": "drive-thru", "span_id": 2051136689067581851, "trace_id": 13282342500739868346 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-05 04:56:48
- success: True
- trace_id: 13282342500739868346
-
Scan 161462111
- duration: 0:00:16.207663
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462111
- 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_imsstyle_boats/2026-04-04/1775296465", "key": "raw/stellar_imsstyle_boats/2026-04-04/1775296465/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13354980605743165140, "service_name": "drive-thru", "span_id": 7365391555329848537, "trace_id": 15370596873261739549 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-04 04:55:45
- success: True
- trace_id: 15370596873261739549
-
Scan 161404852
- duration: 0:00:16.263252
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404852
- 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_imsstyle_boats/2026-04-03/1775211039", "key": "raw/stellar_imsstyle_boats/2026-04-03/1775211039/style_boats.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_boats", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1267224506244075380, "service_name": "drive-thru", "span_id": 4336602230051078784, "trace_id": 13864758440716577786 } } - running: False
- schema_name_id: 1503
- start_time: 2026-04-03 05:13:19
- success: True
- trace_id: 13864758440716577786
- attributes:
{ "1": "string", "10": "string", "2": "string", "2022_03_10_07_25_54": "string", "2022_03_10_07_25_54_2": "string", "2022_03_10_07_25_57": "string", "2022_03_10_07_25_57_3": "string", "2022_03_10_07_26_01": "string", "2022_03_10_07_26_01_4": "string", "2022_03_10_07_26_04": "string", "2022_03_10_07_26_04_5": "string", "2022_03_10_07_26_36": "string", "2022_03_10_07_26_39": "string", "2022_03_10_07_26_42": "string", "2022_03_10_07_26_53": "string", "2022_03_10_07_26_56": "string", "2022_03_10_07_27_00": "string", "2022_03_10_07_27_03": "string", "2022_03_10_07_27_47": "string", "2022_03_10_07_28_19": "string", "2022_03_10_07_28_19_17": "string", "2022_03_10_07_28_26": "string", "2022_03_10_07_28_26_18": "string", "2022_03_10_07_28_50": "string", "2022_03_10_07_28_59": "string", "2022_03_10_07_29_14": "string", "2022_03_10_07_29_14_21": "string", "2022_03_10_07_29_17": "string", "2022_03_10_07_29_17_22": "string", "2022_03_10_07_29_22": "string", "2022_03_10_07_29_22_23": "string", "2022_03_10_07_29_26": "string", "2022_03_10_07_29_26_24": "string", "2022_03_10_07_29_30": "string", "2022_03_10_07_29_30_25": "string", "2022_03_10_07_30_02": "string", "2022_03_10_07_30_02_26": "string", "2022_03_10_07_30_06": "string", "2022_03_10_07_30_06_27": "string", "2022_03_10_07_30_09": "string", "2022_03_10_07_30_09_28": "string", "2022_03_10_07_30_21": "string", "2022_03_10_07_30_21_29": "string", "2022_03_10_07_30_25": "string", "2022_03_10_07_30_25_30": "string", "2022_03_10_07_30_28": "string", "2022_03_10_07_30_28_31": "string", "2022_03_10_07_30_48": "string", "2022_03_10_07_30_48_32": "string", "2022_05_20_21_15_50": "string", "2022_05_20_21_15_50_33": "string", "2022_05_20_21_16_10_20": "string", "2022_05_28_07_00_06_10": "string", "2022_05_28_07_00_19_9": "string", "2022_05_28_07_00_34_8": "string", "2022_05_28_07_00_50_7": "string", "2022_05_28_07_01_03_6": "string", "2022_07_20_16_57_57": "string", "2022_08_16": "string", "2022_08_16_08_18_47_16": "string", "2022_08_17": "string", "2022_08_17_10_25_15_15": "string", "2022_08_17_10_26_20_11": "string", "2022_08_29": "string", "2022_08_29_14_13_57_19": "string", "2022_11_30": "string", "2023_10_30": "string", "3": "string", "4": "string", "5": "string", "5421": "string", "6": "string", "7": "string", "8": "string", "8833": "string", "8835": "string", "8836": "string", "9": "string", "9673": "string", "9978": "string", "9979": "string", "Active": "string", "Pontoon": "string", "Red_White": "string", "Sanger_Wakeboard_Boat": "string", "Skiboat_Bayliner": "string", "Water_Trampoline": "string", "Yes": "string", "backend_display": "string", "boat_number": "string", "boat_year_model": "string", "buoy_insurance_status": "string", "clean_status": "string", "club_location": "string", "created_at": "string", "cylinders": "string", "dealer_city": "string", "dealer_name": "string", "dealer_state": "string", "engine_purchased_cost": "string", "hp": "string", "hull_number": "string", "id": "string", "in_fleet": "string", "insurance_reg_no": "string", "manufacturer": "string", "model": "string", "motor": "string", "motor_manufacturer_model": "string", "motor_year_model": "string", "paperless_number": "string", "po_number": "string", "position": "string", "purchased_cost": "string", "purchased_date": "string", "sale_date": "string", "sale_price": "string", "serial": "string", "service_end": "string", "service_start": "string", "state_number": "string", "state_reg_date": "string", "state_reg_exp_date": "string", "status": "string", "style_id": "string", "tenant": "string", "type": "string", "updated_at": "string", "updated_at_1": "string" } - created: 2026-04-17 04:58:52
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:48:44",
"disabled": false,
"format": "raw",
"id": 1503,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsstyle_boats"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"1": "string",
"10": "string",
"2": "string",
"2022_03_10_07_25_54": "string",
"2022_03_10_07_25_54_2": "string",
"2022_03_10_07_25_57": "string",
"2022_03_10_07_25_57_3": "string",
"2022_03_10_07_26_01": "string",
"2022_03_10_07_26_01_4": "string",
"2022_03_10_07_26_04": "string",
"2022_03_10_07_26_04_5": "string",
"2022_03_10_07_26_36": "string",
"2022_03_10_07_26_39": "string",
"2022_03_10_07_26_42": "string",
"2022_03_10_07_26_53": "string",
"2022_03_10_07_26_56": "string",
"2022_03_10_07_27_00": "string",
"2022_03_10_07_27_03": "string",
"2022_03_10_07_27_47": "string",
"2022_03_10_07_28_19": "string",
"2022_03_10_07_28_19_17": "string",
"2022_03_10_07_28_26": "string",
"2022_03_10_07_28_26_18": "string",
"2022_03_10_07_28_50": "string",
"2022_03_10_07_28_59": "string",
"2022_03_10_07_29_14": "string",
"2022_03_10_07_29_14_21": "string",
"2022_03_10_07_29_17": "string",
"2022_03_10_07_29_17_22": "string",
"2022_03_10_07_29_22": "string",
"2022_03_10_07_29_22_23": "string",
"2022_03_10_07_29_26": "string",
"2022_03_10_07_29_26_24": "string",
"2022_03_10_07_29_30": "string",
"2022_03_10_07_29_30_25": "string",
"2022_03_10_07_30_02": "string",
"2022_03_10_07_30_02_26": "string",
"2022_03_10_07_30_06": "string",
"2022_03_10_07_30_06_27": "string",
"2022_03_10_07_30_09": "string",
"2022_03_10_07_30_09_28": "string",
"2022_03_10_07_30_21": "string",
"2022_03_10_07_30_21_29": "string",
"2022_03_10_07_30_25": "string",
"2022_03_10_07_30_25_30": "string",
"2022_03_10_07_30_28": "string",
"2022_03_10_07_30_28_31": "string",
"2022_03_10_07_30_48": "string",
"2022_03_10_07_30_48_32": "string",
"2022_05_20_21_15_50": "string",
"2022_05_20_21_15_50_33": "string",
"2022_05_20_21_16_10_20": "string",
"2022_05_28_07_00_06_10": "string",
"2022_05_28_07_00_19_9": "string",
"2022_05_28_07_00_34_8": "string",
"2022_05_28_07_00_50_7": "string",
"2022_05_28_07_01_03_6": "string",
"2022_07_20_16_57_57": "string",
"2022_08_16": "string",
"2022_08_16_08_18_47_16": "string",
"2022_08_17": "string",
"2022_08_17_10_25_15_15": "string",
"2022_08_17_10_26_20_11": "string",
"2022_08_29": "string",
"2022_08_29_14_13_57_19": "string",
"2022_11_30": "string",
"2023_10_30": "string",
"3": "string",
"4": "string",
"5": "string",
"5421": "string",
"6": "string",
"7": "string",
"8": "string",
"8833": "string",
"8835": "string",
"8836": "string",
"9": "string",
"9673": "string",
"9978": "string",
"9979": "string",
"Active": "string",
"Pontoon": "string",
"Red_White": "string",
"Sanger_Wakeboard_Boat": "string",
"Skiboat_Bayliner": "string",
"Water_Trampoline": "string",
"Yes": "string",
"backend_display": "string",
"boat_number": "string",
"boat_year_model": "string",
"buoy_insurance_status": "string",
"clean_status": "string",
"club_location": "string",
"created_at": "string",
"cylinders": "string",
"dealer_city": "string",
"dealer_name": "string",
"dealer_state": "string",
"engine_purchased_cost": "string",
"hp": "string",
"hull_number": "string",
"id": "string",
"in_fleet": "string",
"insurance_reg_no": "string",
"manufacturer": "string",
"model": "string",
"motor": "string",
"motor_manufacturer_model": "string",
"motor_year_model": "string",
"paperless_number": "string",
"po_number": "string",
"position": "string",
"purchased_cost": "string",
"purchased_date": "string",
"sale_date": "string",
"sale_price": "string",
"serial": "string",
"service_end": "string",
"service_start": "string",
"state_number": "string",
"state_reg_date": "string",
"state_reg_exp_date": "string",
"status": "string",
"style_id": "string",
"tenant": "string",
"type": "string",
"updated_at": "string",
"updated_at_1": "string"
},
"created": "2026-04-17 04:58:52",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_boats`\n(\n `tenant` string , `id` string , `style_id` string , `boat_number` string , `paperless_number` string , `motor` string , `manufacturer` string , `serial` string , `in_fleet` string , `hull_number` string , `state_number` string , `cylinders` string , `hp` string , `model` string , `type` string , `purchased_date` string , `purchased_cost` string , `sale_date` string , `sale_price` string , `club_location` string , `dealer_name` string , `dealer_city` string , `dealer_state` string , `po_number` string , `boat_year_model` string , `motor_year_model` string , `motor_manufacturer_model` string , `state_reg_date` string , `state_reg_exp_date` string , `engine_purchased_cost` string , `backend_display` string , `position` string , `status` string , `service_start` string , `service_end` string , `clean_status` string , `insurance_reg_no` string , `buoy_insurance_status` 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_imsstyle_boats/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_boats`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_boats"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}