Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission
  • created: 2022-08-18 17:56:13
  • disabled: False
  • format: raw
  • id: 1147
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_listing_rent_submission"
}
  • type: rds
Schema Versions: 15
    • created: 2026-04-17 14:33:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776454398'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776454398
    • id: 1718423
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162194194
    • updated: 2026-04-17 14:34:04
    • created: 2026-04-17 09:26:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776435932'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776435932
    • id: 1718226
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162178332
    • updated: 2026-04-17 09:26:21
    • created: 2026-04-17 00:35:15
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776404079'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776404079
    • id: 1717485
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162163721
    • updated: 2026-04-17 00:35:29
    • created: 2026-04-16 20:56:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776390931'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776390931
    • id: 1717381
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162156435
    • updated: 2026-04-16 20:56:48
    • created: 2026-04-16 14:37:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776368195'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776368195
    • id: 1717200
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162138332
    • updated: 2026-04-16 14:37:21
    • created: 2026-04-16 09:37:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776350212'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776350212
    • id: 1717033
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162122837
    • updated: 2026-04-16 09:37:38
    • created: 2026-04-16 00:35:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776317708'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776317708
    • id: 1716249
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162107865
    • updated: 2026-04-16 00:35:58
    • created: 2026-04-15 20:48:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776304091'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776304091
    • id: 1716145
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162100431
    • updated: 2026-04-15 20:49:07
    • created: 2026-04-15 14:38:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776281885'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776281885
    • id: 1716003
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162082386
    • updated: 2026-04-15 14:38:50
    • created: 2026-04-15 09:09:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776261749'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776261749
    • id: 1715812
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162066567
    • updated: 2026-04-15 09:09:31
    • created: 2026-04-15 00:45:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776231908'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776231908
    • id: 1715061
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162052079
    • updated: 2026-04-15 00:45:45
    • created: 2026-04-14 20:30:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776216574'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776216574
    • id: 1714926
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162044360
    • updated: 2026-04-14 20:30:18
    • created: 2026-04-14 14:34:02
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776195203'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776195203
    • id: 1714771
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162026400
    • updated: 2026-04-14 14:34:16
    • created: 2026-04-14 09:30:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776177005'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776177005
    • id: 1714623
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 162011162
    • updated: 2026-04-14 09:30:49
    • created: 2026-04-14 00:51:40
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776145868'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776145868
    • id: 1713865
    • processed: 1
    • raw_data: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int32",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "int16",
    "call_center": "int16",
    "call_center_moved_in": "int16",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "int16",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "int16",
    "confirmation_code": "string",
    "contacted": "int16",
    "corrected": "int16",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "int16",
    "hosted_website": "int16",
    "hot_lead": "int16",
    "invoice_id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "listing_want_id": "int32",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp[ns]",
    "monthly_insurance": "double",
    "move_in": "date32[day]",
    "move_in_actual": "date32[day]",
    "move_in_original": "date32[day]",
    "move_out": "date32[day]",
    "npv": "double",
    "omi_completed": "int16",
    "omi_flow_enabled": "int16",
    "omi_timestamp": "timestamp[ns]",
    "online_move_in_url": "string",
    "payout_batch_id": "int32",
    "phone_changed_number": "int16",
    "phone_facility_transfer": "int16",
    "phone_status": "string",
    "phone_verified": "int16",
    "price": "double",
    "promo": "string",
    "read": "int16",
    "rebate_processed": "int16",
    "referrer_id": "int32",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "session_id": "int32",
    "site_id": "int32",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int32",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp[ns]",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int32",
    "visit_id": "string",
    "zip": "string"
}
    • schema_attributes: 
      {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
    • schema_name_id: 1147
    • schema_scan_id: 161996486
    • updated: 2026-04-14 00:51:53
Schema Scans: 15
Last at 2026-04-17 14:33:50
    • duration: 0:00:14.029612
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162194194
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776454398",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-17/1776454398/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11846436945355980390,
        "service_name": "sparefoot",
        "span_id": 6568370013598728425,
        "trace_id": 11846436945355980390
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-17 14:33:50
    • success: True
    • trace_id: 11846436945355980390
    • duration: 0:00:16.749915
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162178332
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776435932",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-17/1776435932/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16908733596581893924,
        "service_name": "sparefoot",
        "span_id": 15156790728734954520,
        "trace_id": 16908733596581893924
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-17 09:26:05
    • success: True
    • trace_id: 16908733596581893924
    • duration: 0:00:16.391018
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162163721
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776404079",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-17/1776404079/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3416970679750216473,
        "service_name": "sparefoot",
        "span_id": 12841388392988427988,
        "trace_id": 3416970679750216473
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-17 00:35:12
    • success: True
    • trace_id: 3416970679750216473
    • duration: 0:00:16.675450
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162156435
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776390931",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-16/1776390931/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3844707488745830523,
        "service_name": "sparefoot",
        "span_id": 1135919900200038180,
        "trace_id": 3844707488745830523
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-16 20:56:31
    • success: True
    • trace_id: 3844707488745830523
    • duration: 0:00:16.602143
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162138332
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776368195",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-16/1776368195/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4007079343278571105,
        "service_name": "sparefoot",
        "span_id": 16496428368118957133,
        "trace_id": 4007079343278571105
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-16 14:37:05
    • success: True
    • trace_id: 4007079343278571105
    • duration: 0:00:13.950416
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162122837
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776350212",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-16/1776350212/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11332790625655071343,
        "service_name": "sparefoot",
        "span_id": 8937184874484351856,
        "trace_id": 11332790625655071343
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-16 09:37:24
    • success: True
    • trace_id: 11332790625655071343
    • duration: 0:00:13.966480
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162107865
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-16/1776317708",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-16/1776317708/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 791946860140550237,
        "service_name": "sparefoot",
        "span_id": 14557081506072546615,
        "trace_id": 791946860140550237
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-16 00:35:44
    • success: True
    • trace_id: 791946860140550237
    • duration: 0:00:13.835149
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162100431
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776304091",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-15/1776304091/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5287134302593736912,
        "service_name": "sparefoot",
        "span_id": 5340933739762419994,
        "trace_id": 5287134302593736912
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-15 20:48:53
    • success: True
    • trace_id: 5287134302593736912
    • duration: 0:00:16.469178
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162082386
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776281885",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-15/1776281885/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17920544194729166131,
        "service_name": "sparefoot",
        "span_id": 8957877875232614635,
        "trace_id": 17920544194729166131
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-15 14:38:34
    • success: True
    • trace_id: 17920544194729166131
    • duration: 0:00:14.009139
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162066567
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776261749",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-15/1776261749/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4483265954099662018,
        "service_name": "sparefoot",
        "span_id": 10094401818125270012,
        "trace_id": 4483265954099662018
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-15 09:09:17
    • success: True
    • trace_id: 4483265954099662018
    • duration: 0:00:14.397479
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162052079
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-15/1776231908",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-15/1776231908/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2340372252056909356,
        "service_name": "sparefoot",
        "span_id": 11851729519454334391,
        "trace_id": 2340372252056909356
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-15 00:45:30
    • success: True
    • trace_id: 2340372252056909356
    • duration: 0:00:16.967694
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162044360
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776216574",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-14/1776216574/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4863101811528014433,
        "service_name": "sparefoot",
        "span_id": 4870793198179323477,
        "trace_id": 4863101811528014433
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-14 20:30:01
    • success: True
    • trace_id: 4863101811528014433
    • duration: 0:00:16.682907
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162026400
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776195203",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-14/1776195203/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 976594586642429495,
        "service_name": "sparefoot",
        "span_id": 14245853715900652261,
        "trace_id": 976594586642429495
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-14 14:33:59
    • success: True
    • trace_id: 976594586642429495
    • duration: 0:00:16.534778
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162011162
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776177005",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-14/1776177005/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1665211184039375915,
        "service_name": "sparefoot",
        "span_id": 11691840716522195415,
        "trace_id": 1665211184039375915
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-14 09:30:32
    • success: True
    • trace_id: 1665211184039375915
    • duration: 0:00:16.382886
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161996486
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-14/1776145868",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-14/1776145868/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3826250075089468445,
        "service_name": "sparefoot",
        "span_id": 1940956857376190127,
        "trace_id": 3826250075089468445
    }
}
    • running: False
    • schema_name_id: 1147
    • start_time: 2026-04-14 00:51:37
    • success: True
    • trace_id: 3826250075089468445
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "aaa_member_number": "string",
    "actual_d": "double",
    "actual_w": "double",
    "affiliate_id": "string",
    "api_cust_id": "string",
    "api_lead_id": "string",
    "api_unit_id": "string",
    "auto_state": "string",
    "base_bid": "double",
    "bid_amount": "double",
    "bid_type": "string",
    "booking_agent_id": "int",
    "booking_first_name": "string",
    "booking_last_name": "string",
    "booking_phone": "string",
    "booking_state": "string",
    "booking_type": "string",
    "booking_widget": "smallint",
    "call_center": "smallint",
    "call_center_moved_in": "smallint",
    "call_center_notes": "string",
    "caller_id_phone": "string",
    "canceled": "smallint",
    "centershift_account_id": "string",
    "city": "string",
    "commission": "double",
    "complete": "smallint",
    "confirmation_code": "string",
    "contacted": "smallint",
    "corrected": "smallint",
    "country": "string",
    "customer_notes": "string",
    "deposit_paid": "double",
    "dispute_reason": "string",
    "e_visit_id": "string",
    "facility_tenant_id": "string",
    "free": "smallint",
    "hosted_website": "smallint",
    "hot_lead": "smallint",
    "invoice_id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "listing_want_id": "int",
    "match_reasons": "string",
    "match_score": "double",
    "modified_dtm": "timestamp",
    "monthly_insurance": "double",
    "move_in": "date",
    "move_in_actual": "date",
    "move_in_original": "date",
    "move_out": "date",
    "npv": "double",
    "omi_completed": "smallint",
    "omi_flow_enabled": "smallint",
    "omi_timestamp": "timestamp",
    "online_move_in_url": "string",
    "payout_batch_id": "int",
    "phone_changed_number": "smallint",
    "phone_facility_transfer": "smallint",
    "phone_status": "string",
    "phone_verified": "smallint",
    "price": "double",
    "promo": "string",
    "read": "smallint",
    "rebate_processed": "smallint",
    "referrer_id": "int",
    "resale_rate": "double",
    "review_status": "string",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "session_id": "int",
    "site_id": "int",
    "site_phone": "string",
    "size_d": "double",
    "size_h": "double",
    "size_w": "double",
    "state": "string",
    "statement_id": "int",
    "street_address": "string",
    "terms_version": "string",
    "timestamp": "timestamp",
    "total_paid": "double",
    "traffic_source_id": "string",
    "unit_number": "string",
    "user_id": "int",
    "visit_id": "string",
    "zip": "string"
}
  • created: 2026-04-17 14:33:53
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776454398'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-08-18 17:56:13",
        "disabled": false,
        "format": "raw",
        "id": 1147,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_listing_rent_submission"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "aaa_member_number": "string",
            "actual_d": "double",
            "actual_w": "double",
            "affiliate_id": "string",
            "api_cust_id": "string",
            "api_lead_id": "string",
            "api_unit_id": "string",
            "auto_state": "string",
            "base_bid": "double",
            "bid_amount": "double",
            "bid_type": "string",
            "booking_agent_id": "int",
            "booking_first_name": "string",
            "booking_last_name": "string",
            "booking_phone": "string",
            "booking_state": "string",
            "booking_type": "string",
            "booking_widget": "smallint",
            "call_center": "smallint",
            "call_center_moved_in": "smallint",
            "call_center_notes": "string",
            "caller_id_phone": "string",
            "canceled": "smallint",
            "centershift_account_id": "string",
            "city": "string",
            "commission": "double",
            "complete": "smallint",
            "confirmation_code": "string",
            "contacted": "smallint",
            "corrected": "smallint",
            "country": "string",
            "customer_notes": "string",
            "deposit_paid": "double",
            "dispute_reason": "string",
            "e_visit_id": "string",
            "facility_tenant_id": "string",
            "free": "smallint",
            "hosted_website": "smallint",
            "hot_lead": "smallint",
            "invoice_id": "int",
            "listing_avail_id": "int",
            "listing_avail_space_id": "int",
            "listing_want_id": "int",
            "match_reasons": "string",
            "match_score": "double",
            "modified_dtm": "timestamp",
            "monthly_insurance": "double",
            "move_in": "date",
            "move_in_actual": "date",
            "move_in_original": "date",
            "move_out": "date",
            "npv": "double",
            "omi_completed": "smallint",
            "omi_flow_enabled": "smallint",
            "omi_timestamp": "timestamp",
            "online_move_in_url": "string",
            "payout_batch_id": "int",
            "phone_changed_number": "smallint",
            "phone_facility_transfer": "smallint",
            "phone_status": "string",
            "phone_verified": "smallint",
            "price": "double",
            "promo": "string",
            "read": "smallint",
            "rebate_processed": "smallint",
            "referrer_id": "int",
            "resale_rate": "double",
            "review_status": "string",
            "search_weight_id": "int",
            "search_weight_test_id": "int",
            "session_id": "int",
            "site_id": "int",
            "site_phone": "string",
            "size_d": "double",
            "size_h": "double",
            "size_w": "double",
            "state": "string",
            "statement_id": "int",
            "street_address": "string",
            "terms_version": "string",
            "timestamp": "timestamp",
            "total_paid": "double",
            "traffic_source_id": "string",
            "unit_number": "string",
            "user_id": "int",
            "visit_id": "string",
            "zip": "string"
        },
        "created": "2026-04-17 14:33:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`\n(\n `aaa_member_number`  string , `actual_d`  double , `actual_w`  double , `affiliate_id`  string , `api_cust_id`  string , `api_lead_id`  string , `api_unit_id`  string , `auto_state`  string , `base_bid`  double , `bid_amount`  double , `bid_type`  string , `booking_agent_id`  int , `booking_first_name`  string , `booking_last_name`  string , `booking_phone`  string , `booking_state`  string , `booking_type`  string , `booking_widget`  smallint , `call_center`  smallint , `call_center_moved_in`  smallint , `call_center_notes`  string , `caller_id_phone`  string , `canceled`  smallint , `centershift_account_id`  string , `city`  string , `commission`  double , `complete`  smallint , `confirmation_code`  string , `contacted`  smallint , `corrected`  smallint , `country`  string , `customer_notes`  string , `deposit_paid`  double , `dispute_reason`  string , `e_visit_id`  string , `facility_tenant_id`  string , `free`  smallint , `hosted_website`  smallint , `hot_lead`  smallint , `invoice_id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `listing_want_id`  int , `match_reasons`  string , `match_score`  double , `modified_dtm`  timestamp , `monthly_insurance`  double , `move_in`  date , `move_in_actual`  date , `move_in_original`  date , `move_out`  date , `npv`  double , `omi_completed`  smallint , `omi_flow_enabled`  smallint , `omi_timestamp`  timestamp , `online_move_in_url`  string , `payout_batch_id`  int , `phone_changed_number`  smallint , `phone_facility_transfer`  smallint , `phone_status`  string , `phone_verified`  smallint , `price`  double , `promo`  string , `read`  smallint , `rebate_processed`  smallint , `referrer_id`  int , `resale_rate`  double , `review_status`  string , `search_weight_id`  int , `search_weight_test_id`  int , `session_id`  int , `site_id`  int , `site_phone`  string , `size_d`  double , `size_h`  double , `size_w`  double , `state`  string , `statement_id`  int , `street_address`  string , `terms_version`  string , `timestamp`  timestamp , `total_paid`  double , `traffic_source_id`  string , `unit_number`  string , `user_id`  int , `visit_id`  string , `zip`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_rent_submission/2026-04-17/1776454398'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_listing_rent_submission"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform