Schema Info
Schema Name: sfdl_prod_drivethru.auctions_sa_auction_units
- created: 2025-09-15 01:03:54
- disabled: False
- format: raw
- id: 4275
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "auctions_sa_auction_units" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717280
- created: 2026-04-16 19:06:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-16/1776384328'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-16/1776384328
- id: 1717280
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 162152383
- updated: 2026-04-16 19:07:28
-
Version 1716050
- created: 2026-04-15 19:06:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-15/1776297937'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-15/1776297937
- id: 1716050
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 162096358
- updated: 2026-04-15 19:06:32
-
Version 1714844
- created: 2026-04-14 19:06:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-14/1776211522'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-14/1776211522
- id: 1714844
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 162040846
- updated: 2026-04-14 19:06:18
-
Version 1713645
- created: 2026-04-13 19:06:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-13/1776125119'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-13/1776125119
- id: 1713645
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161985233
- updated: 2026-04-13 19:06:21
-
Version 1712431
- created: 2026-04-12 19:06:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-12/1776038737'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-12/1776038737
- id: 1712431
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161928015
- updated: 2026-04-12 19:06:57
-
Version 1711238
- created: 2026-04-11 19:06:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-11/1775952344'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-11/1775952344
- id: 1711238
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161879292
- updated: 2026-04-11 19:06:37
-
Version 1710028
- created: 2026-04-10 19:06:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-10/1775865911'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-10/1775865911
- id: 1710028
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161826395
- updated: 2026-04-10 19:06:33
-
Version 1708894
- created: 2026-04-09 19:06:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-09/1775779537'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-09/1775779537
- id: 1708894
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161770508
- updated: 2026-04-09 19:06:38
-
Version 1707752
- created: 2026-04-08 19:05:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-08/1775693106'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-08/1775693106
- id: 1707752
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161715229
- updated: 2026-04-08 19:06:03
-
Version 1706524
- created: 2026-04-07 19:06:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-07/1775606724'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-07/1775606724
- id: 1706524
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161660028
- updated: 2026-04-07 19:06:20
-
Version 1705345
- created: 2026-04-06 19:06:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-06/1775520324'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-06/1775520324
- id: 1705345
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161603775
- updated: 2026-04-06 19:06:27
-
Version 1704115
- created: 2026-04-05 19:05:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-05/1775433902'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-05/1775433902
- id: 1704115
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161546857
- updated: 2026-04-05 19:05:54
-
Version 1702931
- created: 2026-04-04 19:06:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-04/1775347537'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-04/1775347537
- id: 1702931
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161500630
- updated: 2026-04-04 19:06:31
-
Version 1701755
- created: 2026-04-03 19:06:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-03/1775261124'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-03/1775261124
- id: 1701755
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161444644
- updated: 2026-04-03 19:06:25
-
Version 1700546
- created: 2026-04-02 19:05:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_auction_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-02/1775174707'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_auction_units/2026-04-02/1775174707
- id: 1700546
- processed: 1
- raw_data:
{ "address": 16, "assign_to": 46, "auction_end_time": 12, "auction_id": 1, "auction_listing_fee": 21, "auction_runup_end_time": 13, "auction_start_time": 11, "balance_due": 27, "bids_cnt": 32, "cancellation_amount": 28, "cancellation_date": 29, "city": 17, "created_at": 34, "created_by": 33, "current_bid_amount": 7, "current_bidder_id": 8, "emails_sent": 49, "first_name": 14, "id": 0, "is_deleted": 36, "is_noshow": 38, "is_resolved": 42, "is_unsold_resolved": 45, "last_name": 15, "late_fees": 26, "ledger_id": 52, "lien_unit_type": 5, "no_show_cnt": 25, "no_show_green_cnt": 39, "no_show_red_cnt": 40, "offer_expires": 48, "past_due_rents": 20, "payment_status": 24, "rent_collected": 22, "request_time": 41, "reserve_amount": 9, "resolved_by": 43, "resolved_on": 44, "short_link": 37, "starting_bid_amount": 6, "state_id": 18, "status": 23, "unit_description": 10, "unit_no": 2, "unit_price": 47, "unit_size": 3, "unit_type": 4, "updated_at": 35, "views_cnt": 30, "watch_cnt": 31, "webhook_status": 50, "wss_status": 51, "zipcode": 19 } - schema_attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - schema_name_id: 4275
- schema_scan_id: 161386036
- updated: 2026-04-02 19:06:13
Schema Scans: 15
Last at 2026-04-16 19:06:07
-
Scan 162152383
- duration: 0:01:21.628309
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162152383
- 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_units/2026-04-16/1776384328", "key": "raw/auctions_sa_auction_units/2026-04-16/1776384328/sa_auction_units_1776384002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11617112788543748875, "service_name": "drive-thru", "span_id": 13436018477438829210, "trace_id": 4488637768211493462 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-16 19:06:07
- success: True
- trace_id: 4488637768211493462
-
Scan 162096358
- duration: 0:00:15.669095
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162096358
- 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_units/2026-04-15/1776297937", "key": "raw/auctions_sa_auction_units/2026-04-15/1776297937/sa_auction_units_1776297601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14547417328917729583, "service_name": "drive-thru", "span_id": 8777299976982120332, "trace_id": 13208139073683882586 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-15 19:06:16
- success: True
- trace_id: 13208139073683882586
-
Scan 162040846
- duration: 0:00:13.212410
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162040846
- 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_units/2026-04-14/1776211522", "key": "raw/auctions_sa_auction_units/2026-04-14/1776211522/sa_auction_units_1776211201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14488410961595863583, "service_name": "drive-thru", "span_id": 4882559033254494528, "trace_id": 17143684436729454961 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-14 19:06:05
- success: True
- trace_id: 17143684436729454961
-
Scan 161985233
- duration: 0:00:15.643509
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161985233
- 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_units/2026-04-13/1776125119", "key": "raw/auctions_sa_auction_units/2026-04-13/1776125119/sa_auction_units_1776124802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18269462536115554472, "service_name": "drive-thru", "span_id": 12951664853179659852, "trace_id": 13810494145330256286 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-13 19:06:06
- success: True
- trace_id: 13810494145330256286
-
Scan 161928015
- duration: 0:00:15.688479
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161928015
- 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_units/2026-04-12/1776038737", "key": "raw/auctions_sa_auction_units/2026-04-12/1776038737/sa_auction_units_1776038402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6371394307374495344, "service_name": "drive-thru", "span_id": 8242628714744509083, "trace_id": 16858159233708529465 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-12 19:06:41
- success: True
- trace_id: 16858159233708529465
-
Scan 161879292
- duration: 0:00:15.617081
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161879292
- 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_units/2026-04-11/1775952344", "key": "raw/auctions_sa_auction_units/2026-04-11/1775952344/sa_auction_units_1775952002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5975666724938874225, "service_name": "drive-thru", "span_id": 10491119359805110551, "trace_id": 16139895653930077106 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-11 19:06:22
- success: True
- trace_id: 16139895653930077106
-
Scan 161826395
- duration: 0:00:15.826501
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161826395
- 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_units/2026-04-10/1775865911", "key": "raw/auctions_sa_auction_units/2026-04-10/1775865911/sa_auction_units_1775865602.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16889369651747419632, "service_name": "drive-thru", "span_id": 14072546606111942545, "trace_id": 13090773151262319080 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-10 19:06:17
- success: True
- trace_id: 13090773151262319080
-
Scan 161770508
- duration: 0:00:13.005160
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161770508
- 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_units/2026-04-09/1775779537", "key": "raw/auctions_sa_auction_units/2026-04-09/1775779537/sa_auction_units_1775779202.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5355316593667748013, "service_name": "drive-thru", "span_id": 16723490587211573645, "trace_id": 5480705921354169483 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-09 19:06:25
- success: True
- trace_id: 5480705921354169483
-
Scan 161715229
- duration: 0:00:15.759722
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161715229
- 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_units/2026-04-08/1775693106", "key": "raw/auctions_sa_auction_units/2026-04-08/1775693106/sa_auction_units_1775692802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17268001421569558778, "service_name": "drive-thru", "span_id": 12554257161959270023, "trace_id": 18134736427577439695 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-08 19:05:47
- success: True
- trace_id: 18134736427577439695
-
Scan 161660028
- duration: 0:00:13.258785
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161660028
- 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_units/2026-04-07/1775606724", "key": "raw/auctions_sa_auction_units/2026-04-07/1775606724/sa_auction_units_1775606402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9324787017375061369, "service_name": "drive-thru", "span_id": 16554106968192665518, "trace_id": 2031378439480606864 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-07 19:06:06
- success: True
- trace_id: 2031378439480606864
-
Scan 161603775
- duration: 0:00:13.304312
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161603775
- 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_units/2026-04-06/1775520324", "key": "raw/auctions_sa_auction_units/2026-04-06/1775520324/sa_auction_units_1775520002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3314596805758714353, "service_name": "drive-thru", "span_id": 3488991964517658617, "trace_id": 8811978657712940933 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-06 19:06:13
- success: True
- trace_id: 8811978657712940933
-
Scan 161546857
- duration: 0:00:13.032936
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161546857
- 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_units/2026-04-05/1775433902", "key": "raw/auctions_sa_auction_units/2026-04-05/1775433902/sa_auction_units_1775433601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1603532036949759079, "service_name": "drive-thru", "span_id": 12149284475366414635, "trace_id": 14835139398830822347 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-05 19:05:41
- success: True
- trace_id: 14835139398830822347
-
Scan 161500630
- duration: 0:00:15.594545
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161500630
- 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_units/2026-04-04/1775347537", "key": "raw/auctions_sa_auction_units/2026-04-04/1775347537/sa_auction_units_1775347201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17103814023174262661, "service_name": "drive-thru", "span_id": 11909291164945650113, "trace_id": 13134514107045690087 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-04 19:06:16
- success: True
- trace_id: 13134514107045690087
-
Scan 161444644
- duration: 0:00:15.449127
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161444644
- 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_units/2026-04-03/1775261124", "key": "raw/auctions_sa_auction_units/2026-04-03/1775261124/sa_auction_units_1775260801.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7392426005512597451, "service_name": "drive-thru", "span_id": 14028741893737316157, "trace_id": 4594373658093734100 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-03 19:06:09
- success: True
- trace_id: 4594373658093734100
-
Scan 161386036
- duration: 0:00:15.678868
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161386036
- 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_units/2026-04-02/1775174707", "key": "raw/auctions_sa_auction_units/2026-04-02/1775174707/sa_auction_units_1775174402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_auction_units", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3518369332652816042, "service_name": "drive-thru", "span_id": 6062124281246576727, "trace_id": 13308268500955800010 } } - running: False
- schema_name_id: 4275
- start_time: 2026-04-02 19:05:57
- success: True
- trace_id: 13308268500955800010
- attributes:
{ "address": "string", "assign_to": "string", "auction_end_time": "string", "auction_id": "string", "auction_listing_fee": "string", "auction_runup_end_time": "string", "auction_start_time": "string", "balance_due": "string", "bids_cnt": "string", "cancellation_amount": "string", "cancellation_date": "string", "city": "string", "created_at": "string", "created_by": "string", "current_bid_amount": "string", "current_bidder_id": "string", "emails_sent": "string", "first_name": "string", "id": "string", "is_deleted": "string", "is_noshow": "string", "is_resolved": "string", "is_unsold_resolved": "string", "last_name": "string", "late_fees": "string", "ledger_id": "string", "lien_unit_type": "string", "no_show_cnt": "string", "no_show_green_cnt": "string", "no_show_red_cnt": "string", "offer_expires": "string", "past_due_rents": "string", "payment_status": "string", "rent_collected": "string", "request_time": "string", "reserve_amount": "string", "resolved_by": "string", "resolved_on": "string", "short_link": "string", "starting_bid_amount": "string", "state_id": "string", "status": "string", "unit_description": "string", "unit_no": "string", "unit_price": "string", "unit_size": "string", "unit_type": "string", "updated_at": "string", "views_cnt": "string", "watch_cnt": "string", "webhook_status": "string", "wss_status": "string", "zipcode": "string" } - created: 2026-04-16 19:06:08
- 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_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-16/1776384328'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2025-09-15 01:03:54",
"disabled": false,
"format": "raw",
"id": 4275,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "auctions_sa_auction_units"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"address": "string",
"assign_to": "string",
"auction_end_time": "string",
"auction_id": "string",
"auction_listing_fee": "string",
"auction_runup_end_time": "string",
"auction_start_time": "string",
"balance_due": "string",
"bids_cnt": "string",
"cancellation_amount": "string",
"cancellation_date": "string",
"city": "string",
"created_at": "string",
"created_by": "string",
"current_bid_amount": "string",
"current_bidder_id": "string",
"emails_sent": "string",
"first_name": "string",
"id": "string",
"is_deleted": "string",
"is_noshow": "string",
"is_resolved": "string",
"is_unsold_resolved": "string",
"last_name": "string",
"late_fees": "string",
"ledger_id": "string",
"lien_unit_type": "string",
"no_show_cnt": "string",
"no_show_green_cnt": "string",
"no_show_red_cnt": "string",
"offer_expires": "string",
"past_due_rents": "string",
"payment_status": "string",
"rent_collected": "string",
"request_time": "string",
"reserve_amount": "string",
"resolved_by": "string",
"resolved_on": "string",
"short_link": "string",
"starting_bid_amount": "string",
"state_id": "string",
"status": "string",
"unit_description": "string",
"unit_no": "string",
"unit_price": "string",
"unit_size": "string",
"unit_type": "string",
"updated_at": "string",
"views_cnt": "string",
"watch_cnt": "string",
"webhook_status": "string",
"wss_status": "string",
"zipcode": "string"
},
"created": "2026-04-16 19:06:08",
"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_units`\n(\n `id` string , `auction_id` string , `unit_no` string , `unit_size` string , `unit_type` string , `lien_unit_type` string , `starting_bid_amount` string , `current_bid_amount` string , `current_bidder_id` string , `reserve_amount` string , `unit_description` string , `auction_start_time` string , `auction_end_time` string , `auction_runup_end_time` string , `first_name` string , `last_name` string , `address` string , `city` string , `state_id` string , `zipcode` string , `past_due_rents` string , `auction_listing_fee` string , `rent_collected` string , `status` string , `payment_status` string , `no_show_cnt` string , `late_fees` string , `balance_due` string , `cancellation_amount` string , `cancellation_date` string , `views_cnt` string , `watch_cnt` string , `bids_cnt` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `short_link` string , `is_noshow` string , `no_show_green_cnt` string , `no_show_red_cnt` string , `request_time` string , `is_resolved` string , `resolved_by` string , `resolved_on` string , `is_unsold_resolved` string , `assign_to` string , `unit_price` string , `offer_expires` string , `emails_sent` string , `webhook_status` string , `wss_status` string , `ledger_id` 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_units/2026-04-16/1776384328'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_auction_units`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_auction_units"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}