Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsaccessory_tiers

created: 2023-02-07 01:44:40
disabled: False
format: raw
id: 1425
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717919

created: 2026-04-17 04:54:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-17/1776419641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-17/1776419641
id: 1717919
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 162169255
updated: 2026-04-17 04:55:00

Version 1716694

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-16/1776334540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-16/1776334540
id: 1716694
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 162114363
updated: 2026-04-16 05:16:18

Version 1715461

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-15/1776242355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 162056344
updated: 2026-04-15 03:40:25

Version 1714300

created: 2026-04-14 05:00:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-14/1776160750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 162002896
updated: 2026-04-14 05:00:23

Version 1713068

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-13/1776074795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-13/1776074795
id: 1713068
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161945274
updated: 2026-04-13 05:07:17

Version 1711975

created: 2026-04-12 05:08:00

ddl:

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

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161896434
updated: 2026-04-12 05:08:12

Version 1710690

created: 2026-04-11 05:17:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-11/1775902572'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161843909
updated: 2026-04-11 05:17:16

Version 1709532

created: 2026-04-10 05:01:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-10/1775815218
id: 1709532
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161788571
updated: 2026-04-10 05:01:54

Version 1708468

created: 2026-04-09 05:04:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-09/1775728847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161733034
updated: 2026-04-09 05:05:13

Version 1707218

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

ddl:

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

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161678377
updated: 2026-04-08 05:13:38

Version 1705982

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

ddl:

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

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161622059
updated: 2026-04-07 05:15:06

Version 1704746

created: 2026-04-06 05:15:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-06/1775470526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-06/1775470526
id: 1704746
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161564216
updated: 2026-04-06 05:16:01

Version 1703541

created: 2026-04-05 04:56:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-05/1775382938'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-05/1775382938
id: 1703541
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161516507
updated: 2026-04-05 04:56:27

Version 1702417

created: 2026-04-04 04:56:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-04/1775296464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccessory_tiers/2026-04-04/1775296464
id: 1702417
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161462118
updated: 2026-04-04 04:56:18

Version 1701190

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-03/1775211028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 6,
    "created_at": 7,
    "id": 1,
    "max_hours": 4,
    "min_hours": 3,
    "price": 5,
    "tenant": 0,
    "updated_at": 8
}

schema_attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1425
schema_scan_id: 161404788
updated: 2026-04-03 05:10:56

Schema Scans: 15

Last at 2026-04-17 04:54:47

Scan 162169255

duration: 0:00:12.584181

exit_message:

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

id: 162169255

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_imsaccessory_tiers/2026-04-17/1776419641",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-17/1776419641/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6738782182383110066,
        "service_name": "drive-thru",
        "span_id": 3495692929236326947,
        "trace_id": 1984781925484716453
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-17 04:54:47
success: True
trace_id: 1984781925484716453

Scan 162114363

duration: 0:00:15.398259

exit_message:

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

id: 162114363

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_imsaccessory_tiers/2026-04-16/1776334540",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-16/1776334540/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14269513064397033718,
        "service_name": "drive-thru",
        "span_id": 2410956890905734946,
        "trace_id": 8536861953005113833
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-16 05:16:03
success: True
trace_id: 8536861953005113833

Scan 162056344

duration: 0:00:14.874493

exit_message:

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

id: 162056344

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_imsaccessory_tiers/2026-04-15/1776242355",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-15/1776242355/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9225729569419008991,
        "service_name": "drive-thru",
        "span_id": 10029963155972099857,
        "trace_id": 17508385677474847877
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-15 03:40:10
success: True
trace_id: 17508385677474847877

Scan 162002896

duration: 0:00:12.595555

exit_message:

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

id: 162002896

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_imsaccessory_tiers/2026-04-14/1776160750",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-14/1776160750/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15131819263154059454,
        "service_name": "drive-thru",
        "span_id": 4530467596363680457,
        "trace_id": 16235665474332880661
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-14 05:00:11
success: True
trace_id: 16235665474332880661

Scan 161945274

duration: 0:00:12.834355

exit_message:

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

id: 161945274

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_imsaccessory_tiers/2026-04-13/1776074795",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-13/1776074795/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2088058627058629774,
        "service_name": "drive-thru",
        "span_id": 11981996822735229513,
        "trace_id": 4436336001352768090
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-13 05:07:04
success: True
trace_id: 4436336001352768090

Scan 161896434

duration: 0:00:12.544060

exit_message:

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

id: 161896434

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_imsaccessory_tiers/2026-04-12/1775988156",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-12/1775988156/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15943375871521844730,
        "service_name": "drive-thru",
        "span_id": 16664132872646194923,
        "trace_id": 14642704567497938480
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-12 05:07:59
success: True
trace_id: 14642704567497938480

Scan 161843909

duration: 0:00:15.079521

exit_message:

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

id: 161843909

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_imsaccessory_tiers/2026-04-11/1775902572",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-11/1775902572/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6701620729297551064,
        "service_name": "drive-thru",
        "span_id": 7263205762682705648,
        "trace_id": 15792089786651747167
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-11 05:17:01
success: True
trace_id: 15792089786651747167

Scan 161788571

duration: 0:00:15.095392

exit_message:

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

id: 161788571

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_imsaccessory_tiers/2026-04-10/1775815218",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-10/1775815218/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10501957921504387726,
        "service_name": "drive-thru",
        "span_id": 5172425513795003451,
        "trace_id": 9667111875803974705
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-10 05:01:39
success: True
trace_id: 9667111875803974705

Scan 161733034

duration: 0:00:15.009632

exit_message:

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

id: 161733034

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_imsaccessory_tiers/2026-04-09/1775728847",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-09/1775728847/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16806143936719648036,
        "service_name": "drive-thru",
        "span_id": 17079676138449430227,
        "trace_id": 13362163689774555100
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-09 05:04:58
success: True
trace_id: 13362163689774555100

Scan 161678377

duration: 0:00:15.117762

exit_message:

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

id: 161678377

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_imsaccessory_tiers/2026-04-08/1775642997",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-08/1775642997/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14929608902604105990,
        "service_name": "drive-thru",
        "span_id": 6528693352324594219,
        "trace_id": 2453164813815538899
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-08 05:13:23
success: True
trace_id: 2453164813815538899

Scan 161622059

duration: 0:00:14.912835

exit_message:

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

id: 161622059

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_imsaccessory_tiers/2026-04-07/1775556856",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-07/1775556856/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15553599654547919765,
        "service_name": "drive-thru",
        "span_id": 8658588491852258038,
        "trace_id": 13669371992824430008
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-07 05:14:51
success: True
trace_id: 13669371992824430008

Scan 161564216

duration: 0:00:12.622212

exit_message:

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

id: 161564216

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_imsaccessory_tiers/2026-04-06/1775470526",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-06/1775470526/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12278115088328741946,
        "service_name": "drive-thru",
        "span_id": 7962528228581901209,
        "trace_id": 269125976161484749
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-06 05:15:48
success: True
trace_id: 269125976161484749

Scan 161516507

duration: 0:00:12.594737

exit_message:

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

id: 161516507

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_imsaccessory_tiers/2026-04-05/1775382938",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-05/1775382938/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9893567186604679291,
        "service_name": "drive-thru",
        "span_id": 16586159498206005572,
        "trace_id": 4693580577707472893
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-05 04:56:14
success: True
trace_id: 4693580577707472893

Scan 161462118

duration: 0:00:15.013194

exit_message:

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

id: 161462118

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_imsaccessory_tiers/2026-04-04/1775296464",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-04/1775296464/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11818228745626231531,
        "service_name": "drive-thru",
        "span_id": 3654075387074296448,
        "trace_id": 16934533156693825636
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-04 04:56:03
success: True
trace_id: 16934533156693825636

Scan 161404788

duration: 0:00:15.215227

exit_message:

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

id: 161404788

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_imsaccessory_tiers/2026-04-03/1775211028",
        "key": "raw/stellar_imsaccessory_tiers/2026-04-03/1775211028/accessory_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccessory_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18443829705181962494,
        "service_name": "drive-thru",
        "span_id": 6392988315888009926,
        "trace_id": 14654978234684513200
    }
}

running: False
schema_name_id: 1425
start_time: 2026-04-03 05:10:41
success: True
trace_id: 14654978234684513200

Partitions:

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

Schema:

attributes:

{
    "0_00": "string",
    "0_01": "string",
    "1": "string",
    "10": "string",
    "100000_00": "string",
    "10000_00": "string",
    "1000_00": "string",
    "100_00": "string",
    "11": "string",
    "12": "string",
    "13": "string",
    "1_00": "string",
    "2": "string",
    "200_00": "string",
    "2022_03_14_13_54_13": "string",
    "2022_03_15_10_46_12": "string",
    "2022_03_15_10_47_47": "string",
    "2022_03_16_07_04_18_22": "string",
    "2022_03_16_07_04_25_15": "string",
    "2022_03_16_07_04_34_8": "string",
    "2022_03_16_07_04_55": "string",
    "2022_03_16_07_04_55_23": "string",
    "2022_03_18_08_11_38": "string",
    "2022_03_18_08_11_38_24": "string",
    "2022_03_18_08_11_44": "string",
    "2022_03_18_08_11_44_25": "string",
    "2022_06_08_12_24_11": "string",
    "2022_06_08_12_34_49_26": "string",
    "2022_06_08_12_55_27": "string",
    "2022_06_08_12_55_27_27": "string",
    "2022_06_08_12_55_39": "string",
    "2022_06_08_12_55_39_28": "string",
    "2022_06_14_11_08_06": "string",
    "2022_06_14_11_08_06_29": "string",
    "2022_06_14_11_08_30": "string",
    "2022_06_14_11_08_30_30": "string",
    "2022_06_14_11_08_39": "string",
    "2022_06_14_11_08_39_31": "string",
    "2022_06_14_11_08_45": "string",
    "3": "string",
    "4": "string",
    "400_00": "string",
    "5": "string",
    "6": "string",
    "600_00": "string",
    "7": "string",
    "75_00": "string",
    "7_00": "string",
    "8": "string",
    "9": "string",
    "99999_00": "string",
    "accessory_id": "string",
    "accessory_option_id": "string",
    "created_at": "string",
    "id": "string",
    "max_hours": "string",
    "min_hours": "string",
    "price": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

created: 2026-04-17 04:54:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-17/1776419641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
}

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:44:40",
        "disabled": false,
        "format": "raw",
        "id": 1425,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsaccessory_tiers"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "0_00": "string",
            "0_01": "string",
            "1": "string",
            "10": "string",
            "100000_00": "string",
            "10000_00": "string",
            "1000_00": "string",
            "100_00": "string",
            "11": "string",
            "12": "string",
            "13": "string",
            "1_00": "string",
            "2": "string",
            "200_00": "string",
            "2022_03_14_13_54_13": "string",
            "2022_03_15_10_46_12": "string",
            "2022_03_15_10_47_47": "string",
            "2022_03_16_07_04_18_22": "string",
            "2022_03_16_07_04_25_15": "string",
            "2022_03_16_07_04_34_8": "string",
            "2022_03_16_07_04_55": "string",
            "2022_03_16_07_04_55_23": "string",
            "2022_03_18_08_11_38": "string",
            "2022_03_18_08_11_38_24": "string",
            "2022_03_18_08_11_44": "string",
            "2022_03_18_08_11_44_25": "string",
            "2022_06_08_12_24_11": "string",
            "2022_06_08_12_34_49_26": "string",
            "2022_06_08_12_55_27": "string",
            "2022_06_08_12_55_27_27": "string",
            "2022_06_08_12_55_39": "string",
            "2022_06_08_12_55_39_28": "string",
            "2022_06_14_11_08_06": "string",
            "2022_06_14_11_08_06_29": "string",
            "2022_06_14_11_08_30": "string",
            "2022_06_14_11_08_30_30": "string",
            "2022_06_14_11_08_39": "string",
            "2022_06_14_11_08_39_31": "string",
            "2022_06_14_11_08_45": "string",
            "3": "string",
            "4": "string",
            "400_00": "string",
            "5": "string",
            "6": "string",
            "600_00": "string",
            "7": "string",
            "75_00": "string",
            "7_00": "string",
            "8": "string",
            "9": "string",
            "99999_00": "string",
            "accessory_id": "string",
            "accessory_option_id": "string",
            "created_at": "string",
            "id": "string",
            "max_hours": "string",
            "min_hours": "string",
            "price": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_1": "string"
        },
        "created": "2026-04-17 04:54:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccessory_tiers`\n(\n `tenant`  string , `id`  string , `accessory_id`  string , `min_hours`  string , `max_hours`  string , `price`  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_imsaccessory_tiers/2026-04-17/1776419641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccessory_tiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccessory_tiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}