Schema Info

Schema Name: sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history

created: 2025-10-01 09:03:06
disabled: False
format: raw
id: 4278
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717283

created: 2026-04-16 19:08:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494
id: 1717283
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 162152403
updated: 2026-04-16 19:08:48

Version 1716053

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-15/1776298077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-15/1776298077
id: 1716053
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 162096390
updated: 2026-04-15 19:08:16

Version 1714849

created: 2026-04-14 19:08:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-14/1776211689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-14/1776211689
id: 1714849
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 162040870
updated: 2026-04-14 19:08:40

Version 1713648

created: 2026-04-13 19:08:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-13/1776125283'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-13/1776125283
id: 1713648
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161985260
updated: 2026-04-13 19:08:23

Version 1712435

created: 2026-04-12 19:08:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-12/1776038898'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-12/1776038898
id: 1712435
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161928040
updated: 2026-04-12 19:08:40

Version 1711241

created: 2026-04-11 19:08:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-11/1775952513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-11/1775952513
id: 1711241
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161879307
updated: 2026-04-11 19:09:04

Version 1710031

created: 2026-04-10 19:10:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-10/1775866078'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-10/1775866078
id: 1710031
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161826419
updated: 2026-04-10 19:10:21

Version 1708897

created: 2026-04-09 19:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-09/1775779704'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-09/1775779704
id: 1708897
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161770539
updated: 2026-04-09 19:08:46

Version 1707755

created: 2026-04-08 19:07:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-08/1775693271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-08/1775693271
id: 1707755
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161715256
updated: 2026-04-08 19:08:12

Version 1706528

created: 2026-04-07 19:07:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-07/1775606865'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-07/1775606865
id: 1706528
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161660060
updated: 2026-04-07 19:08:06

Version 1705349

created: 2026-04-06 19:08:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-06/1775520490'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-06/1775520490
id: 1705349
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161603824
updated: 2026-04-06 19:08:32

Version 1704119

created: 2026-04-05 19:07:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-05/1775434070'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-05/1775434070
id: 1704119
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161546874
updated: 2026-04-05 19:08:11

Version 1702934

created: 2026-04-04 19:08:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-04/1775347704'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-04/1775347704
id: 1702934
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161500651
updated: 2026-04-04 19:08:42

Version 1701759

created: 2026-04-03 19:08:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-03/1775261290'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-03/1775261290
id: 1701759
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161444673
updated: 2026-04-03 19:08:30

Version 1700549

created: 2026-04-02 19:08:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-02/1775174873'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_unit_cancelletion_history/2026-04-02/1775174873
id: 1700549
processed: 1

raw_data:

{
    "amount": 6,
    "auction_id": 3,
    "billing_method": 5,
    "created_at": 10,
    "created_by": 9,
    "id": 0,
    "is_deleted": 12,
    "location_id": 2,
    "seller_id": 1,
    "status": 8,
    "type": 7,
    "unit_id": 4,
    "updated_at": 11
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4278
schema_scan_id: 161386063
updated: 2026-04-02 19:08:19

Schema Scans: 15

Last at 2026-04-16 19:08:36

Scan 162152403

duration: 0:00:11.938566

exit_message:

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

id: 162152403

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/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494/sa_auction_unit_cancelletion_history_1776384002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14249304759079174656,
        "service_name": "drive-thru",
        "span_id": 15522715587092993570,
        "trace_id": 18443440884164660901
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-16 19:08:36
success: True
trace_id: 18443440884164660901

Scan 162096390

duration: 0:00:11.956399

exit_message:

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

id: 162096390

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/auctions_sa_auction_unit_cancelletion_history/2026-04-15/1776298077",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-15/1776298077/sa_auction_unit_cancelletion_history_1776297601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7888578478091511016,
        "service_name": "drive-thru",
        "span_id": 17875241292263521972,
        "trace_id": 4468411888255859763
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-15 19:08:04
success: True
trace_id: 4468411888255859763

Scan 162040870

duration: 0:00:12.001152

exit_message:

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

id: 162040870

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/auctions_sa_auction_unit_cancelletion_history/2026-04-14/1776211689",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-14/1776211689/sa_auction_unit_cancelletion_history_1776211201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2924371615318776156,
        "service_name": "drive-thru",
        "span_id": 18194996389637029946,
        "trace_id": 7582061610207615604
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-14 19:08:28
success: True
trace_id: 7582061610207615604

Scan 161985260

duration: 0:00:11.898592

exit_message:

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

id: 161985260

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/auctions_sa_auction_unit_cancelletion_history/2026-04-13/1776125283",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-13/1776125283/sa_auction_unit_cancelletion_history_1776124802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9848771045152504780,
        "service_name": "drive-thru",
        "span_id": 9030198221739232365,
        "trace_id": 3265317638597847991
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-13 19:08:11
success: True
trace_id: 3265317638597847991

Scan 161928040

duration: 0:00:15.102642

exit_message:

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

id: 161928040

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/auctions_sa_auction_unit_cancelletion_history/2026-04-12/1776038898",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-12/1776038898/sa_auction_unit_cancelletion_history_1776038402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12140659076844943511,
        "service_name": "drive-thru",
        "span_id": 14304362265628667938,
        "trace_id": 5944954060290314654
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-12 19:08:25
success: True
trace_id: 5944954060290314654

Scan 161879307

duration: 0:00:14.620085

exit_message:

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

id: 161879307

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/auctions_sa_auction_unit_cancelletion_history/2026-04-11/1775952513",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-11/1775952513/sa_auction_unit_cancelletion_history_1775952002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3771832977554624168,
        "service_name": "drive-thru",
        "span_id": 2419380894820821861,
        "trace_id": 18184403170662092205
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-11 19:08:50
success: True
trace_id: 18184403170662092205

Scan 161826419

duration: 0:00:14.692369

exit_message:

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

id: 161826419

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/auctions_sa_auction_unit_cancelletion_history/2026-04-10/1775866078",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-10/1775866078/sa_auction_unit_cancelletion_history_1775865602.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16465202445279245223,
        "service_name": "drive-thru",
        "span_id": 16913945073101811321,
        "trace_id": 1159061817590861096
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-10 19:10:07
success: True
trace_id: 1159061817590861096

Scan 161770539

duration: 0:00:14.565542

exit_message:

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

id: 161770539

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/auctions_sa_auction_unit_cancelletion_history/2026-04-09/1775779704",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-09/1775779704/sa_auction_unit_cancelletion_history_1775779202.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8573857006015036613,
        "service_name": "drive-thru",
        "span_id": 17196254591647602201,
        "trace_id": 3105291266596316105
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-09 19:08:31
success: True
trace_id: 3105291266596316105

Scan 161715256

duration: 0:00:14.530768

exit_message:

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

id: 161715256

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/auctions_sa_auction_unit_cancelletion_history/2026-04-08/1775693271",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-08/1775693271/sa_auction_unit_cancelletion_history_1775692802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15171307713411621258,
        "service_name": "drive-thru",
        "span_id": 16257210829622349454,
        "trace_id": 4538204493388917845
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-08 19:07:57
success: True
trace_id: 4538204493388917845

Scan 161660060

duration: 0:00:14.415377

exit_message:

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

id: 161660060

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/auctions_sa_auction_unit_cancelletion_history/2026-04-07/1775606865",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-07/1775606865/sa_auction_unit_cancelletion_history_1775606402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5195249804921115291,
        "service_name": "drive-thru",
        "span_id": 2885674486179292201,
        "trace_id": 2118272669084260923
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-07 19:07:51
success: True
trace_id: 2118272669084260923

Scan 161603824

duration: 0:00:12.033843

exit_message:

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

id: 161603824

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/auctions_sa_auction_unit_cancelletion_history/2026-04-06/1775520490",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-06/1775520490/sa_auction_unit_cancelletion_history_1775520002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10719516441309685538,
        "service_name": "drive-thru",
        "span_id": 6215734490409837989,
        "trace_id": 4340176777029095021
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-06 19:08:20
success: True
trace_id: 4340176777029095021

Scan 161546874

duration: 0:00:14.778295

exit_message:

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

id: 161546874

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/auctions_sa_auction_unit_cancelletion_history/2026-04-05/1775434070",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-05/1775434070/sa_auction_unit_cancelletion_history_1775433601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11429734535405154493,
        "service_name": "drive-thru",
        "span_id": 17637747432509956502,
        "trace_id": 64268131617667207
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-05 19:07:57
success: True
trace_id: 64268131617667207

Scan 161500651

duration: 0:00:11.959806

exit_message:

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

id: 161500651

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/auctions_sa_auction_unit_cancelletion_history/2026-04-04/1775347704",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-04/1775347704/sa_auction_unit_cancelletion_history_1775347201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2998209135000826389,
        "service_name": "drive-thru",
        "span_id": 5035464933803950231,
        "trace_id": 6760915457488584381
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-04 19:08:30
success: True
trace_id: 6760915457488584381

Scan 161444673

duration: 0:00:12.053231

exit_message:

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

id: 161444673

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/auctions_sa_auction_unit_cancelletion_history/2026-04-03/1775261290",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-03/1775261290/sa_auction_unit_cancelletion_history_1775260801.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4955513262300929321,
        "service_name": "drive-thru",
        "span_id": 13887484601712360877,
        "trace_id": 3633781400039825850
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-03 19:08:18
success: True
trace_id: 3633781400039825850

Scan 161386063

duration: 0:00:14.496605

exit_message:

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

id: 161386063

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/auctions_sa_auction_unit_cancelletion_history/2026-04-02/1775174873",
        "key": "raw/auctions_sa_auction_unit_cancelletion_history/2026-04-02/1775174873/sa_auction_unit_cancelletion_history_1775174402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10193954676285135138,
        "service_name": "drive-thru",
        "span_id": 13104742133722794754,
        "trace_id": 6257947268570678523
    }
}

running: False
schema_name_id: 4278
start_time: 2026-04-02 19:08:05
success: True
trace_id: 6257947268570678523

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "auction_id": "string",
    "billing_method": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "seller_id": "string",
    "status": "string",
    "type": "string",
    "unit_id": "string",
    "updated_at": "string"
}

created: 2026-04-16 19:08:36

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
}

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-10-01 09:03:06",
        "disabled": false,
        "format": "raw",
        "id": 4278,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "auctions_sa_auction_unit_cancelletion_history"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "auction_id": "string",
            "billing_method": "string",
            "created_at": "string",
            "created_by": "string",
            "id": "string",
            "is_deleted": "string",
            "location_id": "string",
            "seller_id": "string",
            "status": "string",
            "type": "string",
            "unit_id": "string",
            "updated_at": "string"
        },
        "created": "2026-04-16 19:08:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`\n(\n `id`  string , `seller_id`  string , `location_id`  string , `auction_id`  string , `unit_id`  string , `billing_method`  string , `amount`  string , `type`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_auction_unit_cancelletion_history/2026-04-16/1776384494'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_unit_cancelletion_history"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}