Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imscoupons

created: 2023-02-07 01:48:23
disabled: False
format: raw
id: 1496
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718014

created: 2026-04-17 04:58:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 162169365
updated: 2026-04-17 04:58:50

Version 1716729

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 162114399
updated: 2026-04-16 05:17:34

Version 1715464

created: 2026-04-15 03:40:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-15/1776242359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-15/1776242359
id: 1715464
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 162056347
updated: 2026-04-15 03:40:31

Version 1714402

created: 2026-04-14 05:04:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 162003136
updated: 2026-04-14 05:05:02

Version 1713099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-13/1776074800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-13/1776074800
id: 1713099
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161945305
updated: 2026-04-13 05:08:29

Version 1711899

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-12/1775988157
id: 1711899
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161896343
updated: 2026-04-12 05:04:22

Version 1710750

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161843969
updated: 2026-04-11 05:19:35

Version 1709554

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161788595
updated: 2026-04-10 05:02:44

Version 1708391

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161732948
updated: 2026-04-09 05:02:14

Version 1707215

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-08/1775643001'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-08/1775643001
id: 1707215
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161678374
updated: 2026-04-08 05:13:26

Version 1706075

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-07/1775556857
id: 1706075
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161622166
updated: 2026-04-07 05:18:48

Version 1704771

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-06/1775470529'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-06/1775470529
id: 1704771
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161564240
updated: 2026-04-06 05:16:54

Version 1703629

created: 2026-04-05 04:59:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-05/1775382946
id: 1703629
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161516650
updated: 2026-04-05 04:59:42

Version 1702427

created: 2026-04-04 04:56:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscoupons/2026-04-04/1775296469
id: 1702427
processed: 1

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161462128
updated: 2026-04-04 04:56:40

Version 1701251

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
]

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

raw_data:

{
    "abandoned_cart": 29,
    "code": 3,
    "count_allowed": 7,
    "count_allowed_daily": 8,
    "count_used": 9,
    "coupon_amount": 6,
    "coupon_end": 13,
    "coupon_name": 4,
    "coupon_start": 12,
    "coupon_type": 5,
    "created_at": 30,
    "disable_consecutive_per_customer": 24,
    "holidays_only_if_valid_day": 27,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 23,
    "max_departure_time": 15,
    "max_hours": 19,
    "max_hours_before_departure": 21,
    "max_return_time": 17,
    "max_same_day_per_customer": 22,
    "min_departure_time": 14,
    "min_hours": 18,
    "min_hours_before_departure": 20,
    "min_return_time": 16,
    "rental_end": 11,
    "rental_start": 10,
    "status": 25,
    "tenant": 0,
    "updated_at": 31,
    "valid_days": 26,
    "valid_styles": 28
}

schema_attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

schema_name_id: 1496
schema_scan_id: 161404849
updated: 2026-04-03 05:13:30

Schema Scans: 15

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

Scan 162169365

duration: 0:00:12.508392

exit_message:

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

id: 162169365

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_imscoupons/2026-04-17/1776419647",
        "key": "raw/stellar_imscoupons/2026-04-17/1776419647/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1113062451018509619,
        "service_name": "drive-thru",
        "span_id": 1257672942350225229,
        "trace_id": 7398895417595343494
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-17 04:58:37
success: True
trace_id: 7398895417595343494

Scan 162114399

duration: 0:00:12.422276

exit_message:

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

id: 162114399

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_imscoupons/2026-04-16/1776334546",
        "key": "raw/stellar_imscoupons/2026-04-16/1776334546/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13895773485595791604,
        "service_name": "drive-thru",
        "span_id": 10327061191255128297,
        "trace_id": 5391977074403847939
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-16 05:17:22
success: True
trace_id: 5391977074403847939

Scan 162056347

duration: 0:00:12.534906

exit_message:

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

id: 162056347

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_imscoupons/2026-04-15/1776242359",
        "key": "raw/stellar_imscoupons/2026-04-15/1776242359/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2174177221105751411,
        "service_name": "drive-thru",
        "span_id": 6903982729761613557,
        "trace_id": 10857024616841511240
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-15 03:40:18
success: True
trace_id: 10857024616841511240

Scan 162003136

duration: 0:00:12.480088

exit_message:

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

id: 162003136

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_imscoupons/2026-04-14/1776160756",
        "key": "raw/stellar_imscoupons/2026-04-14/1776160756/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10472955822114610041,
        "service_name": "drive-thru",
        "span_id": 10510364172968872814,
        "trace_id": 14950477644072791991
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-14 05:04:50
success: True
trace_id: 14950477644072791991

Scan 161945305

duration: 0:00:14.907348

exit_message:

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

id: 161945305

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_imscoupons/2026-04-13/1776074800",
        "key": "raw/stellar_imscoupons/2026-04-13/1776074800/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11479919175973397953,
        "service_name": "drive-thru",
        "span_id": 11877514723732956408,
        "trace_id": 9135115578975499372
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-13 05:08:14
success: True
trace_id: 9135115578975499372

Scan 161896343

duration: 0:00:12.516161

exit_message:

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

id: 161896343

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_imscoupons/2026-04-12/1775988157",
        "key": "raw/stellar_imscoupons/2026-04-12/1775988157/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12623260631848406592,
        "service_name": "drive-thru",
        "span_id": 8450907154445372348,
        "trace_id": 6640248515107196543
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-12 05:04:09
success: True
trace_id: 6640248515107196543

Scan 161843969

duration: 0:00:15.243781

exit_message:

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

id: 161843969

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_imscoupons/2026-04-11/1775902576",
        "key": "raw/stellar_imscoupons/2026-04-11/1775902576/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8700264929004618184,
        "service_name": "drive-thru",
        "span_id": 9716229226270962602,
        "trace_id": 13566762135683202561
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-11 05:19:20
success: True
trace_id: 13566762135683202561

Scan 161788595

duration: 0:00:15.047028

exit_message:

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

id: 161788595

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_imscoupons/2026-04-10/1775815219",
        "key": "raw/stellar_imscoupons/2026-04-10/1775815219/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3613053913000891548,
        "service_name": "drive-thru",
        "span_id": 1549787767290972732,
        "trace_id": 2658340832204213220
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-10 05:02:29
success: True
trace_id: 2658340832204213220

Scan 161732948

duration: 0:00:12.493533

exit_message:

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

id: 161732948

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_imscoupons/2026-04-09/1775728837",
        "key": "raw/stellar_imscoupons/2026-04-09/1775728837/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8094778340925636220,
        "service_name": "drive-thru",
        "span_id": 7789490547716967641,
        "trace_id": 14815149979195768747
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-09 05:02:02
success: True
trace_id: 14815149979195768747

Scan 161678374

duration: 0:00:12.548691

exit_message:

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

id: 161678374

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_imscoupons/2026-04-08/1775643001",
        "key": "raw/stellar_imscoupons/2026-04-08/1775643001/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6201367189470014164,
        "service_name": "drive-thru",
        "span_id": 13590802065190391714,
        "trace_id": 7429839365621771516
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-08 05:13:13
success: True
trace_id: 7429839365621771516

Scan 161622166

duration: 0:00:12.484165

exit_message:

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

id: 161622166

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_imscoupons/2026-04-07/1775556857",
        "key": "raw/stellar_imscoupons/2026-04-07/1775556857/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18231908493318001696,
        "service_name": "drive-thru",
        "span_id": 16032764419651374851,
        "trace_id": 12710885092552122226
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-07 05:18:35
success: True
trace_id: 12710885092552122226

Scan 161564240

duration: 0:00:12.404571

exit_message:

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

id: 161564240

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_imscoupons/2026-04-06/1775470529",
        "key": "raw/stellar_imscoupons/2026-04-06/1775470529/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1708707588089116426,
        "service_name": "drive-thru",
        "span_id": 12693823680407766434,
        "trace_id": 6398241610953803917
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-06 05:16:41
success: True
trace_id: 6398241610953803917

Scan 161516650

duration: 0:00:14.978644

exit_message:

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

id: 161516650

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_imscoupons/2026-04-05/1775382946",
        "key": "raw/stellar_imscoupons/2026-04-05/1775382946/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10697138094791296414,
        "service_name": "drive-thru",
        "span_id": 13944438926807172907,
        "trace_id": 13802997394271282995
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-05 04:59:27
success: True
trace_id: 13802997394271282995

Scan 161462128

duration: 0:00:12.572919

exit_message:

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

id: 161462128

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_imscoupons/2026-04-04/1775296469",
        "key": "raw/stellar_imscoupons/2026-04-04/1775296469/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 394127219736465868,
        "service_name": "drive-thru",
        "span_id": 1866872200672380897,
        "trace_id": 9314645138966398434
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-04 04:56:27
success: True
trace_id: 9314645138966398434

Scan 161404849

duration: 0:00:15.211102

exit_message:

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

id: 161404849

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_imscoupons/2026-04-03/1775211035",
        "key": "raw/stellar_imscoupons/2026-04-03/1775211035/coupons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscoupons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11628781464493344822,
        "service_name": "drive-thru",
        "span_id": 12488940146642701012,
        "trace_id": 3880137340955093289
    }
}

running: False
schema_name_id: 1496
start_time: 2026-04-03 05:13:15
success: True
trace_id: 3880137340955093289

Partitions:

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

Schema:

attributes:

{
    "abandoned_cart": "string",
    "code": "string",
    "count_allowed": "string",
    "count_allowed_daily": "string",
    "count_used": "string",
    "coupon_amount": "string",
    "coupon_end": "string",
    "coupon_name": "string",
    "coupon_start": "string",
    "coupon_type": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_return_time": "string",
    "rental_end": "string",
    "rental_start": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_styles": "string"
}

created: 2026-04-17 04:58:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-02-07 01:48:23",
        "disabled": false,
        "format": "raw",
        "id": 1496,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imscoupons"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "abandoned_cart": "string",
            "code": "string",
            "count_allowed": "string",
            "count_allowed_daily": "string",
            "count_used": "string",
            "coupon_amount": "string",
            "coupon_end": "string",
            "coupon_name": "string",
            "coupon_start": "string",
            "coupon_type": "string",
            "created_at": "string",
            "disable_consecutive_per_customer": "string",
            "holidays_only_if_valid_day": "string",
            "id": "string",
            "location_id": "string",
            "max_active_per_customer": "string",
            "max_departure_time": "string",
            "max_hours": "string",
            "max_hours_before_departure": "string",
            "max_return_time": "string",
            "max_same_day_per_customer": "string",
            "min_departure_time": "string",
            "min_hours": "string",
            "min_hours_before_departure": "string",
            "min_return_time": "string",
            "rental_end": "string",
            "rental_start": "string",
            "status": "string",
            "tenant": "string",
            "updated_at": "string",
            "valid_days": "string",
            "valid_styles": "string"
        },
        "created": "2026-04-17 04:58:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscoupons`\n(\n `tenant`  string , `id`  string , `location_id`  string , `code`  string , `coupon_name`  string , `coupon_type`  string , `coupon_amount`  string , `count_allowed`  string , `count_allowed_daily`  string , `count_used`  string , `rental_start`  string , `rental_end`  string , `coupon_start`  string , `coupon_end`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure`  string , `max_hours_before_departure`  string , `max_same_day_per_customer`  string , `max_active_per_customer`  string , `disable_consecutive_per_customer`  string , `status`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `valid_styles`  string , `abandoned_cart`  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_imscoupons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscoupons`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscoupons"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}