Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsemail_rules

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717998

created: 2026-04-17 04:58:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 162169339
updated: 2026-04-17 04:58:13

Version 1716725

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-16/1776334547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 162114394
updated: 2026-04-16 05:17:24

Version 1715503

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-15/1776242360'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 162056386
updated: 2026-04-15 03:41:57

Version 1714324

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 162002978
updated: 2026-04-14 05:01:34

Version 1713107

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-13/1776074801'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161945313
updated: 2026-04-13 05:08:42

Version 1711887

created: 2026-04-12 05:03:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-12/1775988159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rules/2026-04-12/1775988159
id: 1711887
processed: 1

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161896324
updated: 2026-04-12 05:03:42

Version 1710763

created: 2026-04-11 05:19:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-11/1775902580'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rules/2026-04-11/1775902580
id: 1710763
processed: 1

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161843984
updated: 2026-04-11 05:20:07

Version 1709572

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161788615
updated: 2026-04-10 05:03:28

Version 1708438

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161733000
updated: 2026-04-09 05:04:00

Version 1707256

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-08/1775643004'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rules/2026-04-08/1775643004
id: 1707256
processed: 1

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161678415
updated: 2026-04-08 05:15:17

Version 1706071

created: 2026-04-07 05:18:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161622158
updated: 2026-04-07 05:18:39

Version 1704756

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-06/1775470531'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rules/2026-04-06/1775470531
id: 1704756
processed: 1

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161564227
updated: 2026-04-06 05:16:26

Version 1703567

created: 2026-04-05 04:57:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161516554
updated: 2026-04-05 04:57:36

Version 1702434

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-04/1775296471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

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

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161462135
updated: 2026-04-04 04:56:55

Version 1701214

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsemail_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsemail_rules/2026-04-03/1775211036
id: 1701214
processed: 1

raw_data:

{
    "applies_to": 10,
    "automation_type": 2,
    "created_at": 15,
    "email_template_id": 4,
    "filters": 12,
    "id": 1,
    "location_id": 3,
    "operator": 11,
    "rule_name": 5,
    "schedule_date_column": 9,
    "schedule_direction": 8,
    "schedule_num": 6,
    "schedule_period": 7,
    "settings": 13,
    "status": 14,
    "tenant": 0,
    "updated_at": 16
}

schema_attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1433
schema_scan_id: 161404812
updated: 2026-04-03 05:12:04

Schema Scans: 15

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

Scan 162169339

duration: 0:00:11.969479

exit_message:

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

id: 162169339

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_rules/2026-04-17/1776419648",
        "key": "raw/stellar_imsemail_rules/2026-04-17/1776419648/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10916232197061789256,
        "service_name": "drive-thru",
        "span_id": 15125902716680762218,
        "trace_id": 7971058741608620229
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-17 04:58:01
success: True
trace_id: 7971058741608620229

Scan 162114394

duration: 0:00:12.019164

exit_message:

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

id: 162114394

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_rules/2026-04-16/1776334547",
        "key": "raw/stellar_imsemail_rules/2026-04-16/1776334547/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14778883944923693922,
        "service_name": "drive-thru",
        "span_id": 7182794979989987088,
        "trace_id": 10008861284115164056
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-16 05:17:12
success: True
trace_id: 10008861284115164056

Scan 162056386

duration: 0:00:11.857316

exit_message:

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

id: 162056386

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_rules/2026-04-15/1776242360",
        "key": "raw/stellar_imsemail_rules/2026-04-15/1776242360/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2757515139048610831,
        "service_name": "drive-thru",
        "span_id": 10341882581559129665,
        "trace_id": 17498923666580663366
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-15 03:41:45
success: True
trace_id: 17498923666580663366

Scan 162002978

duration: 0:00:14.424274

exit_message:

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

id: 162002978

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_rules/2026-04-14/1776160756",
        "key": "raw/stellar_imsemail_rules/2026-04-14/1776160756/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16728669683505349588,
        "service_name": "drive-thru",
        "span_id": 1960895324325409727,
        "trace_id": 1342652420325467599
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-14 05:01:20
success: True
trace_id: 1342652420325467599

Scan 161945313

duration: 0:00:12.008642

exit_message:

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

id: 161945313

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_rules/2026-04-13/1776074801",
        "key": "raw/stellar_imsemail_rules/2026-04-13/1776074801/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2345895616164737360,
        "service_name": "drive-thru",
        "span_id": 2931398601600087993,
        "trace_id": 108561154480620407
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-13 05:08:30
success: True
trace_id: 108561154480620407

Scan 161896324

duration: 0:00:11.884528

exit_message:

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

id: 161896324

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_rules/2026-04-12/1775988159",
        "key": "raw/stellar_imsemail_rules/2026-04-12/1775988159/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16479036369989363185,
        "service_name": "drive-thru",
        "span_id": 18177819912888612093,
        "trace_id": 13440358679204398652
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-12 05:03:30
success: True
trace_id: 13440358679204398652

Scan 161843984

duration: 0:00:14.435414

exit_message:

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

id: 161843984

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_rules/2026-04-11/1775902580",
        "key": "raw/stellar_imsemail_rules/2026-04-11/1775902580/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4780315186344290932,
        "service_name": "drive-thru",
        "span_id": 7637557921139747012,
        "trace_id": 15000576702120379858
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-11 05:19:53
success: True
trace_id: 15000576702120379858

Scan 161788615

duration: 0:00:14.591832

exit_message:

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

id: 161788615

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_rules/2026-04-10/1775815219",
        "key": "raw/stellar_imsemail_rules/2026-04-10/1775815219/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17914554295730853071,
        "service_name": "drive-thru",
        "span_id": 14219866918405811324,
        "trace_id": 3980950905609536242
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-10 05:03:13
success: True
trace_id: 3980950905609536242

Scan 161733000

duration: 0:00:11.945435

exit_message:

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

id: 161733000

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_rules/2026-04-09/1775728837",
        "key": "raw/stellar_imsemail_rules/2026-04-09/1775728837/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15475372534401995060,
        "service_name": "drive-thru",
        "span_id": 12893923696005004638,
        "trace_id": 3901870449781610712
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-09 05:03:48
success: True
trace_id: 3901870449781610712

Scan 161678415

duration: 0:00:14.443960

exit_message:

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

id: 161678415

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_rules/2026-04-08/1775643004",
        "key": "raw/stellar_imsemail_rules/2026-04-08/1775643004/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16316012106431520277,
        "service_name": "drive-thru",
        "span_id": 16638300103610449407,
        "trace_id": 13274210261481567487
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-08 05:15:03
success: True
trace_id: 13274210261481567487

Scan 161622158

duration: 0:00:14.582530

exit_message:

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

id: 161622158

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_rules/2026-04-07/1775556858",
        "key": "raw/stellar_imsemail_rules/2026-04-07/1775556858/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18269789903697569802,
        "service_name": "drive-thru",
        "span_id": 4990448450839219020,
        "trace_id": 2261945686220535483
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-07 05:18:24
success: True
trace_id: 2261945686220535483

Scan 161564227

duration: 0:00:14.624858

exit_message:

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

id: 161564227

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_rules/2026-04-06/1775470531",
        "key": "raw/stellar_imsemail_rules/2026-04-06/1775470531/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3168140187345010013,
        "service_name": "drive-thru",
        "span_id": 12706229607308356056,
        "trace_id": 6475606227514978271
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-06 05:16:12
success: True
trace_id: 6475606227514978271

Scan 161516554

duration: 0:00:11.909336

exit_message:

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

id: 161516554

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_rules/2026-04-05/1775382945",
        "key": "raw/stellar_imsemail_rules/2026-04-05/1775382945/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7499834593779394244,
        "service_name": "drive-thru",
        "span_id": 1076803608971951054,
        "trace_id": 11757380284250802243
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-05 04:57:24
success: True
trace_id: 11757380284250802243

Scan 161462135

duration: 0:00:14.332137

exit_message:

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

id: 161462135

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_rules/2026-04-04/1775296471",
        "key": "raw/stellar_imsemail_rules/2026-04-04/1775296471/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1239719247300963217,
        "service_name": "drive-thru",
        "span_id": 16534252870819408355,
        "trace_id": 2289297687525008082
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-04 04:56:40
success: True
trace_id: 2289297687525008082

Scan 161404812

duration: 0:00:11.955864

exit_message:

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

id: 161404812

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_rules/2026-04-03/1775211036",
        "key": "raw/stellar_imsemail_rules/2026-04-03/1775211036/email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsemail_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6729250190082763042,
        "service_name": "drive-thru",
        "span_id": 6271085196701437184,
        "trace_id": 12885657193976780896
    }
}

running: False
schema_name_id: 1433
start_time: 2026-04-03 05:11:52
success: True
trace_id: 12885657193976780896

Partitions:

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

Schema:

attributes:

{
    "applies_to": "string",
    "automation_type": "string",
    "created_at": "string",
    "email_template_id": "string",
    "filters": "string",
    "id": "string",
    "location_id": "string",
    "operator": "string",
    "rule_name": "string",
    "schedule_date_column": "string",
    "schedule_direction": "string",
    "schedule_num": "string",
    "schedule_period": "string",
    "settings": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:58:02

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_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
}

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:13",
        "disabled": false,
        "format": "raw",
        "id": 1433,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsemail_rules"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "applies_to": "string",
            "automation_type": "string",
            "created_at": "string",
            "email_template_id": "string",
            "filters": "string",
            "id": "string",
            "location_id": "string",
            "operator": "string",
            "rule_name": "string",
            "schedule_date_column": "string",
            "schedule_direction": "string",
            "schedule_num": "string",
            "schedule_period": "string",
            "settings": "string",
            "status": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:58:02",
        "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_rules`\n(\n `tenant`  string , `id`  string , `automation_type`  string , `location_id`  string , `email_template_id`  string , `rule_name`  string , `schedule_num`  string , `schedule_period`  string , `schedule_direction`  string , `schedule_date_column`  string , `applies_to`  string , `operator`  string , `filters`  string , `settings`  string , `status`  string , `created_at`  string , `updated_at`  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_rules/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsemail_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsemail_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}