Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons

created: 2025-11-25 03:51:16
disabled: False
format: raw
id: 4291
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717909

created: 2026-04-17 04:54:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-17/1776419639'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-17/1776419639
id: 1717909
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 162169245
updated: 2026-04-17 04:54:17

Version 1716803

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-16/1776334556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-16/1776334556
id: 1716803
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 162114484
updated: 2026-04-16 05:20:47

Version 1715442

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-15/1776242353'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 162056325
updated: 2026-04-15 03:39:38

Version 1714322

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-14/1776160755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-14/1776160755
id: 1714322
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 162002976
updated: 2026-04-14 05:01:33

Version 1713059

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-13/1776074794'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161945265
updated: 2026-04-13 05:06:52

Version 1711891

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-12/1775988151'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161896330
updated: 2026-04-12 05:03:54

Version 1710671

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-11/1775902566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161843889
updated: 2026-04-11 05:16:27

Version 1709531

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-10/1775815216'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-10/1775815216
id: 1709531
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161788570
updated: 2026-04-10 05:01:53

Version 1708461

created: 2026-04-09 05:04:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-09/1775728846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161733026
updated: 2026-04-09 05:04:58

Version 1707241

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-08/1775642998
id: 1707241
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161678400
updated: 2026-04-08 05:14:38

Version 1705970

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-07/1775556848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161622048
updated: 2026-04-07 05:14:35

Version 1704748

created: 2026-04-06 05:15:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-06/1775470523'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-06/1775470523
id: 1704748
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161564219
updated: 2026-04-06 05:16:05

Version 1703632

created: 2026-04-05 04:59:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-05/1775382953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161516664
updated: 2026-04-05 04:59:48

Version 1702421

created: 2026-04-04 04:56:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsabandoned_cart_coupons/2026-04-04/1775296466
id: 1702421
processed: 1

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161462122
updated: 2026-04-04 04:56:27

Version 1701223

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-03/1775211026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
]

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

raw_data:

{
    "abandoned_cart_id": 4,
    "coupon_code": 3,
    "coupon_id": 2,
    "created_at": 5,
    "id": 1,
    "tenant": 0,
    "updated_at": 6
}

schema_attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 4291
schema_scan_id: 161404821
updated: 2026-04-03 05:12:27

Schema Scans: 15

Last at 2026-04-17 04:54:05

Scan 162169245

duration: 0:00:11.645307

exit_message:

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

id: 162169245

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_coupons/2026-04-17/1776419639",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-17/1776419639/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6255694515388003555,
        "service_name": "drive-thru",
        "span_id": 17059951846907517631,
        "trace_id": 4325366758029441209
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-17 04:54:05
success: True
trace_id: 4325366758029441209

Scan 162114484

duration: 0:00:14.137342

exit_message:

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

id: 162114484

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_coupons/2026-04-16/1776334556",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-16/1776334556/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15238319053110541926,
        "service_name": "drive-thru",
        "span_id": 5020668074665366115,
        "trace_id": 6559674996915807075
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-16 05:20:32
success: True
trace_id: 6559674996915807075

Scan 162056325

duration: 0:00:11.759497

exit_message:

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

id: 162056325

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_coupons/2026-04-15/1776242353",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-15/1776242353/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12385879677462632547,
        "service_name": "drive-thru",
        "span_id": 7808887289711147554,
        "trace_id": 3293846376355953744
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-15 03:39:26
success: True
trace_id: 3293846376355953744

Scan 162002976

duration: 0:00:14.175869

exit_message:

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

id: 162002976

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_coupons/2026-04-14/1776160755",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-14/1776160755/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9173590080947448774,
        "service_name": "drive-thru",
        "span_id": 8086873322678852359,
        "trace_id": 14855118302280034892
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-14 05:01:19
success: True
trace_id: 14855118302280034892

Scan 161945265

duration: 0:00:11.775899

exit_message:

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

id: 161945265

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_coupons/2026-04-13/1776074794",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-13/1776074794/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17048314181394084618,
        "service_name": "drive-thru",
        "span_id": 7225450798340011009,
        "trace_id": 6142448058873806595
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-13 05:06:41
success: True
trace_id: 6142448058873806595

Scan 161896330

duration: 0:00:11.652953

exit_message:

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

id: 161896330

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_coupons/2026-04-12/1775988151",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-12/1775988151/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11469279320801239177,
        "service_name": "drive-thru",
        "span_id": 13871397381795342363,
        "trace_id": 12341853559121158698
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-12 05:03:42
success: True
trace_id: 12341853559121158698

Scan 161843889

duration: 0:00:11.719743

exit_message:

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

id: 161843889

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_coupons/2026-04-11/1775902566",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-11/1775902566/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6317428448668775268,
        "service_name": "drive-thru",
        "span_id": 7545616961335674131,
        "trace_id": 7429041372416418134
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-11 05:16:15
success: True
trace_id: 7429041372416418134

Scan 161788570

duration: 0:00:14.299078

exit_message:

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

id: 161788570

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_coupons/2026-04-10/1775815216",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-10/1775815216/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13847908248731509851,
        "service_name": "drive-thru",
        "span_id": 15474842111501687506,
        "trace_id": 13421477208151700268
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-10 05:01:38
success: True
trace_id: 13421477208151700268

Scan 161733026

duration: 0:00:14.206054

exit_message:

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

id: 161733026

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_coupons/2026-04-09/1775728846",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-09/1775728846/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12335043682458982635,
        "service_name": "drive-thru",
        "span_id": 1210777410276815538,
        "trace_id": 6679514604329869463
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-09 05:04:44
success: True
trace_id: 6679514604329869463

Scan 161678400

duration: 0:00:11.678300

exit_message:

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

id: 161678400

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_coupons/2026-04-08/1775642998",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-08/1775642998/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12555735982279644697,
        "service_name": "drive-thru",
        "span_id": 15738732815258738346,
        "trace_id": 10981769794649396805
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-08 05:14:26
success: True
trace_id: 10981769794649396805

Scan 161622048

duration: 0:00:11.759977

exit_message:

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

id: 161622048

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_coupons/2026-04-07/1775556848",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-07/1775556848/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9468751281852167076,
        "service_name": "drive-thru",
        "span_id": 2388648909138933899,
        "trace_id": 7217556421729966221
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-07 05:14:24
success: True
trace_id: 7217556421729966221

Scan 161564219

duration: 0:00:14.209558

exit_message:

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

id: 161564219

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_coupons/2026-04-06/1775470523",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-06/1775470523/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9576916267535037090,
        "service_name": "drive-thru",
        "span_id": 3671951774388247624,
        "trace_id": 16945607004695412209
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-06 05:15:51
success: True
trace_id: 16945607004695412209

Scan 161516664

duration: 0:00:11.542830

exit_message:

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

id: 161516664

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_coupons/2026-04-05/1775382953",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-05/1775382953/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11264878625741199643,
        "service_name": "drive-thru",
        "span_id": 4097617417395243253,
        "trace_id": 4506552120668482494
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-05 04:59:36
success: True
trace_id: 4506552120668482494

Scan 161462122

duration: 0:00:14.198890

exit_message:

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

id: 161462122

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_coupons/2026-04-04/1775296466",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-04/1775296466/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5140427722381284808,
        "service_name": "drive-thru",
        "span_id": 18403327957264949375,
        "trace_id": 298632347000977161
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-04 04:56:13
success: True
trace_id: 298632347000977161

Scan 161404821

duration: 0:00:11.653719

exit_message:

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

id: 161404821

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_coupons/2026-04-03/1775211026",
        "key": "raw/stellar_imsabandoned_cart_coupons/2026-04-03/1775211026/abandoned_cart_coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12468124883235287254,
        "service_name": "drive-thru",
        "span_id": 7392171689685389802,
        "trace_id": 3549958720744839532
    }
}

running: False
schema_name_id: 4291
start_time: 2026-04-03 05:12:15
success: True
trace_id: 3549958720744839532

Partitions:

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

Schema:

attributes:

{
    "abandoned_cart_id": "string",
    "coupon_code": "string",
    "coupon_id": "string",
    "created_at": "string",
    "id": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:54:06

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`\n(\n `tenant`  string , `id`  string , `coupon_id`  string , `coupon_code`  string , `abandoned_cart_id`  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_coupons/2026-04-17/1776419639'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsabandoned_cart_coupons"
}

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