Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsemail_rule_styles

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717947

created: 2026-04-17 04:56:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_styles/2026-04-17/1776419647
id: 1717947
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 162169286
updated: 2026-04-17 04:56:19

Version 1716712

created: 2026-04-16 05:16:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_styles/2026-04-16/1776334547
id: 1716712
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 162114381
updated: 2026-04-16 05:16:56

Version 1715506

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 162056391
updated: 2026-04-15 03:42:08

Version 1714309

created: 2026-04-14 05:00:40

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 162002939
updated: 2026-04-14 05:00:51

Version 1713116

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161945323
updated: 2026-04-13 05:09:08

Version 1711898

created: 2026-04-12 05:04:09

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161896342
updated: 2026-04-12 05:04:23

Version 1710769

created: 2026-04-11 05:20:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rule_styles/2026-04-11/1775902577
id: 1710769
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161843990
updated: 2026-04-11 05:20:18

Version 1709541

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161788582
updated: 2026-04-10 05:02:15

Version 1708399

created: 2026-04-09 05:02:21

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161732957
updated: 2026-04-09 05:02:32

Version 1707270

created: 2026-04-08 05:15:33

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161678430
updated: 2026-04-08 05:15:47

Version 1705998

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161622077
updated: 2026-04-07 05:15:41

Version 1704785

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161564256
updated: 2026-04-06 05:17:29

Version 1703550

created: 2026-04-05 04:56:41

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161516525
updated: 2026-04-05 04:56:52

Version 1702462

created: 2026-04-04 04:57:44

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161462172
updated: 2026-04-04 04:57:55

Version 1701245

created: 2026-04-03 05:13:03

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1442
schema_scan_id: 161404843
updated: 2026-04-03 05:13:16

Schema Scans: 15

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

Scan 162169286

duration: 0:00:11.686806

exit_message:

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

id: 162169286

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_styles/2026-04-17/1776419647",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-17/1776419647/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5247152228955437891,
        "service_name": "drive-thru",
        "span_id": 17219753681672078947,
        "trace_id": 6124288998439472630
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-17 04:56:07
success: True
trace_id: 6124288998439472630

Scan 162114381

duration: 0:00:11.696676

exit_message:

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

id: 162114381

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_styles/2026-04-16/1776334547",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-16/1776334547/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12681232208563449775,
        "service_name": "drive-thru",
        "span_id": 17938498313902167730,
        "trace_id": 4896574393051016829
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-16 05:16:45
success: True
trace_id: 4896574393051016829

Scan 162056391

duration: 0:00:11.537389

exit_message:

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

id: 162056391

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_styles/2026-04-15/1776242360",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-15/1776242360/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4535741212568912790,
        "service_name": "drive-thru",
        "span_id": 13065571626162237733,
        "trace_id": 5173870226948480066
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-15 03:41:56
success: True
trace_id: 5173870226948480066

Scan 162002939

duration: 0:00:11.610371

exit_message:

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

id: 162002939

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_styles/2026-04-14/1776160756",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-14/1776160756/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3711452234322753857,
        "service_name": "drive-thru",
        "span_id": 8044669873745906034,
        "trace_id": 4835172214368643304
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-14 05:00:39
success: True
trace_id: 4835172214368643304

Scan 161945323

duration: 0:00:14.050621

exit_message:

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

id: 161945323

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_styles/2026-04-13/1776074801",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-13/1776074801/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 903197326988692032,
        "service_name": "drive-thru",
        "span_id": 12995050582595004039,
        "trace_id": 2040158776707522216
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-13 05:08:54
success: True
trace_id: 2040158776707522216

Scan 161896342

duration: 0:00:14.024637

exit_message:

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

id: 161896342

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_styles/2026-04-12/1775988158",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-12/1775988158/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14806610477981634044,
        "service_name": "drive-thru",
        "span_id": 8284527019201712400,
        "trace_id": 12182827412137879166
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-12 05:04:09
success: True
trace_id: 12182827412137879166

Scan 161843990

duration: 0:00:11.634888

exit_message:

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

id: 161843990

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_styles/2026-04-11/1775902577",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-11/1775902577/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9552009729550560738,
        "service_name": "drive-thru",
        "span_id": 8610557648286200591,
        "trace_id": 2331161701206450335
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-11 05:20:06
success: True
trace_id: 2331161701206450335

Scan 161788582

duration: 0:00:14.104617

exit_message:

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

id: 161788582

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_styles/2026-04-10/1775815217",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-10/1775815217/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17012311707561045363,
        "service_name": "drive-thru",
        "span_id": 18076812717812693273,
        "trace_id": 3934550606754204534
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-10 05:02:01
success: True
trace_id: 3934550606754204534

Scan 161732957

duration: 0:00:11.474194

exit_message:

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

id: 161732957

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_styles/2026-04-09/1775728837",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-09/1775728837/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6908477697024315917,
        "service_name": "drive-thru",
        "span_id": 6209640742407682748,
        "trace_id": 3745536839959017356
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-09 05:02:21
success: True
trace_id: 3745536839959017356

Scan 161678430

duration: 0:00:14.257661

exit_message:

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

id: 161678430

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_styles/2026-04-08/1775643003",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-08/1775643003/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16611089231364787525,
        "service_name": "drive-thru",
        "span_id": 12960141662460619614,
        "trace_id": 6170675527508769848
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-08 05:15:33
success: True
trace_id: 6170675527508769848

Scan 161622077

duration: 0:00:11.644690

exit_message:

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

id: 161622077

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_styles/2026-04-07/1775556858",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-07/1775556858/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14619497333825926908,
        "service_name": "drive-thru",
        "span_id": 10295594573040631276,
        "trace_id": 10559701549281152940
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-07 05:15:29
success: True
trace_id: 10559701549281152940

Scan 161564256

duration: 0:00:14.053826

exit_message:

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

id: 161564256

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_styles/2026-04-06/1775470530",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-06/1775470530/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6043592887885051576,
        "service_name": "drive-thru",
        "span_id": 6457412577017933969,
        "trace_id": 5144453030278671817
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-06 05:17:15
success: True
trace_id: 5144453030278671817

Scan 161516525

duration: 0:00:11.545983

exit_message:

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

id: 161516525

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_styles/2026-04-05/1775382945",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-05/1775382945/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6471819010827556272,
        "service_name": "drive-thru",
        "span_id": 10139601151248563143,
        "trace_id": 3311044172129821414
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-05 04:56:41
success: True
trace_id: 3311044172129821414

Scan 161462172

duration: 0:00:11.518790

exit_message:

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

id: 161462172

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_styles/2026-04-04/1775296471",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-04/1775296471/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10993113012811935041,
        "service_name": "drive-thru",
        "span_id": 12748566188197246688,
        "trace_id": 7349823891734222460
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-04 04:57:43
success: True
trace_id: 7349823891734222460

Scan 161404843

duration: 0:00:14.147513

exit_message:

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

id: 161404843

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_styles/2026-04-03/1775211035",
        "key": "raw/stellar_imsemail_rule_styles/2026-04-03/1775211035/email_rule_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rule_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4434763262286253185,
        "service_name": "drive-thru",
        "span_id": 14027227249115465564,
        "trace_id": 10419673383355934606
    }
}

running: False
schema_name_id: 1442
start_time: 2026-04-03 05:13:02
success: True
trace_id: 10419673383355934606

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 04:56:08

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_styles`\n(\n `tenant`  string , `email_rule_id`  string , `style_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_styles/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rule_styles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rule_styles"
}

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:38",
        "disabled": false,
        "format": "raw",
        "id": 1442,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsemail_rule_styles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "email_rule_id": "string",
            "style_id": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:56:08",
        "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_styles`\n(\n `tenant`  string , `email_rule_id`  string , `style_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_styles/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rule_styles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rule_styles"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}