Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsholidays
- created: 2023-02-07 01:45:49
- disabled: False
- format: raw
- id: 1446
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsholidays" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717977
- created: 2026-04-17 04:57:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-17/1776419647
- id: 1717977
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 162169315
- updated: 2026-04-17 04:57:28
-
Version 1716697
- created: 2026-04-16 05:16:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-16/1776334547'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-16/1776334547
- id: 1716697
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 162114366
- updated: 2026-04-16 05:16:24
-
Version 1715501
- created: 2026-04-15 03:41:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-15/1776242361'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-15/1776242361
- id: 1715501
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 162056387
- updated: 2026-04-15 03:41:59
-
Version 1714338
- created: 2026-04-14 05:02:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-14/1776160757
- id: 1714338
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 162003010
- updated: 2026-04-14 05:02:15
-
Version 1713117
- created: 2026-04-13 05:08:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-13/1776074802'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-13/1776074802
- id: 1713117
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161945324
- updated: 2026-04-13 05:09:08
-
Version 1711912
- created: 2026-04-12 05:04:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-12/1775988159'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-12/1775988159
- id: 1711912
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161896362
- updated: 2026-04-12 05:05:06
-
Version 1710735
- created: 2026-04-11 05:18:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-11/1775902576
- id: 1710735
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161843955
- updated: 2026-04-11 05:19:00
-
Version 1709609
- created: 2026-04-10 05:04:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-10/1775815220
- id: 1709609
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161788673
- updated: 2026-04-10 05:05:01
-
Version 1708368
- created: 2026-04-09 05:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-09/1775728839
- id: 1708368
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161732923
- updated: 2026-04-09 05:01:22
-
Version 1707255
- created: 2026-04-08 05:14:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-08/1775643004'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-08/1775643004
- id: 1707255
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161678414
- updated: 2026-04-08 05:15:10
-
Version 1706007
- created: 2026-04-07 05:15:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-07/1775556859
- id: 1706007
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161622085
- updated: 2026-04-07 05:15:59
-
Version 1704777
- created: 2026-04-06 05:16:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-06/1775470532'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-06/1775470532
- id: 1704777
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161564248
- updated: 2026-04-06 05:17:09
-
Version 1703593
- created: 2026-04-05 04:58:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-05/1775382945
- id: 1703593
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161516590
- updated: 2026-04-05 04:58:40
-
Version 1702466
- created: 2026-04-04 04:57:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-04/1775296472'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-04/1775296472
- id: 1702466
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161462175
- updated: 2026-04-04 04:58:09
-
Version 1701240
- created: 2026-04-03 05:12:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsholidays/2026-04-03/1775211035
- id: 1701240
- processed: 1
- raw_data:
{ "holiday_date": 2, "location_id": 1, "tenant": 0 } - schema_attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - schema_name_id: 1446
- schema_scan_id: 161404838
- updated: 2026-04-03 05:13:03
Schema Scans: 15
Last at 2026-04-17 04:57:14
-
Scan 162169315
- duration: 0:00:14.214703
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169315
- 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_imsholidays/2026-04-17/1776419647", "key": "raw/stellar_imsholidays/2026-04-17/1776419647/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8345726279520672357, "service_name": "drive-thru", "span_id": 11025798371043323165, "trace_id": 2911157337461193624 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-17 04:57:14
- success: True
- trace_id: 2911157337461193624
-
Scan 162114366
- duration: 0:00:11.735541
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114366
- 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_imsholidays/2026-04-16/1776334547", "key": "raw/stellar_imsholidays/2026-04-16/1776334547/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18027275115044828931, "service_name": "drive-thru", "span_id": 10426060698446827294, "trace_id": 12587698951643513147 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-16 05:16:12
- success: True
- trace_id: 12587698951643513147
-
Scan 162056387
- duration: 0:00:14.090154
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056387
- 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_imsholidays/2026-04-15/1776242361", "key": "raw/stellar_imsholidays/2026-04-15/1776242361/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14592125623675421636, "service_name": "drive-thru", "span_id": 1217199999785658931, "trace_id": 13256654723748314774 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-15 03:41:45
- success: True
- trace_id: 13256654723748314774
-
Scan 162003010
- duration: 0:00:14.301749
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003010
- 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_imsholidays/2026-04-14/1776160757", "key": "raw/stellar_imsholidays/2026-04-14/1776160757/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13849830023996377869, "service_name": "drive-thru", "span_id": 8329200678680856508, "trace_id": 8353274619088991646 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-14 05:02:00
- success: True
- trace_id: 8353274619088991646
-
Scan 161945324
- duration: 0:00:14.245138
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945324
- 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_imsholidays/2026-04-13/1776074802", "key": "raw/stellar_imsholidays/2026-04-13/1776074802/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 196384465306969712, "service_name": "drive-thru", "span_id": 1927447196078150387, "trace_id": 12264151373516009411 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-13 05:08:54
- success: True
- trace_id: 12264151373516009411
-
Scan 161896362
- duration: 0:00:11.622651
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896362
- 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_imsholidays/2026-04-12/1775988159", "key": "raw/stellar_imsholidays/2026-04-12/1775988159/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17928451740457482149, "service_name": "drive-thru", "span_id": 2957499973466446247, "trace_id": 18180825322871207812 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-12 05:04:54
- success: True
- trace_id: 18180825322871207812
-
Scan 161843955
- duration: 0:00:11.567995
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843955
- 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_imsholidays/2026-04-11/1775902576", "key": "raw/stellar_imsholidays/2026-04-11/1775902576/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16515555502394662518, "service_name": "drive-thru", "span_id": 6012773332951066524, "trace_id": 5284751053575200371 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-11 05:18:48
- success: True
- trace_id: 5284751053575200371
-
Scan 161788673
- duration: 0:00:14.191039
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788673
- 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_imsholidays/2026-04-10/1775815220", "key": "raw/stellar_imsholidays/2026-04-10/1775815220/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8132144568557395709, "service_name": "drive-thru", "span_id": 1121197524860736200, "trace_id": 7623300540716229338 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-10 05:04:47
- success: True
- trace_id: 7623300540716229338
-
Scan 161732923
- duration: 0:00:14.166029
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732923
- 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_imsholidays/2026-04-09/1775728839", "key": "raw/stellar_imsholidays/2026-04-09/1775728839/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13488443237855291526, "service_name": "drive-thru", "span_id": 13376132779493229606, "trace_id": 15615557624045906611 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-09 05:01:07
- success: True
- trace_id: 15615557624045906611
-
Scan 161678414
- duration: 0:00:11.573758
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678414
- 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_imsholidays/2026-04-08/1775643004", "key": "raw/stellar_imsholidays/2026-04-08/1775643004/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9958961830133980106, "service_name": "drive-thru", "span_id": 3488600499975925556, "trace_id": 59619619433461665 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-08 05:14:59
- success: True
- trace_id: 59619619433461665
-
Scan 161622085
- duration: 0:00:14.137176
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622085
- 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_imsholidays/2026-04-07/1775556859", "key": "raw/stellar_imsholidays/2026-04-07/1775556859/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11845365925525522512, "service_name": "drive-thru", "span_id": 11989964357872426668, "trace_id": 17109112652148715401 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-07 05:15:45
- success: True
- trace_id: 17109112652148715401
-
Scan 161564248
- duration: 0:00:14.211851
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564248
- 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_imsholidays/2026-04-06/1775470532", "key": "raw/stellar_imsholidays/2026-04-06/1775470532/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5414406984940586528, "service_name": "drive-thru", "span_id": 12927660828641109317, "trace_id": 11082355599320142433 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-06 05:16:55
- success: True
- trace_id: 11082355599320142433
-
Scan 161516590
- duration: 0:00:14.093182
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516590
- 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_imsholidays/2026-04-05/1775382945", "key": "raw/stellar_imsholidays/2026-04-05/1775382945/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14351991628271021085, "service_name": "drive-thru", "span_id": 13790396900177825687, "trace_id": 9735913365768289978 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-05 04:58:26
- success: True
- trace_id: 9735913365768289978
-
Scan 161462175
- duration: 0:00:14.115274
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462175
- 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_imsholidays/2026-04-04/1775296472", "key": "raw/stellar_imsholidays/2026-04-04/1775296472/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4156385084852934478, "service_name": "drive-thru", "span_id": 16078814338629275222, "trace_id": 8991679177253297312 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-04 04:57:55
- success: True
- trace_id: 8991679177253297312
-
Scan 161404838
- duration: 0:00:14.126941
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404838
- 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_imsholidays/2026-04-03/1775211035", "key": "raw/stellar_imsholidays/2026-04-03/1775211035/holidays.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsholidays", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13775072129005528996, "service_name": "drive-thru", "span_id": 17750736290339962200, "trace_id": 9089439249311463183 } } - running: False
- schema_name_id: 1446
- start_time: 2026-04-03 05:12:49
- success: True
- trace_id: 9089439249311463183
- attributes:
{ "2022_05_30_1": "string", "2022_06_19_1": "string", "2022_07_04_1": "string", "2022_09_05": "string", "holiday_date": "string", "holiday_date_1": "string", "location_id": "string", "tenant": "string" } - created: 2026-04-17 04:57:15
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays" }
- 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:45:49",
"disabled": false,
"format": "raw",
"id": 1446,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsholidays"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"2022_05_30_1": "string",
"2022_06_19_1": "string",
"2022_07_04_1": "string",
"2022_09_05": "string",
"holiday_date": "string",
"holiday_date_1": "string",
"location_id": "string",
"tenant": "string"
},
"created": "2026-04-17 04:57:15",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsholidays`\n(\n `tenant` string , `location_id` string , `holiday_date` 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_imsholidays/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsholidays`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsholidays"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}