Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsseasons

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717988

created: 2026-04-17 04:57:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-17/1776419651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-17/1776419651
id: 1717988
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 162169327
updated: 2026-04-17 04:57:49

Version 1716750

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-16/1776334552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-16/1776334552
id: 1716750
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 162114419
updated: 2026-04-16 05:18:24

Version 1715510

created: 2026-04-15 03:42:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-15/1776242365'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-15/1776242365
id: 1715510
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 162056395
updated: 2026-04-15 03:42:16

Version 1714413

created: 2026-04-14 05:05:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-14/1776160760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-14/1776160760
id: 1714413
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 162003161
updated: 2026-04-14 05:05:33

Version 1713152

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-13/1776074806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-13/1776074806
id: 1713152
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161945360
updated: 2026-04-13 05:10:29

Version 1711909

created: 2026-04-12 05:04:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-12/1775988163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-12/1775988163
id: 1711909
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161896357
updated: 2026-04-12 05:04:57

Version 1710724

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-11/1775902578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-11/1775902578
id: 1710724
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161843943
updated: 2026-04-11 05:18:34

Version 1709602

created: 2026-04-10 05:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

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

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161788658
updated: 2026-04-10 05:04:43

Version 1708397

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-09/1775728841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-09/1775728841
id: 1708397
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161732955
updated: 2026-04-09 05:02:27

Version 1707192

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-08/1775642998
id: 1707192
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161678351
updated: 2026-04-08 05:12:23

Version 1706002

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-07/1775556860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-07/1775556860
id: 1706002
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161622080
updated: 2026-04-07 05:15:45

Version 1704855

created: 2026-04-06 05:20:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-06/1775470536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-06/1775470536
id: 1704855
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161564340
updated: 2026-04-06 05:20:16

Version 1703576

created: 2026-04-05 04:57:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-05/1775382949'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-05/1775382949
id: 1703576
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161516568
updated: 2026-04-05 04:57:59

Version 1702381

created: 2026-04-04 04:54:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-04/1775296462'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-04/1775296462
id: 1702381
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161462080
updated: 2026-04-04 04:54:52

Version 1701295

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-03/1775211038'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsseasons/2026-04-03/1775211038
id: 1701295
processed: 1

raw_data:

{
    "created_at": 19,
    "holiday_max_end_time": 18,
    "holiday_max_start_time": 16,
    "holiday_min_end_time": 17,
    "holiday_min_start_time": 15,
    "id": 1,
    "location_id": 2,
    "season_end": 5,
    "season_name": 3,
    "season_start": 4,
    "status": 6,
    "tenant": 0,
    "updated_at": 20,
    "weekday_max_end_time": 10,
    "weekday_max_start_time": 8,
    "weekday_min_end_time": 9,
    "weekday_min_start_time": 7,
    "weekend_max_end_time": 14,
    "weekend_max_start_time": 12,
    "weekend_min_end_time": 13,
    "weekend_min_start_time": 11
}

schema_attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

schema_name_id: 1454
schema_scan_id: 161404894
updated: 2026-04-03 05:15:10

Schema Scans: 15

Last at 2026-04-17 04:57:37

Scan 162169327

duration: 0:00:12.371102

exit_message:

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

id: 162169327

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_imsseasons/2026-04-17/1776419651",
        "key": "raw/stellar_imsseasons/2026-04-17/1776419651/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9769902336186145857,
        "service_name": "drive-thru",
        "span_id": 16451918603539923269,
        "trace_id": 17610553511569437685
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-17 04:57:37
success: True
trace_id: 17610553511569437685

Scan 162114419

duration: 0:00:12.344519

exit_message:

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

id: 162114419

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_imsseasons/2026-04-16/1776334552",
        "key": "raw/stellar_imsseasons/2026-04-16/1776334552/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16602960253067139512,
        "service_name": "drive-thru",
        "span_id": 11426523297873814110,
        "trace_id": 3617788124290153691
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-16 05:18:12
success: True
trace_id: 3617788124290153691

Scan 162056395

duration: 0:00:14.978129

exit_message:

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

id: 162056395

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_imsseasons/2026-04-15/1776242365",
        "key": "raw/stellar_imsseasons/2026-04-15/1776242365/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3813368123586762242,
        "service_name": "drive-thru",
        "span_id": 1872330450821742139,
        "trace_id": 3162833167725570482
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-15 03:42:01
success: True
trace_id: 3162833167725570482

Scan 162003161

duration: 0:00:12.294525

exit_message:

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

id: 162003161

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_imsseasons/2026-04-14/1776160760",
        "key": "raw/stellar_imsseasons/2026-04-14/1776160760/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16955752507044226146,
        "service_name": "drive-thru",
        "span_id": 10556369009389835470,
        "trace_id": 4648253280622500765
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-14 05:05:21
success: True
trace_id: 4648253280622500765

Scan 161945360

duration: 0:00:14.834574

exit_message:

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

id: 161945360

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_imsseasons/2026-04-13/1776074806",
        "key": "raw/stellar_imsseasons/2026-04-13/1776074806/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15928988629613301249,
        "service_name": "drive-thru",
        "span_id": 9634765733866836983,
        "trace_id": 14788757892784676981
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-13 05:10:14
success: True
trace_id: 14788757892784676981

Scan 161896357

duration: 0:00:14.815475

exit_message:

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

id: 161896357

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_imsseasons/2026-04-12/1775988163",
        "key": "raw/stellar_imsseasons/2026-04-12/1775988163/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5255815359834858775,
        "service_name": "drive-thru",
        "span_id": 10157787324338555243,
        "trace_id": 17268815288544628463
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-12 05:04:43
success: True
trace_id: 17268815288544628463

Scan 161843943

duration: 0:00:14.784817

exit_message:

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

id: 161843943

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_imsseasons/2026-04-11/1775902578",
        "key": "raw/stellar_imsseasons/2026-04-11/1775902578/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 547972321405694407,
        "service_name": "drive-thru",
        "span_id": 7682847305373846546,
        "trace_id": 6660375881662498351
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-11 05:18:19
success: True
trace_id: 6660375881662498351

Scan 161788658

duration: 0:00:14.827068

exit_message:

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

id: 161788658

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_imsseasons/2026-04-10/1775815221",
        "key": "raw/stellar_imsseasons/2026-04-10/1775815221/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17462765867139877641,
        "service_name": "drive-thru",
        "span_id": 8204443640290692256,
        "trace_id": 4089605356193890865
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-10 05:04:28
success: True
trace_id: 4089605356193890865

Scan 161732955

duration: 0:00:12.270576

exit_message:

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

id: 161732955

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_imsseasons/2026-04-09/1775728841",
        "key": "raw/stellar_imsseasons/2026-04-09/1775728841/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18299220866734174998,
        "service_name": "drive-thru",
        "span_id": 10111476395335016870,
        "trace_id": 1306366572847826351
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-09 05:02:14
success: True
trace_id: 1306366572847826351

Scan 161678351

duration: 0:00:14.721463

exit_message:

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

id: 161678351

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_imsseasons/2026-04-08/1775642998",
        "key": "raw/stellar_imsseasons/2026-04-08/1775642998/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18258342648763490127,
        "service_name": "drive-thru",
        "span_id": 12876362841902046508,
        "trace_id": 5530943997642369412
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-08 05:12:09
success: True
trace_id: 5530943997642369412

Scan 161622080

duration: 0:00:12.200479

exit_message:

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

id: 161622080

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_imsseasons/2026-04-07/1775556860",
        "key": "raw/stellar_imsseasons/2026-04-07/1775556860/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16437801880580180377,
        "service_name": "drive-thru",
        "span_id": 7162457377936731604,
        "trace_id": 53585773606939608
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-07 05:15:33
success: True
trace_id: 53585773606939608

Scan 161564340

duration: 0:00:12.262374

exit_message:

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

id: 161564340

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_imsseasons/2026-04-06/1775470536",
        "key": "raw/stellar_imsseasons/2026-04-06/1775470536/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17079118951493732428,
        "service_name": "drive-thru",
        "span_id": 13308044323041775634,
        "trace_id": 8871561442841405274
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-06 05:20:04
success: True
trace_id: 8871561442841405274

Scan 161516568

duration: 0:00:14.924975

exit_message:

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

id: 161516568

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_imsseasons/2026-04-05/1775382949",
        "key": "raw/stellar_imsseasons/2026-04-05/1775382949/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13105753638622784865,
        "service_name": "drive-thru",
        "span_id": 13156506386997132553,
        "trace_id": 7891156546010515160
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-05 04:57:45
success: True
trace_id: 7891156546010515160

Scan 161462080

duration: 0:00:12.313940

exit_message:

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

id: 161462080

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_imsseasons/2026-04-04/1775296462",
        "key": "raw/stellar_imsseasons/2026-04-04/1775296462/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17676163140382667789,
        "service_name": "drive-thru",
        "span_id": 4917776594489067296,
        "trace_id": 6588519507363113047
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-04 04:54:40
success: True
trace_id: 6588519507363113047

Scan 161404894

duration: 0:00:12.332349

exit_message:

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

id: 161404894

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_imsseasons/2026-04-03/1775211038",
        "key": "raw/stellar_imsseasons/2026-04-03/1775211038/seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsseasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16017221987578641868,
        "service_name": "drive-thru",
        "span_id": 15796267125044988669,
        "trace_id": 794365897832463395
    }
}

running: False
schema_name_id: 1454
start_time: 2026-04-03 05:14:58
success: True
trace_id: 794365897832463395

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "10_00": "string",
    "18_00": "string",
    "19_00": "string",
    "2022_03_18_07_31_50": "string",
    "20_00": "string",
    "7_00": "string",
    "9_00": "string",
    "Active": "string",
    "DEFAULT": "string",
    "created_at": "string",
    "holiday_max_end_time": "string",
    "holiday_max_start_time": "string",
    "holiday_min_end_time": "string",
    "holiday_min_start_time": "string",
    "id": "string",
    "location_id": "string",
    "season_end": "string",
    "season_name": "string",
    "season_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string",
    "weekday_max_end_time": "string",
    "weekday_max_start_time": "string",
    "weekday_min_end_time": "string",
    "weekday_min_start_time": "string",
    "weekend_max_end_time": "string",
    "weekend_max_start_time": "string",
    "weekend_min_end_time": "string",
    "weekend_min_start_time": "string"
}

created: 2026-04-17 04:57:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-17/1776419651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:46:13",
        "disabled": false,
        "format": "raw",
        "id": 1454,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsseasons"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "10_00": "string",
            "18_00": "string",
            "19_00": "string",
            "2022_03_18_07_31_50": "string",
            "20_00": "string",
            "7_00": "string",
            "9_00": "string",
            "Active": "string",
            "DEFAULT": "string",
            "created_at": "string",
            "holiday_max_end_time": "string",
            "holiday_max_start_time": "string",
            "holiday_min_end_time": "string",
            "holiday_min_start_time": "string",
            "id": "string",
            "location_id": "string",
            "season_end": "string",
            "season_name": "string",
            "season_start": "string",
            "status": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_1": "string",
            "weekday_max_end_time": "string",
            "weekday_max_start_time": "string",
            "weekday_min_end_time": "string",
            "weekday_min_start_time": "string",
            "weekend_max_end_time": "string",
            "weekend_max_start_time": "string",
            "weekend_min_end_time": "string",
            "weekend_min_start_time": "string"
        },
        "created": "2026-04-17 04:57:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsseasons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `season_name`  string , `season_start`  string , `season_end`  string , `status`  string , `weekday_min_start_time`  string , `weekday_max_start_time`  string , `weekday_min_end_time`  string , `weekday_max_end_time`  string , `weekend_min_start_time`  string , `weekend_max_start_time`  string , `weekend_min_end_time`  string , `weekend_max_end_time`  string , `holiday_min_start_time`  string , `holiday_max_start_time`  string , `holiday_min_end_time`  string , `holiday_max_end_time`  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_imsseasons/2026-04-17/1776419651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsseasons`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsseasons"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}