Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsemail_rule_seasons

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717965

created: 2026-04-17 04:56:48

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-17/1776419648
id: 1717965
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 162169303
updated: 2026-04-17 04:56:59

Version 1716763

created: 2026-04-16 05:18:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-16/1776334546
id: 1716763
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 162114432
updated: 2026-04-16 05:18:52

Version 1715499

created: 2026-04-15 03:41:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-15/1776242360
id: 1715499
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 162056383
updated: 2026-04-15 03:41:49

Version 1714342

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-14/1776160756
id: 1714342
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 162003021
updated: 2026-04-14 05:02:27

Version 1713128

created: 2026-04-13 05:09:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-13/1776074801
id: 1713128
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161945334
updated: 2026-04-13 05:09:33

Version 1711977

created: 2026-04-12 05:08:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-12/1775988158
id: 1711977
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161896438
updated: 2026-04-12 05:08:25

Version 1710702

created: 2026-04-11 05:17:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-11/1775902576
id: 1710702
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161843921
updated: 2026-04-11 05:17:39

Version 1709560

created: 2026-04-10 05:02:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-10/1775815217
id: 1709560
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161788602
updated: 2026-04-10 05:03:00

Version 1708365

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-09/1775728837
id: 1708365
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161732919
updated: 2026-04-09 05:01:14

Version 1707222

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-08/1775643003
id: 1707222
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161678381
updated: 2026-04-08 05:13:49

Version 1706017

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-07/1775556858
id: 1706017
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161622095
updated: 2026-04-07 05:16:23

Version 1704803

created: 2026-04-06 05:17:55

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-06/1775470530
id: 1704803
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161564276
updated: 2026-04-06 05:18:06

Version 1703568

created: 2026-04-05 04:57:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-05/1775382945
id: 1703568
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161516557
updated: 2026-04-05 04:57:36

Version 1702486

created: 2026-04-04 04:58:37

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_seasons/2026-04-04/1775296471
id: 1702486
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161462240
updated: 2026-04-04 04:58:50

Version 1701207

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1447
schema_scan_id: 161404805
updated: 2026-04-03 05:11:49

Schema Scans: 15

Last at 2026-04-17 04:56:48

Scan 162169303

duration: 0:00:11.519497

exit_message:

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

id: 162169303

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_imsemail_rule_seasons/2026-04-17/1776419648",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-17/1776419648/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18212416104922456131,
        "service_name": "drive-thru",
        "span_id": 10938106951250081460,
        "trace_id": 11257366353299739974
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-17 04:56:48
success: True
trace_id: 11257366353299739974

Scan 162114432

duration: 0:00:11.491012

exit_message:

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

id: 162114432

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_imsemail_rule_seasons/2026-04-16/1776334546",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-16/1776334546/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18215940962610259993,
        "service_name": "drive-thru",
        "span_id": 4252602496483071311,
        "trace_id": 1991710101132671480
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-16 05:18:40
success: True
trace_id: 1991710101132671480

Scan 162056383

duration: 0:00:14.073060

exit_message:

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

id: 162056383

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_imsemail_rule_seasons/2026-04-15/1776242360",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-15/1776242360/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1684168213250874829,
        "service_name": "drive-thru",
        "span_id": 11890911014018464277,
        "trace_id": 13515820456597631198
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-15 03:41:35
success: True
trace_id: 13515820456597631198

Scan 162003021

duration: 0:00:14.181481

exit_message:

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

id: 162003021

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_imsemail_rule_seasons/2026-04-14/1776160756",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-14/1776160756/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13138081179847205706,
        "service_name": "drive-thru",
        "span_id": 3660299691469272636,
        "trace_id": 16353045944205847663
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-14 05:02:13
success: True
trace_id: 16353045944205847663

Scan 161945334

duration: 0:00:14.264327

exit_message:

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

id: 161945334

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_imsemail_rule_seasons/2026-04-13/1776074801",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-13/1776074801/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4150300455805879833,
        "service_name": "drive-thru",
        "span_id": 11615564553544259368,
        "trace_id": 17782692705591018612
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-13 05:09:19
success: True
trace_id: 17782692705591018612

Scan 161896438

duration: 0:00:14.104330

exit_message:

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

id: 161896438

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_imsemail_rule_seasons/2026-04-12/1775988158",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-12/1775988158/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7695617245297959087,
        "service_name": "drive-thru",
        "span_id": 7833615322180744750,
        "trace_id": 5681570394784261578
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-12 05:08:11
success: True
trace_id: 5681570394784261578

Scan 161843921

duration: 0:00:11.560153

exit_message:

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

id: 161843921

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_imsemail_rule_seasons/2026-04-11/1775902576",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-11/1775902576/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9208338894677628940,
        "service_name": "drive-thru",
        "span_id": 11200229691390724466,
        "trace_id": 10241529180953598905
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-11 05:17:28
success: True
trace_id: 10241529180953598905

Scan 161788602

duration: 0:00:14.019033

exit_message:

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

id: 161788602

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_imsemail_rule_seasons/2026-04-10/1775815217",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-10/1775815217/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10117196340642911308,
        "service_name": "drive-thru",
        "span_id": 5657593985680053657,
        "trace_id": 4585314664557537417
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-10 05:02:46
success: True
trace_id: 4585314664557537417

Scan 161732919

duration: 0:00:14.454264

exit_message:

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

id: 161732919

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_imsemail_rule_seasons/2026-04-09/1775728837",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-09/1775728837/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15988201740174428775,
        "service_name": "drive-thru",
        "span_id": 11554618897029203120,
        "trace_id": 7895902966780410614
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-09 05:00:59
success: True
trace_id: 7895902966780410614

Scan 161678381

duration: 0:00:14.053936

exit_message:

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

id: 161678381

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_imsemail_rule_seasons/2026-04-08/1775643003",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-08/1775643003/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15268438707376775034,
        "service_name": "drive-thru",
        "span_id": 995781483599265767,
        "trace_id": 7636163776533746460
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-08 05:13:35
success: True
trace_id: 7636163776533746460

Scan 161622095

duration: 0:00:11.618208

exit_message:

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

id: 161622095

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_imsemail_rule_seasons/2026-04-07/1775556858",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-07/1775556858/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14227541553620327423,
        "service_name": "drive-thru",
        "span_id": 15102343930506950216,
        "trace_id": 2919114118091332235
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-07 05:16:11
success: True
trace_id: 2919114118091332235

Scan 161564276

duration: 0:00:11.532524

exit_message:

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

id: 161564276

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_imsemail_rule_seasons/2026-04-06/1775470530",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-06/1775470530/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2582518986679034906,
        "service_name": "drive-thru",
        "span_id": 2508012931911947617,
        "trace_id": 8331104488499308362
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-06 05:17:55
success: True
trace_id: 8331104488499308362

Scan 161516557

duration: 0:00:11.462684

exit_message:

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

id: 161516557

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_imsemail_rule_seasons/2026-04-05/1775382945",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-05/1775382945/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13772735476764714487,
        "service_name": "drive-thru",
        "span_id": 14351103918809687775,
        "trace_id": 17150269656528987287
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-05 04:57:24
success: True
trace_id: 17150269656528987287

Scan 161462240

duration: 0:00:14.070949

exit_message:

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

id: 161462240

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_imsemail_rule_seasons/2026-04-04/1775296471",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-04/1775296471/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 80019910960299105,
        "service_name": "drive-thru",
        "span_id": 1532873184550159245,
        "trace_id": 13716230072620099889
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-04 04:58:36
success: True
trace_id: 13716230072620099889

Scan 161404805

duration: 0:00:14.176338

exit_message:

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

id: 161404805

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_imsemail_rule_seasons/2026-04-03/1775211035",
        "key": "raw/stellar_imsemail_rule_seasons/2026-04-03/1775211035/email_rule_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13855586131847570766,
        "service_name": "drive-thru",
        "span_id": 7410004909086017425,
        "trace_id": 13892583756347753390
    }
}

running: False
schema_name_id: 1447
start_time: 2026-04-03 05:11:35
success: True
trace_id: 13892583756347753390

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 04:56:48

ddl:

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