Schema Info

Schema Name: sfdl_prod_drivethru.auctions_sa_auction_bid

created: 2025-09-15 01:04:56
disabled: False
format: raw
id: 4276
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717284

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-16/1776384474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-16/1776384474
id: 1717284
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 162152404
updated: 2026-04-16 19:08:50

Version 1716054

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-15/1776298055'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-15/1776298055
id: 1716054
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 162096392
updated: 2026-04-15 19:08:25

Version 1714850

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-14/1776211667'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-14/1776211667
id: 1714850
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 162040871
updated: 2026-04-14 19:08:51

Version 1713649

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-13/1776125262'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-13/1776125262
id: 1713649
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161985262
updated: 2026-04-13 19:08:31

Version 1712436

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-12/1776038880'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-12/1776038880
id: 1712436
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161928041
updated: 2026-04-12 19:08:52

Version 1711242

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-11/1775952491'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-11/1775952491
id: 1711242
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161879310
updated: 2026-04-11 19:09:06

Version 1710030

created: 2026-04-10 19:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-10/1775866056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-10/1775866056
id: 1710030
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161826416
updated: 2026-04-10 19:10:03

Version 1708898

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-09/1775779682'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-09/1775779682
id: 1708898
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161770540
updated: 2026-04-09 19:09:00

Version 1707756

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-08/1775693248'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-08/1775693248
id: 1707756
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161715257
updated: 2026-04-08 19:08:23

Version 1706529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-07/1775606843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-07/1775606843
id: 1706529
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161660063
updated: 2026-04-07 19:08:22

Version 1705350

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-06/1775520468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-06/1775520468
id: 1705350
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161603827
updated: 2026-04-06 19:08:42

Version 1704121

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-05/1775434048'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-05/1775434048
id: 1704121
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161546875
updated: 2026-04-05 19:08:20

Version 1702935

created: 2026-04-04 19:08:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-04/1775347682'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-04/1775347682
id: 1702935
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161500653
updated: 2026-04-04 19:08:51

Version 1701760

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-03/1775261268'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-03/1775261268
id: 1701760
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161444674
updated: 2026-04-03 19:08:40

Version 1700550

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-02/1775174851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_bid/2026-04-02/1775174851
id: 1700550
processed: 1

raw_data:

{
    "amount": 5,
    "auction_id": 3,
    "buyer_wining_fee": 8,
    "created_at": 12,
    "created_by": 11,
    "id": 0,
    "is_deleted": 15,
    "is_loosing_mail_sent": 14,
    "is_reward": 9,
    "location_id": 2,
    "note": 10,
    "status": 6,
    "type": 7,
    "units_id": 4,
    "updated_at": 13,
    "users_id": 1
}

schema_attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

schema_name_id: 4276
schema_scan_id: 161386064
updated: 2026-04-02 19:08:23

Schema Scans: 15

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

Scan 162152404

duration: 0:00:12.036925

exit_message:

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

id: 162152404

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_bid/2026-04-16/1776384474",
        "key": "raw/auctions_sa_auction_bid/2026-04-16/1776384474/sa_auction_bid_1776384002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2843979014942040522,
        "service_name": "drive-thru",
        "span_id": 5213533819844827763,
        "trace_id": 1806301242362943033
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-16 19:08:38
success: True
trace_id: 1806301242362943033

Scan 162096392

duration: 0:00:12.128021

exit_message:

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

id: 162096392

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_bid/2026-04-15/1776298055",
        "key": "raw/auctions_sa_auction_bid/2026-04-15/1776298055/sa_auction_bid_1776297601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1817531295654252235,
        "service_name": "drive-thru",
        "span_id": 7432110435723390091,
        "trace_id": 18291621367441290207
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-15 19:08:13
success: True
trace_id: 18291621367441290207

Scan 162040871

duration: 0:00:14.718669

exit_message:

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

id: 162040871

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_bid/2026-04-14/1776211667",
        "key": "raw/auctions_sa_auction_bid/2026-04-14/1776211667/sa_auction_bid_1776211201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14587757570141443588,
        "service_name": "drive-thru",
        "span_id": 16084609150303559544,
        "trace_id": 622671829639130618
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-14 19:08:37
success: True
trace_id: 622671829639130618

Scan 161985262

duration: 0:00:12.148941

exit_message:

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

id: 161985262

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_bid/2026-04-13/1776125262",
        "key": "raw/auctions_sa_auction_bid/2026-04-13/1776125262/sa_auction_bid_1776124802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1089016033449992848,
        "service_name": "drive-thru",
        "span_id": 16996775076801858869,
        "trace_id": 5320251303933786779
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-13 19:08:19
success: True
trace_id: 5320251303933786779

Scan 161928041

duration: 0:00:14.547628

exit_message:

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

id: 161928041

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_bid/2026-04-12/1776038880",
        "key": "raw/auctions_sa_auction_bid/2026-04-12/1776038880/sa_auction_bid_1776038402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 417016299583669452,
        "service_name": "drive-thru",
        "span_id": 1677722933589062688,
        "trace_id": 11786782643528349267
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-12 19:08:37
success: True
trace_id: 11786782643528349267

Scan 161879310

duration: 0:00:12.051589

exit_message:

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

id: 161879310

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_bid/2026-04-11/1775952491",
        "key": "raw/auctions_sa_auction_bid/2026-04-11/1775952491/sa_auction_bid_1775952002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11385569850969980393,
        "service_name": "drive-thru",
        "span_id": 2437498082050040047,
        "trace_id": 9697479858067881783
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-11 19:08:54
success: True
trace_id: 9697479858067881783

Scan 161826416

duration: 0:00:12.055934

exit_message:

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

id: 161826416

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_bid/2026-04-10/1775866056",
        "key": "raw/auctions_sa_auction_bid/2026-04-10/1775866056/sa_auction_bid_1775865602.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3715454279972926649,
        "service_name": "drive-thru",
        "span_id": 4189700406144680062,
        "trace_id": 9719708835862390868
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-10 19:09:51
success: True
trace_id: 9719708835862390868

Scan 161770540

duration: 0:00:14.580301

exit_message:

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

id: 161770540

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_bid/2026-04-09/1775779682",
        "key": "raw/auctions_sa_auction_bid/2026-04-09/1775779682/sa_auction_bid_1775779202.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5919930856759534494,
        "service_name": "drive-thru",
        "span_id": 15822146768241628212,
        "trace_id": 11868088293548148597
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-09 19:08:46
success: True
trace_id: 11868088293548148597

Scan 161715257

duration: 0:00:14.615375

exit_message:

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

id: 161715257

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_bid/2026-04-08/1775693248",
        "key": "raw/auctions_sa_auction_bid/2026-04-08/1775693248/sa_auction_bid_1775692802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15528203713863653619,
        "service_name": "drive-thru",
        "span_id": 1520433748125816607,
        "trace_id": 4250436955687541764
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-08 19:08:08
success: True
trace_id: 4250436955687541764

Scan 161660063

duration: 0:00:14.621841

exit_message:

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

id: 161660063

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_bid/2026-04-07/1775606843",
        "key": "raw/auctions_sa_auction_bid/2026-04-07/1775606843/sa_auction_bid_1775606402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 956825592590486012,
        "service_name": "drive-thru",
        "span_id": 3228507599199660158,
        "trace_id": 15878360197737109768
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-07 19:08:07
success: True
trace_id: 15878360197737109768

Scan 161603827

duration: 0:00:14.686743

exit_message:

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

id: 161603827

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_bid/2026-04-06/1775520468",
        "key": "raw/auctions_sa_auction_bid/2026-04-06/1775520468/sa_auction_bid_1775520002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9635362824416115857,
        "service_name": "drive-thru",
        "span_id": 3063595351964917750,
        "trace_id": 7684039589354659480
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-06 19:08:27
success: True
trace_id: 7684039589354659480

Scan 161546875

duration: 0:00:14.530502

exit_message:

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

id: 161546875

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_bid/2026-04-05/1775434048",
        "key": "raw/auctions_sa_auction_bid/2026-04-05/1775434048/sa_auction_bid_1775433601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10138427277642895784,
        "service_name": "drive-thru",
        "span_id": 5743823054912950831,
        "trace_id": 2613853892284418089
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-05 19:08:05
success: True
trace_id: 2613853892284418089

Scan 161500653

duration: 0:00:12.023906

exit_message:

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

id: 161500653

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_bid/2026-04-04/1775347682",
        "key": "raw/auctions_sa_auction_bid/2026-04-04/1775347682/sa_auction_bid_1775347201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1307168045060273897,
        "service_name": "drive-thru",
        "span_id": 11448070161432012040,
        "trace_id": 693816381795065393
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-04 19:08:39
success: True
trace_id: 693816381795065393

Scan 161444674

duration: 0:00:14.557183

exit_message:

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

id: 161444674

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_bid/2026-04-03/1775261268",
        "key": "raw/auctions_sa_auction_bid/2026-04-03/1775261268/sa_auction_bid_1775260801.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16163206608476990520,
        "service_name": "drive-thru",
        "span_id": 7223226806470095737,
        "trace_id": 3790519930565042607
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-03 19:08:25
success: True
trace_id: 3790519930565042607

Scan 161386064

duration: 0:00:14.586632

exit_message:

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

id: 161386064

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_bid/2026-04-02/1775174851",
        "key": "raw/auctions_sa_auction_bid/2026-04-02/1775174851/sa_auction_bid_1775174402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auction_bid",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14992063344544213858,
        "service_name": "drive-thru",
        "span_id": 8534118734817985033,
        "trace_id": 5049775596686496329
    }
}

running: False
schema_name_id: 4276
start_time: 2026-04-02 19:08:08
success: True
trace_id: 5049775596686496329

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "auction_id": "string",
    "buyer_wining_fee": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "is_loosing_mail_sent": "string",
    "is_reward": "string",
    "location_id": "string",
    "note": "string",
    "status": "string",
    "type": "string",
    "units_id": "string",
    "updated_at": "string",
    "users_id": "string"
}

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

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_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-16/1776384474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
}

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-09-15 01:04:56",
        "disabled": false,
        "format": "raw",
        "id": 4276,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "auctions_sa_auction_bid"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "auction_id": "string",
            "buyer_wining_fee": "string",
            "created_at": "string",
            "created_by": "string",
            "id": "string",
            "is_deleted": "string",
            "is_loosing_mail_sent": "string",
            "is_reward": "string",
            "location_id": "string",
            "note": "string",
            "status": "string",
            "type": "string",
            "units_id": "string",
            "updated_at": "string",
            "users_id": "string"
        },
        "created": "2026-04-16 19:08:38",
        "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_bid`\n(\n `id`  string , `users_id`  string , `location_id`  string , `auction_id`  string , `units_id`  string , `amount`  string , `status`  string , `type`  string , `buyer_wining_fee`  string , `is_reward`  string , `note`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_loosing_mail_sent`  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_bid/2026-04-16/1776384474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_bid`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_bid"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}