Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_accessories

created: 2023-02-07 01:46:25
disabled: False
format: raw
id: 1459
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717953

created: 2026-04-17 04:56:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-17/1776419643
id: 1717953
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 162169291
updated: 2026-04-17 04:56:34

Version 1716723

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-16/1776334541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 162114391
updated: 2026-04-16 05:17:21

Version 1715447

created: 2026-04-15 03:39:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-15/1776242356
id: 1715447
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 162056329
updated: 2026-04-15 03:39:51

Version 1714381

created: 2026-04-14 05:03:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-14/1776160757
id: 1714381
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 162003104
updated: 2026-04-14 05:04:08

Version 1713103

created: 2026-04-13 05:08:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161945309
updated: 2026-04-13 05:08:39

Version 1711913

created: 2026-04-12 05:04:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-12/1775988156'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-12/1775988156
id: 1711913
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161896361
updated: 2026-04-12 05:05:09

Version 1710687

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-11/1775902575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-11/1775902575
id: 1710687
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161843906
updated: 2026-04-11 05:17:09

Version 1709503

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-10/1775815208'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161788536
updated: 2026-04-10 05:00:45

Version 1708372

created: 2026-04-09 05:01:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-09/1775728831'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-09/1775728831
id: 1708372
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161732927
updated: 2026-04-09 05:01:29

Version 1707265

created: 2026-04-08 05:15:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-08/1775642997'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-08/1775642997
id: 1707265
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161678425
updated: 2026-04-08 05:15:34

Version 1706012

created: 2026-04-07 05:15:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-07/1775556856
id: 1706012
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161622089
updated: 2026-04-07 05:16:13

Version 1704827

created: 2026-04-06 05:18:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-06/1775470529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-06/1775470529
id: 1704827
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161564302
updated: 2026-04-06 05:19:08

Version 1703590

created: 2026-04-05 04:58:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-05/1775382945
id: 1703590
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161516587
updated: 2026-04-05 04:58:29

Version 1702482

created: 2026-04-04 04:58:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-04/1775296466
id: 1702482
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161462225
updated: 2026-04-04 04:58:44

Version 1701300

created: 2026-04-03 05:15:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-03/1775211035
id: 1701300
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "booking_id": 1,
    "created_at": 7,
    "price": 4,
    "price_override": 5,
    "qty": 3,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

schema_name_id: 1459
schema_scan_id: 161404900
updated: 2026-04-03 05:15:28

Schema Scans: 15

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

Scan 162169291

duration: 0:00:15.397425

exit_message:

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

id: 162169291

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-17/1776419643",
        "key": "raw/stellar_imsbooking_accessories/2026-04-17/1776419643/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 936182543733815934,
        "service_name": "drive-thru",
        "span_id": 13270709969271861099,
        "trace_id": 8997854307166472667
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-17 04:56:19
success: True
trace_id: 8997854307166472667

Scan 162114391

duration: 0:00:12.944779

exit_message:

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

id: 162114391

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-16/1776334541",
        "key": "raw/stellar_imsbooking_accessories/2026-04-16/1776334541/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3085093672792350502,
        "service_name": "drive-thru",
        "span_id": 9756813871773264101,
        "trace_id": 13762166179456100082
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-16 05:17:08
success: True
trace_id: 13762166179456100082

Scan 162056329

duration: 0:00:12.913275

exit_message:

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

id: 162056329

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-15/1776242356",
        "key": "raw/stellar_imsbooking_accessories/2026-04-15/1776242356/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2819485174085506653,
        "service_name": "drive-thru",
        "span_id": 1609957400947800822,
        "trace_id": 2684560972671346320
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-15 03:39:38
success: True
trace_id: 2684560972671346320

Scan 162003104

duration: 0:00:12.795766

exit_message:

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

id: 162003104

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-14/1776160757",
        "key": "raw/stellar_imsbooking_accessories/2026-04-14/1776160757/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12123977849263039805,
        "service_name": "drive-thru",
        "span_id": 6586542391907434846,
        "trace_id": 8109937771376063434
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-14 05:03:55
success: True
trace_id: 8109937771376063434

Scan 161945309

duration: 0:00:12.863017

exit_message:

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

id: 161945309

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-13/1776074797",
        "key": "raw/stellar_imsbooking_accessories/2026-04-13/1776074797/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17847526076455233834,
        "service_name": "drive-thru",
        "span_id": 6560278894184280757,
        "trace_id": 7157715146657319708
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-13 05:08:26
success: True
trace_id: 7157715146657319708

Scan 161896361

duration: 0:00:15.249651

exit_message:

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

id: 161896361

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-12/1775988156",
        "key": "raw/stellar_imsbooking_accessories/2026-04-12/1775988156/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17210653575092868519,
        "service_name": "drive-thru",
        "span_id": 325566526476439274,
        "trace_id": 6987826189938407507
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-12 05:04:54
success: True
trace_id: 6987826189938407507

Scan 161843906

duration: 0:00:15.237453

exit_message:

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

id: 161843906

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-11/1775902575",
        "key": "raw/stellar_imsbooking_accessories/2026-04-11/1775902575/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11702852602784290085,
        "service_name": "drive-thru",
        "span_id": 3239177494626865149,
        "trace_id": 14923486393817823772
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-11 05:16:54
success: True
trace_id: 14923486393817823772

Scan 161788536

duration: 0:00:15.518666

exit_message:

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

id: 161788536

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-10/1775815208",
        "key": "raw/stellar_imsbooking_accessories/2026-04-10/1775815208/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16520649316400696464,
        "service_name": "drive-thru",
        "span_id": 15243283081866248170,
        "trace_id": 2992363866281164544
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-10 05:00:29
success: True
trace_id: 2992363866281164544

Scan 161732927

duration: 0:00:12.834983

exit_message:

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

id: 161732927

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-09/1775728831",
        "key": "raw/stellar_imsbooking_accessories/2026-04-09/1775728831/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4190402093153970456,
        "service_name": "drive-thru",
        "span_id": 6722249202545279363,
        "trace_id": 9840718982581301964
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-09 05:01:17
success: True
trace_id: 9840718982581301964

Scan 161678425

duration: 0:00:12.907594

exit_message:

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

id: 161678425

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-08/1775642997",
        "key": "raw/stellar_imsbooking_accessories/2026-04-08/1775642997/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12123895628131346384,
        "service_name": "drive-thru",
        "span_id": 16207588331052496498,
        "trace_id": 5176381139287013322
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-08 05:15:21
success: True
trace_id: 5176381139287013322

Scan 161622089

duration: 0:00:15.526997

exit_message:

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

id: 161622089

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-07/1775556856",
        "key": "raw/stellar_imsbooking_accessories/2026-04-07/1775556856/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17624860550899264484,
        "service_name": "drive-thru",
        "span_id": 16126166104409230329,
        "trace_id": 3303445957421959008
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-07 05:15:57
success: True
trace_id: 3303445957421959008

Scan 161564302

duration: 0:00:15.462632

exit_message:

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

id: 161564302

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-06/1775470529",
        "key": "raw/stellar_imsbooking_accessories/2026-04-06/1775470529/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6221920805057516674,
        "service_name": "drive-thru",
        "span_id": 14429702098780814051,
        "trace_id": 13749542724280469094
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-06 05:18:53
success: True
trace_id: 13749542724280469094

Scan 161516587

duration: 0:00:12.829170

exit_message:

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

id: 161516587

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-05/1775382945",
        "key": "raw/stellar_imsbooking_accessories/2026-04-05/1775382945/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5121098923554819672,
        "service_name": "drive-thru",
        "span_id": 13487643352021020761,
        "trace_id": 15594800292033454206
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-05 04:58:17
success: True
trace_id: 15594800292033454206

Scan 161462225

duration: 0:00:15.473082

exit_message:

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

id: 161462225

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-04/1775296466",
        "key": "raw/stellar_imsbooking_accessories/2026-04-04/1775296466/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5924439805562070305,
        "service_name": "drive-thru",
        "span_id": 5331619343266410792,
        "trace_id": 15846805712146453227
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-04 04:58:28
success: True
trace_id: 15846805712146453227

Scan 161404900

duration: 0:00:15.503003

exit_message:

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

id: 161404900

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_accessories/2026-04-03/1775211035",
        "key": "raw/stellar_imsbooking_accessories/2026-04-03/1775211035/booking_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8673835344220505250,
        "service_name": "drive-thru",
        "span_id": 13537587160557354406,
        "trace_id": 17894562116098998612
    }
}

running: False
schema_name_id: 1459
start_time: 2026-04-03 05:15:13
success: True
trace_id: 17894562116098998612

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "10": "string",
    "11": "string",
    "14": "string",
    "16": "string",
    "2": "string",
    "2022_05_27_18_33_28": "string",
    "2022_05_27_18_33_28_14": "string",
    "2022_05_27_18_33_28_17": "string",
    "2022_06_07_04_59_11": "string",
    "2022_06_07_04_59_11_23": "string",
    "2022_06_07_04_59_11_25": "string",
    "2022_06_17_07_29_23": "string",
    "2022_06_17_07_29_23_25": "string",
    "2022_06_17_07_29_23_26": "string",
    "2022_06_19_21_31_46": "string",
    "2022_06_19_21_31_46_42": "string",
    "2022_06_19_21_31_46_45": "string",
    "2022_06_20_15_44_30": "string",
    "2022_06_20_15_44_30_27": "string",
    "2022_06_25_09_29_33": "string",
    "2022_06_25_09_29_33_14": "string",
    "2022_06_25_09_29_33_4": "string",
    "2022_06_26_07_42_04": "string",
    "2022_06_26_07_42_04_17": "string",
    "2022_06_26_07_42_04_18": "string",
    "2022_07_11_10_39_37": "string",
    "2022_07_11_10_39_37_27": "string",
    "2022_07_11_10_39_37_28": "string",
    "2022_07_11_10_39_59": "string",
    "2022_07_11_10_39_59_59": "string",
    "2022_07_11_10_41_02": "string",
    "2022_07_11_10_41_02_67": "string",
    "2022_07_11_10_42_16": "string",
    "2022_07_11_10_42_16_41": "string",
    "2022_07_15_16_13_44": "string",
    "2022_07_15_16_13_44_67": "string",
    "2022_07_15_16_13_44_68": "string",
    "2022_07_15_17_39_08": "string",
    "2022_07_15_17_39_08_59": "string",
    "2022_07_15_17_39_08_60": "string",
    "2022_07_15_17_42_33": "string",
    "2022_07_15_17_42_33_21": "string",
    "2022_07_15_17_42_33_23": "string",
    "2022_07_22_18_00_43": "string",
    "2022_07_22_18_00_43_18": "string",
    "2022_07_22_18_00_43_21": "string",
    "2022_07_24_07_15_40": "string",
    "2022_07_24_07_15_40_107": "string",
    "2022_08_02_15_39_03": "string",
    "2022_08_02_15_39_03_28": "string",
    "2022_08_02_15_39_03_30": "string",
    "2022_08_04_18_00_33": "string",
    "2022_08_04_18_00_33_45": "string",
    "2022_08_04_18_00_33_57": "string",
    "2022_08_15_07_42_44": "string",
    "2022_08_15_07_42_44_42": "string",
    "2022_08_18_09_17_08": "string",
    "2022_08_18_09_17_08_122": "string",
    "2022_08_26_10_14_29": "string",
    "2022_08_26_10_14_29_91": "string",
    "2022_09_03_21_01_14": "string",
    "25": "string",
    "3": "string",
    "30": "string",
    "4": "string",
    "40": "string",
    "45": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "8": "string",
    "9": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_id": "string",
    "created_at": "string",
    "price": "string",
    "price_override": "string",
    "qty": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_4": "string"
}

created: 2026-04-17 04:56:21

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:46:25",
        "disabled": false,
        "format": "raw",
        "id": 1459,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_accessories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "10": "string",
            "11": "string",
            "14": "string",
            "16": "string",
            "2": "string",
            "2022_05_27_18_33_28": "string",
            "2022_05_27_18_33_28_14": "string",
            "2022_05_27_18_33_28_17": "string",
            "2022_06_07_04_59_11": "string",
            "2022_06_07_04_59_11_23": "string",
            "2022_06_07_04_59_11_25": "string",
            "2022_06_17_07_29_23": "string",
            "2022_06_17_07_29_23_25": "string",
            "2022_06_17_07_29_23_26": "string",
            "2022_06_19_21_31_46": "string",
            "2022_06_19_21_31_46_42": "string",
            "2022_06_19_21_31_46_45": "string",
            "2022_06_20_15_44_30": "string",
            "2022_06_20_15_44_30_27": "string",
            "2022_06_25_09_29_33": "string",
            "2022_06_25_09_29_33_14": "string",
            "2022_06_25_09_29_33_4": "string",
            "2022_06_26_07_42_04": "string",
            "2022_06_26_07_42_04_17": "string",
            "2022_06_26_07_42_04_18": "string",
            "2022_07_11_10_39_37": "string",
            "2022_07_11_10_39_37_27": "string",
            "2022_07_11_10_39_37_28": "string",
            "2022_07_11_10_39_59": "string",
            "2022_07_11_10_39_59_59": "string",
            "2022_07_11_10_41_02": "string",
            "2022_07_11_10_41_02_67": "string",
            "2022_07_11_10_42_16": "string",
            "2022_07_11_10_42_16_41": "string",
            "2022_07_15_16_13_44": "string",
            "2022_07_15_16_13_44_67": "string",
            "2022_07_15_16_13_44_68": "string",
            "2022_07_15_17_39_08": "string",
            "2022_07_15_17_39_08_59": "string",
            "2022_07_15_17_39_08_60": "string",
            "2022_07_15_17_42_33": "string",
            "2022_07_15_17_42_33_21": "string",
            "2022_07_15_17_42_33_23": "string",
            "2022_07_22_18_00_43": "string",
            "2022_07_22_18_00_43_18": "string",
            "2022_07_22_18_00_43_21": "string",
            "2022_07_24_07_15_40": "string",
            "2022_07_24_07_15_40_107": "string",
            "2022_08_02_15_39_03": "string",
            "2022_08_02_15_39_03_28": "string",
            "2022_08_02_15_39_03_30": "string",
            "2022_08_04_18_00_33": "string",
            "2022_08_04_18_00_33_45": "string",
            "2022_08_04_18_00_33_57": "string",
            "2022_08_15_07_42_44": "string",
            "2022_08_15_07_42_44_42": "string",
            "2022_08_18_09_17_08": "string",
            "2022_08_18_09_17_08_122": "string",
            "2022_08_26_10_14_29": "string",
            "2022_08_26_10_14_29_91": "string",
            "2022_09_03_21_01_14": "string",
            "25": "string",
            "3": "string",
            "30": "string",
            "4": "string",
            "40": "string",
            "45": "string",
            "5": "string",
            "6": "string",
            "7": "string",
            "8": "string",
            "9": "string",
            "accessory_id": "string",
            "accessory_option_id": "string",
            "booking_id": "string",
            "created_at": "string",
            "price": "string",
            "price_override": "string",
            "qty": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_4": "string"
        },
        "created": "2026-04-17 04:56:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_accessories`\n(\n `tenant`  string , `booking_id`  string , `accessory_id`  string , `qty`  string , `price`  string , `price_override`  string , `accessory_option_id`  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_imsbooking_accessories/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_accessories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_accessories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}