Schema Info

Schema Name: sfdl_prod_drivethru.auctions_sa_auctions

created: 2025-09-15 01:02:25
disabled: False
format: raw
id: 4274
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717276

created: 2026-04-16 19:04:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-16/1776384170'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-16/1776384170
id: 1717276
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 162152279
updated: 2026-04-16 19:05:08

Version 1716048

created: 2026-04-15 19:04:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-15/1776297778'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-15/1776297778
id: 1716048
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 162096323
updated: 2026-04-15 19:04:28

Version 1714842

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-14/1776211376'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-14/1776211376
id: 1714842
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 162040678
updated: 2026-04-14 19:03:32

Version 1713641

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-13/1776124969'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-13/1776124969
id: 1713641
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161985185
updated: 2026-04-13 19:03:19

Version 1712426

created: 2026-04-12 19:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-12/1776038577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-12/1776038577
id: 1712426
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161927962
updated: 2026-04-12 19:03:27

Version 1711237

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-11/1775952184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-11/1775952184
id: 1711237
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161879247
updated: 2026-04-11 19:05:44

Version 1710027

created: 2026-04-10 19:03:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-10/1775865775'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-10/1775865775
id: 1710027
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161826327
updated: 2026-04-10 19:03:41

Version 1708893

created: 2026-04-09 19:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-09/1775779379'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-09/1775779379
id: 1708893
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161770476
updated: 2026-04-09 19:03:28

Version 1707751

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-08/1775692949'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-08/1775692949
id: 1707751
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161715196
updated: 2026-04-08 19:03:01

Version 1706521

created: 2026-04-07 19:03:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-07/1775606578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-07/1775606578
id: 1706521
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161660002
updated: 2026-04-07 19:03:31

Version 1705346

created: 2026-04-06 19:06:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-06/1775520174'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-06/1775520174
id: 1705346
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161603776
updated: 2026-04-06 19:06:29

Version 1704114

created: 2026-04-05 19:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-05/1775433778'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-05/1775433778
id: 1704114
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161546814
updated: 2026-04-05 19:03:28

Version 1702930

created: 2026-04-04 19:03:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-04/1775347379'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-04/1775347379
id: 1702930
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161500595
updated: 2026-04-04 19:04:03

Version 1701753

created: 2026-04-03 19:03:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-03/1775260968'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-03/1775260968
id: 1701753
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161444583
updated: 2026-04-03 19:03:16

Version 1700544

created: 2026-04-02 19:02:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-02/1775174550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auctions/2026-04-02/1775174550
id: 1700544
processed: 1

raw_data:

{
    "accept_payment_method": 17,
    "auction_end_time": 8,
    "auction_start_time": 7,
    "auction_type": 2,
    "bids_cnt": 22,
    "created_at": 26,
    "created_by": 25,
    "default_date": 9,
    "ending_off_set": 15,
    "event_added": 29,
    "event_launched": 31,
    "event_title": 6,
    "event_updated": 30,
    "first_ad_time": 12,
    "id": 0,
    "instructions": 18,
    "is_deleted": 28,
    "is_summary_sent": 24,
    "lien_letter_time": 10,
    "loc_timezone": 3,
    "location_id": 5,
    "manager_id": 4,
    "notice_content": 38,
    "notice_create": 33,
    "notice_expiry_date": 37,
    "notice_publish_date": 36,
    "notice_state_id": 35,
    "notice_title": 34,
    "pick_up_deadline": 14,
    "sales_tax": 16,
    "second_ad_time": 13,
    "second_lien_letter_time": 11,
    "status": 19,
    "timeline_reasons": 32,
    "units_cnt": 20,
    "updated_at": 27,
    "users_id": 1,
    "views_cnt": 21,
    "watch_cnt": 23
}

schema_attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

schema_name_id: 4274
schema_scan_id: 161385961
updated: 2026-04-02 19:02:56

Schema Scans: 15

Last at 2026-04-16 19:04:52

Scan 162152279

duration: 0:00:15.478687

exit_message:

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

id: 162152279

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_auctions/2026-04-16/1776384170",
        "key": "raw/auctions_sa_auctions/2026-04-16/1776384170/sa_auctions_1776384002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9622284087373459465,
        "service_name": "drive-thru",
        "span_id": 8317071740154635102,
        "trace_id": 15874505569055292637
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-16 19:04:52
success: True
trace_id: 15874505569055292637

Scan 162096323

duration: 0:00:15.253307

exit_message:

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

id: 162096323

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_auctions/2026-04-15/1776297778",
        "key": "raw/auctions_sa_auctions/2026-04-15/1776297778/sa_auctions_1776297601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15616398065791923853,
        "service_name": "drive-thru",
        "span_id": 1526498693539027492,
        "trace_id": 14431973352514458532
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-15 19:04:13
success: True
trace_id: 14431973352514458532

Scan 162040678

duration: 0:00:15.451795

exit_message:

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

id: 162040678

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_auctions/2026-04-14/1776211376",
        "key": "raw/auctions_sa_auctions/2026-04-14/1776211376/sa_auctions_1776211201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10126408711992868884,
        "service_name": "drive-thru",
        "span_id": 8430963831656594754,
        "trace_id": 4512537873653970995
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-14 19:03:17
success: True
trace_id: 4512537873653970995

Scan 161985185

duration: 0:00:12.690004

exit_message:

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

id: 161985185

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_auctions/2026-04-13/1776124969",
        "key": "raw/auctions_sa_auctions/2026-04-13/1776124969/sa_auctions_1776124802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8223702440760850758,
        "service_name": "drive-thru",
        "span_id": 2355501815590286084,
        "trace_id": 18394038496331074293
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-13 19:03:07
success: True
trace_id: 18394038496331074293

Scan 161927962

duration: 0:00:15.334095

exit_message:

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

id: 161927962

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_auctions/2026-04-12/1776038577",
        "key": "raw/auctions_sa_auctions/2026-04-12/1776038577/sa_auctions_1776038402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 783009408744727453,
        "service_name": "drive-thru",
        "span_id": 14916054515542657682,
        "trace_id": 5803590246351732298
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-12 19:03:12
success: True
trace_id: 5803590246351732298

Scan 161879247

duration: 0:00:15.269517

exit_message:

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

id: 161879247

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_auctions/2026-04-11/1775952184",
        "key": "raw/auctions_sa_auctions/2026-04-11/1775952184/sa_auctions_1775952002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9823403319182079968,
        "service_name": "drive-thru",
        "span_id": 868267967552837054,
        "trace_id": 18122716506888916641
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-11 19:05:29
success: True
trace_id: 18122716506888916641

Scan 161826327

duration: 0:00:15.517353

exit_message:

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

id: 161826327

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_auctions/2026-04-10/1775865775",
        "key": "raw/auctions_sa_auctions/2026-04-10/1775865775/sa_auctions_1775865602.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8231248780039423729,
        "service_name": "drive-thru",
        "span_id": 1462904510332053946,
        "trace_id": 4457044123325421331
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-10 19:03:26
success: True
trace_id: 4457044123325421331

Scan 161770476

duration: 0:00:12.834386

exit_message:

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

id: 161770476

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_auctions/2026-04-09/1775779379",
        "key": "raw/auctions_sa_auctions/2026-04-09/1775779379/sa_auctions_1775779202.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8479189894607003632,
        "service_name": "drive-thru",
        "span_id": 8250540764881518040,
        "trace_id": 4727394250161357985
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-09 19:03:16
success: True
trace_id: 4727394250161357985

Scan 161715196

duration: 0:00:15.305523

exit_message:

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

id: 161715196

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_auctions/2026-04-08/1775692949",
        "key": "raw/auctions_sa_auctions/2026-04-08/1775692949/sa_auctions_1775692802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10556695892613663590,
        "service_name": "drive-thru",
        "span_id": 15438804215031104552,
        "trace_id": 11694140714817355220
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-08 19:02:46
success: True
trace_id: 11694140714817355220

Scan 161660002

duration: 0:00:12.780338

exit_message:

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

id: 161660002

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_auctions/2026-04-07/1775606578",
        "key": "raw/auctions_sa_auctions/2026-04-07/1775606578/sa_auctions_1775606402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7972921420938586081,
        "service_name": "drive-thru",
        "span_id": 18277237443245426402,
        "trace_id": 11757392639559524577
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-07 19:03:19
success: True
trace_id: 11757392639559524577

Scan 161603776

duration: 0:00:15.228915

exit_message:

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

id: 161603776

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_auctions/2026-04-06/1775520174",
        "key": "raw/auctions_sa_auctions/2026-04-06/1775520174/sa_auctions_1775520002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5435503293546889383,
        "service_name": "drive-thru",
        "span_id": 3939225199530306807,
        "trace_id": 15469167383533104905
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-06 19:06:14
success: True
trace_id: 15469167383533104905

Scan 161546814

duration: 0:00:12.591568

exit_message:

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

id: 161546814

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_auctions/2026-04-05/1775433778",
        "key": "raw/auctions_sa_auctions/2026-04-05/1775433778/sa_auctions_1775433601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8662650954325056335,
        "service_name": "drive-thru",
        "span_id": 16127966866744415637,
        "trace_id": 13875501110766799913
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-05 19:03:15
success: True
trace_id: 13875501110766799913

Scan 161500595

duration: 0:00:12.823762

exit_message:

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

id: 161500595

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_auctions/2026-04-04/1775347379",
        "key": "raw/auctions_sa_auctions/2026-04-04/1775347379/sa_auctions_1775347201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10003836853496590712,
        "service_name": "drive-thru",
        "span_id": 17266543704818263688,
        "trace_id": 2870668458448909309
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-04 19:03:50
success: True
trace_id: 2870668458448909309

Scan 161444583

duration: 0:00:12.664383

exit_message:

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

id: 161444583

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_auctions/2026-04-03/1775260968",
        "key": "raw/auctions_sa_auctions/2026-04-03/1775260968/sa_auctions_1775260801.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9434119352582121444,
        "service_name": "drive-thru",
        "span_id": 1719704055174022685,
        "trace_id": 2831122055066357701
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-03 19:03:04
success: True
trace_id: 2831122055066357701

Scan 161385961

duration: 0:00:12.681060

exit_message:

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

id: 161385961

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_auctions/2026-04-02/1775174550",
        "key": "raw/auctions_sa_auctions/2026-04-02/1775174550/sa_auctions_1775174402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_auctions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4045117214276378644,
        "service_name": "drive-thru",
        "span_id": 13399125501476491691,
        "trace_id": 17872220199798213225
    }
}

running: False
schema_name_id: 4274
start_time: 2026-04-02 19:02:43
success: True
trace_id: 17872220199798213225

Partitions:

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

Schema:

attributes:

{
    "accept_payment_method": "string",
    "auction_end_time": "string",
    "auction_start_time": "string",
    "auction_type": "string",
    "bids_cnt": "string",
    "created_at": "string",
    "created_by": "string",
    "default_date": "string",
    "ending_off_set": "string",
    "event_added": "string",
    "event_launched": "string",
    "event_title": "string",
    "event_updated": "string",
    "first_ad_time": "string",
    "id": "string",
    "instructions": "string",
    "is_deleted": "string",
    "is_summary_sent": "string",
    "lien_letter_time": "string",
    "loc_timezone": "string",
    "location_id": "string",
    "manager_id": "string",
    "notice_content": "string",
    "notice_create": "string",
    "notice_expiry_date": "string",
    "notice_publish_date": "string",
    "notice_state_id": "string",
    "notice_title": "string",
    "pick_up_deadline": "string",
    "sales_tax": "string",
    "second_ad_time": "string",
    "second_lien_letter_time": "string",
    "status": "string",
    "timeline_reasons": "string",
    "units_cnt": "string",
    "updated_at": "string",
    "users_id": "string",
    "views_cnt": "string",
    "watch_cnt": "string"
}

created: 2026-04-16 19:04:54

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_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-16/1776384170'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
}

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:02:25",
        "disabled": false,
        "format": "raw",
        "id": 4274,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "auctions_sa_auctions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accept_payment_method": "string",
            "auction_end_time": "string",
            "auction_start_time": "string",
            "auction_type": "string",
            "bids_cnt": "string",
            "created_at": "string",
            "created_by": "string",
            "default_date": "string",
            "ending_off_set": "string",
            "event_added": "string",
            "event_launched": "string",
            "event_title": "string",
            "event_updated": "string",
            "first_ad_time": "string",
            "id": "string",
            "instructions": "string",
            "is_deleted": "string",
            "is_summary_sent": "string",
            "lien_letter_time": "string",
            "loc_timezone": "string",
            "location_id": "string",
            "manager_id": "string",
            "notice_content": "string",
            "notice_create": "string",
            "notice_expiry_date": "string",
            "notice_publish_date": "string",
            "notice_state_id": "string",
            "notice_title": "string",
            "pick_up_deadline": "string",
            "sales_tax": "string",
            "second_ad_time": "string",
            "second_lien_letter_time": "string",
            "status": "string",
            "timeline_reasons": "string",
            "units_cnt": "string",
            "updated_at": "string",
            "users_id": "string",
            "views_cnt": "string",
            "watch_cnt": "string"
        },
        "created": "2026-04-16 19:04:54",
        "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_auctions`\n(\n `id`  string , `users_id`  string , `auction_type`  string , `loc_timezone`  string , `manager_id`  string , `location_id`  string , `event_title`  string , `auction_start_time`  string , `auction_end_time`  string , `default_date`  string , `lien_letter_time`  string , `second_lien_letter_time`  string , `first_ad_time`  string , `second_ad_time`  string , `pick_up_deadline`  string , `ending_off_set`  string , `sales_tax`  string , `accept_payment_method`  string , `instructions`  string , `status`  string , `units_cnt`  string , `views_cnt`  string , `bids_cnt`  string , `watch_cnt`  string , `is_summary_sent`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  string , `event_added`  string , `event_updated`  string , `event_launched`  string , `timeline_reasons`  string , `notice_create`  string , `notice_title`  string , `notice_state_id`  string , `notice_publish_date`  string , `notice_expiry_date`  string , `notice_content`  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_auctions/2026-04-16/1776384170'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auctions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auctions"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}