Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsprice_rule_seasons

created: 2023-02-07 01:49:17
disabled: False
format: raw
id: 1510
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718001

created: 2026-04-17 04:58:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-17/1776419650
id: 1718001
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 162169341
updated: 2026-04-17 04:58:17

Version 1716726

created: 2026-04-16 05:17:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-16/1776334550
id: 1716726
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 162114396
updated: 2026-04-16 05:17:32

Version 1715528

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-15/1776242364
id: 1715528
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 162056414
updated: 2026-04-15 03:43:00

Version 1714331

created: 2026-04-14 05:01:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-14/1776160759
id: 1714331
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 162002991
updated: 2026-04-14 05:01:50

Version 1713147

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-13/1776074805
id: 1713147
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161945355
updated: 2026-04-13 05:10:16

Version 1711972

created: 2026-04-12 05:07:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-12/1775988162
id: 1711972
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161896431
updated: 2026-04-12 05:07:57

Version 1710732

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161843951
updated: 2026-04-11 05:18:50

Version 1709589

created: 2026-04-10 05:03:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-10/1775815219
id: 1709589
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161788636
updated: 2026-04-10 05:04:05

Version 1708437

created: 2026-04-09 05:03:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-09/1775728840
id: 1708437
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161732998
updated: 2026-04-09 05:03:59

Version 1707167

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-08/1775642989
id: 1707167
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161678326
updated: 2026-04-08 05:10:30

Version 1706003

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-07/1775556859
id: 1706003
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161622081
updated: 2026-04-07 05:15:55

Version 1704808

created: 2026-04-06 05:18:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-06/1775470534
id: 1704808
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161564283
updated: 2026-04-06 05:18:20

Version 1703573

created: 2026-04-05 04:57:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-05/1775382948
id: 1703573
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161516565
updated: 2026-04-05 04:57:47

Version 1702377

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-04/1775296461
id: 1702377
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161462075
updated: 2026-04-04 04:54:48

Version 1701302

created: 2026-04-03 05:15:20

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rule_seasons/2026-04-03/1775211037
id: 1701302
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1510
schema_scan_id: 161404903
updated: 2026-04-03 05:15:34

Schema Scans: 15

Last at 2026-04-17 04:58:06

Scan 162169341

duration: 0:00:11.537860

exit_message:

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

id: 162169341

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_imsprice_rule_seasons/2026-04-17/1776419650",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-17/1776419650/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10604331178057872308,
        "service_name": "drive-thru",
        "span_id": 8775388451639537526,
        "trace_id": 12027800519833752403
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-17 04:58:06
success: True
trace_id: 12027800519833752403

Scan 162114396

duration: 0:00:14.074782

exit_message:

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

id: 162114396

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_imsprice_rule_seasons/2026-04-16/1776334550",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-16/1776334550/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10876424159925094131,
        "service_name": "drive-thru",
        "span_id": 7224545985021210780,
        "trace_id": 8917137377899739535
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-16 05:17:18
success: True
trace_id: 8917137377899739535

Scan 162056414

duration: 0:00:14.115700

exit_message:

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

id: 162056414

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_imsprice_rule_seasons/2026-04-15/1776242364",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-15/1776242364/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5953786073045068695,
        "service_name": "drive-thru",
        "span_id": 204210701246682282,
        "trace_id": 16733588122328209379
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-15 03:42:46
success: True
trace_id: 16733588122328209379

Scan 162002991

duration: 0:00:11.540683

exit_message:

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

id: 162002991

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_imsprice_rule_seasons/2026-04-14/1776160759",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-14/1776160759/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 922094818962971260,
        "service_name": "drive-thru",
        "span_id": 13413730796521350890,
        "trace_id": 12253977555448669903
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-14 05:01:38
success: True
trace_id: 12253977555448669903

Scan 161945355

duration: 0:00:11.625144

exit_message:

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

id: 161945355

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_imsprice_rule_seasons/2026-04-13/1776074805",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-13/1776074805/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3645579371874140236,
        "service_name": "drive-thru",
        "span_id": 2251396632571441404,
        "trace_id": 9606712455068142365
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-13 05:10:05
success: True
trace_id: 9606712455068142365

Scan 161896431

duration: 0:00:11.490621

exit_message:

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

id: 161896431

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_imsprice_rule_seasons/2026-04-12/1775988162",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-12/1775988162/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5664412342240705106,
        "service_name": "drive-thru",
        "span_id": 4312878662452957555,
        "trace_id": 10038837884148848294
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-12 05:07:46
success: True
trace_id: 10038837884148848294

Scan 161843951

duration: 0:00:11.412944

exit_message:

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

id: 161843951

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_imsprice_rule_seasons/2026-04-11/1775902578",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-11/1775902578/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14188795227457241703,
        "service_name": "drive-thru",
        "span_id": 12304493157700532952,
        "trace_id": 6733234729831222780
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-11 05:18:38
success: True
trace_id: 6733234729831222780

Scan 161788636

duration: 0:00:11.575077

exit_message:

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

id: 161788636

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_imsprice_rule_seasons/2026-04-10/1775815219",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-10/1775815219/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4810899825536372167,
        "service_name": "drive-thru",
        "span_id": 4185264466168077904,
        "trace_id": 10670404075997811126
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-10 05:03:54
success: True
trace_id: 10670404075997811126

Scan 161732998

duration: 0:00:14.285491

exit_message:

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

id: 161732998

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_imsprice_rule_seasons/2026-04-09/1775728840",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-09/1775728840/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7950372208681942193,
        "service_name": "drive-thru",
        "span_id": 8605389065354629517,
        "trace_id": 3950846306682400436
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-09 05:03:44
success: True
trace_id: 3950846306682400436

Scan 161678326

duration: 0:00:14.190871

exit_message:

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

id: 161678326

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_imsprice_rule_seasons/2026-04-08/1775642989",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-08/1775642989/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14912043515424121384,
        "service_name": "drive-thru",
        "span_id": 7654333455258286244,
        "trace_id": 152660037746237285
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-08 05:10:16
success: True
trace_id: 152660037746237285

Scan 161622081

duration: 0:00:14.064213

exit_message:

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

id: 161622081

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_imsprice_rule_seasons/2026-04-07/1775556859",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-07/1775556859/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5429427799047476731,
        "service_name": "drive-thru",
        "span_id": 9096699544884163442,
        "trace_id": 9357445991404911538
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-07 05:15:41
success: True
trace_id: 9357445991404911538

Scan 161564283

duration: 0:00:14.039165

exit_message:

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

id: 161564283

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_imsprice_rule_seasons/2026-04-06/1775470534",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-06/1775470534/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6107020730729933621,
        "service_name": "drive-thru",
        "span_id": 15172403008137608346,
        "trace_id": 4051739374032714746
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-06 05:18:06
success: True
trace_id: 4051739374032714746

Scan 161516565

duration: 0:00:11.437517

exit_message:

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

id: 161516565

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_imsprice_rule_seasons/2026-04-05/1775382948",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-05/1775382948/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11480492392281631750,
        "service_name": "drive-thru",
        "span_id": 3181793534675736527,
        "trace_id": 17004479898006335579
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-05 04:57:36
success: True
trace_id: 17004479898006335579

Scan 161462075

duration: 0:00:11.682137

exit_message:

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

id: 161462075

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_imsprice_rule_seasons/2026-04-04/1775296461",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-04/1775296461/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14182497969893986038,
        "service_name": "drive-thru",
        "span_id": 3143315162017976844,
        "trace_id": 13135122455632106911
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-04 04:54:37
success: True
trace_id: 13135122455632106911

Scan 161404903

duration: 0:00:14.043503

exit_message:

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

id: 161404903

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_imsprice_rule_seasons/2026-04-03/1775211037",
        "key": "raw/stellar_imsprice_rule_seasons/2026-04-03/1775211037/price_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6643244780143446501,
        "service_name": "drive-thru",
        "span_id": 16090104289208054855,
        "trace_id": 5424810789639447363
    }
}

running: False
schema_name_id: 1510
start_time: 2026-04-03 05:15:20
success: True
trace_id: 5424810789639447363

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 04:58:06

ddl:

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