Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsstyle_prices
- created: 2023-02-07 01:46:58
- disabled: False
- format: raw
- id: 1468
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsstyle_prices" } - type: drivethrucsv
Schema Versions: 15
-
Version 1718008
- created: 2026-04-17 04:58:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-17/1776419653
- id: 1718008
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 162169356
- updated: 2026-04-17 04:58:39
-
Version 1716797
- created: 2026-04-16 05:20:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-16/1776334554'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-16/1776334554
- id: 1716797
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 162114474
- updated: 2026-04-16 05:20:25
-
Version 1715559
- created: 2026-04-15 03:44:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-15/1776242367'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-15/1776242367
- id: 1715559
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 162056448
- updated: 2026-04-15 03:44:22
-
Version 1714379
- created: 2026-04-14 05:03:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-14/1776160763'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-14/1776160763
- id: 1714379
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 162003102
- updated: 2026-04-14 05:04:08
-
Version 1713134
- created: 2026-04-13 05:09:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-13/1776074808'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-13/1776074808
- id: 1713134
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161945342
- updated: 2026-04-13 05:09:50
-
Version 1711986
- created: 2026-04-12 05:08:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-12/1775988165'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-12/1775988165
- id: 1711986
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161896450
- updated: 2026-04-12 05:09:08
-
Version 1710753
- created: 2026-04-11 05:19:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-11/1775902581'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-11/1775902581
- id: 1710753
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161843974
- updated: 2026-04-11 05:19:42
-
Version 1709574
- created: 2026-04-10 05:03:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-10/1775815221
- id: 1709574
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161788616
- updated: 2026-04-10 05:03:30
-
Version 1708440
- created: 2026-04-09 05:03:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-09/1775728843'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-09/1775728843
- id: 1708440
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161733002
- updated: 2026-04-09 05:04:05
-
Version 1707272
- created: 2026-04-08 05:15:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-08/1775642999
- id: 1707272
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161678432
- updated: 2026-04-08 05:15:50
-
Version 1706040
- created: 2026-04-07 05:17:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-07/1775556862'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-07/1775556862
- id: 1706040
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161622118
- updated: 2026-04-07 05:17:18
-
Version 1704830
- created: 2026-04-06 05:18:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-06/1775470538'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-06/1775470538
- id: 1704830
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161564305
- updated: 2026-04-06 05:19:12
-
Version 1703633
- created: 2026-04-05 04:59:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-05/1775382950'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-05/1775382950
- id: 1703633
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161516666
- updated: 2026-04-05 04:59:49
-
Version 1702415
- created: 2026-04-04 04:56:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-04/1775296466
- id: 1702415
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161462116
- updated: 2026-04-04 04:56:13
-
Version 1701268
- created: 2026-04-03 05:13:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-03/1775211040'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_prices/2026-04-03/1775211040
- id: 1701268
- processed: 1
- raw_data:
{ "created_at": 11, "default_price": 2, "friday": 10, "holiday": 3, "monday": 6, "saturday": 4, "sunday": 5, "tenant": 0, "thursday": 9, "time_id": 1, "tuesday": 7, "updated_at": 12, "wednesday": 8 } - schema_attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - schema_name_id: 1468
- schema_scan_id: 161404866
- updated: 2026-04-03 05:14:05
Schema Scans: 15
Last at 2026-04-17 04:58:24
-
Scan 162169356
- duration: 0:00:14.853657
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169356
- 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_prices/2026-04-17/1776419653", "key": "raw/stellar_imsstyle_prices/2026-04-17/1776419653/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15249808617370908948, "service_name": "drive-thru", "span_id": 1108057718673952923, "trace_id": 3966540559207023904 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-17 04:58:24
- success: True
- trace_id: 3966540559207023904
-
Scan 162114474
- duration: 0:00:12.244345
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114474
- 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_prices/2026-04-16/1776334554", "key": "raw/stellar_imsstyle_prices/2026-04-16/1776334554/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8706560958282942222, "service_name": "drive-thru", "span_id": 5367633467683130654, "trace_id": 8257280656617191587 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-16 05:20:13
- success: True
- trace_id: 8257280656617191587
-
Scan 162056448
- duration: 0:00:14.873182
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056448
- 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_prices/2026-04-15/1776242367", "key": "raw/stellar_imsstyle_prices/2026-04-15/1776242367/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9382669900094849970, "service_name": "drive-thru", "span_id": 1741199184425862825, "trace_id": 1197913462054574672 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-15 03:44:07
- success: True
- trace_id: 1197913462054574672
-
Scan 162003102
- duration: 0:00:14.892347
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003102
- 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_prices/2026-04-14/1776160763", "key": "raw/stellar_imsstyle_prices/2026-04-14/1776160763/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4731743358522725537, "service_name": "drive-thru", "span_id": 14975475510064099514, "trace_id": 13435363847519698188 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-14 05:03:53
- success: True
- trace_id: 13435363847519698188
-
Scan 161945342
- duration: 0:00:14.931549
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945342
- 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_prices/2026-04-13/1776074808", "key": "raw/stellar_imsstyle_prices/2026-04-13/1776074808/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9818261046636394613, "service_name": "drive-thru", "span_id": 510070319247733321, "trace_id": 13911721554280143716 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-13 05:09:35
- success: True
- trace_id: 13911721554280143716
-
Scan 161896450
- duration: 0:00:12.385848
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896450
- 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_prices/2026-04-12/1775988165", "key": "raw/stellar_imsstyle_prices/2026-04-12/1775988165/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9894409692961757473, "service_name": "drive-thru", "span_id": 12666593172227524, "trace_id": 14183579217182276274 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-12 05:08:56
- success: True
- trace_id: 14183579217182276274
-
Scan 161843974
- duration: 0:00:12.252468
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843974
- 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_prices/2026-04-11/1775902581", "key": "raw/stellar_imsstyle_prices/2026-04-11/1775902581/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12792409122689741614, "service_name": "drive-thru", "span_id": 9651704276371766655, "trace_id": 4586225870735866814 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-11 05:19:29
- success: True
- trace_id: 4586225870735866814
-
Scan 161788616
- duration: 0:00:14.889861
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788616
- 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_prices/2026-04-10/1775815221", "key": "raw/stellar_imsstyle_prices/2026-04-10/1775815221/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7708597443640000937, "service_name": "drive-thru", "span_id": 1189514537021760060, "trace_id": 6104792569094654692 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-10 05:03:15
- success: True
- trace_id: 6104792569094654692
-
Scan 161733002
- duration: 0:00:15.011827
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161733002
- 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_prices/2026-04-09/1775728843", "key": "raw/stellar_imsstyle_prices/2026-04-09/1775728843/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16981650711457211553, "service_name": "drive-thru", "span_id": 16725663053887303449, "trace_id": 12846064652026673979 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-09 05:03:50
- success: True
- trace_id: 12846064652026673979
-
Scan 161678432
- duration: 0:00:15.010958
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678432
- 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_prices/2026-04-08/1775642999", "key": "raw/stellar_imsstyle_prices/2026-04-08/1775642999/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12776454469915816836, "service_name": "drive-thru", "span_id": 6943926056614431589, "trace_id": 7311536339511353993 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-08 05:15:35
- success: True
- trace_id: 7311536339511353993
-
Scan 161622118
- duration: 0:00:15.093939
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622118
- 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_prices/2026-04-07/1775556862", "key": "raw/stellar_imsstyle_prices/2026-04-07/1775556862/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3373216777504655099, "service_name": "drive-thru", "span_id": 4885258728968018189, "trace_id": 12612251580308494926 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-07 05:17:03
- success: True
- trace_id: 12612251580308494926
-
Scan 161564305
- duration: 0:00:14.828664
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564305
- 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_prices/2026-04-06/1775470538", "key": "raw/stellar_imsstyle_prices/2026-04-06/1775470538/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17887128570023875051, "service_name": "drive-thru", "span_id": 3956008925613800169, "trace_id": 11179264012051983868 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-06 05:18:57
- success: True
- trace_id: 11179264012051983868
-
Scan 161516666
- duration: 0:00:12.334623
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516666
- 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_prices/2026-04-05/1775382950", "key": "raw/stellar_imsstyle_prices/2026-04-05/1775382950/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 26356314861051394, "service_name": "drive-thru", "span_id": 9834130831986010958, "trace_id": 18114925893437997340 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-05 04:59:37
- success: True
- trace_id: 18114925893437997340
-
Scan 161462116
- duration: 0:00:12.556601
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462116
- 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_prices/2026-04-04/1775296466", "key": "raw/stellar_imsstyle_prices/2026-04-04/1775296466/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9794088907772380766, "service_name": "drive-thru", "span_id": 9938961605637136326, "trace_id": 758412371458212022 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-04 04:56:00
- success: True
- trace_id: 758412371458212022
-
Scan 161404866
- duration: 0:00:12.413351
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404866
- 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_prices/2026-04-03/1775211040", "key": "raw/stellar_imsstyle_prices/2026-04-03/1775211040/style_prices.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_prices", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16450168311935035736, "service_name": "drive-thru", "span_id": 16750490288880738778, "trace_id": 3355911657927165877 } } - running: False
- schema_name_id: 1468
- start_time: 2026-04-03 05:13:52
- success: True
- trace_id: 3355911657927165877
- attributes:
{ "100_00": "string", "150_00": "string", "2022_03_10_07_41_28": "string", "2022_03_10_07_42_00": "string", "2022_03_10_07_42_31": "string", "2022_03_10_07_43_08": "string", "2022_03_10_07_43_34": "string", "2022_03_10_07_43_34_2": "string", "2022_03_10_07_43_48": "string", "2022_03_10_07_43_48_10": "string", "2022_03_10_07_43_54": "string", "2022_03_10_07_43_54_5": "string", "2022_03_10_07_43_59": "string", "2022_03_10_07_43_59_8": "string", "2022_03_10_07_44_05": "string", "2022_03_10_07_44_05_9": "string", "2022_03_10_07_44_11": "string", "2022_05_28_16_54_53_7": "string", "2022_05_28_16_57_21_3": "string", "2022_06_10_21_01_22_6": "string", "2022_06_10_21_02_48_4": "string", "275_00": "string", "300_00": "string", "400_00": "string", "425_00": "string", "430_00": "string", "450_00": "string", "600_00": "string", "650_00": "string", "75_00": "string", "created_at": "string", "default_price": "string", "friday": "string", "holiday": "string", "monday": "string", "saturday": "string", "sunday": "string", "tenant": "string", "thursday": "string", "time_id": "string", "tuesday": "string", "updated_at": "string", "updated_at_1": "string", "wednesday": "string" } - created: 2026-04-17 04:58:25
- 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_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:46:58",
"disabled": false,
"format": "raw",
"id": 1468,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsstyle_prices"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"100_00": "string",
"150_00": "string",
"2022_03_10_07_41_28": "string",
"2022_03_10_07_42_00": "string",
"2022_03_10_07_42_31": "string",
"2022_03_10_07_43_08": "string",
"2022_03_10_07_43_34": "string",
"2022_03_10_07_43_34_2": "string",
"2022_03_10_07_43_48": "string",
"2022_03_10_07_43_48_10": "string",
"2022_03_10_07_43_54": "string",
"2022_03_10_07_43_54_5": "string",
"2022_03_10_07_43_59": "string",
"2022_03_10_07_43_59_8": "string",
"2022_03_10_07_44_05": "string",
"2022_03_10_07_44_05_9": "string",
"2022_03_10_07_44_11": "string",
"2022_05_28_16_54_53_7": "string",
"2022_05_28_16_57_21_3": "string",
"2022_06_10_21_01_22_6": "string",
"2022_06_10_21_02_48_4": "string",
"275_00": "string",
"300_00": "string",
"400_00": "string",
"425_00": "string",
"430_00": "string",
"450_00": "string",
"600_00": "string",
"650_00": "string",
"75_00": "string",
"created_at": "string",
"default_price": "string",
"friday": "string",
"holiday": "string",
"monday": "string",
"saturday": "string",
"sunday": "string",
"tenant": "string",
"thursday": "string",
"time_id": "string",
"tuesday": "string",
"updated_at": "string",
"updated_at_1": "string",
"wednesday": "string"
},
"created": "2026-04-17 04:58:25",
"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_prices`\n(\n `tenant` string , `time_id` string , `default_price` string , `holiday` string , `saturday` string , `sunday` string , `monday` string , `tuesday` string , `wednesday` string , `thursday` string , `friday` 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_prices/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_prices`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_prices"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}