Schema Info
Schema Name: sfdl_prod_drivethru.auctions_sa_users
- created: 2025-09-15 01:01:43
- disabled: False
- format: raw
- id: 4272
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "auctions_sa_users" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717277
- created: 2026-04-16 19:05:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-16/1776384135'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-16/1776384135
- id: 1717277
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 162152338
- updated: 2026-04-16 19:05:37
-
Version 1716049
- created: 2026-04-15 19:04:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-15/1776297735'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-15/1776297735
- id: 1716049
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 162096322
- updated: 2026-04-15 19:04:29
-
Version 1714841
- created: 2026-04-14 19:03:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-14/1776211333'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-14/1776211333
- id: 1714841
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 162040656
- updated: 2026-04-14 19:03:21
-
Version 1713640
- created: 2026-04-13 19:02:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-13/1776124928'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-13/1776124928
- id: 1713640
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161985175
- updated: 2026-04-13 19:03:01
-
Version 1712425
- created: 2026-04-12 19:02:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-12/1776038536'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-12/1776038536
- id: 1712425
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161927903
- updated: 2026-04-12 19:03:07
-
Version 1711236
- 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_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-11/1775952141'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-11/1775952141
- id: 1711236
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161879114
- updated: 2026-04-11 19:04:23
-
Version 1710025
- created: 2026-04-10 19:02:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-10/1775865732'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-10/1775865732
- id: 1710025
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161826289
- updated: 2026-04-10 19:03:04
-
Version 1708890
- created: 2026-04-09 19:02:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-09/1775779337'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-09/1775779337
- id: 1708890
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161770470
- updated: 2026-04-09 19:03:10
-
Version 1707749
- created: 2026-04-08 19:02:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-08/1775692909'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-08/1775692909
- id: 1707749
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161715193
- updated: 2026-04-08 19:02:42
-
Version 1706520
- created: 2026-04-07 19:02:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-07/1775606535'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-07/1775606535
- id: 1706520
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161659995
- updated: 2026-04-07 19:03:03
-
Version 1705344
- created: 2026-04-06 19:05:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-06/1775520132'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-06/1775520132
- id: 1705344
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161603709
- updated: 2026-04-06 19:05:45
-
Version 1704112
- created: 2026-04-05 19:02:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-05/1775433734'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-05/1775433734
- id: 1704112
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161546790
- updated: 2026-04-05 19:03:11
-
Version 1702928
- created: 2026-04-04 19:03:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-04/1775347337'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-04/1775347337
- id: 1702928
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161500466
- updated: 2026-04-04 19:03:15
-
Version 1701751
- created: 2026-04-03 19:02:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-03/1775260934'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-03/1775260934
- id: 1701751
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161444580
- updated: 2026-04-03 19:03:05
-
Version 1700543
- created: 2026-04-02 19:02:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-02/1775174509'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_users/2026-04-02/1775174509
- id: 1700543
- processed: 1
- raw_data:
{ "access_controls": 44, "access_token": 8, "address1": 15, "address2": 16, "ailean_code": 66, "ailean_password": 68, "ailean_username": 67, "alternate_pickup_person": 3, "auth_key": 5, "auto_responder": 24, "billing_method": 37, "buyer_wining_fee": 36, "cancellation_amount": 79, "cancellation_minus_seven": 35, "cancellation_plus_seven": 34, "cancellation_subscription": 78, "city": 17, "company_name": 4, "created_at": 53, "created_by": 52, "custom_deposit": 28, "deposit": 27, "doorswap_password": 62, "doorswap_username": 61, "email": 11, "email_access_controls": 45, "email_verify_token": 71, "facebook_url": 41, "facilities_setting": 76, "first_name": 1, "gives_percentage": 30, "heard_about": 77, "id": 0, "invoice_downpayment": 29, "invoice_frequency": 80, "invoice_recipient": 81, "is_approved": 47, "is_blocked": 39, "is_deleted": 55, "is_v2_force_login": 89, "is_v2_migrated": 56, "is_valid_email": 88, "is_verified": 46, "lang": 21, "last_logged_in": 25, "last_name": 2, "lat": 20, "manager_bio": 43, "manager_type": 14, "marketing_sms": 87, "mobile_no": 22, "monthly_fee": 38, "notes": 73, "opted_email": 51, "opted_marketing_email": 49, "opted_timeline_protection": 50, "password_hash": 6, "password_reset_token": 7, "pay_type": 26, "payroll_id": 10, "preauth_fail_at": 85, "preauth_fail_count": 84, "ref_user_id": 23, "referal": 72, "sales_tax": 75, "sentinel_password": 70, "sentinel_username": 69, "silent_auction": 31, "silent_auction_background": 33, "silent_auction_logo": 32, "sitelink_code": 57, "sitelink_fee": 82, "sitelink_password": 59, "sitelink_username": 58, "state_id": 18, "status": 12, "storagecommander_user": 60, "storedge_username": 63, "syrasoft_password": 65, "syrasoft_username": 64, "system_sms": 86, "terms_and_conditions": 74, "twitter_url": 42, "updated_at": 54, "user_type": 13, "webhook_api": 83, "website_url": 40, "wizard": 48, "wss_secret_key": 9, "zipcode": 19 } - schema_attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - schema_name_id: 4272
- schema_scan_id: 161385959
- updated: 2026-04-02 19:02:43
Schema Scans: 15
Last at 2026-04-16 19:05:21
-
Scan 162152338
- duration: 0:00:16.691241
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162152338
- 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_users/2026-04-16/1776384135", "key": "raw/auctions_sa_users/2026-04-16/1776384135/sa_users_1776384002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14253778470314154508, "service_name": "drive-thru", "span_id": 18083334920756610159, "trace_id": 14325007276850279229 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-16 19:05:21
- success: True
- trace_id: 14325007276850279229
-
Scan 162096322
- duration: 0:00:16.619761
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162096322
- 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_users/2026-04-15/1776297735", "key": "raw/auctions_sa_users/2026-04-15/1776297735/sa_users_1776297601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17661482788813070337, "service_name": "drive-thru", "span_id": 9067088735309255470, "trace_id": 3624666854544617906 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-15 19:04:12
- success: True
- trace_id: 3624666854544617906
-
Scan 162040656
- duration: 0:00:16.482415
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162040656
- 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_users/2026-04-14/1776211333", "key": "raw/auctions_sa_users/2026-04-14/1776211333/sa_users_1776211201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2451747424572435223, "service_name": "drive-thru", "span_id": 17991979800915480876, "trace_id": 3783761248562699567 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-14 19:03:05
- success: True
- trace_id: 3783761248562699567
-
Scan 161985175
- duration: 0:00:16.796130
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161985175
- 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_users/2026-04-13/1776124928", "key": "raw/auctions_sa_users/2026-04-13/1776124928/sa_users_1776124802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17045666255213750573, "service_name": "drive-thru", "span_id": 13724696864886567627, "trace_id": 2430275688445807814 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-13 19:02:44
- success: True
- trace_id: 2430275688445807814
-
Scan 161927903
- duration: 0:00:16.492334
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161927903
- 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_users/2026-04-12/1776038536", "key": "raw/auctions_sa_users/2026-04-12/1776038536/sa_users_1776038402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14983689049780297725, "service_name": "drive-thru", "span_id": 762862861473019604, "trace_id": 4061439639153425543 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-12 19:02:50
- success: True
- trace_id: 4061439639153425543
-
Scan 161879114
- duration: 0:00:14.005013
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161879114
- 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_users/2026-04-11/1775952141", "key": "raw/auctions_sa_users/2026-04-11/1775952141/sa_users_1775952002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 861361359480036182, "service_name": "drive-thru", "span_id": 16666840228329477117, "trace_id": 5990803418178745642 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-11 19:04:09
- success: True
- trace_id: 5990803418178745642
-
Scan 161826289
- duration: 0:00:13.866031
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161826289
- 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_users/2026-04-10/1775865732", "key": "raw/auctions_sa_users/2026-04-10/1775865732/sa_users_1775865602.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4337788172919313248, "service_name": "drive-thru", "span_id": 17431320917924214475, "trace_id": 4119843341933307279 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-10 19:02:50
- success: True
- trace_id: 4119843341933307279
-
Scan 161770470
- duration: 0:00:16.647226
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161770470
- 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_users/2026-04-09/1775779337", "key": "raw/auctions_sa_users/2026-04-09/1775779337/sa_users_1775779202.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12471379696951284133, "service_name": "drive-thru", "span_id": 10920390549234943001, "trace_id": 1132074881025881784 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-09 19:02:53
- success: True
- trace_id: 1132074881025881784
-
Scan 161715193
- duration: 0:00:13.881911
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161715193
- 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_users/2026-04-08/1775692909", "key": "raw/auctions_sa_users/2026-04-08/1775692909/sa_users_1775692802.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11665975081510560960, "service_name": "drive-thru", "span_id": 1150334938643015950, "trace_id": 1837986037636160577 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-08 19:02:28
- success: True
- trace_id: 1837986037636160577
-
Scan 161659995
- duration: 0:00:14.127311
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161659995
- 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_users/2026-04-07/1775606535", "key": "raw/auctions_sa_users/2026-04-07/1775606535/sa_users_1775606402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1718582036589999123, "service_name": "drive-thru", "span_id": 14996566735811672587, "trace_id": 7129668004801443808 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-07 19:02:49
- success: True
- trace_id: 7129668004801443808
-
Scan 161603709
- duration: 0:00:16.599433
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161603709
- 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_users/2026-04-06/1775520132", "key": "raw/auctions_sa_users/2026-04-06/1775520132/sa_users_1775520002.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17169984580018228310, "service_name": "drive-thru", "span_id": 1618384352715035885, "trace_id": 13171349563580187665 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-06 19:05:28
- success: True
- trace_id: 13171349563580187665
-
Scan 161546790
- duration: 0:00:16.748301
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161546790
- 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_users/2026-04-05/1775433734", "key": "raw/auctions_sa_users/2026-04-05/1775433734/sa_users_1775433601.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18404460714801199373, "service_name": "drive-thru", "span_id": 1261885526683973391, "trace_id": 1399392034760205677 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-05 19:02:54
- success: True
- trace_id: 1399392034760205677
-
Scan 161500466
- duration: 0:00:14.364132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161500466
- 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_users/2026-04-04/1775347337", "key": "raw/auctions_sa_users/2026-04-04/1775347337/sa_users_1775347201.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1291681346340182911, "service_name": "drive-thru", "span_id": 14406734148099751635, "trace_id": 3745663253649591637 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-04 19:03:01
- success: True
- trace_id: 3745663253649591637
-
Scan 161444580
- duration: 0:00:16.679939
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161444580
- 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_users/2026-04-03/1775260934", "key": "raw/auctions_sa_users/2026-04-03/1775260934/sa_users_1775260801.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8001127426918662134, "service_name": "drive-thru", "span_id": 3245284546750316318, "trace_id": 6708059284419574582 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-03 19:02:48
- success: True
- trace_id: 6708059284419574582
-
Scan 161385959
- duration: 0:00:14.120813
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161385959
- 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_users/2026-04-02/1775174509", "key": "raw/auctions_sa_users/2026-04-02/1775174509/sa_users_1775174402.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.auctions_sa_users", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18225493946943746375, "service_name": "drive-thru", "span_id": 3994021665471558667, "trace_id": 1118701988477608134 } } - running: False
- schema_name_id: 4272
- start_time: 2026-04-02 19:02:29
- success: True
- trace_id: 1118701988477608134
- attributes:
{ "access_controls": "string", "access_token": "string", "address1": "string", "address2": "string", "ailean_code": "string", "ailean_password": "string", "ailean_username": "string", "alternate_pickup_person": "string", "auth_key": "string", "auto_responder": "string", "billing_method": "string", "buyer_wining_fee": "string", "cancellation_amount": "string", "cancellation_minus_seven": "string", "cancellation_plus_seven": "string", "cancellation_subscription": "string", "city": "string", "company_name": "string", "created_at": "string", "created_by": "string", "custom_deposit": "string", "deposit": "string", "doorswap_password": "string", "doorswap_username": "string", "email": "string", "email_access_controls": "string", "email_verify_token": "string", "facebook_url": "string", "facilities_setting": "string", "first_name": "string", "gives_percentage": "string", "heard_about": "string", "id": "string", "invoice_downpayment": "string", "invoice_frequency": "string", "invoice_recipient": "string", "is_approved": "string", "is_blocked": "string", "is_deleted": "string", "is_v2_force_login": "string", "is_v2_migrated": "string", "is_valid_email": "string", "is_verified": "string", "lang": "string", "last_logged_in": "string", "last_name": "string", "lat": "string", "manager_bio": "string", "manager_type": "string", "marketing_sms": "string", "mobile_no": "string", "monthly_fee": "string", "notes": "string", "opted_email": "string", "opted_marketing_email": "string", "opted_timeline_protection": "string", "password_hash": "string", "password_reset_token": "string", "pay_type": "string", "payroll_id": "string", "preauth_fail_at": "string", "preauth_fail_count": "string", "ref_user_id": "string", "referal": "string", "sales_tax": "string", "sentinel_password": "string", "sentinel_username": "string", "silent_auction": "string", "silent_auction_background": "string", "silent_auction_logo": "string", "sitelink_code": "string", "sitelink_fee": "string", "sitelink_password": "string", "sitelink_username": "string", "state_id": "string", "status": "string", "storagecommander_user": "string", "storedge_username": "string", "syrasoft_password": "string", "syrasoft_username": "string", "system_sms": "string", "terms_and_conditions": "string", "twitter_url": "string", "updated_at": "string", "user_type": "string", "webhook_api": "string", "website_url": "string", "wizard": "string", "wss_secret_key": "string", "zipcode": "string" } - created: 2026-04-16 19:05:24
- 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_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-16/1776384135'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users" }
- 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:01:43",
"disabled": false,
"format": "raw",
"id": 4272,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "auctions_sa_users"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"access_controls": "string",
"access_token": "string",
"address1": "string",
"address2": "string",
"ailean_code": "string",
"ailean_password": "string",
"ailean_username": "string",
"alternate_pickup_person": "string",
"auth_key": "string",
"auto_responder": "string",
"billing_method": "string",
"buyer_wining_fee": "string",
"cancellation_amount": "string",
"cancellation_minus_seven": "string",
"cancellation_plus_seven": "string",
"cancellation_subscription": "string",
"city": "string",
"company_name": "string",
"created_at": "string",
"created_by": "string",
"custom_deposit": "string",
"deposit": "string",
"doorswap_password": "string",
"doorswap_username": "string",
"email": "string",
"email_access_controls": "string",
"email_verify_token": "string",
"facebook_url": "string",
"facilities_setting": "string",
"first_name": "string",
"gives_percentage": "string",
"heard_about": "string",
"id": "string",
"invoice_downpayment": "string",
"invoice_frequency": "string",
"invoice_recipient": "string",
"is_approved": "string",
"is_blocked": "string",
"is_deleted": "string",
"is_v2_force_login": "string",
"is_v2_migrated": "string",
"is_valid_email": "string",
"is_verified": "string",
"lang": "string",
"last_logged_in": "string",
"last_name": "string",
"lat": "string",
"manager_bio": "string",
"manager_type": "string",
"marketing_sms": "string",
"mobile_no": "string",
"monthly_fee": "string",
"notes": "string",
"opted_email": "string",
"opted_marketing_email": "string",
"opted_timeline_protection": "string",
"password_hash": "string",
"password_reset_token": "string",
"pay_type": "string",
"payroll_id": "string",
"preauth_fail_at": "string",
"preauth_fail_count": "string",
"ref_user_id": "string",
"referal": "string",
"sales_tax": "string",
"sentinel_password": "string",
"sentinel_username": "string",
"silent_auction": "string",
"silent_auction_background": "string",
"silent_auction_logo": "string",
"sitelink_code": "string",
"sitelink_fee": "string",
"sitelink_password": "string",
"sitelink_username": "string",
"state_id": "string",
"status": "string",
"storagecommander_user": "string",
"storedge_username": "string",
"syrasoft_password": "string",
"syrasoft_username": "string",
"system_sms": "string",
"terms_and_conditions": "string",
"twitter_url": "string",
"updated_at": "string",
"user_type": "string",
"webhook_api": "string",
"website_url": "string",
"wizard": "string",
"wss_secret_key": "string",
"zipcode": "string"
},
"created": "2026-04-16 19:05:24",
"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_users`\n(\n `id` string , `first_name` string , `last_name` string , `alternate_pickup_person` string , `company_name` string , `auth_key` string , `password_hash` string , `password_reset_token` string , `access_token` string , `wss_secret_key` string , `payroll_id` string , `email` string , `status` string , `user_type` string , `manager_type` string , `address1` string , `address2` string , `city` string , `state_id` string , `zipcode` string , `lat` string , `lang` string , `mobile_no` string , `ref_user_id` string , `auto_responder` string , `last_logged_in` string , `pay_type` string , `deposit` string , `custom_deposit` string , `invoice_downpayment` string , `gives_percentage` string , `silent_auction` string , `silent_auction_logo` string , `silent_auction_background` string , `cancellation_plus_seven` string , `cancellation_minus_seven` string , `buyer_wining_fee` string , `billing_method` string , `monthly_fee` string , `is_blocked` string , `website_url` string , `facebook_url` string , `twitter_url` string , `manager_bio` string , `access_controls` string , `email_access_controls` string , `is_verified` string , `is_approved` string , `wizard` string , `opted_marketing_email` string , `opted_timeline_protection` string , `opted_email` string , `created_by` string , `created_at` string , `updated_at` string , `is_deleted` string , `is_v2_migrated` string , `sitelink_code` string , `sitelink_username` string , `sitelink_password` string , `storagecommander_user` string , `doorswap_username` string , `doorswap_password` string , `storedge_username` string , `syrasoft_username` string , `syrasoft_password` string , `ailean_code` string , `ailean_username` string , `ailean_password` string , `sentinel_username` string , `sentinel_password` string , `email_verify_token` string , `referal` string , `notes` string , `terms_and_conditions` string , `sales_tax` string , `facilities_setting` string , `heard_about` string , `cancellation_subscription` string , `cancellation_amount` string , `invoice_frequency` string , `invoice_recipient` string , `sitelink_fee` string , `webhook_api` string , `preauth_fail_count` string , `preauth_fail_at` string , `system_sms` string , `marketing_sms` string , `is_valid_email` string , `is_v2_force_login` 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_users/2026-04-16/1776384135'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_users`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_users"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}