Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules

created: 2025-11-25 03:50:02
disabled: False
format: raw
id: 4290
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717924

created: 2026-04-17 04:55:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-17/1776419643
id: 1717924
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 162169260
updated: 2026-04-17 04:55:14

Version 1716808

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-16/1776334557'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-16/1776334557
id: 1716808
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 162114491
updated: 2026-04-16 05:21:07

Version 1715444

created: 2026-04-15 03:39:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-15/1776242353'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-15/1776242353
id: 1715444
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 162056327
updated: 2026-04-15 03:39:49

Version 1714303

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-14/1776160748'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-14/1776160748
id: 1714303
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 162002924
updated: 2026-04-14 05:00:38

Version 1713060

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-13/1776074794'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-13/1776074794
id: 1713060
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161945266
updated: 2026-04-13 05:06:55

Version 1711903

created: 2026-04-12 05:04:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-12/1775988151'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-12/1775988151
id: 1711903
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161896350
updated: 2026-04-12 05:04:36

Version 1710685

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-11/1775902566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-11/1775902566
id: 1710685
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161843904
updated: 2026-04-11 05:17:02

Version 1709499

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-10/1775815206'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-10/1775815206
id: 1709499
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161788532
updated: 2026-04-10 05:00:25

Version 1708456

created: 2026-04-09 05:04:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-09/1775728846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-09/1775728846
id: 1708456
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161733020
updated: 2026-04-09 05:04:46

Version 1707248

created: 2026-04-08 05:14:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-08/1775642999
id: 1707248
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161678407
updated: 2026-04-08 05:14:54

Version 1705973

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-07/1775556848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-07/1775556848
id: 1705973
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161622051
updated: 2026-04-07 05:14:47

Version 1704751

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-06/1775470527
id: 1704751
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161564222
updated: 2026-04-06 05:16:15

Version 1703616

created: 2026-04-05 04:59:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-05/1775382953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-05/1775382953
id: 1703616
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161516636
updated: 2026-04-05 04:59:25

Version 1702395

created: 2026-04-04 04:55:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

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

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161462096
updated: 2026-04-04 04:55:30

Version 1701195

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-03/1775211026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_email_rules/2026-04-03/1775211026
id: 1701195
processed: 1

raw_data:

{
    "abandoned_cart_id": 1,
    "created_at": 9,
    "email_rule_id": 2,
    "error_details": 7,
    "sent_at": 8,
    "sms_length": 5,
    "sms_recipient": 4,
    "status": 6,
    "template_type": 3,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4290
schema_scan_id: 161404793
updated: 2026-04-03 05:11:14

Schema Scans: 15

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

Scan 162169260

duration: 0:00:11.843230

exit_message:

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

id: 162169260

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_imsabandoned_cart_email_rules/2026-04-17/1776419643",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-17/1776419643/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17954244017147986095,
        "service_name": "drive-thru",
        "span_id": 18003129287207718950,
        "trace_id": 8235326154318907785
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-17 04:55:02
success: True
trace_id: 8235326154318907785

Scan 162114491

duration: 0:00:11.746110

exit_message:

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

id: 162114491

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_imsabandoned_cart_email_rules/2026-04-16/1776334557",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-16/1776334557/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9111613652161366035,
        "service_name": "drive-thru",
        "span_id": 14499905007950054470,
        "trace_id": 5875195328114562592
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-16 05:20:55
success: True
trace_id: 5875195328114562592

Scan 162056327

duration: 0:00:14.387020

exit_message:

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

id: 162056327

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_imsabandoned_cart_email_rules/2026-04-15/1776242353",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-15/1776242353/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9506891655297630408,
        "service_name": "drive-thru",
        "span_id": 5982011456628461040,
        "trace_id": 11816500148214407633
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-15 03:39:35
success: True
trace_id: 11816500148214407633

Scan 162002924

duration: 0:00:14.353302

exit_message:

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

id: 162002924

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_imsabandoned_cart_email_rules/2026-04-14/1776160748",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-14/1776160748/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17709434752535721107,
        "service_name": "drive-thru",
        "span_id": 6452198018304080924,
        "trace_id": 11652930708240314176
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-14 05:00:24
success: True
trace_id: 11652930708240314176

Scan 161945266

duration: 0:00:11.771487

exit_message:

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

id: 161945266

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_imsabandoned_cart_email_rules/2026-04-13/1776074794",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-13/1776074794/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2328445335870407765,
        "service_name": "drive-thru",
        "span_id": 471352135169120927,
        "trace_id": 6406329240848348457
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-13 05:06:44
success: True
trace_id: 6406329240848348457

Scan 161896350

duration: 0:00:11.674168

exit_message:

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

id: 161896350

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_imsabandoned_cart_email_rules/2026-04-12/1775988151",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-12/1775988151/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11569477589345574607,
        "service_name": "drive-thru",
        "span_id": 6696493210287603892,
        "trace_id": 15032796223205152932
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-12 05:04:25
success: True
trace_id: 15032796223205152932

Scan 161843904

duration: 0:00:11.865430

exit_message:

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

id: 161843904

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_imsabandoned_cart_email_rules/2026-04-11/1775902566",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-11/1775902566/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2836102192490123202,
        "service_name": "drive-thru",
        "span_id": 5793780356359020436,
        "trace_id": 1437466273701520599
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-11 05:16:51
success: True
trace_id: 1437466273701520599

Scan 161788532

duration: 0:00:11.981542

exit_message:

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

id: 161788532

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_imsabandoned_cart_email_rules/2026-04-10/1775815206",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-10/1775815206/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10273711033806325059,
        "service_name": "drive-thru",
        "span_id": 14662338389119353440,
        "trace_id": 14722767750807092497
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-10 05:00:13
success: True
trace_id: 14722767750807092497

Scan 161733020

duration: 0:00:14.439703

exit_message:

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

id: 161733020

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_imsabandoned_cart_email_rules/2026-04-09/1775728846",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-09/1775728846/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2779086368483709329,
        "service_name": "drive-thru",
        "span_id": 7657657485283243397,
        "trace_id": 13706688992403918278
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-09 05:04:32
success: True
trace_id: 13706688992403918278

Scan 161678407

duration: 0:00:11.692730

exit_message:

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

id: 161678407

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_imsabandoned_cart_email_rules/2026-04-08/1775642999",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-08/1775642999/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6358232876813750552,
        "service_name": "drive-thru",
        "span_id": 17685542610433606676,
        "trace_id": 15008076743408742329
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-08 05:14:42
success: True
trace_id: 15008076743408742329

Scan 161622051

duration: 0:00:11.858090

exit_message:

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

id: 161622051

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_imsabandoned_cart_email_rules/2026-04-07/1775556848",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-07/1775556848/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2025667687311395000,
        "service_name": "drive-thru",
        "span_id": 7189197234758293255,
        "trace_id": 11786186735206372494
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-07 05:14:35
success: True
trace_id: 11786186735206372494

Scan 161564222

duration: 0:00:14.331833

exit_message:

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

id: 161564222

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_imsabandoned_cart_email_rules/2026-04-06/1775470527",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-06/1775470527/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10928628708960828502,
        "service_name": "drive-thru",
        "span_id": 11759895325906480194,
        "trace_id": 6010369155187799913
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-06 05:16:01
success: True
trace_id: 6010369155187799913

Scan 161516636

duration: 0:00:14.213428

exit_message:

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

id: 161516636

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_imsabandoned_cart_email_rules/2026-04-05/1775382953",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-05/1775382953/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6807370585528323054,
        "service_name": "drive-thru",
        "span_id": 3353386289360550154,
        "trace_id": 15601637454374648120
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-05 04:59:11
success: True
trace_id: 15601637454374648120

Scan 161462096

duration: 0:00:14.281050

exit_message:

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

id: 161462096

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_imsabandoned_cart_email_rules/2026-04-04/1775296467",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-04/1775296467/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7532760834740926916,
        "service_name": "drive-thru",
        "span_id": 513871013331158219,
        "trace_id": 7036580839524998059
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-04 04:55:15
success: True
trace_id: 7036580839524998059

Scan 161404793

duration: 0:00:11.949082

exit_message:

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

id: 161404793

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_imsabandoned_cart_email_rules/2026-04-03/1775211026",
        "key": "raw/stellar_imsabandoned_cart_email_rules/2026-04-03/1775211026/abandoned_cart_email_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17355383497642628250,
        "service_name": "drive-thru",
        "span_id": 8923300406876281942,
        "trace_id": 396771932399519256
    }
}

running: False
schema_name_id: 4290
start_time: 2026-04-03 05:11:02
success: True
trace_id: 396771932399519256

Partitions:

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

Schema:

attributes:

{
    "abandoned_cart_id": "string",
    "created_at": "string",
    "email_rule_id": "string",
    "error_details": "string",
    "sent_at": "string",
    "sms_length": "string",
    "sms_recipient": "string",
    "status": "string",
    "template_type": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:03

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_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": "2025-11-25 03:50:02",
        "disabled": false,
        "format": "raw",
        "id": 4290,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsabandoned_cart_email_rules"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "abandoned_cart_id": "string",
            "created_at": "string",
            "email_rule_id": "string",
            "error_details": "string",
            "sent_at": "string",
            "sms_length": "string",
            "sms_recipient": "string",
            "status": "string",
            "template_type": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`\n(\n `tenant`  string , `abandoned_cart_id`  string , `email_rule_id`  string , `template_type`  string , `sms_recipient`  string , `sms_length`  string , `status`  string , `error_details`  string , `sent_at`  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_imsabandoned_cart_email_rules/2026-04-17/1776419643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_email_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}