Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyle_hourly_prices

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718025

created: 2026-04-17 04:59:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653
id: 1718025
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 162169394
updated: 2026-04-17 04:59:22

Version 1716773

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-16/1776334553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-16/1776334553
id: 1716773
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 162114443
updated: 2026-04-16 05:19:17

Version 1715560

created: 2026-04-15 03:44:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-15/1776242367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-15/1776242367
id: 1715560
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 162056449
updated: 2026-04-15 03:44:23

Version 1714372

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-14/1776160762'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-14/1776160762
id: 1714372
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 162003092
updated: 2026-04-14 05:03:52

Version 1713155

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-13/1776074808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-13/1776074808
id: 1713155
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161945363
updated: 2026-04-13 05:10:35

Version 1711988

created: 2026-04-12 05:09:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-12/1775988165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-12/1775988165
id: 1711988
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161896451
updated: 2026-04-12 05:09:18

Version 1710771

created: 2026-04-11 05:20:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-11/1775902580'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-11/1775902580
id: 1710771
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161843991
updated: 2026-04-11 05:20:22

Version 1709616

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-10/1775815221
id: 1709616
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161788704
updated: 2026-04-10 05:05:29

Version 1708405

created: 2026-04-09 05:02:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-09/1775728842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-09/1775728842
id: 1708405
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161732963
updated: 2026-04-09 05:02:45

Version 1707254

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

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

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161678413
updated: 2026-04-08 05:15:09

Version 1706048

created: 2026-04-07 05:17:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-07/1775556862'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-07/1775556862
id: 1706048
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161622126
updated: 2026-04-07 05:17:34

Version 1704823

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-06/1775470538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-06/1775470538
id: 1704823
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161564298
updated: 2026-04-06 05:18:55

Version 1703565

created: 2026-04-05 04:57:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-05/1775382950'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-05/1775382950
id: 1703565
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161516550
updated: 2026-04-05 04:57:30

Version 1702416

created: 2026-04-04 04:56:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

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

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161462117
updated: 2026-04-04 04:56:14

Version 1701271

created: 2026-04-03 05:13:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-03/1775211040'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-03/1775211040
id: 1701271
processed: 1

raw_data:

{
    "created_at": 21,
    "day_discount": 14,
    "default_price": 5,
    "first_hour_am": 16,
    "first_hour_pm": 17,
    "friday": 13,
    "holiday": 6,
    "hourly_type": 4,
    "id": 1,
    "max_hours": 20,
    "max_price": 18,
    "min_hours": 19,
    "monday": 9,
    "saturday": 7,
    "season_id": 3,
    "style_id": 2,
    "sunday": 8,
    "tenant": 0,
    "thursday": 12,
    "tuesday": 10,
    "under_one_hour": 15,
    "updated_at": 22,
    "wednesday": 11
}

schema_attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

schema_name_id: 1436
schema_scan_id: 161404869
updated: 2026-04-03 05:14:12

Schema Scans: 15

Last at 2026-04-17 04:59:09

Scan 162169394

duration: 0:00:12.534833

exit_message:

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

id: 162169394

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5330915417928373568,
        "service_name": "drive-thru",
        "span_id": 15329935948080601196,
        "trace_id": 774773142984274729
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-17 04:59:09
success: True
trace_id: 774773142984274729

Scan 162114443

duration: 0:00:12.681076

exit_message:

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

id: 162114443

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-16/1776334553",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-16/1776334553/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14170378385175029064,
        "service_name": "drive-thru",
        "span_id": 6649015288530889963,
        "trace_id": 11920355721371164631
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-16 05:19:04
success: True
trace_id: 11920355721371164631

Scan 162056449

duration: 0:00:15.109047

exit_message:

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

id: 162056449

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-15/1776242367",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-15/1776242367/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3210904616831873142,
        "service_name": "drive-thru",
        "span_id": 706128438434814273,
        "trace_id": 10255031990035099634
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-15 03:44:08
success: True
trace_id: 10255031990035099634

Scan 162003092

duration: 0:00:15.117650

exit_message:

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

id: 162003092

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-14/1776160762",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-14/1776160762/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10230907810604678882,
        "service_name": "drive-thru",
        "span_id": 1693611797454053163,
        "trace_id": 9469960150862774933
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-14 05:03:37
success: True
trace_id: 9469960150862774933

Scan 161945363

duration: 0:00:12.640390

exit_message:

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

id: 161945363

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-13/1776074808",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-13/1776074808/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9124313857538902839,
        "service_name": "drive-thru",
        "span_id": 4985663744119032177,
        "trace_id": 14160616793397795875
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-13 05:10:23
success: True
trace_id: 14160616793397795875

Scan 161896451

duration: 0:00:15.030053

exit_message:

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

id: 161896451

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-12/1775988165",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-12/1775988165/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17411274020679212734,
        "service_name": "drive-thru",
        "span_id": 9263830549149003773,
        "trace_id": 10296006178747474595
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-12 05:09:03
success: True
trace_id: 10296006178747474595

Scan 161843991

duration: 0:00:15.094762

exit_message:

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

id: 161843991

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-11/1775902580",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-11/1775902580/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14920198264189523710,
        "service_name": "drive-thru",
        "span_id": 2793363362823579555,
        "trace_id": 3870216294148859636
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-11 05:20:07
success: True
trace_id: 3870216294148859636

Scan 161788704

duration: 0:00:15.216842

exit_message:

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

id: 161788704

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-10/1775815221",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-10/1775815221/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11025068610266593115,
        "service_name": "drive-thru",
        "span_id": 7744829469253717416,
        "trace_id": 18281593719951224613
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-10 05:05:14
success: True
trace_id: 18281593719951224613

Scan 161732963

duration: 0:00:12.570148

exit_message:

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

id: 161732963

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-09/1775728842",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-09/1775728842/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4542719091568046920,
        "service_name": "drive-thru",
        "span_id": 18029099362195715318,
        "trace_id": 16068981336144929942
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-09 05:02:33
success: True
trace_id: 16068981336144929942

Scan 161678413

duration: 0:00:15.079209

exit_message:

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

id: 161678413

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-08/1775642999",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-08/1775642999/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3676753903615684023,
        "service_name": "drive-thru",
        "span_id": 12137543176431374474,
        "trace_id": 8705772372059528211
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-08 05:14:54
success: True
trace_id: 8705772372059528211

Scan 161622126

duration: 0:00:15.058504

exit_message:

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

id: 161622126

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-07/1775556862",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-07/1775556862/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10131289908809812141,
        "service_name": "drive-thru",
        "span_id": 12378443078871452466,
        "trace_id": 9566385811058316469
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-07 05:17:19
success: True
trace_id: 9566385811058316469

Scan 161564298

duration: 0:00:14.976165

exit_message:

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

id: 161564298

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-06/1775470538",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-06/1775470538/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15440784782370973627,
        "service_name": "drive-thru",
        "span_id": 7733262405859763847,
        "trace_id": 16947328761542679742
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-06 05:18:40
success: True
trace_id: 16947328761542679742

Scan 161516550

duration: 0:00:12.378920

exit_message:

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

id: 161516550

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-05/1775382950",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-05/1775382950/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14111591638849251660,
        "service_name": "drive-thru",
        "span_id": 13378491319848922888,
        "trace_id": 14851428086349240765
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-05 04:57:17
success: True
trace_id: 14851428086349240765

Scan 161462117

duration: 0:00:12.552744

exit_message:

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

id: 161462117

payload:

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

running: False
schema_name_id: 1436
start_time: 2026-04-04 04:56:01
success: True
trace_id: 18391385534584359442

Scan 161404869

duration: 0:00:15.191794

exit_message:

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

id: 161404869

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-03/1775211040",
        "key": "raw/stellar_imsstyle_hourly_prices/2026-04-03/1775211040/style_hourly_prices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_hourly_prices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17026953146783915775,
        "service_name": "drive-thru",
        "span_id": 15938836782063603689,
        "trace_id": 17531462178077841128
    }
}

running: False
schema_name_id: 1436
start_time: 2026-04-03 05:13:57
success: True
trace_id: 17531462178077841128

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "100_00": "string",
    "2": "string",
    "2022_03_10_07_41_28": "string",
    "2022_03_10_07_42_00": "string",
    "2022_03_10_07_42_31": "string",
    "2022_03_10_07_43_08": "string",
    "2022_03_10_07_43_34": "string",
    "2022_05_28_16_54_53_3": "string",
    "2022_05_28_16_57_21_5": "string",
    "2022_06_10_21_01_22_2": "string",
    "2022_06_10_21_02_48_4": "string",
    "275_00": "string",
    "3": "string",
    "300_00": "string",
    "4": "string",
    "400_00": "string",
    "425_00": "string",
    "430_00": "string",
    "450_00": "string",
    "5": "string",
    "600_00": "string",
    "650_00": "string",
    "75_00": "string",
    "Nightly": "string",
    "created_at": "string",
    "day_discount": "string",
    "default_price": "string",
    "first_hour_am": "string",
    "first_hour_pm": "string",
    "friday": "string",
    "holiday": "string",
    "hourly_type": "string",
    "id": "string",
    "max_hours": "string",
    "max_price": "string",
    "min_hours": "string",
    "monday": "string",
    "saturday": "string",
    "season_id": "string",
    "style_id": "string",
    "sunday": "string",
    "tenant": "string",
    "thursday": "string",
    "tuesday": "string",
    "under_one_hour": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "wednesday": "string"
}

created: 2026-04-17 04:59:10

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:45:24",
        "disabled": false,
        "format": "raw",
        "id": 1436,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyle_hourly_prices"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "100_00": "string",
            "2": "string",
            "2022_03_10_07_41_28": "string",
            "2022_03_10_07_42_00": "string",
            "2022_03_10_07_42_31": "string",
            "2022_03_10_07_43_08": "string",
            "2022_03_10_07_43_34": "string",
            "2022_05_28_16_54_53_3": "string",
            "2022_05_28_16_57_21_5": "string",
            "2022_06_10_21_01_22_2": "string",
            "2022_06_10_21_02_48_4": "string",
            "275_00": "string",
            "3": "string",
            "300_00": "string",
            "4": "string",
            "400_00": "string",
            "425_00": "string",
            "430_00": "string",
            "450_00": "string",
            "5": "string",
            "600_00": "string",
            "650_00": "string",
            "75_00": "string",
            "Nightly": "string",
            "created_at": "string",
            "day_discount": "string",
            "default_price": "string",
            "first_hour_am": "string",
            "first_hour_pm": "string",
            "friday": "string",
            "holiday": "string",
            "hourly_type": "string",
            "id": "string",
            "max_hours": "string",
            "max_price": "string",
            "min_hours": "string",
            "monday": "string",
            "saturday": "string",
            "season_id": "string",
            "style_id": "string",
            "sunday": "string",
            "tenant": "string",
            "thursday": "string",
            "tuesday": "string",
            "under_one_hour": "string",
            "updated_at": "string",
            "updated_at_1": "string",
            "wednesday": "string"
        },
        "created": "2026-04-17 04:59:10",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `hourly_type`  string , `default_price`  string , `holiday`  string , `saturday`  string , `sunday`  string , `monday`  string , `tuesday`  string , `wednesday`  string , `thursday`  string , `friday`  string , `day_discount`  string , `under_one_hour`  string , `first_hour_am`  string , `first_hour_pm`  string , `max_price`  string , `min_hours`  string , `max_hours`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_hourly_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_hourly_prices`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_hourly_prices"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}