Schema Info
Schema Name: sfdl_stage_rds.master_sparefoot_listing_rent_submission
- created: 2018-05-02 16:23:34
- disabled: False
- format: raw
- id: 503
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_rds", "table": "master_sparefoot_listing_rent_submission" } - type: rds
Schema Versions: 3
-
Version 179717
- created: 2018-07-17 00:29:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.master_sparefoot_listing_rent_submission`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.master_sparefoot_listing_rent_submission`\n(\n `listing_avail_space_id` int , `listing_avail_id` int , `api_unit_id` varchar(32) , `unit_number` varchar(32) , `listing_want_id` int , `user_id` int , `booking_first_name` varchar(128) , `booking_last_name` varchar(128) , `booking_phone` varchar(16) , `timestamp` timestamp , `price` decimal(10,2) , `deposit_paid` decimal(10,2) , `bid_amount` decimal(10,2) , `move_in` date , `move_in_original` date , `confirmation_code` varchar(32) , `referrer_id` int , `affiliate_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `complete` smallint , `read` smallint , `visit_id` varchar(32) , `size_w` decimal(10,2) , `size_d` decimal(10,2) , `size_h` decimal(10,2) , `promo` string , `street_address` varchar(255) , `city` varchar(40) , `state` char(2) , `country` char(2) , `zip` varchar(10) , `api_cust_id` varchar(32) , `booking_state` varchar(20) , `auto_state` varchar(60) , `match_reasons` string , `match_score` decimal , `facility_tenant_id` varchar(32) , `statement_id` int , `call_center` smallint , `booking_agent_id` int , `call_center_notes` string , `dispute_reason` string , `booking_widget` smallint , `hosted_website` smallint , `contacted` smallint , `e_visit_id` varchar(32) , `call_center_moved_in` smallint , `commission` decimal(8,2) , `payout_batch_id` int , `corrected` smallint , `hot_lead` smallint , `api_lead_id` varchar(36) , `phone_verified` smallint , `phone_facility_transfer` smallint , `phone_changed_number` smallint , `phone_status` varchar(60) , `centershift_account_id` varchar(10) , `search_weight_test_id` int , `search_weight_id` int , `free` smallint , `move_out` date , `total_paid` decimal(10,2) , `invoice_id` int , `customer_notes` string , `rebate_processed` smallint , `caller_id_phone` varchar(16) , `actual_w` decimal(10,2) , `actual_d` decimal(10,2) , `base_bid` decimal(10,2) , `terms_version` varchar(8) , `site_phone` varchar(16) , `booking_type` varchar(12) , `bid_type` varchar(12) , `move_in_actual` date , `npv` decimal(10,2) , `review_status` varchar(60) , `canceled` smallint , `resale_rate` decimal(6,2) , `monthly_insurance` decimal(6,2) , `aaa_member_number` varchar(16) , `modified_dtm` timestamp , `session_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-17/1531805363'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.master_sparefoot_listing_rent_submission" ] - hive_path: s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-17/1531805363
- id: 179717
- processed: 1
- raw_data:
{ "aaa_member_number": 80, "actual_d": 68, "actual_w": 67, "affiliate_id": 17, "api_cust_id": 32, "api_lead_id": 52, "api_unit_id": 2, "auto_state": 34, "base_bid": 69, "bid_amount": 12, "bid_type": 73, "booking_agent_id": 40, "booking_first_name": 6, "booking_last_name": 7, "booking_phone": 8, "booking_state": 33, "booking_type": 72, "booking_widget": 43, "call_center": 39, "call_center_moved_in": 47, "call_center_notes": 41, "caller_id_phone": 66, "canceled": 77, "centershift_account_id": 57, "city": 28, "commission": 48, "complete": 20, "confirmation_code": 15, "contacted": 45, "corrected": 50, "country": 30, "customer_notes": 64, "deposit_paid": 11, "dispute_reason": 42, "e_visit_id": 46, "facility_tenant_id": 37, "free": 60, "hosted_website": 44, "hot_lead": 51, "invoice_id": 63, "listing_avail_id": 1, "listing_avail_space_id": 0, "listing_want_id": 4, "match_reasons": 35, "match_score": 36, "modified_dtm": 81, "monthly_insurance": 79, "move_in": 13, "move_in_actual": 74, "move_in_original": 14, "move_out": 61, "npv": 75, "payout_batch_id": 49, "phone_changed_number": 55, "phone_facility_transfer": 54, "phone_status": 56, "phone_verified": 53, "price": 10, "promo": 26, "read": 21, "rebate_processed": 65, "referrer_id": 16, "resale_rate": 78, "review_status": 76, "search_weight_id": 59, "search_weight_test_id": 58, "session_id": 82, "site_id": 18, "site_phone": 71, "size_d": 24, "size_h": 25, "size_w": 23, "state": 29, "statement_id": 38, "street_address": 27, "terms_version": 70, "timestamp": 9, "total_paid": 62, "traffic_source_id": 19, "unit_number": 3, "user_id": 5, "visit_id": 22, "zip": 31 } - schema_attributes:
{ "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" } - schema_name_id: 503
- schema_scan_id: 1416666
- updated: 2018-07-17 00:29:41
-
Version 179608
- created: 2018-07-16 00:31:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.master_sparefoot_listing_rent_submission`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.master_sparefoot_listing_rent_submission`\n(\n `listing_avail_space_id` int , `listing_avail_id` int , `api_unit_id` varchar(32) , `unit_number` varchar(32) , `listing_want_id` int , `user_id` int , `booking_first_name` varchar(128) , `booking_last_name` varchar(128) , `booking_phone` varchar(16) , `timestamp` timestamp , `price` decimal(10,2) , `deposit_paid` decimal(10,2) , `bid_amount` decimal(10,2) , `move_in` date , `move_in_original` date , `confirmation_code` varchar(32) , `referrer_id` int , `affiliate_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `complete` smallint , `read` smallint , `visit_id` varchar(32) , `size_w` decimal(10,2) , `size_d` decimal(10,2) , `size_h` decimal(10,2) , `promo` string , `street_address` varchar(255) , `city` varchar(40) , `state` char(2) , `country` char(2) , `zip` varchar(10) , `api_cust_id` varchar(32) , `booking_state` varchar(20) , `auto_state` varchar(60) , `match_reasons` string , `match_score` decimal , `facility_tenant_id` varchar(32) , `statement_id` int , `call_center` smallint , `booking_agent_id` int , `call_center_notes` string , `dispute_reason` string , `booking_widget` smallint , `hosted_website` smallint , `contacted` smallint , `e_visit_id` varchar(32) , `call_center_moved_in` smallint , `commission` decimal(8,2) , `payout_batch_id` int , `corrected` smallint , `hot_lead` smallint , `api_lead_id` varchar(36) , `phone_verified` smallint , `phone_facility_transfer` smallint , `phone_changed_number` smallint , `phone_status` varchar(60) , `centershift_account_id` varchar(10) , `search_weight_test_id` int , `search_weight_id` int , `free` smallint , `move_out` date , `total_paid` decimal(10,2) , `invoice_id` int , `customer_notes` string , `rebate_processed` smallint , `caller_id_phone` varchar(16) , `actual_w` decimal(10,2) , `actual_d` decimal(10,2) , `base_bid` decimal(10,2) , `terms_version` varchar(8) , `site_phone` varchar(16) , `booking_type` varchar(12) , `bid_type` varchar(12) , `move_in_actual` date , `npv` decimal(10,2) , `review_status` varchar(60) , `canceled` smallint , `resale_rate` decimal(6,2) , `monthly_insurance` decimal(6,2) , `aaa_member_number` varchar(16) , `modified_dtm` timestamp , `session_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-16/1531719078'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.master_sparefoot_listing_rent_submission" ] - hive_path: s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-16/1531719078
- id: 179608
- processed: 1
- raw_data:
{ "aaa_member_number": 80, "actual_d": 68, "actual_w": 67, "affiliate_id": 17, "api_cust_id": 32, "api_lead_id": 52, "api_unit_id": 2, "auto_state": 34, "base_bid": 69, "bid_amount": 12, "bid_type": 73, "booking_agent_id": 40, "booking_first_name": 6, "booking_last_name": 7, "booking_phone": 8, "booking_state": 33, "booking_type": 72, "booking_widget": 43, "call_center": 39, "call_center_moved_in": 47, "call_center_notes": 41, "caller_id_phone": 66, "canceled": 77, "centershift_account_id": 57, "city": 28, "commission": 48, "complete": 20, "confirmation_code": 15, "contacted": 45, "corrected": 50, "country": 30, "customer_notes": 64, "deposit_paid": 11, "dispute_reason": 42, "e_visit_id": 46, "facility_tenant_id": 37, "free": 60, "hosted_website": 44, "hot_lead": 51, "invoice_id": 63, "listing_avail_id": 1, "listing_avail_space_id": 0, "listing_want_id": 4, "match_reasons": 35, "match_score": 36, "modified_dtm": 81, "monthly_insurance": 79, "move_in": 13, "move_in_actual": 74, "move_in_original": 14, "move_out": 61, "npv": 75, "payout_batch_id": 49, "phone_changed_number": 55, "phone_facility_transfer": 54, "phone_status": 56, "phone_verified": 53, "price": 10, "promo": 26, "read": 21, "rebate_processed": 65, "referrer_id": 16, "resale_rate": 78, "review_status": 76, "search_weight_id": 59, "search_weight_test_id": 58, "session_id": 82, "site_id": 18, "site_phone": 71, "size_d": 24, "size_h": 25, "size_w": 23, "state": 29, "statement_id": 38, "street_address": 27, "terms_version": 70, "timestamp": 9, "total_paid": 62, "traffic_source_id": 19, "unit_number": 3, "user_id": 5, "visit_id": 22, "zip": 31 } - schema_attributes:
{ "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" } - schema_name_id: 503
- schema_scan_id: 1414677
- updated: 2018-07-16 00:31:36
-
Version 179510
- created: 2018-07-15 00:24:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.master_sparefoot_listing_rent_submission`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.master_sparefoot_listing_rent_submission`\n(\n `listing_avail_space_id` int , `listing_avail_id` int , `api_unit_id` varchar(32) , `unit_number` varchar(32) , `listing_want_id` int , `user_id` int , `booking_first_name` varchar(128) , `booking_last_name` varchar(128) , `booking_phone` varchar(16) , `timestamp` timestamp , `price` decimal(10,2) , `deposit_paid` decimal(10,2) , `bid_amount` decimal(10,2) , `move_in` date , `move_in_original` date , `confirmation_code` varchar(32) , `referrer_id` int , `affiliate_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `complete` smallint , `read` smallint , `visit_id` varchar(32) , `size_w` decimal(10,2) , `size_d` decimal(10,2) , `size_h` decimal(10,2) , `promo` string , `street_address` varchar(255) , `city` varchar(40) , `state` char(2) , `country` char(2) , `zip` varchar(10) , `api_cust_id` varchar(32) , `booking_state` varchar(20) , `auto_state` varchar(60) , `match_reasons` string , `match_score` decimal , `facility_tenant_id` varchar(32) , `statement_id` int , `call_center` smallint , `booking_agent_id` int , `call_center_notes` string , `dispute_reason` string , `booking_widget` smallint , `hosted_website` smallint , `contacted` smallint , `e_visit_id` varchar(32) , `call_center_moved_in` smallint , `commission` decimal(8,2) , `payout_batch_id` int , `corrected` smallint , `hot_lead` smallint , `api_lead_id` varchar(36) , `phone_verified` smallint , `phone_facility_transfer` smallint , `phone_changed_number` smallint , `phone_status` varchar(60) , `centershift_account_id` varchar(10) , `search_weight_test_id` int , `search_weight_id` int , `free` smallint , `move_out` date , `total_paid` decimal(10,2) , `invoice_id` int , `customer_notes` string , `rebate_processed` smallint , `caller_id_phone` varchar(16) , `actual_w` decimal(10,2) , `actual_d` decimal(10,2) , `base_bid` decimal(10,2) , `terms_version` varchar(8) , `site_phone` varchar(16) , `booking_type` varchar(12) , `bid_type` varchar(12) , `move_in_actual` date , `npv` decimal(10,2) , `review_status` varchar(60) , `canceled` smallint , `resale_rate` decimal(6,2) , `monthly_insurance` decimal(6,2) , `aaa_member_number` varchar(16) , `modified_dtm` timestamp , `session_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-15/1531632249'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_rds.master_sparefoot_listing_rent_submission" ] - hive_path: s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-15/1531632249
- id: 179510
- processed: 1
- raw_data:
{ "aaa_member_number": 80, "actual_d": 68, "actual_w": 67, "affiliate_id": 17, "api_cust_id": 32, "api_lead_id": 52, "api_unit_id": 2, "auto_state": 34, "base_bid": 69, "bid_amount": 12, "bid_type": 73, "booking_agent_id": 40, "booking_first_name": 6, "booking_last_name": 7, "booking_phone": 8, "booking_state": 33, "booking_type": 72, "booking_widget": 43, "call_center": 39, "call_center_moved_in": 47, "call_center_notes": 41, "caller_id_phone": 66, "canceled": 77, "centershift_account_id": 57, "city": 28, "commission": 48, "complete": 20, "confirmation_code": 15, "contacted": 45, "corrected": 50, "country": 30, "customer_notes": 64, "deposit_paid": 11, "dispute_reason": 42, "e_visit_id": 46, "facility_tenant_id": 37, "free": 60, "hosted_website": 44, "hot_lead": 51, "invoice_id": 63, "listing_avail_id": 1, "listing_avail_space_id": 0, "listing_want_id": 4, "match_reasons": 35, "match_score": 36, "modified_dtm": 81, "monthly_insurance": 79, "move_in": 13, "move_in_actual": 74, "move_in_original": 14, "move_out": 61, "npv": 75, "payout_batch_id": 49, "phone_changed_number": 55, "phone_facility_transfer": 54, "phone_status": 56, "phone_verified": 53, "price": 10, "promo": 26, "read": 21, "rebate_processed": 65, "referrer_id": 16, "resale_rate": 78, "review_status": 76, "search_weight_id": 59, "search_weight_test_id": 58, "session_id": 82, "site_id": 18, "site_phone": 71, "size_d": 24, "size_h": 25, "size_w": 23, "state": 29, "statement_id": 38, "street_address": 27, "terms_version": 70, "timestamp": 9, "total_paid": 62, "traffic_source_id": 19, "unit_number": 3, "user_id": 5, "visit_id": 22, "zip": 31 } - schema_attributes:
{ "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" } - schema_name_id: 503
- schema_scan_id: 1413873
- updated: 2018-07-15 00:24:36
Schema Scans: 3
Last at 2018-07-17 00:29:27
-
Scan 1416666
- duration: 0:00:17.102816
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 1416666
- payload:
{ "datatype_dict": { "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-master-stage", "hive_path": "s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-17/1531805363", "key": "raw/sparefoot_listing_rent_submission/2018-07-17/1531805363/split.sparefoot.listing_rent_submission.000000.dat.gz" }, "schema": { "name": "sfdl_stage_rds.master_sparefoot_listing_rent_submission", "type": "rds" } } - running: False
- schema_name_id: 503
- start_time: 2018-07-17 00:29:27
- success: True
-
Scan 1414677
- duration: 0:00:18.089380
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 1414677
- payload:
{ "datatype_dict": { "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-master-stage", "hive_path": "s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-16/1531719078", "key": "raw/sparefoot_listing_rent_submission/2018-07-16/1531719078/split.sparefoot.listing_rent_submission.000000.dat.gz" }, "schema": { "name": "sfdl_stage_rds.master_sparefoot_listing_rent_submission", "type": "rds" } } - running: False
- schema_name_id: 503
- start_time: 2018-07-16 00:31:21
- success: True
-
Scan 1413873
- duration: 0:00:26.969859
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 1413873
- payload:
{ "datatype_dict": { "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-master-stage", "hive_path": "s3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-15/1531632249", "key": "raw/sparefoot_listing_rent_submission/2018-07-15/1531632249/split.sparefoot.listing_rent_submission.000000.dat.gz" }, "schema": { "name": "sfdl_stage_rds.master_sparefoot_listing_rent_submission", "type": "rds" } } - running: False
- schema_name_id: 503
- start_time: 2018-07-15 00:24:12
- success: True
- attributes:
{ "aaa_member_number": "varchar(16)", "actual_d": "decimal(10,2)", "actual_w": "decimal(10,2)", "affiliate_id": "varchar(32)", "api_cust_id": "varchar(32)", "api_lead_id": "varchar(36)", "api_unit_id": "varchar(32)", "auto_state": "varchar(60)", "base_bid": "decimal(10,2)", "bid_amount": "decimal(10,2)", "bid_type": "varchar(12)", "booking_agent_id": "int", "booking_first_name": "varchar(128)", "booking_last_name": "varchar(128)", "booking_phone": "varchar(16)", "booking_state": "varchar(20)", "booking_type": "varchar(12)", "booking_widget": "smallint", "call_center": "smallint", "call_center_moved_in": "smallint", "call_center_notes": "string", "caller_id_phone": "varchar(16)", "canceled": "smallint", "centershift_account_id": "varchar(10)", "city": "varchar(40)", "commission": "decimal(8,2)", "complete": "smallint", "confirmation_code": "varchar(32)", "contacted": "smallint", "corrected": "smallint", "country": "char(2)", "customer_notes": "string", "deposit_paid": "decimal(10,2) ", "dispute_reason": "string", "e_visit_id": "varchar(32)", "facility_tenant_id": "varchar(32)", "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": "decimal", "modified_dtm": "timestamp", "monthly_insurance": "decimal(6,2)", "move_in": "date", "move_in_actual": "date", "move_in_original": "date", "move_out": "date", "npv": "decimal(10,2)", "payout_batch_id": "int", "phone_changed_number": "smallint", "phone_facility_transfer": "smallint", "phone_status": "varchar(60)", "phone_verified": "smallint", "price": "decimal(10,2) ", "promo": "string", "read": "smallint", "rebate_processed": "smallint", "referrer_id": "int", "resale_rate": "decimal(6,2)", "review_status": "varchar(60)", "search_weight_id": "int", "search_weight_test_id": "int", "session_id": "int", "site_id": "int", "site_phone": "varchar(16)", "size_d": "decimal(10,2)", "size_h": "decimal(10,2)", "size_w": "decimal(10,2)", "state": "char(2)", "statement_id": "int", "street_address": "varchar(255)", "terms_version": "varchar(8)", "timestamp": "timestamp", "total_paid": "decimal(10,2) ", "traffic_source_id": "varchar(255)", "unit_number": "varchar(32)", "user_id": "int", "visit_id": "varchar(32)", "zip": "varchar(10)" } - created: 2018-07-17 00:29:30
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.master_sparefoot_listing_rent_submission`\n(\n `listing_avail_space_id` int , `listing_avail_id` int , `api_unit_id` varchar(32) , `unit_number` varchar(32) , `listing_want_id` int , `user_id` int , `booking_first_name` varchar(128) , `booking_last_name` varchar(128) , `booking_phone` varchar(16) , `timestamp` timestamp , `price` decimal(10,2) , `deposit_paid` decimal(10,2) , `bid_amount` decimal(10,2) , `move_in` date , `move_in_original` date , `confirmation_code` varchar(32) , `referrer_id` int , `affiliate_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `complete` smallint , `read` smallint , `visit_id` varchar(32) , `size_w` decimal(10,2) , `size_d` decimal(10,2) , `size_h` decimal(10,2) , `promo` string , `street_address` varchar(255) , `city` varchar(40) , `state` char(2) , `country` char(2) , `zip` varchar(10) , `api_cust_id` varchar(32) , `booking_state` varchar(20) , `auto_state` varchar(60) , `match_reasons` string , `match_score` decimal , `facility_tenant_id` varchar(32) , `statement_id` int , `call_center` smallint , `booking_agent_id` int , `call_center_notes` string , `dispute_reason` string , `booking_widget` smallint , `hosted_website` smallint , `contacted` smallint , `e_visit_id` varchar(32) , `call_center_moved_in` smallint , `commission` decimal(8,2) , `payout_batch_id` int , `corrected` smallint , `hot_lead` smallint , `api_lead_id` varchar(36) , `phone_verified` smallint , `phone_facility_transfer` smallint , `phone_changed_number` smallint , `phone_status` varchar(60) , `centershift_account_id` varchar(10) , `search_weight_test_id` int , `search_weight_id` int , `free` smallint , `move_out` date , `total_paid` decimal(10,2) , `invoice_id` int , `customer_notes` string , `rebate_processed` smallint , `caller_id_phone` varchar(16) , `actual_w` decimal(10,2) , `actual_d` decimal(10,2) , `base_bid` decimal(10,2) , `terms_version` varchar(8) , `site_phone` varchar(16) , `booking_type` varchar(12) , `bid_type` varchar(12) , `move_in_actual` date , `npv` decimal(10,2) , `review_status` varchar(60) , `canceled` smallint , `resale_rate` decimal(6,2) , `monthly_insurance` decimal(6,2) , `aaa_member_number` varchar(16) , `modified_dtm` timestamp , `session_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-17/1531805363'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.master_sparefoot_listing_rent_submission`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.master_sparefoot_listing_rent_submission" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2018-05-02 16:23:34",
"disabled": false,
"format": "raw",
"id": 503,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_rds",
"table": "master_sparefoot_listing_rent_submission"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"aaa_member_number": "varchar(16)",
"actual_d": "decimal(10,2)",
"actual_w": "decimal(10,2)",
"affiliate_id": "varchar(32)",
"api_cust_id": "varchar(32)",
"api_lead_id": "varchar(36)",
"api_unit_id": "varchar(32)",
"auto_state": "varchar(60)",
"base_bid": "decimal(10,2)",
"bid_amount": "decimal(10,2)",
"bid_type": "varchar(12)",
"booking_agent_id": "int",
"booking_first_name": "varchar(128)",
"booking_last_name": "varchar(128)",
"booking_phone": "varchar(16)",
"booking_state": "varchar(20)",
"booking_type": "varchar(12)",
"booking_widget": "smallint",
"call_center": "smallint",
"call_center_moved_in": "smallint",
"call_center_notes": "string",
"caller_id_phone": "varchar(16)",
"canceled": "smallint",
"centershift_account_id": "varchar(10)",
"city": "varchar(40)",
"commission": "decimal(8,2)",
"complete": "smallint",
"confirmation_code": "varchar(32)",
"contacted": "smallint",
"corrected": "smallint",
"country": "char(2)",
"customer_notes": "string",
"deposit_paid": "decimal(10,2) ",
"dispute_reason": "string",
"e_visit_id": "varchar(32)",
"facility_tenant_id": "varchar(32)",
"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": "decimal",
"modified_dtm": "timestamp",
"monthly_insurance": "decimal(6,2)",
"move_in": "date",
"move_in_actual": "date",
"move_in_original": "date",
"move_out": "date",
"npv": "decimal(10,2)",
"payout_batch_id": "int",
"phone_changed_number": "smallint",
"phone_facility_transfer": "smallint",
"phone_status": "varchar(60)",
"phone_verified": "smallint",
"price": "decimal(10,2) ",
"promo": "string",
"read": "smallint",
"rebate_processed": "smallint",
"referrer_id": "int",
"resale_rate": "decimal(6,2)",
"review_status": "varchar(60)",
"search_weight_id": "int",
"search_weight_test_id": "int",
"session_id": "int",
"site_id": "int",
"site_phone": "varchar(16)",
"size_d": "decimal(10,2)",
"size_h": "decimal(10,2)",
"size_w": "decimal(10,2)",
"state": "char(2)",
"statement_id": "int",
"street_address": "varchar(255)",
"terms_version": "varchar(8)",
"timestamp": "timestamp",
"total_paid": "decimal(10,2) ",
"traffic_source_id": "varchar(255)",
"unit_number": "varchar(32)",
"user_id": "int",
"visit_id": "varchar(32)",
"zip": "varchar(10)"
},
"created": "2018-07-17 00:29:30",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.master_sparefoot_listing_rent_submission`\n(\n `listing_avail_space_id` int , `listing_avail_id` int , `api_unit_id` varchar(32) , `unit_number` varchar(32) , `listing_want_id` int , `user_id` int , `booking_first_name` varchar(128) , `booking_last_name` varchar(128) , `booking_phone` varchar(16) , `timestamp` timestamp , `price` decimal(10,2) , `deposit_paid` decimal(10,2) , `bid_amount` decimal(10,2) , `move_in` date , `move_in_original` date , `confirmation_code` varchar(32) , `referrer_id` int , `affiliate_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `complete` smallint , `read` smallint , `visit_id` varchar(32) , `size_w` decimal(10,2) , `size_d` decimal(10,2) , `size_h` decimal(10,2) , `promo` string , `street_address` varchar(255) , `city` varchar(40) , `state` char(2) , `country` char(2) , `zip` varchar(10) , `api_cust_id` varchar(32) , `booking_state` varchar(20) , `auto_state` varchar(60) , `match_reasons` string , `match_score` decimal , `facility_tenant_id` varchar(32) , `statement_id` int , `call_center` smallint , `booking_agent_id` int , `call_center_notes` string , `dispute_reason` string , `booking_widget` smallint , `hosted_website` smallint , `contacted` smallint , `e_visit_id` varchar(32) , `call_center_moved_in` smallint , `commission` decimal(8,2) , `payout_batch_id` int , `corrected` smallint , `hot_lead` smallint , `api_lead_id` varchar(36) , `phone_verified` smallint , `phone_facility_transfer` smallint , `phone_changed_number` smallint , `phone_status` varchar(60) , `centershift_account_id` varchar(10) , `search_weight_test_id` int , `search_weight_id` int , `free` smallint , `move_out` date , `total_paid` decimal(10,2) , `invoice_id` int , `customer_notes` string , `rebate_processed` smallint , `caller_id_phone` varchar(16) , `actual_w` decimal(10,2) , `actual_d` decimal(10,2) , `base_bid` decimal(10,2) , `terms_version` varchar(8) , `site_phone` varchar(16) , `booking_type` varchar(12) , `bid_type` varchar(12) , `move_in_actual` date , `npv` decimal(10,2) , `review_status` varchar(60) , `canceled` smallint , `resale_rate` decimal(6,2) , `monthly_insurance` decimal(6,2) , `aaa_member_number` varchar(16) , `modified_dtm` timestamp , `session_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-master-stage/raw/sparefoot_listing_rent_submission/2018-07-17/1531805363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.master_sparefoot_listing_rent_submission`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.master_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"
}
}