Schema Info
Schema Name: sfdl_prod_drivethru.auctions_sa_locations
- created: 2025-09-15 01:02:04
- disabled: False
- format: raw
- id: 4273
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "auctions_sa_locations" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717275
- created: 2026-04-16 19:04:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-16/1776384174'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-16/1776384174
- id: 1717275
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 162152209
- updated: 2026-04-16 19:04:33
-
Version 1716047
- created: 2026-04-15 19:03:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-15/1776297781'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-15/1776297781
- id: 1716047
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 162096244
- updated: 2026-04-15 19:03:50
-
Version 1714843
- created: 2026-04-14 19:04:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-14/1776211378'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-14/1776211378
- id: 1714843
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 162040824
- updated: 2026-04-14 19:04:33
-
Version 1713642
- created: 2026-04-13 19:03:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-13/1776124972'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-13/1776124972
- id: 1713642
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161985189
- updated: 2026-04-13 19:03:35
-
Version 1712427
- created: 2026-04-12 19:03:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-12/1776038581'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-12/1776038581
- id: 1712427
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161927970
- updated: 2026-04-12 19:03:31
-
Version 1711235
- created: 2026-04-11 19:04:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-11/1775952187'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-11/1775952187
- id: 1711235
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161879115
- updated: 2026-04-11 19:04:23
-
Version 1710026
- created: 2026-04-10 19:03:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-10/1775865778'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-10/1775865778
- id: 1710026
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161826303
- updated: 2026-04-10 19:03:18
-
Version 1708891
- created: 2026-04-09 19:03:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-09/1775779382'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-09/1775779382
- id: 1708891
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161770472
- updated: 2026-04-09 19:03:20
-
Version 1707750
- created: 2026-04-08 19:02:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-08/1775692954'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-08/1775692954
- id: 1707750
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161715194
- updated: 2026-04-08 19:02:58
-
Version 1706522
- created: 2026-04-07 19:03:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-07/1775606582'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-07/1775606582
- id: 1706522
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161660003
- updated: 2026-04-07 19:03:34
-
Version 1705343
- created: 2026-04-06 19:04:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-06/1775520178'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-06/1775520178
- id: 1705343
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161603599
- updated: 2026-04-06 19:04:18
-
Version 1704113
- created: 2026-04-05 19:03:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-05/1775433781'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-05/1775433781
- id: 1704113
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161546813
- updated: 2026-04-05 19:03:26
-
Version 1702929
- created: 2026-04-04 19:03:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-04/1775347382'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-04/1775347382
- id: 1702929
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161500569
- updated: 2026-04-04 19:03:55
-
Version 1701752
- created: 2026-04-03 19:02:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-03/1775260971'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-03/1775260971
- id: 1701752
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161444582
- updated: 2026-04-03 19:03:13
-
Version 1700545
- created: 2026-04-02 19:03:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-02/1775174554'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_locations/2026-04-02/1775174554
- id: 1700545
- processed: 1
- raw_data:
{ "accept_payment_method": 41, "address1": 8, "address2": 9, "ailean_location_code": 37, "billing_email": 25, "billing_method": 26, "billing_mode": 24, "cancellation_amount": 43, "cancellation_minus_seven": 23, "cancellation_plus_seven": 22, "cancellation_subscription": 42, "city": 10, "cloud_image_id": 17, "created_at": 47, "created_by": 46, "currency_code": 50, "deposit": 20, "doorswap_code": 34, "facebook_url": 30, "gives_percentage": 21, "id": 0, "invoice_frequency": 44, "invoice_recipient": 45, "is_deleted": 49, "is_show_directory": 18, "lang": 14, "lat": 13, "loc_timezone": 3, "location_code": 32, "location_name": 2, "logo_path": 16, "monthly_fee": 27, "notes": 40, "phone_no": 15, "pick_up_deadline": 5, "sales_tax": 4, "selling_terms": 19, "sentinel_code": 39, "state_id": 11, "status": 28, "storagecommanderlocation_code": 33, "store_hours": 7, "store_identifier": 6, "storedge_code": 35, "syrasoft_code": 36, "twitter_url": 31, "updated_at": 48, "users_id": 1, "website_url": 29, "wss_guid": 38, "zipcode": 12 } - schema_attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - schema_name_id: 4273
- schema_scan_id: 161385971
- updated: 2026-04-02 19:03:15
Schema Scans: 15
Last at 2026-04-16 19:04:20
-
Scan 162152209
- duration: 0:00:13.325458
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162152209
- 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_locations/2026-04-16/1776384174", "key": "raw/auctions_sa_locations/2026-04-16/1776384174/sa_locations_1776384002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15489213441359484328, "service_name": "drive-thru", "span_id": 6345192659641343301, "trace_id": 5851553977034188784 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-16 19:04:20
- success: True
- trace_id: 5851553977034188784
-
Scan 162096244
- duration: 0:00:13.074305
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162096244
- 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_locations/2026-04-15/1776297781", "key": "raw/auctions_sa_locations/2026-04-15/1776297781/sa_locations_1776297601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7576370957988702753, "service_name": "drive-thru", "span_id": 491817872208225218, "trace_id": 3761756441345977974 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-15 19:03:37
- success: True
- trace_id: 3761756441345977974
-
Scan 162040824
- duration: 0:00:15.489129
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162040824
- 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_locations/2026-04-14/1776211378", "key": "raw/auctions_sa_locations/2026-04-14/1776211378/sa_locations_1776211201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15421163863509083713, "service_name": "drive-thru", "span_id": 12793102002388881529, "trace_id": 15450077311128031984 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-14 19:04:18
- success: True
- trace_id: 15450077311128031984
-
Scan 161985189
- duration: 0:00:15.764074
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161985189
- 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_locations/2026-04-13/1776124972", "key": "raw/auctions_sa_locations/2026-04-13/1776124972/sa_locations_1776124802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16579870363193928075, "service_name": "drive-thru", "span_id": 10345811500775096521, "trace_id": 16248266573152055802 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-13 19:03:19
- success: True
- trace_id: 16248266573152055802
-
Scan 161927970
- duration: 0:00:15.679615
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161927970
- 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_locations/2026-04-12/1776038581", "key": "raw/auctions_sa_locations/2026-04-12/1776038581/sa_locations_1776038402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3641005608507843255, "service_name": "drive-thru", "span_id": 9901228307204888831, "trace_id": 17987126712793066765 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-12 19:03:16
- success: True
- trace_id: 17987126712793066765
-
Scan 161879115
- duration: 0:00:13.074551
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161879115
- 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_locations/2026-04-11/1775952187", "key": "raw/auctions_sa_locations/2026-04-11/1775952187/sa_locations_1775952002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11661822579491331626, "service_name": "drive-thru", "span_id": 12231980950204733077, "trace_id": 16720336020283133488 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-11 19:04:10
- success: True
- trace_id: 16720336020283133488
-
Scan 161826303
- duration: 0:00:13.027236
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161826303
- 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_locations/2026-04-10/1775865778", "key": "raw/auctions_sa_locations/2026-04-10/1775865778/sa_locations_1775865602.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2669183649056302163, "service_name": "drive-thru", "span_id": 10720786153360280504, "trace_id": 9601277367239065953 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-10 19:03:05
- success: True
- trace_id: 9601277367239065953
-
Scan 161770472
- duration: 0:00:12.972184
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161770472
- 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_locations/2026-04-09/1775779382", "key": "raw/auctions_sa_locations/2026-04-09/1775779382/sa_locations_1775779202.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16263473330519639040, "service_name": "drive-thru", "span_id": 9803547338963563390, "trace_id": 11732536707206684681 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-09 19:03:07
- success: True
- trace_id: 11732536707206684681
-
Scan 161715194
- duration: 0:00:13.091875
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161715194
- 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_locations/2026-04-08/1775692954", "key": "raw/auctions_sa_locations/2026-04-08/1775692954/sa_locations_1775692802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17087491543809353537, "service_name": "drive-thru", "span_id": 4663691399942766209, "trace_id": 13047635182025651790 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-08 19:02:44
- success: True
- trace_id: 13047635182025651790
-
Scan 161660003
- duration: 0:00:15.618634
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161660003
- 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_locations/2026-04-07/1775606582", "key": "raw/auctions_sa_locations/2026-04-07/1775606582/sa_locations_1775606402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11231667375950648677, "service_name": "drive-thru", "span_id": 10126544707478084712, "trace_id": 17901599371187607508 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-07 19:03:19
- success: True
- trace_id: 17901599371187607508
-
Scan 161603599
- duration: 0:00:15.581200
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161603599
- 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_locations/2026-04-06/1775520178", "key": "raw/auctions_sa_locations/2026-04-06/1775520178/sa_locations_1775520002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5721864166608751990, "service_name": "drive-thru", "span_id": 11375826788135839258, "trace_id": 1261743370743387956 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-06 19:04:02
- success: True
- trace_id: 1261743370743387956
-
Scan 161546813
- duration: 0:00:15.574437
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161546813
- 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_locations/2026-04-05/1775433781", "key": "raw/auctions_sa_locations/2026-04-05/1775433781/sa_locations_1775433601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16073263733477808857, "service_name": "drive-thru", "span_id": 5933776304740196932, "trace_id": 11758604968953403272 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-05 19:03:11
- success: True
- trace_id: 11758604968953403272
-
Scan 161500569
- duration: 0:00:15.504914
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161500569
- 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_locations/2026-04-04/1775347382", "key": "raw/auctions_sa_locations/2026-04-04/1775347382/sa_locations_1775347201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4161104756009414394, "service_name": "drive-thru", "span_id": 735181404992130481, "trace_id": 14191765413120036422 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-04 19:03:39
- success: True
- trace_id: 14191765413120036422
-
Scan 161444582
- duration: 0:00:15.574003
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161444582
- 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_locations/2026-04-03/1775260971", "key": "raw/auctions_sa_locations/2026-04-03/1775260971/sa_locations_1775260801.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11890305517174894288, "service_name": "drive-thru", "span_id": 14015509149192753029, "trace_id": 16460964928157328541 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-03 19:02:58
- success: True
- trace_id: 16460964928157328541
-
Scan 161385971
- duration: 0:00:13.142868
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161385971
- 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_locations/2026-04-02/1775174554", "key": "raw/auctions_sa_locations/2026-04-02/1775174554/sa_locations_1775174402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_locations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7477728979360893061, "service_name": "drive-thru", "span_id": 409540363918138497, "trace_id": 3248524457002599915 } } - running: False
- schema_name_id: 4273
- start_time: 2026-04-02 19:03:02
- success: True
- trace_id: 3248524457002599915
- attributes:
{ "accept_payment_method": "string", "address1": "string", "address2": "string", "ailean_location_code": "string", "billing_email": "string", "billing_method": "string", "billing_mode": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "cloud_image_id": "string", "created_at": "string", "created_by": "string", "currency_code": "string", "deposit": "string", "doorswap_code": "string", "facebook_url": "string", "gives_percentage": "string", "id": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_deleted": "string", "is_show_directory": "string", "lang": "string", "lat": "string", "loc_timezone": "string", "location_code": "string", "location_name": "string", "logo_path": "string", "monthly_fee": "string", "notes": "string", "phone_no": "string", "pick_up_deadline": "string", "sales_tax": "string", "selling_terms": "string", "sentinel_code": "string", "state_id": "string", "status": "string", "storagecommanderlocation_code": "string", "store_hours": "string", "store_identifier": "string", "storedge_code": "string", "syrasoft_code": "string", "twitter_url": "string", "updated_at": "string", "users_id": "string", "website_url": "string", "wss_guid": "string", "zipcode": "string" } - created: 2026-04-16 19:04:21
- 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_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-16/1776384174'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations" }
- 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:02:04",
"disabled": false,
"format": "raw",
"id": 4273,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "auctions_sa_locations"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"accept_payment_method": "string",
"address1": "string",
"address2": "string",
"ailean_location_code": "string",
"billing_email": "string",
"billing_method": "string",
"billing_mode": "string",
"cancellation_amount": "string",
"cancellation_minus_seven": "string",
"cancellation_plus_seven": "string",
"cancellation_subscription": "string",
"city": "string",
"cloud_image_id": "string",
"created_at": "string",
"created_by": "string",
"currency_code": "string",
"deposit": "string",
"doorswap_code": "string",
"facebook_url": "string",
"gives_percentage": "string",
"id": "string",
"invoice_frequency": "string",
"invoice_recipient": "string",
"is_deleted": "string",
"is_show_directory": "string",
"lang": "string",
"lat": "string",
"loc_timezone": "string",
"location_code": "string",
"location_name": "string",
"logo_path": "string",
"monthly_fee": "string",
"notes": "string",
"phone_no": "string",
"pick_up_deadline": "string",
"sales_tax": "string",
"selling_terms": "string",
"sentinel_code": "string",
"state_id": "string",
"status": "string",
"storagecommanderlocation_code": "string",
"store_hours": "string",
"store_identifier": "string",
"storedge_code": "string",
"syrasoft_code": "string",
"twitter_url": "string",
"updated_at": "string",
"users_id": "string",
"website_url": "string",
"wss_guid": "string",
"zipcode": "string"
},
"created": "2026-04-16 19:04:21",
"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_locations`\n(\n `id` string , `users_id` string , `location_name` string , `loc_timezone` string , `sales_tax` string , `pick_up_deadline` string , `store_identifier` string , `store_hours` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `phone_no` string , `logo_path` string , `cloud_image_id` string , `is_show_directory` string , `selling_terms` string , `deposit` string , `gives_percentage` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `billing_mode` string , `billing_email` string , `billing_method` string , `monthly_fee` string , `status` string , `website_url` string , `facebook_url` string , `twitter_url` string , `location_code` string , `storagecommanderlocation_code` string , `doorswap_code` string , `storedge_code` string , `syrasoft_code` string , `ailean_location_code` string , `wss_guid` string , `sentinel_code` string , `notes` string , `accept_payment_method` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `currency_code` 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_locations/2026-04-16/1776384174'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_locations`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_locations"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}