Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyle_times

created: 2023-02-07 01:47:48
disabled: False
format: raw
id: 1485
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718004

created: 2026-04-17 04:58:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-17/1776419654
id: 1718004
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 162169346
updated: 2026-04-17 04:58:32

Version 1716765

created: 2026-04-16 05:18:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-16/1776334554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-16/1776334554
id: 1716765
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 162114435
updated: 2026-04-16 05:19:01

Version 1715553

created: 2026-04-15 03:43:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-15/1776242368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-15/1776242368
id: 1715553
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 162056440
updated: 2026-04-15 03:44:03

Version 1714375

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-14/1776160763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-14/1776160763
id: 1714375
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 162003096
updated: 2026-04-14 05:03:55

Version 1713139

created: 2026-04-13 05:09:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-13/1776074809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-13/1776074809
id: 1713139
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161945346
updated: 2026-04-13 05:09:58

Version 1711948

created: 2026-04-12 05:06:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-12/1775988166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-12/1775988166
id: 1711948
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161896399
updated: 2026-04-12 05:06:47

Version 1710765

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-11/1775902581'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-11/1775902581
id: 1710765
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161843985
updated: 2026-04-11 05:20:06

Version 1709580

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

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

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161788626
updated: 2026-04-10 05:03:48

Version 1708447

created: 2026-04-09 05:04:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-09/1775728843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-09/1775728843
id: 1708447
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161733010
updated: 2026-04-09 05:04:25

Version 1707176

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-08/1775642993'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-08/1775642993
id: 1707176
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161678335
updated: 2026-04-08 05:11:21

Version 1706049

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-07/1775556863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-07/1775556863
id: 1706049
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161622127
updated: 2026-04-07 05:17:34

Version 1704790

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-06/1775470538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

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

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161564261
updated: 2026-04-06 05:17:39

Version 1703610

created: 2026-04-05 04:59:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-05/1775382951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-05/1775382951
id: 1703610
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161516620
updated: 2026-04-05 04:59:12

Version 1702447

created: 2026-04-04 04:57:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-04/1775296474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-04/1775296474
id: 1702447
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161462149
updated: 2026-04-04 04:57:24

Version 1701284

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-03/1775211041'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_times/2026-04-03/1775211041
id: 1701284
processed: 1

raw_data:

{
    "created_at": 25,
    "description": 4,
    "end_1": 7,
    "end_2": 11,
    "end_3": 15,
    "end_4": 19,
    "end_days_1": 8,
    "end_days_2": 12,
    "end_days_3": 16,
    "end_days_4": 20,
    "frontend_display": 5,
    "holidays_only_if_valid_day": 23,
    "id": 1,
    "mapped_time_id": 24,
    "season_id": 3,
    "start_1": 6,
    "start_2": 10,
    "start_3": 14,
    "start_4": 18,
    "status_1": 9,
    "status_2": 13,
    "status_3": 17,
    "status_4": 21,
    "style_id": 2,
    "tenant": 0,
    "updated_at": 26,
    "valid_days": 22
}

schema_attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

schema_name_id: 1485
schema_scan_id: 161404883
updated: 2026-04-03 05:14:44

Schema Scans: 15

Last at 2026-04-17 04:58:16

Scan 162169346

duration: 0:00:15.537900

exit_message:

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

id: 162169346

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_times/2026-04-17/1776419654",
        "key": "raw/stellar_imsstyle_times/2026-04-17/1776419654/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16653273696134287793,
        "service_name": "drive-thru",
        "span_id": 12118749523007156895,
        "trace_id": 12704402501098581718
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-17 04:58:16
success: True
trace_id: 12704402501098581718

Scan 162114435

duration: 0:00:12.780482

exit_message:

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

id: 162114435

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_times/2026-04-16/1776334554",
        "key": "raw/stellar_imsstyle_times/2026-04-16/1776334554/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1125785175752426564,
        "service_name": "drive-thru",
        "span_id": 13326617359760733215,
        "trace_id": 7475110166861000049
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-16 05:18:48
success: True
trace_id: 7475110166861000049

Scan 162056440

duration: 0:00:15.495101

exit_message:

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

id: 162056440

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_times/2026-04-15/1776242368",
        "key": "raw/stellar_imsstyle_times/2026-04-15/1776242368/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7955063545508926572,
        "service_name": "drive-thru",
        "span_id": 7496256992541202424,
        "trace_id": 8736885865609730993
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-15 03:43:47
success: True
trace_id: 8736885865609730993

Scan 162003096

duration: 0:00:12.902040

exit_message:

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

id: 162003096

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_times/2026-04-14/1776160763",
        "key": "raw/stellar_imsstyle_times/2026-04-14/1776160763/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4454983068794780007,
        "service_name": "drive-thru",
        "span_id": 2309774430632596911,
        "trace_id": 15553214747264193618
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-14 05:03:42
success: True
trace_id: 15553214747264193618

Scan 161945346

duration: 0:00:13.098015

exit_message:

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

id: 161945346

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_times/2026-04-13/1776074809",
        "key": "raw/stellar_imsstyle_times/2026-04-13/1776074809/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12926856397781839618,
        "service_name": "drive-thru",
        "span_id": 17249034334005826206,
        "trace_id": 246250938608390730
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-13 05:09:45
success: True
trace_id: 246250938608390730

Scan 161896399

duration: 0:00:15.390265

exit_message:

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

id: 161896399

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_times/2026-04-12/1775988166",
        "key": "raw/stellar_imsstyle_times/2026-04-12/1775988166/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3650436872062428345,
        "service_name": "drive-thru",
        "span_id": 6949441369459381703,
        "trace_id": 8075699517638509620
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-12 05:06:31
success: True
trace_id: 8075699517638509620

Scan 161843985

duration: 0:00:12.833632

exit_message:

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

id: 161843985

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_times/2026-04-11/1775902581",
        "key": "raw/stellar_imsstyle_times/2026-04-11/1775902581/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17902694428005636369,
        "service_name": "drive-thru",
        "span_id": 626395522115023667,
        "trace_id": 15896129317747058426
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-11 05:19:53
success: True
trace_id: 15896129317747058426

Scan 161788626

duration: 0:00:15.643975

exit_message:

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

id: 161788626

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_times/2026-04-10/1775815221",
        "key": "raw/stellar_imsstyle_times/2026-04-10/1775815221/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9465876269119176388,
        "service_name": "drive-thru",
        "span_id": 3883164920542211121,
        "trace_id": 7752447971314729574
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-10 05:03:32
success: True
trace_id: 7752447971314729574

Scan 161733010

duration: 0:00:15.598993

exit_message:

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

id: 161733010

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_times/2026-04-09/1775728843",
        "key": "raw/stellar_imsstyle_times/2026-04-09/1775728843/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3548237231065712910,
        "service_name": "drive-thru",
        "span_id": 15281637460182822635,
        "trace_id": 3976022113341449583
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-09 05:04:09
success: True
trace_id: 3976022113341449583

Scan 161678335

duration: 0:00:13.002655

exit_message:

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

id: 161678335

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_times/2026-04-08/1775642993",
        "key": "raw/stellar_imsstyle_times/2026-04-08/1775642993/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17851931740364119125,
        "service_name": "drive-thru",
        "span_id": 15969303579184857219,
        "trace_id": 17374807220242162618
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-08 05:11:08
success: True
trace_id: 17374807220242162618

Scan 161622127

duration: 0:00:12.805134

exit_message:

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

id: 161622127

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_times/2026-04-07/1775556863",
        "key": "raw/stellar_imsstyle_times/2026-04-07/1775556863/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3514224936464938497,
        "service_name": "drive-thru",
        "span_id": 11872465431203684214,
        "trace_id": 14727673913983876827
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-07 05:17:21
success: True
trace_id: 14727673913983876827

Scan 161564261

duration: 0:00:12.860874

exit_message:

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

id: 161564261

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_times/2026-04-06/1775470538",
        "key": "raw/stellar_imsstyle_times/2026-04-06/1775470538/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8673240435309588062,
        "service_name": "drive-thru",
        "span_id": 10692759024839572232,
        "trace_id": 8671364317426463024
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-06 05:17:26
success: True
trace_id: 8671364317426463024

Scan 161516620

duration: 0:00:12.894206

exit_message:

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

id: 161516620

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_times/2026-04-05/1775382951",
        "key": "raw/stellar_imsstyle_times/2026-04-05/1775382951/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7913830720520279866,
        "service_name": "drive-thru",
        "span_id": 4689922636735568188,
        "trace_id": 8606537976759553186
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-05 04:58:59
success: True
trace_id: 8606537976759553186

Scan 161462149

duration: 0:00:12.795481

exit_message:

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

id: 161462149

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_times/2026-04-04/1775296474",
        "key": "raw/stellar_imsstyle_times/2026-04-04/1775296474/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4434534244914895029,
        "service_name": "drive-thru",
        "span_id": 3978989280370513477,
        "trace_id": 4281507346551435643
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-04 04:57:11
success: True
trace_id: 4281507346551435643

Scan 161404883

duration: 0:00:15.585604

exit_message:

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

id: 161404883

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_times/2026-04-03/1775211041",
        "key": "raw/stellar_imsstyle_times/2026-04-03/1775211041/style_times.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_times",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16502781998168515117,
        "service_name": "drive-thru",
        "span_id": 4513749613912844806,
        "trace_id": 13279532813356663307
    }
}

running: False
schema_name_id: 1485
start_time: 2026-04-03 05:14:28
success: True
trace_id: 13279532813356663307

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "10": "string",
    "2": "string",
    "2022_03_10_07_37_24": "string",
    "2022_03_10_07_37_28": "string",
    "2022_03_10_07_37_36": "string",
    "2022_03_10_07_37_39": "string",
    "2022_03_10_07_37_44": "string",
    "2022_03_10_07_37_48": "string",
    "2022_03_10_07_37_52": "string",
    "2022_03_10_07_37_56": "string",
    "2022_03_10_07_37_59": "string",
    "2022_03_10_07_38_03": "string",
    "2022_03_10_07_38_51": "string",
    "2022_03_10_07_38_58_10": "string",
    "2022_03_10_07_39_06_9": "string",
    "2022_03_10_07_39_14_8": "string",
    "2022_03_10_07_39_36_5": "string",
    "2022_03_10_07_40_00_3": "string",
    "2022_03_16_07_33_12_2": "string",
    "2022_03_18_06_59_32_6": "string",
    "2022_03_18_06_59_46_4": "string",
    "2022_03_18_07_51_27_7": "string",
    "20_00": "string",
    "3": "string",
    "4": "string",
    "5": "string",
    "6": "string",
    "7": "string",
    "7_00": "string",
    "7_50": "string",
    "8": "string",
    "8_00": "string",
    "8_50": "string",
    "9": "string",
    "9_00": "string",
    "9_50": "string",
    "Daily": "string",
    "Off": "string",
    "On": "string",
    "Yes": "string",
    "created_at": "string",
    "description": "string",
    "end_1": "string",
    "end_2": "string",
    "end_3": "string",
    "end_4": "string",
    "end_days_1": "string",
    "end_days_2": "string",
    "end_days_3": "string",
    "end_days_4": "string",
    "frontend_display": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "mapped_time_id": "string",
    "season_id": "string",
    "start_1": "string",
    "start_2": "string",
    "start_3": "string",
    "start_4": "string",
    "status_1": "string",
    "status_2": "string",
    "status_3": "string",
    "status_4": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "valid_days": "string"
}

created: 2026-04-17 04:58:18

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_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
}

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:47:48",
        "disabled": false,
        "format": "raw",
        "id": 1485,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyle_times"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "10": "string",
            "2": "string",
            "2022_03_10_07_37_24": "string",
            "2022_03_10_07_37_28": "string",
            "2022_03_10_07_37_36": "string",
            "2022_03_10_07_37_39": "string",
            "2022_03_10_07_37_44": "string",
            "2022_03_10_07_37_48": "string",
            "2022_03_10_07_37_52": "string",
            "2022_03_10_07_37_56": "string",
            "2022_03_10_07_37_59": "string",
            "2022_03_10_07_38_03": "string",
            "2022_03_10_07_38_51": "string",
            "2022_03_10_07_38_58_10": "string",
            "2022_03_10_07_39_06_9": "string",
            "2022_03_10_07_39_14_8": "string",
            "2022_03_10_07_39_36_5": "string",
            "2022_03_10_07_40_00_3": "string",
            "2022_03_16_07_33_12_2": "string",
            "2022_03_18_06_59_32_6": "string",
            "2022_03_18_06_59_46_4": "string",
            "2022_03_18_07_51_27_7": "string",
            "20_00": "string",
            "3": "string",
            "4": "string",
            "5": "string",
            "6": "string",
            "7": "string",
            "7_00": "string",
            "7_50": "string",
            "8": "string",
            "8_00": "string",
            "8_50": "string",
            "9": "string",
            "9_00": "string",
            "9_50": "string",
            "Daily": "string",
            "Off": "string",
            "On": "string",
            "Yes": "string",
            "created_at": "string",
            "description": "string",
            "end_1": "string",
            "end_2": "string",
            "end_3": "string",
            "end_4": "string",
            "end_days_1": "string",
            "end_days_2": "string",
            "end_days_3": "string",
            "end_days_4": "string",
            "frontend_display": "string",
            "holidays_only_if_valid_day": "string",
            "id": "string",
            "mapped_time_id": "string",
            "season_id": "string",
            "start_1": "string",
            "start_2": "string",
            "start_3": "string",
            "start_4": "string",
            "status_1": "string",
            "status_2": "string",
            "status_3": "string",
            "status_4": "string",
            "style_id": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_1": "string",
            "valid_days": "string"
        },
        "created": "2026-04-17 04:58:18",
        "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_times`\n(\n `tenant`  string , `id`  string , `style_id`  string , `season_id`  string , `description`  string , `frontend_display`  string , `start_1`  string , `end_1`  string , `end_days_1`  string , `status_1`  string , `start_2`  string , `end_2`  string , `end_days_2`  string , `status_2`  string , `start_3`  string , `end_3`  string , `end_days_3`  string , `status_3`  string , `start_4`  string , `end_4`  string , `end_days_4`  string , `status_4`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `mapped_time_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_imsstyle_times/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_times`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_times"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}