Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsavailability_rule_seasons

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717923

created: 2026-04-17 04:55:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-17/1776419642'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-17/1776419642
id: 1717923
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 162169259
updated: 2026-04-17 04:55:11

Version 1716689

created: 2026-04-16 05:15:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-16/1776334540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-16/1776334540
id: 1716689
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 162114358
updated: 2026-04-16 05:16:00

Version 1715468

created: 2026-04-15 03:40:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-15/1776242356
id: 1715468
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 162056351
updated: 2026-04-15 03:40:43

Version 1714356

created: 2026-04-14 05:02:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-14/1776160753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-14/1776160753
id: 1714356
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 162003051
updated: 2026-04-14 05:03:08

Version 1713095

created: 2026-04-13 05:08:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-13/1776074797
id: 1713095
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161945301
updated: 2026-04-13 05:08:16

Version 1711879

created: 2026-04-12 05:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-12/1775988153'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-12/1775988153
id: 1711879
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161896312
updated: 2026-04-12 05:03:10

Version 1710683

created: 2026-04-11 05:16:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-11/1775902575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-11/1775902575
id: 1710683
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161843902
updated: 2026-04-11 05:16:56

Version 1709518

created: 2026-04-10 05:01:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-10/1775815212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-10/1775815212
id: 1709518
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161788556
updated: 2026-04-10 05:01:21

Version 1708355

created: 2026-04-09 05:00:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-09/1775728832'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-09/1775728832
id: 1708355
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161732906
updated: 2026-04-09 05:00:50

Version 1707223

created: 2026-04-08 05:13:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

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

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161678382
updated: 2026-04-08 05:13:48

Version 1705972

created: 2026-04-07 05:14:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-07/1775556849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-07/1775556849
id: 1705972
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161622050
updated: 2026-04-07 05:14:40

Version 1704761

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-06/1775470529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-06/1775470529
id: 1704761
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161564232
updated: 2026-04-06 05:16:34

Version 1703531

created: 2026-04-05 04:55:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-05/1775382939'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-05/1775382939
id: 1703531
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161516477
updated: 2026-04-05 04:56:00

Version 1702385

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-04/1775296467
id: 1702385
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161462088
updated: 2026-04-04 04:55:06

Version 1701210

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsavailability_rule_seasons/2026-04-03/1775211035
id: 1701210
processed: 1

raw_data:

{
    "availability_rule_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1445
schema_scan_id: 161404808
updated: 2026-04-03 05:11:57

Schema Scans: 15

Last at 2026-04-17 04:55:00

Scan 162169259

duration: 0:00:11.636540

exit_message:

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

id: 162169259

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_imsavailability_rule_seasons/2026-04-17/1776419642",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-17/1776419642/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1305123713975830546,
        "service_name": "drive-thru",
        "span_id": 14353502085810675026,
        "trace_id": 17981067902759828557
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-17 04:55:00
success: True
trace_id: 17981067902759828557

Scan 162114358

duration: 0:00:14.144531

exit_message:

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

id: 162114358

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_imsavailability_rule_seasons/2026-04-16/1776334540",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-16/1776334540/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15665860684754139715,
        "service_name": "drive-thru",
        "span_id": 3268666745843031730,
        "trace_id": 9373496048321321419
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-16 05:15:46
success: True
trace_id: 9373496048321321419

Scan 162056351

duration: 0:00:14.138087

exit_message:

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

id: 162056351

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_imsavailability_rule_seasons/2026-04-15/1776242356",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-15/1776242356/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1921478616468528698,
        "service_name": "drive-thru",
        "span_id": 5644286059529042292,
        "trace_id": 9254002073584445611
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-15 03:40:29
success: True
trace_id: 9254002073584445611

Scan 162003051

duration: 0:00:14.169865

exit_message:

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

id: 162003051

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_imsavailability_rule_seasons/2026-04-14/1776160753",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-14/1776160753/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9448511921475831298,
        "service_name": "drive-thru",
        "span_id": 8893003351094384208,
        "trace_id": 7241693765006095149
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-14 05:02:53
success: True
trace_id: 7241693765006095149

Scan 161945301

duration: 0:00:14.011393

exit_message:

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

id: 161945301

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_imsavailability_rule_seasons/2026-04-13/1776074797",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-13/1776074797/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7986968217436168471,
        "service_name": "drive-thru",
        "span_id": 4515568370856637070,
        "trace_id": 7247676775422984277
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-13 05:08:02
success: True
trace_id: 7247676775422984277

Scan 161896312

duration: 0:00:14.045091

exit_message:

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

id: 161896312

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_imsavailability_rule_seasons/2026-04-12/1775988153",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-12/1775988153/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 109238865631765901,
        "service_name": "drive-thru",
        "span_id": 14956822805457282988,
        "trace_id": 14424202082170998558
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-12 05:02:56
success: True
trace_id: 14424202082170998558

Scan 161843902

duration: 0:00:14.156249

exit_message:

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

id: 161843902

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_imsavailability_rule_seasons/2026-04-11/1775902575",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-11/1775902575/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12144853230510373620,
        "service_name": "drive-thru",
        "span_id": 9543176206417525460,
        "trace_id": 5068396820471553836
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-11 05:16:42
success: True
trace_id: 5068396820471553836

Scan 161788556

duration: 0:00:11.560344

exit_message:

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

id: 161788556

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_imsavailability_rule_seasons/2026-04-10/1775815212",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-10/1775815212/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1882131887185216855,
        "service_name": "drive-thru",
        "span_id": 15433442617226243198,
        "trace_id": 14313435664650621276
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-10 05:01:09
success: True
trace_id: 14313435664650621276

Scan 161732906

duration: 0:00:11.621817

exit_message:

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

id: 161732906

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_imsavailability_rule_seasons/2026-04-09/1775728832",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-09/1775728832/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1594861191613099578,
        "service_name": "drive-thru",
        "span_id": 654130784417109508,
        "trace_id": 17488089589872046289
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-09 05:00:38
success: True
trace_id: 17488089589872046289

Scan 161678382

duration: 0:00:11.539933

exit_message:

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

id: 161678382

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_imsavailability_rule_seasons/2026-04-08/1775642998",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-08/1775642998/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15442295058697861209,
        "service_name": "drive-thru",
        "span_id": 15411827607419981674,
        "trace_id": 3613178075847883864
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-08 05:13:36
success: True
trace_id: 3613178075847883864

Scan 161622050

duration: 0:00:11.640440

exit_message:

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

id: 161622050

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_imsavailability_rule_seasons/2026-04-07/1775556849",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-07/1775556849/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6895623598256796107,
        "service_name": "drive-thru",
        "span_id": 12010267759475327905,
        "trace_id": 17927893936702453378
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-07 05:14:28
success: True
trace_id: 17927893936702453378

Scan 161564232

duration: 0:00:14.075624

exit_message:

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

id: 161564232

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_imsavailability_rule_seasons/2026-04-06/1775470529",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-06/1775470529/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1185651206263648385,
        "service_name": "drive-thru",
        "span_id": 9937653999562540583,
        "trace_id": 12284045633313670551
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-06 05:16:20
success: True
trace_id: 12284045633313670551

Scan 161516477

duration: 0:00:11.648480

exit_message:

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

id: 161516477

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_imsavailability_rule_seasons/2026-04-05/1775382939",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-05/1775382939/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14603204775101604894,
        "service_name": "drive-thru",
        "span_id": 11020209698439059196,
        "trace_id": 12279195276960589656
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-05 04:55:48
success: True
trace_id: 12279195276960589656

Scan 161462088

duration: 0:00:11.644303

exit_message:

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

id: 161462088

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_imsavailability_rule_seasons/2026-04-04/1775296467",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-04/1775296467/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3526740583309288420,
        "service_name": "drive-thru",
        "span_id": 11339565910279338203,
        "trace_id": 7018844195396877677
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-04 04:54:54
success: True
trace_id: 7018844195396877677

Scan 161404808

duration: 0:00:14.211371

exit_message:

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

id: 161404808

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_imsavailability_rule_seasons/2026-04-03/1775211035",
        "key": "raw/stellar_imsavailability_rule_seasons/2026-04-03/1775211035/availability_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsavailability_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5687580855982102796,
        "service_name": "drive-thru",
        "span_id": 2978120088190622444,
        "trace_id": 16836511213454352397
    }
}

running: False
schema_name_id: 1445
start_time: 2026-04-03 05:11:43
success: True
trace_id: 16836511213454352397

Partitions:

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

Schema:

attributes:

{
    "availability_rule_id": "string",
    "season_id": "string",
    "tenant": "string"
}

created: 2026-04-17 04:55:00

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-17/1776419642'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
}

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:48",
        "disabled": false,
        "format": "raw",
        "id": 1445,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsavailability_rule_seasons"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "availability_rule_id": "string",
            "season_id": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:55:00",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`\n(\n `tenant`  string , `availability_rule_id`  string , `season_id`  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_imsavailability_rule_seasons/2026-04-17/1776419642'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsavailability_rule_seasons`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsavailability_rule_seasons"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}