Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission
  • created: 2022-08-12 10:53:47
  • disabled: False
  • format: raw
  • id: 1373
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_rds",
    "table": "sparefoot_sparefoot_listing_rent_submission"
}
  • type: rds
Schema Versions: 15
    • created: 2026-04-17 00:35:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-17/1776404110'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-17/1776404110
    • id: 906578
    • 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: 1373
    • schema_scan_id: 6415146
    • updated: 2026-04-17 00:36:01
    • created: 2026-04-16 00:29:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-16/1776317323'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-16/1776317323
    • id: 906369
    • 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: 1373
    • schema_scan_id: 6414608
    • updated: 2026-04-16 00:29:38
    • created: 2026-04-15 00:38:56
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-15/1776231493'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-15/1776231493
    • id: 906160
    • 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: 1373
    • schema_scan_id: 6414124
    • updated: 2026-04-15 00:39:10
    • created: 2026-04-14 00:43:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-14/1776145350'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-14/1776145350
    • id: 905945
    • 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: 1373
    • schema_scan_id: 6413614
    • updated: 2026-04-14 00:43:43
    • created: 2026-04-13 00:36:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-13/1776058551'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-13/1776058551
    • id: 905728
    • 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: 1373
    • schema_scan_id: 6413067
    • updated: 2026-04-13 00:36:35
    • created: 2026-04-12 00:33:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-12/1775972001'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-12/1775972001
    • id: 905528
    • 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: 1373
    • schema_scan_id: 6412680
    • updated: 2026-04-12 00:34:07
    • created: 2026-04-11 00:47:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-11/1775886386'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-11/1775886386
    • id: 905328
    • 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: 1373
    • schema_scan_id: 6412301
    • updated: 2026-04-11 00:47:14
    • created: 2026-04-10 00:41:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-10/1775799634'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-10/1775799634
    • id: 905113
    • 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: 1373
    • schema_scan_id: 6411800
    • updated: 2026-04-10 00:41:38
    • created: 2026-04-09 00:42:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-09/1775713329'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-09/1775713329
    • id: 904899
    • 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: 1373
    • schema_scan_id: 6411286
    • updated: 2026-04-09 00:42:56
    • created: 2026-04-08 00:49:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-08/1775627337'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-08/1775627337
    • id: 904687
    • 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: 1373
    • schema_scan_id: 6410790
    • updated: 2026-04-08 00:49:45
    • created: 2026-04-07 00:42:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-07/1775540528'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-07/1775540528
    • id: 904470
    • 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: 1373
    • schema_scan_id: 6410274
    • updated: 2026-04-07 00:42:52
    • created: 2026-04-06 00:48:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-06/1775454453'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-06/1775454453
    • id: 904258
    • 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: 1373
    • schema_scan_id: 6409734
    • updated: 2026-04-06 00:48:25
    • created: 2026-04-05 00:46:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-05/1775367960'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-05/1775367960
    • id: 904056
    • 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: 1373
    • schema_scan_id: 6409352
    • updated: 2026-04-05 00:46:50
    • created: 2026-04-04 00:28:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-04/1775280475'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-04/1775280475
    • id: 903849
    • 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: 1373
    • schema_scan_id: 6408966
    • updated: 2026-04-04 00:28:30
    • created: 2026-04-03 00:36:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-03/1775194538'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
]
    • hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-03/1775194538
    • id: 903636
    • 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: 1373
    • schema_scan_id: 6408471
    • updated: 2026-04-03 00:36:27
Schema Scans: 15
Last at 2026-04-17 00:35:47
    • duration: 0:00:14.388560
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6415146
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-17/1776404110",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-17/1776404110/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5299658744354360621,
        "service_name": "sparefoot",
        "span_id": 8710375154013649007,
        "trace_id": 5299658744354360621
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-17 00:35:47
    • success: True
    • trace_id: 5299658744354360621
    • duration: 0:00:16.755730
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414608
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-16/1776317323",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-16/1776317323/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12901423432075708925,
        "service_name": "sparefoot",
        "span_id": 1850259032957572639,
        "trace_id": 12901423432075708925
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-16 00:29:21
    • success: True
    • trace_id: 12901423432075708925
    • duration: 0:00:16.731788
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414124
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-15/1776231493",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-15/1776231493/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 865761905317160629,
        "service_name": "sparefoot",
        "span_id": 4226351982369607177,
        "trace_id": 865761905317160629
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-15 00:38:53
    • success: True
    • trace_id: 865761905317160629
    • duration: 0:00:14.018028
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413614
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-14/1776145350",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-14/1776145350/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11017807407172707733,
        "service_name": "sparefoot",
        "span_id": 6813071900307031643,
        "trace_id": 11017807407172707733
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-14 00:43:29
    • success: True
    • trace_id: 11017807407172707733
    • duration: 0:00:16.692158
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413067
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-13/1776058551",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-13/1776058551/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4964139596374152188,
        "service_name": "sparefoot",
        "span_id": 15383998923995246864,
        "trace_id": 4964139596374152188
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-13 00:36:18
    • success: True
    • trace_id: 4964139596374152188
    • duration: 0:00:16.812689
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412680
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-12/1775972001",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-12/1775972001/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8488588173176409388,
        "service_name": "sparefoot",
        "span_id": 1401571345367939802,
        "trace_id": 8488588173176409388
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-12 00:33:50
    • success: True
    • trace_id: 8488588173176409388
    • duration: 0:00:14.729751
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412301
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-11/1775886386",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-11/1775886386/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4776406862069368282,
        "service_name": "sparefoot",
        "span_id": 11402072725165060787,
        "trace_id": 4776406862069368282
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-11 00:46:59
    • success: True
    • trace_id: 4776406862069368282
    • duration: 0:00:16.741827
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411800
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-10/1775799634",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-10/1775799634/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10173613245332342641,
        "service_name": "sparefoot",
        "span_id": 14895928134283582851,
        "trace_id": 10173613245332342641
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-10 00:41:21
    • success: True
    • trace_id: 10173613245332342641
    • duration: 0:00:16.596059
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411286
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-09/1775713329",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-09/1775713329/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14587315559230359545,
        "service_name": "sparefoot",
        "span_id": 1203593570842982986,
        "trace_id": 14587315559230359545
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-09 00:42:39
    • success: True
    • trace_id: 14587315559230359545
    • duration: 0:00:14.142657
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410790
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-08/1775627337",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-08/1775627337/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16183785630338677377,
        "service_name": "sparefoot",
        "span_id": 11005956540700637057,
        "trace_id": 16183785630338677377
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-08 00:49:31
    • success: True
    • trace_id: 16183785630338677377
    • duration: 0:00:16.742037
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410274
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-07/1775540528",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-07/1775540528/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5661981079754082116,
        "service_name": "sparefoot",
        "span_id": 9961985404603360714,
        "trace_id": 5661981079754082116
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-07 00:42:35
    • success: True
    • trace_id: 5661981079754082116
    • duration: 0:00:14.056300
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409734
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-06/1775454453",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-06/1775454453/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12574157665736005836,
        "service_name": "sparefoot",
        "span_id": 12302525257293555969,
        "trace_id": 12574157665736005836
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-06 00:48:11
    • success: True
    • trace_id: 12574157665736005836
    • duration: 0:00:16.676927
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409352
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-05/1775367960",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-05/1775367960/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13280758813991029092,
        "service_name": "sparefoot",
        "span_id": 7980303669249077653,
        "trace_id": 13280758813991029092
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-05 00:46:33
    • success: True
    • trace_id: 13280758813991029092
    • duration: 0:00:13.878707
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408966
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-04/1775280475",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-04/1775280475/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4585135292373282650,
        "service_name": "sparefoot",
        "span_id": 14057657496890938151,
        "trace_id": 4585135292373282650
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-04 00:28:16
    • success: True
    • trace_id: 4585135292373282650
    • duration: 0:00:13.973067
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408471
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_rent_submission/2026-04-03/1775194538",
        "key": "raw/sparefoot_listing_rent_submission/2026-04-03/1775194538/listing_rent_submission_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9554186934456727086,
        "service_name": "sparefoot",
        "span_id": 11967503961964177073,
        "trace_id": 9554186934456727086
    }
}
    • running: False
    • schema_name_id: 1373
    • start_time: 2026-04-03 00:36:13
    • success: True
    • trace_id: 9554186934456727086
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 00:35:50
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-17/1776404110'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-08-12 10:53:47",
        "disabled": false,
        "format": "raw",
        "id": 1373,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:35:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_listing_rent_submission/2026-04-17/1776404110'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_rent_submission"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform