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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
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
Raw:
{
    "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"
    }
}