Schema Info

Schema Name: sfdl_stage_rds.ess_esscore_sites
  • created: 2021-07-12 13:44:02
  • disabled: False
  • format: raw
  • id: 1119
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_rds",
    "table": "ess_esscore_sites"
}
  • type: rds
Schema Versions: 4
    • created: 2023-06-15 18:30:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `easy_storage_payments_status`  int , `transferred_ownership_at`  timestamp , `process_billing_at`  timestamp , `parafin_activated_at`  timestamp , `notify_at`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2023-06-15/1686871845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
]
    • hive_path: s3://sfdl-rds-ess-stage/raw/esscore_sites/2023-06-15/1686871845
    • id: 550919
    • processed: 1
    • raw_data: 
      {
    "account_number": 23,
    "ach_enabled": 59,
    "additional_deposits_enabled": 43,
    "address": 2,
    "agreed_to_terms_at": 109,
    "allow_duplicate_gate_keys": 53,
    "alt_phone": 8,
    "american_express_enabled": 63,
    "analytics_code": 33,
    "api_key": 50,
    "auto_approve_rentals": 76,
    "billing_period": 16,
    "blue_moon_credentials": 44,
    "canceled_at": 29,
    "changed_gate_code_report_url": 75,
    "city": 3,
    "company_id": 120,
    "country": 115,
    "created_at": 12,
    "creator_id": 14,
    "customer_rental_prorating": 42,
    "customers_can_edit_payment_accounts": 55,
    "customers_can_prepay": 39,
    "customers_can_schedule_move_outs": 98,
    "customers_updated_at": 92,
    "discover_enabled": 62,
    "domain": 9,
    "easy_storage_payments_status": 123,
    "email": 6,
    "email_manager_lockout_reports": 105,
    "email_manager_on_charge": 24,
    "email_manager_on_customer_lockout_removal": 52,
    "email_manager_on_move_in": 64,
    "email_owner_on_credit_without_payment": 48,
    "facebook_url": 66,
    "favicon": 73,
    "footer_image": 96,
    "footer_image_link": 97,
    "form_updated_at": 119,
    "form_updater_id": 118,
    "gate_account_name": 35,
    "gate_company": 51,
    "gate_key_enabled": 17,
    "gate_keypad_zone": 32,
    "gate_security_level": 36,
    "gate_time_zone": 31,
    "gateway_credentials": 18,
    "gateway_name": 20,
    "google_plus_url": 65,
    "has_card_swiper": 40,
    "home_page_dropdown_name": 77,
    "id": 0,
    "iframe_urls": 89,
    "instagram_url": 69,
    "latitude": 110,
    "linkedin_url": 68,
    "locale": 34,
    "login_button_text": 80,
    "logo": 74,
    "logo_size": 100,
    "longitude": 111,
    "mastercard_enabled": 60,
    "move_out_days_restriction": 107,
    "name": 1,
    "new_renter_instructions": 21,
    "notes": 11,
    "notifications_email": 19,
    "notify_at": 127,
    "office_hours": 70,
    "parafin_activated_at": 126,
    "payrix_account_id": 122,
    "phone": 7,
    "physical_address": 25,
    "physical_city": 26,
    "physical_state": 27,
    "physical_zip": 28,
    "primary_theme_color": 71,
    "process_billing_at": 125,
    "prodatakey": 90,
    "proposal_archived_at": 117,
    "proposal_signed_at": 121,
    "quickbooks_credentials": 83,
    "quickbooks_file_id": 57,
    "quickbooks_owner_id": 56,
    "quickbooks_password_hash": 38,
    "quickbooks_qbo_downloaded_at": 84,
    "quickbooks_settings": 81,
    "rate_management_settings": 108,
    "reminder_period": 30,
    "rental_prorating_option_default": 101,
    "reply_to_email": 58,
    "require_approval_for_automatic_lock_out_removal": 54,
    "require_approval_for_manual_lock_out_removal": 86,
    "review_url": 87,
    "routing_number": 22,
    "save_unpaid_customer_rentals": 41,
    "secondary_theme_color": 72,
    "send_invoice_site_reminder": 37,
    "sent_lock_out_report_at": 85,
    "settings": 106,
    "site_map_height": 46,
    "site_map_is_public": 47,
    "site_map_width": 45,
    "sparefoot_enabled": 103,
    "state": 4,
    "sticky_header": 99,
    "storsmart_enabled": 79,
    "storsmart_settings": 104,
    "stripe_account_id": 116,
    "subdomain": 10,
    "tenant_protection_addendum": 112,
    "time_zone": 91,
    "transferred_ownership_at": 124,
    "twilio_sms_phone_number": 113,
    "twitter_url": 67,
    "two_way_texting_enabled_at": 114,
    "txt_owner_on_credit_without_payment": 49,
    "txt_owner_on_new_rental": 78,
    "unit_status_colors": 82,
    "units_updated_at": 93,
    "updated_at": 13,
    "updater_id": 15,
    "visa_enabled": 61,
    "website_menu_font_size": 88,
    "website_settings": 102,
    "yelp_url": 95,
    "youtube_url": 94,
    "zip": 5
}
    • schema_attributes: 
      {
    "account_number": "varchar(255)",
    "ach_enabled": "smallint",
    "additional_deposits_enabled": "smallint",
    "address": "varchar(255)",
    "agreed_to_terms_at": "timestamp",
    "allow_duplicate_gate_keys": "smallint",
    "alt_phone": "varchar(255)",
    "american_express_enabled": "smallint",
    "analytics_code": "string",
    "api_key": "varchar(255)",
    "auto_approve_rentals": "smallint",
    "billing_period": "int",
    "blue_moon_credentials": "string",
    "canceled_at": "timestamp",
    "changed_gate_code_report_url": "varchar(255)",
    "city": "varchar(255)",
    "company_id": "bigint",
    "country": "varchar(255)",
    "created_at": "timestamp",
    "creator_id": "int",
    "customer_rental_prorating": "varchar(255)",
    "customers_can_edit_payment_accounts": "smallint",
    "customers_can_prepay": "smallint",
    "customers_can_schedule_move_outs": "smallint",
    "customers_updated_at": "timestamp",
    "discover_enabled": "smallint",
    "domain": "varchar(255)",
    "easy_storage_payments_status": "int",
    "email": "varchar(255)",
    "email_manager_lockout_reports": "smallint",
    "email_manager_on_charge": "smallint",
    "email_manager_on_customer_lockout_removal": "smallint",
    "email_manager_on_move_in": "smallint",
    "email_owner_on_credit_without_payment": "smallint",
    "facebook_url": "varchar(255)",
    "favicon": "varchar(255)",
    "footer_image": "varchar(255)",
    "footer_image_link": "varchar(255)",
    "form_updated_at": "timestamp",
    "form_updater_id": "int",
    "gate_account_name": "varchar(255)",
    "gate_company": "varchar(255)",
    "gate_key_enabled": "smallint",
    "gate_keypad_zone": "int",
    "gate_security_level": "varchar(255)",
    "gate_time_zone": "int",
    "gateway_credentials": "string",
    "gateway_name": "varchar(255)",
    "google_plus_url": "varchar(255)",
    "has_card_swiper": "smallint",
    "home_page_dropdown_name": "varchar(255)",
    "id": "int",
    "iframe_urls": "string",
    "instagram_url": "varchar(255)",
    "latitude": "decimal(9,6)",
    "linkedin_url": "varchar(255)",
    "locale": "varchar(255)",
    "login_button_text": "varchar(255)",
    "logo": "varchar(255)",
    "logo_size": "varchar(255)",
    "longitude": "decimal(9,6)",
    "mastercard_enabled": "smallint",
    "move_out_days_restriction": "int",
    "name": "varchar(255)",
    "new_renter_instructions": "string",
    "notes": "string",
    "notifications_email": "varchar(255)",
    "notify_at": "timestamp",
    "office_hours": "string",
    "parafin_activated_at": "timestamp",
    "payrix_account_id": "bigint",
    "phone": "varchar(255)",
    "physical_address": "varchar(255)",
    "physical_city": "varchar(255)",
    "physical_state": "varchar(255)",
    "physical_zip": "varchar(255)",
    "primary_theme_color": "varchar(255)",
    "process_billing_at": "timestamp",
    "prodatakey": "string",
    "proposal_archived_at": "timestamp",
    "proposal_signed_at": "timestamp",
    "quickbooks_credentials": "string",
    "quickbooks_file_id": "varchar(255)",
    "quickbooks_owner_id": "varchar(255)",
    "quickbooks_password_hash": "varchar(255)",
    "quickbooks_qbo_downloaded_at": "timestamp",
    "quickbooks_settings": "string",
    "rate_management_settings": "string",
    "reminder_period": "int",
    "rent_rate_management_reminders_kind": "string",
    "rental_prorating_option_default": "varchar(255)",
    "reply_to_email": "varchar(255)",
    "require_approval_for_automatic_lock_out_removal": "smallint",
    "require_approval_for_manual_lock_out_removal": "smallint",
    "review_url": "varchar(255)",
    "routing_number": "varchar(255)",
    "save_unpaid_customer_rentals": "smallint",
    "secondary_theme_color": "varchar(255)",
    "send_invoice_site_reminder": "smallint",
    "sent_lock_out_report_at": "timestamp",
    "settings": "string",
    "site_map_height": "int",
    "site_map_is_public": "smallint",
    "site_map_width": "int",
    "sparefoot_enabled": "smallint",
    "sparefoot_facility_id": "string",
    "state": "varchar(255)",
    "sticky_header": "smallint",
    "storsmart_enabled": "smallint",
    "storsmart_settings": "string",
    "stripe_account_id": "bigint",
    "subdomain": "varchar(255)",
    "tenant_protection_addendum": "string",
    "time_zone": "varchar(255)",
    "transferred_ownership_at": "timestamp",
    "twilio_sms_phone_number": "varchar(255)",
    "twitter_url": "varchar(255)",
    "two_way_texting_enabled_at": "timestamp",
    "txt_owner_on_credit_without_payment": "smallint",
    "txt_owner_on_new_rental": "smallint",
    "unit_status_colors": "string",
    "units_updated_at": "timestamp",
    "updated_at": "timestamp",
    "updater_id": "int",
    "visa_enabled": "smallint",
    "website_menu_font_size": "int",
    "website_settings": "string",
    "yelp_url": "varchar(255)",
    "youtube_url": "varchar(255)",
    "zip": "varchar(255)"
}
    • schema_name_id: 1119
    • schema_scan_id: 4963391
    • updated: 2023-06-15 18:31:01
    • created: 2022-06-22 20:49:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `rent_rate_management_reminders_kind`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `easy_storage_payments_status`  int , `sparefoot_facility_id`  string , `transferred_ownership_at`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-23/1655948948'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
]
    • hive_path: s3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-23/1655948948
    • id: 402913
    • processed: 1
    • raw_data: 
      {
    "account_number": 23,
    "ach_enabled": 59,
    "additional_deposits_enabled": 43,
    "address": 2,
    "agreed_to_terms_at": 109,
    "allow_duplicate_gate_keys": 53,
    "alt_phone": 8,
    "american_express_enabled": 63,
    "analytics_code": 33,
    "api_key": 50,
    "auto_approve_rentals": 76,
    "billing_period": 16,
    "blue_moon_credentials": 44,
    "canceled_at": 29,
    "changed_gate_code_report_url": 75,
    "city": 3,
    "company_id": 120,
    "country": 115,
    "created_at": 12,
    "creator_id": 14,
    "customer_rental_prorating": 42,
    "customers_can_edit_payment_accounts": 55,
    "customers_can_prepay": 39,
    "customers_can_schedule_move_outs": 98,
    "customers_updated_at": 92,
    "discover_enabled": 62,
    "domain": 9,
    "easy_storage_payments_status": 123,
    "email": 6,
    "email_manager_lockout_reports": 105,
    "email_manager_on_charge": 24,
    "email_manager_on_customer_lockout_removal": 52,
    "email_manager_on_move_in": 64,
    "email_owner_on_credit_without_payment": 48,
    "facebook_url": 66,
    "favicon": 73,
    "footer_image": 96,
    "footer_image_link": 97,
    "form_updated_at": 119,
    "form_updater_id": 118,
    "gate_account_name": 35,
    "gate_company": 51,
    "gate_key_enabled": 17,
    "gate_keypad_zone": 32,
    "gate_security_level": 36,
    "gate_time_zone": 31,
    "gateway_credentials": 18,
    "gateway_name": 20,
    "google_plus_url": 65,
    "has_card_swiper": 40,
    "home_page_dropdown_name": 77,
    "id": 0,
    "iframe_urls": 89,
    "instagram_url": 69,
    "latitude": 110,
    "linkedin_url": 68,
    "locale": 34,
    "login_button_text": 80,
    "logo": 74,
    "logo_size": 100,
    "longitude": 111,
    "mastercard_enabled": 60,
    "move_out_days_restriction": 107,
    "name": 1,
    "new_renter_instructions": 21,
    "notes": 11,
    "notifications_email": 19,
    "office_hours": 70,
    "payrix_account_id": 122,
    "phone": 7,
    "physical_address": 25,
    "physical_city": 26,
    "physical_state": 27,
    "physical_zip": 28,
    "primary_theme_color": 71,
    "prodatakey": 90,
    "proposal_archived_at": 117,
    "proposal_signed_at": 121,
    "quickbooks_credentials": 83,
    "quickbooks_file_id": 57,
    "quickbooks_owner_id": 56,
    "quickbooks_password_hash": 38,
    "quickbooks_qbo_downloaded_at": 84,
    "quickbooks_settings": 81,
    "rate_management_settings": 108,
    "reminder_period": 30,
    "rental_prorating_option_default": 101,
    "reply_to_email": 58,
    "require_approval_for_automatic_lock_out_removal": 54,
    "require_approval_for_manual_lock_out_removal": 86,
    "review_url": 87,
    "routing_number": 22,
    "save_unpaid_customer_rentals": 41,
    "secondary_theme_color": 72,
    "send_invoice_site_reminder": 37,
    "sent_lock_out_report_at": 85,
    "settings": 106,
    "site_map_height": 46,
    "site_map_is_public": 47,
    "site_map_width": 45,
    "sparefoot_enabled": 103,
    "state": 4,
    "sticky_header": 99,
    "storsmart_enabled": 79,
    "storsmart_settings": 104,
    "stripe_account_id": 116,
    "subdomain": 10,
    "tenant_protection_addendum": 112,
    "time_zone": 91,
    "transferred_ownership_at": 124,
    "twilio_sms_phone_number": 113,
    "twitter_url": 67,
    "two_way_texting_enabled_at": 114,
    "txt_owner_on_credit_without_payment": 49,
    "txt_owner_on_new_rental": 78,
    "unit_status_colors": 82,
    "units_updated_at": 93,
    "updated_at": 13,
    "updater_id": 15,
    "visa_enabled": 61,
    "website_menu_font_size": 88,
    "website_settings": 102,
    "yelp_url": 95,
    "youtube_url": 94,
    "zip": 5
}
    • schema_attributes: 
      {
    "account_number": "varchar(255)",
    "ach_enabled": "smallint",
    "additional_deposits_enabled": "smallint",
    "address": "varchar(255)",
    "agreed_to_terms_at": "timestamp",
    "allow_duplicate_gate_keys": "smallint",
    "alt_phone": "varchar(255)",
    "american_express_enabled": "smallint",
    "analytics_code": "string",
    "api_key": "varchar(255)",
    "auto_approve_rentals": "smallint",
    "billing_period": "int",
    "blue_moon_credentials": "string",
    "canceled_at": "timestamp",
    "changed_gate_code_report_url": "varchar(255)",
    "city": "varchar(255)",
    "company_id": "bigint",
    "country": "varchar(255)",
    "created_at": "timestamp",
    "creator_id": "int",
    "customer_rental_prorating": "varchar(255)",
    "customers_can_edit_payment_accounts": "smallint",
    "customers_can_prepay": "smallint",
    "customers_can_schedule_move_outs": "smallint",
    "customers_updated_at": "timestamp",
    "discover_enabled": "smallint",
    "domain": "varchar(255)",
    "easy_storage_payments_status": "int",
    "email": "varchar(255)",
    "email_manager_lockout_reports": "smallint",
    "email_manager_on_charge": "smallint",
    "email_manager_on_customer_lockout_removal": "smallint",
    "email_manager_on_move_in": "smallint",
    "email_owner_on_credit_without_payment": "smallint",
    "facebook_url": "varchar(255)",
    "favicon": "varchar(255)",
    "footer_image": "varchar(255)",
    "footer_image_link": "varchar(255)",
    "form_updated_at": "timestamp",
    "form_updater_id": "int",
    "gate_account_name": "varchar(255)",
    "gate_company": "varchar(255)",
    "gate_key_enabled": "smallint",
    "gate_keypad_zone": "int",
    "gate_security_level": "varchar(255)",
    "gate_time_zone": "int",
    "gateway_credentials": "string",
    "gateway_name": "varchar(255)",
    "google_plus_url": "varchar(255)",
    "has_card_swiper": "smallint",
    "home_page_dropdown_name": "varchar(255)",
    "id": "int",
    "iframe_urls": "string",
    "instagram_url": "varchar(255)",
    "latitude": "decimal(9,6)",
    "linkedin_url": "varchar(255)",
    "locale": "varchar(255)",
    "login_button_text": "varchar(255)",
    "logo": "varchar(255)",
    "logo_size": "varchar(255)",
    "longitude": "decimal(9,6)",
    "mastercard_enabled": "smallint",
    "move_out_days_restriction": "int",
    "name": "varchar(255)",
    "new_renter_instructions": "string",
    "notes": "string",
    "notifications_email": "varchar(255)",
    "office_hours": "string",
    "payrix_account_id": "bigint",
    "phone": "varchar(255)",
    "physical_address": "varchar(255)",
    "physical_city": "varchar(255)",
    "physical_state": "varchar(255)",
    "physical_zip": "varchar(255)",
    "primary_theme_color": "varchar(255)",
    "prodatakey": "string",
    "proposal_archived_at": "timestamp",
    "proposal_signed_at": "timestamp",
    "quickbooks_credentials": "string",
    "quickbooks_file_id": "varchar(255)",
    "quickbooks_owner_id": "varchar(255)",
    "quickbooks_password_hash": "varchar(255)",
    "quickbooks_qbo_downloaded_at": "timestamp",
    "quickbooks_settings": "string",
    "rate_management_settings": "string",
    "reminder_period": "int",
    "rent_rate_management_reminders_kind": "string",
    "rental_prorating_option_default": "varchar(255)",
    "reply_to_email": "varchar(255)",
    "require_approval_for_automatic_lock_out_removal": "smallint",
    "require_approval_for_manual_lock_out_removal": "smallint",
    "review_url": "varchar(255)",
    "routing_number": "varchar(255)",
    "save_unpaid_customer_rentals": "smallint",
    "secondary_theme_color": "varchar(255)",
    "send_invoice_site_reminder": "smallint",
    "sent_lock_out_report_at": "timestamp",
    "settings": "string",
    "site_map_height": "int",
    "site_map_is_public": "smallint",
    "site_map_width": "int",
    "sparefoot_enabled": "smallint",
    "sparefoot_facility_id": "string",
    "state": "varchar(255)",
    "sticky_header": "smallint",
    "storsmart_enabled": "smallint",
    "storsmart_settings": "string",
    "stripe_account_id": "bigint",
    "subdomain": "varchar(255)",
    "tenant_protection_addendum": "string",
    "time_zone": "varchar(255)",
    "transferred_ownership_at": "timestamp",
    "twilio_sms_phone_number": "varchar(255)",
    "twitter_url": "varchar(255)",
    "two_way_texting_enabled_at": "timestamp",
    "txt_owner_on_credit_without_payment": "smallint",
    "txt_owner_on_new_rental": "smallint",
    "unit_status_colors": "string",
    "units_updated_at": "timestamp",
    "updated_at": "timestamp",
    "updater_id": "int",
    "visa_enabled": "smallint",
    "website_menu_font_size": "int",
    "website_settings": "string",
    "yelp_url": "varchar(255)",
    "youtube_url": "varchar(255)",
    "zip": "varchar(255)"
}
    • schema_name_id: 1119
    • schema_scan_id: 3933496
    • updated: 2022-06-22 20:49:22
    • created: 2022-06-22 15:44:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `rent_rate_management_reminders_kind`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `easy_storage_payments_status`  int , `sparefoot_facility_id`  string , `transferred_ownership_at`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-22/1655930652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
]
    • hive_path: s3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-22/1655930652
    • id: 402813
    • processed: 1
    • raw_data: 
      {
    "account_number": 23,
    "ach_enabled": 59,
    "additional_deposits_enabled": 43,
    "address": 2,
    "agreed_to_terms_at": 109,
    "allow_duplicate_gate_keys": 53,
    "alt_phone": 8,
    "american_express_enabled": 63,
    "analytics_code": 33,
    "api_key": 50,
    "auto_approve_rentals": 76,
    "billing_period": 16,
    "blue_moon_credentials": 44,
    "canceled_at": 29,
    "changed_gate_code_report_url": 75,
    "city": 3,
    "company_id": 120,
    "country": 115,
    "created_at": 12,
    "creator_id": 14,
    "customer_rental_prorating": 42,
    "customers_can_edit_payment_accounts": 55,
    "customers_can_prepay": 39,
    "customers_can_schedule_move_outs": 98,
    "customers_updated_at": 92,
    "discover_enabled": 62,
    "domain": 9,
    "easy_storage_payments_status": 123,
    "email": 6,
    "email_manager_lockout_reports": 105,
    "email_manager_on_charge": 24,
    "email_manager_on_customer_lockout_removal": 52,
    "email_manager_on_move_in": 64,
    "email_owner_on_credit_without_payment": 48,
    "facebook_url": 66,
    "favicon": 73,
    "footer_image": 96,
    "footer_image_link": 97,
    "form_updated_at": 119,
    "form_updater_id": 118,
    "gate_account_name": 35,
    "gate_company": 51,
    "gate_key_enabled": 17,
    "gate_keypad_zone": 32,
    "gate_security_level": 36,
    "gate_time_zone": 31,
    "gateway_credentials": 18,
    "gateway_name": 20,
    "google_plus_url": 65,
    "has_card_swiper": 40,
    "home_page_dropdown_name": 77,
    "id": 0,
    "iframe_urls": 89,
    "instagram_url": 69,
    "latitude": 110,
    "linkedin_url": 68,
    "locale": 34,
    "login_button_text": 80,
    "logo": 74,
    "logo_size": 100,
    "longitude": 111,
    "mastercard_enabled": 60,
    "move_out_days_restriction": 107,
    "name": 1,
    "new_renter_instructions": 21,
    "notes": 11,
    "notifications_email": 19,
    "office_hours": 70,
    "payrix_account_id": 122,
    "phone": 7,
    "physical_address": 25,
    "physical_city": 26,
    "physical_state": 27,
    "physical_zip": 28,
    "primary_theme_color": 71,
    "prodatakey": 90,
    "proposal_archived_at": 117,
    "proposal_signed_at": 121,
    "quickbooks_credentials": 83,
    "quickbooks_file_id": 57,
    "quickbooks_owner_id": 56,
    "quickbooks_password_hash": 38,
    "quickbooks_qbo_downloaded_at": 84,
    "quickbooks_settings": 81,
    "rate_management_settings": 108,
    "reminder_period": 30,
    "rental_prorating_option_default": 101,
    "reply_to_email": 58,
    "require_approval_for_automatic_lock_out_removal": 54,
    "require_approval_for_manual_lock_out_removal": 86,
    "review_url": 87,
    "routing_number": 22,
    "save_unpaid_customer_rentals": 41,
    "secondary_theme_color": 72,
    "send_invoice_site_reminder": 37,
    "sent_lock_out_report_at": 85,
    "settings": 106,
    "site_map_height": 46,
    "site_map_is_public": 47,
    "site_map_width": 45,
    "sparefoot_enabled": 103,
    "state": 4,
    "sticky_header": 99,
    "storsmart_enabled": 79,
    "storsmart_settings": 104,
    "stripe_account_id": 116,
    "subdomain": 10,
    "tenant_protection_addendum": 112,
    "time_zone": 91,
    "transferred_ownership_at": 124,
    "twilio_sms_phone_number": 113,
    "twitter_url": 67,
    "two_way_texting_enabled_at": 114,
    "txt_owner_on_credit_without_payment": 49,
    "txt_owner_on_new_rental": 78,
    "unit_status_colors": 82,
    "units_updated_at": 93,
    "updated_at": 13,
    "updater_id": 15,
    "visa_enabled": 61,
    "website_menu_font_size": 88,
    "website_settings": 102,
    "yelp_url": 95,
    "youtube_url": 94,
    "zip": 5
}
    • schema_attributes: 
      {
    "account_number": "varchar(255)",
    "ach_enabled": "smallint",
    "additional_deposits_enabled": "smallint",
    "address": "varchar(255)",
    "agreed_to_terms_at": "timestamp",
    "allow_duplicate_gate_keys": "smallint",
    "alt_phone": "varchar(255)",
    "american_express_enabled": "smallint",
    "analytics_code": "string",
    "api_key": "varchar(255)",
    "auto_approve_rentals": "smallint",
    "billing_period": "int",
    "blue_moon_credentials": "string",
    "canceled_at": "timestamp",
    "changed_gate_code_report_url": "varchar(255)",
    "city": "varchar(255)",
    "company_id": "bigint",
    "country": "varchar(255)",
    "created_at": "timestamp",
    "creator_id": "int",
    "customer_rental_prorating": "varchar(255)",
    "customers_can_edit_payment_accounts": "smallint",
    "customers_can_prepay": "smallint",
    "customers_can_schedule_move_outs": "smallint",
    "customers_updated_at": "timestamp",
    "discover_enabled": "smallint",
    "domain": "varchar(255)",
    "easy_storage_payments_status": "int",
    "email": "varchar(255)",
    "email_manager_lockout_reports": "smallint",
    "email_manager_on_charge": "smallint",
    "email_manager_on_customer_lockout_removal": "smallint",
    "email_manager_on_move_in": "smallint",
    "email_owner_on_credit_without_payment": "smallint",
    "facebook_url": "varchar(255)",
    "favicon": "varchar(255)",
    "footer_image": "varchar(255)",
    "footer_image_link": "varchar(255)",
    "form_updated_at": "timestamp",
    "form_updater_id": "int",
    "gate_account_name": "varchar(255)",
    "gate_company": "varchar(255)",
    "gate_key_enabled": "smallint",
    "gate_keypad_zone": "int",
    "gate_security_level": "varchar(255)",
    "gate_time_zone": "int",
    "gateway_credentials": "string",
    "gateway_name": "varchar(255)",
    "google_plus_url": "varchar(255)",
    "has_card_swiper": "smallint",
    "home_page_dropdown_name": "varchar(255)",
    "id": "int",
    "iframe_urls": "string",
    "instagram_url": "varchar(255)",
    "latitude": "decimal(9,6)",
    "linkedin_url": "varchar(255)",
    "locale": "varchar(255)",
    "login_button_text": "varchar(255)",
    "logo": "varchar(255)",
    "logo_size": "varchar(255)",
    "longitude": "decimal(9,6)",
    "mastercard_enabled": "smallint",
    "move_out_days_restriction": "int",
    "name": "varchar(255)",
    "new_renter_instructions": "string",
    "notes": "string",
    "notifications_email": "varchar(255)",
    "office_hours": "string",
    "payrix_account_id": "bigint",
    "phone": "varchar(255)",
    "physical_address": "varchar(255)",
    "physical_city": "varchar(255)",
    "physical_state": "varchar(255)",
    "physical_zip": "varchar(255)",
    "primary_theme_color": "varchar(255)",
    "prodatakey": "string",
    "proposal_archived_at": "timestamp",
    "proposal_signed_at": "timestamp",
    "quickbooks_credentials": "string",
    "quickbooks_file_id": "varchar(255)",
    "quickbooks_owner_id": "varchar(255)",
    "quickbooks_password_hash": "varchar(255)",
    "quickbooks_qbo_downloaded_at": "timestamp",
    "quickbooks_settings": "string",
    "rate_management_settings": "string",
    "reminder_period": "int",
    "rent_rate_management_reminders_kind": "string",
    "rental_prorating_option_default": "varchar(255)",
    "reply_to_email": "varchar(255)",
    "require_approval_for_automatic_lock_out_removal": "smallint",
    "require_approval_for_manual_lock_out_removal": "smallint",
    "review_url": "varchar(255)",
    "routing_number": "varchar(255)",
    "save_unpaid_customer_rentals": "smallint",
    "secondary_theme_color": "varchar(255)",
    "send_invoice_site_reminder": "smallint",
    "sent_lock_out_report_at": "timestamp",
    "settings": "string",
    "site_map_height": "int",
    "site_map_is_public": "smallint",
    "site_map_width": "int",
    "sparefoot_enabled": "smallint",
    "sparefoot_facility_id": "string",
    "state": "varchar(255)",
    "sticky_header": "smallint",
    "storsmart_enabled": "smallint",
    "storsmart_settings": "string",
    "stripe_account_id": "bigint",
    "subdomain": "varchar(255)",
    "tenant_protection_addendum": "string",
    "time_zone": "varchar(255)",
    "transferred_ownership_at": "timestamp",
    "twilio_sms_phone_number": "varchar(255)",
    "twitter_url": "varchar(255)",
    "two_way_texting_enabled_at": "timestamp",
    "txt_owner_on_credit_without_payment": "smallint",
    "txt_owner_on_new_rental": "smallint",
    "unit_status_colors": "string",
    "units_updated_at": "timestamp",
    "updated_at": "timestamp",
    "updater_id": "int",
    "visa_enabled": "smallint",
    "website_menu_font_size": "int",
    "website_settings": "string",
    "yelp_url": "varchar(255)",
    "youtube_url": "varchar(255)",
    "zip": "varchar(255)"
}
    • schema_name_id: 1119
    • schema_scan_id: 3932876
    • updated: 2022-06-22 15:44:25
    • created: 2021-07-23 23:49:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `rent_rate_management_reminders_kind`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `sparefoot_facility_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2021-07-24/1627102163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
]
    • hive_path: s3://sfdl-rds-ess-stage/raw/esscore_sites/2021-07-24/1627102163
    • id: 341535
    • processed: 1
    • raw_data: 
      {
    "account_number": 23,
    "ach_enabled": 59,
    "additional_deposits_enabled": 43,
    "address": 2,
    "agreed_to_terms_at": 109,
    "allow_duplicate_gate_keys": 53,
    "alt_phone": 8,
    "american_express_enabled": 63,
    "analytics_code": 33,
    "api_key": 50,
    "auto_approve_rentals": 76,
    "billing_period": 16,
    "blue_moon_credentials": 44,
    "canceled_at": 29,
    "changed_gate_code_report_url": 75,
    "city": 3,
    "company_id": 120,
    "country": 115,
    "created_at": 12,
    "creator_id": 14,
    "customer_rental_prorating": 42,
    "customers_can_edit_payment_accounts": 55,
    "customers_can_prepay": 39,
    "customers_can_schedule_move_outs": 98,
    "customers_updated_at": 92,
    "discover_enabled": 62,
    "domain": 9,
    "email": 6,
    "email_manager_lockout_reports": 105,
    "email_manager_on_charge": 24,
    "email_manager_on_customer_lockout_removal": 52,
    "email_manager_on_move_in": 64,
    "email_owner_on_credit_without_payment": 48,
    "facebook_url": 66,
    "favicon": 73,
    "footer_image": 96,
    "footer_image_link": 97,
    "form_updated_at": 119,
    "form_updater_id": 118,
    "gate_account_name": 35,
    "gate_company": 51,
    "gate_key_enabled": 17,
    "gate_keypad_zone": 32,
    "gate_security_level": 36,
    "gate_time_zone": 31,
    "gateway_credentials": 18,
    "gateway_name": 20,
    "google_plus_url": 65,
    "has_card_swiper": 40,
    "home_page_dropdown_name": 77,
    "id": 0,
    "iframe_urls": 89,
    "instagram_url": 69,
    "latitude": 110,
    "linkedin_url": 68,
    "locale": 34,
    "login_button_text": 80,
    "logo": 74,
    "logo_size": 100,
    "longitude": 111,
    "mastercard_enabled": 60,
    "move_out_days_restriction": 107,
    "name": 1,
    "new_renter_instructions": 21,
    "notes": 11,
    "notifications_email": 19,
    "office_hours": 70,
    "payrix_account_id": 122,
    "phone": 7,
    "physical_address": 25,
    "physical_city": 26,
    "physical_state": 27,
    "physical_zip": 28,
    "primary_theme_color": 71,
    "prodatakey": 90,
    "proposal_archived_at": 117,
    "proposal_signed_at": 121,
    "quickbooks_credentials": 83,
    "quickbooks_file_id": 57,
    "quickbooks_owner_id": 56,
    "quickbooks_password_hash": 38,
    "quickbooks_qbo_downloaded_at": 84,
    "quickbooks_settings": 81,
    "rate_management_settings": 108,
    "reminder_period": 30,
    "rental_prorating_option_default": 101,
    "reply_to_email": 58,
    "require_approval_for_automatic_lock_out_removal": 54,
    "require_approval_for_manual_lock_out_removal": 86,
    "review_url": 87,
    "routing_number": 22,
    "save_unpaid_customer_rentals": 41,
    "secondary_theme_color": 72,
    "send_invoice_site_reminder": 37,
    "sent_lock_out_report_at": 85,
    "settings": 106,
    "site_map_height": 46,
    "site_map_is_public": 47,
    "site_map_width": 45,
    "sparefoot_enabled": 103,
    "state": 4,
    "sticky_header": 99,
    "storsmart_enabled": 79,
    "storsmart_settings": 104,
    "stripe_account_id": 116,
    "subdomain": 10,
    "tenant_protection_addendum": 112,
    "time_zone": 91,
    "twilio_sms_phone_number": 113,
    "twitter_url": 67,
    "two_way_texting_enabled_at": 114,
    "txt_owner_on_credit_without_payment": 49,
    "txt_owner_on_new_rental": 78,
    "unit_status_colors": 82,
    "units_updated_at": 93,
    "updated_at": 13,
    "updater_id": 15,
    "visa_enabled": 61,
    "website_menu_font_size": 88,
    "website_settings": 102,
    "yelp_url": 95,
    "youtube_url": 94,
    "zip": 5
}
    • schema_attributes: 
      {
    "account_number": "varchar(255)",
    "ach_enabled": "smallint",
    "additional_deposits_enabled": "smallint",
    "address": "varchar(255)",
    "agreed_to_terms_at": "timestamp",
    "allow_duplicate_gate_keys": "smallint",
    "alt_phone": "varchar(255)",
    "american_express_enabled": "smallint",
    "analytics_code": "string",
    "api_key": "varchar(255)",
    "auto_approve_rentals": "smallint",
    "billing_period": "int",
    "blue_moon_credentials": "string",
    "canceled_at": "timestamp",
    "changed_gate_code_report_url": "varchar(255)",
    "city": "varchar(255)",
    "company_id": "bigint",
    "country": "varchar(255)",
    "created_at": "timestamp",
    "creator_id": "int",
    "customer_rental_prorating": "varchar(255)",
    "customers_can_edit_payment_accounts": "smallint",
    "customers_can_prepay": "smallint",
    "customers_can_schedule_move_outs": "smallint",
    "customers_updated_at": "timestamp",
    "discover_enabled": "smallint",
    "domain": "varchar(255)",
    "email": "varchar(255)",
    "email_manager_lockout_reports": "smallint",
    "email_manager_on_charge": "smallint",
    "email_manager_on_customer_lockout_removal": "smallint",
    "email_manager_on_move_in": "smallint",
    "email_owner_on_credit_without_payment": "smallint",
    "facebook_url": "varchar(255)",
    "favicon": "varchar(255)",
    "footer_image": "varchar(255)",
    "footer_image_link": "varchar(255)",
    "form_updated_at": "timestamp",
    "form_updater_id": "int",
    "gate_account_name": "varchar(255)",
    "gate_company": "varchar(255)",
    "gate_key_enabled": "smallint",
    "gate_keypad_zone": "int",
    "gate_security_level": "varchar(255)",
    "gate_time_zone": "int",
    "gateway_credentials": "string",
    "gateway_name": "varchar(255)",
    "google_plus_url": "varchar(255)",
    "has_card_swiper": "smallint",
    "home_page_dropdown_name": "varchar(255)",
    "id": "int",
    "iframe_urls": "string",
    "instagram_url": "varchar(255)",
    "latitude": "decimal(9,6)",
    "linkedin_url": "varchar(255)",
    "locale": "varchar(255)",
    "login_button_text": "varchar(255)",
    "logo": "varchar(255)",
    "logo_size": "varchar(255)",
    "longitude": "decimal(9,6)",
    "mastercard_enabled": "smallint",
    "move_out_days_restriction": "int",
    "name": "varchar(255)",
    "new_renter_instructions": "string",
    "notes": "string",
    "notifications_email": "varchar(255)",
    "office_hours": "string",
    "payrix_account_id": "bigint",
    "phone": "varchar(255)",
    "physical_address": "varchar(255)",
    "physical_city": "varchar(255)",
    "physical_state": "varchar(255)",
    "physical_zip": "varchar(255)",
    "primary_theme_color": "varchar(255)",
    "prodatakey": "string",
    "proposal_archived_at": "timestamp",
    "proposal_signed_at": "timestamp",
    "quickbooks_credentials": "string",
    "quickbooks_file_id": "varchar(255)",
    "quickbooks_owner_id": "varchar(255)",
    "quickbooks_password_hash": "varchar(255)",
    "quickbooks_qbo_downloaded_at": "timestamp",
    "quickbooks_settings": "string",
    "rate_management_settings": "string",
    "reminder_period": "int",
    "rent_rate_management_reminders_kind": "varchar(255)",
    "rental_prorating_option_default": "varchar(255)",
    "reply_to_email": "varchar(255)",
    "require_approval_for_automatic_lock_out_removal": "smallint",
    "require_approval_for_manual_lock_out_removal": "smallint",
    "review_url": "varchar(255)",
    "routing_number": "varchar(255)",
    "save_unpaid_customer_rentals": "smallint",
    "secondary_theme_color": "varchar(255)",
    "send_invoice_site_reminder": "smallint",
    "sent_lock_out_report_at": "timestamp",
    "settings": "string",
    "site_map_height": "int",
    "site_map_is_public": "smallint",
    "site_map_width": "int",
    "sparefoot_enabled": "smallint",
    "sparefoot_facility_id": "varchar(255)",
    "state": "varchar(255)",
    "sticky_header": "smallint",
    "storsmart_enabled": "smallint",
    "storsmart_settings": "string",
    "stripe_account_id": "bigint",
    "subdomain": "varchar(255)",
    "tenant_protection_addendum": "string",
    "time_zone": "varchar(255)",
    "twilio_sms_phone_number": "varchar(255)",
    "twitter_url": "varchar(255)",
    "two_way_texting_enabled_at": "timestamp",
    "txt_owner_on_credit_without_payment": "smallint",
    "txt_owner_on_new_rental": "smallint",
    "unit_status_colors": "string",
    "units_updated_at": "timestamp",
    "updated_at": "timestamp",
    "updater_id": "int",
    "visa_enabled": "smallint",
    "website_menu_font_size": "int",
    "website_settings": "string",
    "yelp_url": "varchar(255)",
    "youtube_url": "varchar(255)",
    "zip": "varchar(255)"
}
    • schema_name_id: 1119
    • schema_scan_id: 3410605
    • updated: 2021-07-23 23:49:35
Schema Scans: 4
Last at 2023-06-15 18:30:47
    • duration: 0:00:14.163451
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 4963391
    • payload: 
      {
    "datatype_dict": {
        "account_number": "varchar(255)",
        "ach_enabled": "smallint",
        "additional_deposits_enabled": "smallint",
        "address": "varchar(255)",
        "agreed_to_terms_at": "timestamp",
        "allow_duplicate_gate_keys": "smallint",
        "alt_phone": "varchar(255)",
        "american_express_enabled": "smallint",
        "analytics_code": "string",
        "api_key": "varchar(255)",
        "auto_approve_rentals": "smallint",
        "billing_period": "int",
        "blue_moon_credentials": "string",
        "canceled_at": "timestamp",
        "changed_gate_code_report_url": "varchar(255)",
        "city": "varchar(255)",
        "company_id": "bigint",
        "country": "varchar(255)",
        "created_at": "timestamp",
        "creator_id": "int",
        "customer_rental_prorating": "varchar(255)",
        "customers_can_edit_payment_accounts": "smallint",
        "customers_can_prepay": "smallint",
        "customers_can_schedule_move_outs": "smallint",
        "customers_updated_at": "timestamp",
        "discover_enabled": "smallint",
        "domain": "varchar(255)",
        "easy_storage_payments_status": "int",
        "email": "varchar(255)",
        "email_manager_lockout_reports": "smallint",
        "email_manager_on_charge": "smallint",
        "email_manager_on_customer_lockout_removal": "smallint",
        "email_manager_on_move_in": "smallint",
        "email_owner_on_credit_without_payment": "smallint",
        "facebook_url": "varchar(255)",
        "favicon": "varchar(255)",
        "footer_image": "varchar(255)",
        "footer_image_link": "varchar(255)",
        "form_updated_at": "timestamp",
        "form_updater_id": "int",
        "gate_account_name": "varchar(255)",
        "gate_company": "varchar(255)",
        "gate_key_enabled": "smallint",
        "gate_keypad_zone": "int",
        "gate_security_level": "varchar(255)",
        "gate_time_zone": "int",
        "gateway_credentials": "string",
        "gateway_name": "varchar(255)",
        "google_plus_url": "varchar(255)",
        "has_card_swiper": "smallint",
        "home_page_dropdown_name": "varchar(255)",
        "id": "int",
        "iframe_urls": "string",
        "instagram_url": "varchar(255)",
        "latitude": "decimal(9,6)",
        "linkedin_url": "varchar(255)",
        "locale": "varchar(255)",
        "login_button_text": "varchar(255)",
        "logo": "varchar(255)",
        "logo_size": "varchar(255)",
        "longitude": "decimal(9,6)",
        "mastercard_enabled": "smallint",
        "move_out_days_restriction": "int",
        "name": "varchar(255)",
        "new_renter_instructions": "string",
        "notes": "string",
        "notifications_email": "varchar(255)",
        "notify_at": "timestamp",
        "office_hours": "string",
        "parafin_activated_at": "timestamp",
        "payrix_account_id": "bigint",
        "phone": "varchar(255)",
        "physical_address": "varchar(255)",
        "physical_city": "varchar(255)",
        "physical_state": "varchar(255)",
        "physical_zip": "varchar(255)",
        "primary_theme_color": "varchar(255)",
        "process_billing_at": "timestamp",
        "prodatakey": "string",
        "proposal_archived_at": "timestamp",
        "proposal_signed_at": "timestamp",
        "quickbooks_credentials": "string",
        "quickbooks_file_id": "varchar(255)",
        "quickbooks_owner_id": "varchar(255)",
        "quickbooks_password_hash": "varchar(255)",
        "quickbooks_qbo_downloaded_at": "timestamp",
        "quickbooks_settings": "string",
        "rate_management_settings": "string",
        "reminder_period": "int",
        "rental_prorating_option_default": "varchar(255)",
        "reply_to_email": "varchar(255)",
        "require_approval_for_automatic_lock_out_removal": "smallint",
        "require_approval_for_manual_lock_out_removal": "smallint",
        "review_url": "varchar(255)",
        "routing_number": "varchar(255)",
        "save_unpaid_customer_rentals": "smallint",
        "secondary_theme_color": "varchar(255)",
        "send_invoice_site_reminder": "smallint",
        "sent_lock_out_report_at": "timestamp",
        "settings": "string",
        "site_map_height": "int",
        "site_map_is_public": "smallint",
        "site_map_width": "int",
        "sparefoot_enabled": "smallint",
        "state": "varchar(255)",
        "sticky_header": "smallint",
        "storsmart_enabled": "smallint",
        "storsmart_settings": "string",
        "stripe_account_id": "bigint",
        "subdomain": "varchar(255)",
        "tenant_protection_addendum": "string",
        "time_zone": "varchar(255)",
        "transferred_ownership_at": "timestamp",
        "twilio_sms_phone_number": "varchar(255)",
        "twitter_url": "varchar(255)",
        "two_way_texting_enabled_at": "timestamp",
        "txt_owner_on_credit_without_payment": "smallint",
        "txt_owner_on_new_rental": "smallint",
        "unit_status_colors": "string",
        "units_updated_at": "timestamp",
        "updated_at": "timestamp",
        "updater_id": "int",
        "visa_enabled": "smallint",
        "website_menu_font_size": "int",
        "website_settings": "string",
        "yelp_url": "varchar(255)",
        "youtube_url": "varchar(255)",
        "zip": "varchar(255)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "~"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-ess-stage",
        "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_sites/2023-06-15/1686871845",
        "key": "raw/esscore_sites/2023-06-15/1686871845/split.ess_core.sites0.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.ess_esscore_sites",
        "type": "rds"
    }
}
    • running: False
    • schema_name_id: 1119
    • start_time: 2023-06-15 18:30:47
    • success: True
    • trace_id: 15335715412752975324
    • duration: 0:00:15.126112
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3933496
    • payload: 
      {
    "datatype_dict": {
        "account_number": "varchar(255)",
        "ach_enabled": "smallint",
        "additional_deposits_enabled": "smallint",
        "address": "varchar(255)",
        "agreed_to_terms_at": "timestamp",
        "allow_duplicate_gate_keys": "smallint",
        "alt_phone": "varchar(255)",
        "american_express_enabled": "smallint",
        "analytics_code": "string",
        "api_key": "varchar(255)",
        "auto_approve_rentals": "smallint",
        "billing_period": "int",
        "blue_moon_credentials": "string",
        "canceled_at": "timestamp",
        "changed_gate_code_report_url": "varchar(255)",
        "city": "varchar(255)",
        "company_id": "bigint",
        "country": "varchar(255)",
        "created_at": "timestamp",
        "creator_id": "int",
        "customer_rental_prorating": "varchar(255)",
        "customers_can_edit_payment_accounts": "smallint",
        "customers_can_prepay": "smallint",
        "customers_can_schedule_move_outs": "smallint",
        "customers_updated_at": "timestamp",
        "discover_enabled": "smallint",
        "domain": "varchar(255)",
        "easy_storage_payments_status": "int",
        "email": "varchar(255)",
        "email_manager_lockout_reports": "smallint",
        "email_manager_on_charge": "smallint",
        "email_manager_on_customer_lockout_removal": "smallint",
        "email_manager_on_move_in": "smallint",
        "email_owner_on_credit_without_payment": "smallint",
        "facebook_url": "varchar(255)",
        "favicon": "varchar(255)",
        "footer_image": "varchar(255)",
        "footer_image_link": "varchar(255)",
        "form_updated_at": "timestamp",
        "form_updater_id": "int",
        "gate_account_name": "varchar(255)",
        "gate_company": "varchar(255)",
        "gate_key_enabled": "smallint",
        "gate_keypad_zone": "int",
        "gate_security_level": "varchar(255)",
        "gate_time_zone": "int",
        "gateway_credentials": "string",
        "gateway_name": "varchar(255)",
        "google_plus_url": "varchar(255)",
        "has_card_swiper": "smallint",
        "home_page_dropdown_name": "varchar(255)",
        "id": "int",
        "iframe_urls": "string",
        "instagram_url": "varchar(255)",
        "latitude": "decimal(9,6)",
        "linkedin_url": "varchar(255)",
        "locale": "varchar(255)",
        "login_button_text": "varchar(255)",
        "logo": "varchar(255)",
        "logo_size": "varchar(255)",
        "longitude": "decimal(9,6)",
        "mastercard_enabled": "smallint",
        "move_out_days_restriction": "int",
        "name": "varchar(255)",
        "new_renter_instructions": "string",
        "notes": "string",
        "notifications_email": "varchar(255)",
        "office_hours": "string",
        "payrix_account_id": "bigint",
        "phone": "varchar(255)",
        "physical_address": "varchar(255)",
        "physical_city": "varchar(255)",
        "physical_state": "varchar(255)",
        "physical_zip": "varchar(255)",
        "primary_theme_color": "varchar(255)",
        "prodatakey": "string",
        "proposal_archived_at": "timestamp",
        "proposal_signed_at": "timestamp",
        "quickbooks_credentials": "string",
        "quickbooks_file_id": "varchar(255)",
        "quickbooks_owner_id": "varchar(255)",
        "quickbooks_password_hash": "varchar(255)",
        "quickbooks_qbo_downloaded_at": "timestamp",
        "quickbooks_settings": "string",
        "rate_management_settings": "string",
        "reminder_period": "int",
        "rental_prorating_option_default": "varchar(255)",
        "reply_to_email": "varchar(255)",
        "require_approval_for_automatic_lock_out_removal": "smallint",
        "require_approval_for_manual_lock_out_removal": "smallint",
        "review_url": "varchar(255)",
        "routing_number": "varchar(255)",
        "save_unpaid_customer_rentals": "smallint",
        "secondary_theme_color": "varchar(255)",
        "send_invoice_site_reminder": "smallint",
        "sent_lock_out_report_at": "timestamp",
        "settings": "string",
        "site_map_height": "int",
        "site_map_is_public": "smallint",
        "site_map_width": "int",
        "sparefoot_enabled": "smallint",
        "state": "varchar(255)",
        "sticky_header": "smallint",
        "storsmart_enabled": "smallint",
        "storsmart_settings": "string",
        "stripe_account_id": "bigint",
        "subdomain": "varchar(255)",
        "tenant_protection_addendum": "string",
        "time_zone": "varchar(255)",
        "transferred_ownership_at": "timestamp",
        "twilio_sms_phone_number": "varchar(255)",
        "twitter_url": "varchar(255)",
        "two_way_texting_enabled_at": "timestamp",
        "txt_owner_on_credit_without_payment": "smallint",
        "txt_owner_on_new_rental": "smallint",
        "unit_status_colors": "string",
        "units_updated_at": "timestamp",
        "updated_at": "timestamp",
        "updater_id": "int",
        "visa_enabled": "smallint",
        "website_menu_font_size": "int",
        "website_settings": "string",
        "yelp_url": "varchar(255)",
        "youtube_url": "varchar(255)",
        "zip": "varchar(255)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "~"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-ess-stage",
        "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-23/1655948948",
        "key": "raw/esscore_sites/2022-06-23/1655948948/split.ess_core.sites0.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.ess_esscore_sites",
        "type": "rds"
    }
}
    • running: False
    • schema_name_id: 1119
    • start_time: 2022-06-22 20:49:09
    • success: True
    • trace_id: 6587974257113331962
    • duration: 0:00:14.947941
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3932876
    • payload: 
      {
    "datatype_dict": {
        "account_number": "varchar(255)",
        "ach_enabled": "smallint",
        "additional_deposits_enabled": "smallint",
        "address": "varchar(255)",
        "agreed_to_terms_at": "timestamp",
        "allow_duplicate_gate_keys": "smallint",
        "alt_phone": "varchar(255)",
        "american_express_enabled": "smallint",
        "analytics_code": "string",
        "api_key": "varchar(255)",
        "auto_approve_rentals": "smallint",
        "billing_period": "int",
        "blue_moon_credentials": "string",
        "canceled_at": "timestamp",
        "changed_gate_code_report_url": "varchar(255)",
        "city": "varchar(255)",
        "company_id": "bigint",
        "country": "varchar(255)",
        "created_at": "timestamp",
        "creator_id": "int",
        "customer_rental_prorating": "varchar(255)",
        "customers_can_edit_payment_accounts": "smallint",
        "customers_can_prepay": "smallint",
        "customers_can_schedule_move_outs": "smallint",
        "customers_updated_at": "timestamp",
        "discover_enabled": "smallint",
        "domain": "varchar(255)",
        "easy_storage_payments_status": "int",
        "email": "varchar(255)",
        "email_manager_lockout_reports": "smallint",
        "email_manager_on_charge": "smallint",
        "email_manager_on_customer_lockout_removal": "smallint",
        "email_manager_on_move_in": "smallint",
        "email_owner_on_credit_without_payment": "smallint",
        "facebook_url": "varchar(255)",
        "favicon": "varchar(255)",
        "footer_image": "varchar(255)",
        "footer_image_link": "varchar(255)",
        "form_updated_at": "timestamp",
        "form_updater_id": "int",
        "gate_account_name": "varchar(255)",
        "gate_company": "varchar(255)",
        "gate_key_enabled": "smallint",
        "gate_keypad_zone": "int",
        "gate_security_level": "varchar(255)",
        "gate_time_zone": "int",
        "gateway_credentials": "string",
        "gateway_name": "varchar(255)",
        "google_plus_url": "varchar(255)",
        "has_card_swiper": "smallint",
        "home_page_dropdown_name": "varchar(255)",
        "id": "int",
        "iframe_urls": "string",
        "instagram_url": "varchar(255)",
        "latitude": "decimal(9,6)",
        "linkedin_url": "varchar(255)",
        "locale": "varchar(255)",
        "login_button_text": "varchar(255)",
        "logo": "varchar(255)",
        "logo_size": "varchar(255)",
        "longitude": "decimal(9,6)",
        "mastercard_enabled": "smallint",
        "move_out_days_restriction": "int",
        "name": "varchar(255)",
        "new_renter_instructions": "string",
        "notes": "string",
        "notifications_email": "varchar(255)",
        "office_hours": "string",
        "payrix_account_id": "bigint",
        "phone": "varchar(255)",
        "physical_address": "varchar(255)",
        "physical_city": "varchar(255)",
        "physical_state": "varchar(255)",
        "physical_zip": "varchar(255)",
        "primary_theme_color": "varchar(255)",
        "prodatakey": "string",
        "proposal_archived_at": "timestamp",
        "proposal_signed_at": "timestamp",
        "quickbooks_credentials": "string",
        "quickbooks_file_id": "varchar(255)",
        "quickbooks_owner_id": "varchar(255)",
        "quickbooks_password_hash": "varchar(255)",
        "quickbooks_qbo_downloaded_at": "timestamp",
        "quickbooks_settings": "string",
        "rate_management_settings": "string",
        "reminder_period": "int",
        "rental_prorating_option_default": "varchar(255)",
        "reply_to_email": "varchar(255)",
        "require_approval_for_automatic_lock_out_removal": "smallint",
        "require_approval_for_manual_lock_out_removal": "smallint",
        "review_url": "varchar(255)",
        "routing_number": "varchar(255)",
        "save_unpaid_customer_rentals": "smallint",
        "secondary_theme_color": "varchar(255)",
        "send_invoice_site_reminder": "smallint",
        "sent_lock_out_report_at": "timestamp",
        "settings": "string",
        "site_map_height": "int",
        "site_map_is_public": "smallint",
        "site_map_width": "int",
        "sparefoot_enabled": "smallint",
        "state": "varchar(255)",
        "sticky_header": "smallint",
        "storsmart_enabled": "smallint",
        "storsmart_settings": "string",
        "stripe_account_id": "bigint",
        "subdomain": "varchar(255)",
        "tenant_protection_addendum": "string",
        "time_zone": "varchar(255)",
        "transferred_ownership_at": "timestamp",
        "twilio_sms_phone_number": "varchar(255)",
        "twitter_url": "varchar(255)",
        "two_way_texting_enabled_at": "timestamp",
        "txt_owner_on_credit_without_payment": "smallint",
        "txt_owner_on_new_rental": "smallint",
        "unit_status_colors": "string",
        "units_updated_at": "timestamp",
        "updated_at": "timestamp",
        "updater_id": "int",
        "visa_enabled": "smallint",
        "website_menu_font_size": "int",
        "website_settings": "string",
        "yelp_url": "varchar(255)",
        "youtube_url": "varchar(255)",
        "zip": "varchar(255)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "~"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-ess-stage",
        "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_sites/2022-06-22/1655930652",
        "key": "raw/esscore_sites/2022-06-22/1655930652/split.ess_core.sites0.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.ess_esscore_sites",
        "type": "rds"
    }
}
    • running: False
    • schema_name_id: 1119
    • start_time: 2022-06-22 15:44:13
    • success: True
    • trace_id: 9613477236428572366
    • duration: 0:00:14.453202
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3410605
    • payload: 
      {
    "datatype_dict": {
        "account_number": "varchar(255)",
        "ach_enabled": "smallint",
        "additional_deposits_enabled": "smallint",
        "address": "varchar(255)",
        "agreed_to_terms_at": "timestamp",
        "allow_duplicate_gate_keys": "smallint",
        "alt_phone": "varchar(255)",
        "american_express_enabled": "smallint",
        "analytics_code": "string",
        "api_key": "varchar(255)",
        "auto_approve_rentals": "smallint",
        "billing_period": "int",
        "blue_moon_credentials": "string",
        "canceled_at": "timestamp",
        "changed_gate_code_report_url": "varchar(255)",
        "city": "varchar(255)",
        "company_id": "bigint",
        "country": "varchar(255)",
        "created_at": "timestamp",
        "creator_id": "int",
        "customer_rental_prorating": "varchar(255)",
        "customers_can_edit_payment_accounts": "smallint",
        "customers_can_prepay": "smallint",
        "customers_can_schedule_move_outs": "smallint",
        "customers_updated_at": "timestamp",
        "discover_enabled": "smallint",
        "domain": "varchar(255)",
        "email": "varchar(255)",
        "email_manager_lockout_reports": "smallint",
        "email_manager_on_charge": "smallint",
        "email_manager_on_customer_lockout_removal": "smallint",
        "email_manager_on_move_in": "smallint",
        "email_owner_on_credit_without_payment": "smallint",
        "facebook_url": "varchar(255)",
        "favicon": "varchar(255)",
        "footer_image": "varchar(255)",
        "footer_image_link": "varchar(255)",
        "form_updated_at": "timestamp",
        "form_updater_id": "int",
        "gate_account_name": "varchar(255)",
        "gate_company": "varchar(255)",
        "gate_key_enabled": "smallint",
        "gate_keypad_zone": "int",
        "gate_security_level": "varchar(255)",
        "gate_time_zone": "int",
        "gateway_credentials": "string",
        "gateway_name": "varchar(255)",
        "google_plus_url": "varchar(255)",
        "has_card_swiper": "smallint",
        "home_page_dropdown_name": "varchar(255)",
        "id": "int",
        "iframe_urls": "string",
        "instagram_url": "varchar(255)",
        "latitude": "decimal(9,6)",
        "linkedin_url": "varchar(255)",
        "locale": "varchar(255)",
        "login_button_text": "varchar(255)",
        "logo": "varchar(255)",
        "logo_size": "varchar(255)",
        "longitude": "decimal(9,6)",
        "mastercard_enabled": "smallint",
        "move_out_days_restriction": "int",
        "name": "varchar(255)",
        "new_renter_instructions": "string",
        "notes": "string",
        "notifications_email": "varchar(255)",
        "office_hours": "string",
        "payrix_account_id": "bigint",
        "phone": "varchar(255)",
        "physical_address": "varchar(255)",
        "physical_city": "varchar(255)",
        "physical_state": "varchar(255)",
        "physical_zip": "varchar(255)",
        "primary_theme_color": "varchar(255)",
        "prodatakey": "string",
        "proposal_archived_at": "timestamp",
        "proposal_signed_at": "timestamp",
        "quickbooks_credentials": "string",
        "quickbooks_file_id": "varchar(255)",
        "quickbooks_owner_id": "varchar(255)",
        "quickbooks_password_hash": "varchar(255)",
        "quickbooks_qbo_downloaded_at": "timestamp",
        "quickbooks_settings": "string",
        "rate_management_settings": "string",
        "reminder_period": "int",
        "rental_prorating_option_default": "varchar(255)",
        "reply_to_email": "varchar(255)",
        "require_approval_for_automatic_lock_out_removal": "smallint",
        "require_approval_for_manual_lock_out_removal": "smallint",
        "review_url": "varchar(255)",
        "routing_number": "varchar(255)",
        "save_unpaid_customer_rentals": "smallint",
        "secondary_theme_color": "varchar(255)",
        "send_invoice_site_reminder": "smallint",
        "sent_lock_out_report_at": "timestamp",
        "settings": "string",
        "site_map_height": "int",
        "site_map_is_public": "smallint",
        "site_map_width": "int",
        "sparefoot_enabled": "smallint",
        "state": "varchar(255)",
        "sticky_header": "smallint",
        "storsmart_enabled": "smallint",
        "storsmart_settings": "string",
        "stripe_account_id": "bigint",
        "subdomain": "varchar(255)",
        "tenant_protection_addendum": "string",
        "time_zone": "varchar(255)",
        "twilio_sms_phone_number": "varchar(255)",
        "twitter_url": "varchar(255)",
        "two_way_texting_enabled_at": "timestamp",
        "txt_owner_on_credit_without_payment": "smallint",
        "txt_owner_on_new_rental": "smallint",
        "unit_status_colors": "string",
        "units_updated_at": "timestamp",
        "updated_at": "timestamp",
        "updater_id": "int",
        "visa_enabled": "smallint",
        "website_menu_font_size": "int",
        "website_settings": "string",
        "yelp_url": "varchar(255)",
        "youtube_url": "varchar(255)",
        "zip": "varchar(255)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "~"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-ess-stage",
        "hive_path": "s3://sfdl-rds-ess-stage/raw/esscore_sites/2021-07-24/1627102163",
        "key": "raw/esscore_sites/2021-07-24/1627102163/split.ess_core.sites0.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.ess_esscore_sites",
        "type": "rds"
    }
}
    • running: False
    • schema_name_id: 1119
    • start_time: 2021-07-23 23:49:23
    • success: True
    • trace_id: 1204707556478520458
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "account_number": "varchar(255)",
    "ach_enabled": "smallint",
    "additional_deposits_enabled": "smallint",
    "address": "varchar(255)",
    "agreed_to_terms_at": "timestamp",
    "allow_duplicate_gate_keys": "smallint",
    "alt_phone": "varchar(255)",
    "american_express_enabled": "smallint",
    "analytics_code": "string",
    "api_key": "varchar(255)",
    "auto_approve_rentals": "smallint",
    "billing_period": "int",
    "blue_moon_credentials": "string",
    "canceled_at": "timestamp",
    "changed_gate_code_report_url": "varchar(255)",
    "city": "varchar(255)",
    "company_id": "bigint",
    "country": "varchar(255)",
    "created_at": "timestamp",
    "creator_id": "int",
    "customer_rental_prorating": "varchar(255)",
    "customers_can_edit_payment_accounts": "smallint",
    "customers_can_prepay": "smallint",
    "customers_can_schedule_move_outs": "smallint",
    "customers_updated_at": "timestamp",
    "discover_enabled": "smallint",
    "domain": "varchar(255)",
    "easy_storage_payments_status": "int",
    "email": "varchar(255)",
    "email_manager_lockout_reports": "smallint",
    "email_manager_on_charge": "smallint",
    "email_manager_on_customer_lockout_removal": "smallint",
    "email_manager_on_move_in": "smallint",
    "email_owner_on_credit_without_payment": "smallint",
    "facebook_url": "varchar(255)",
    "favicon": "varchar(255)",
    "footer_image": "varchar(255)",
    "footer_image_link": "varchar(255)",
    "form_updated_at": "timestamp",
    "form_updater_id": "int",
    "gate_account_name": "varchar(255)",
    "gate_company": "varchar(255)",
    "gate_key_enabled": "smallint",
    "gate_keypad_zone": "int",
    "gate_security_level": "varchar(255)",
    "gate_time_zone": "int",
    "gateway_credentials": "string",
    "gateway_name": "varchar(255)",
    "google_plus_url": "varchar(255)",
    "has_card_swiper": "smallint",
    "home_page_dropdown_name": "varchar(255)",
    "id": "int",
    "iframe_urls": "string",
    "instagram_url": "varchar(255)",
    "latitude": "decimal(9,6)",
    "linkedin_url": "varchar(255)",
    "locale": "varchar(255)",
    "login_button_text": "varchar(255)",
    "logo": "varchar(255)",
    "logo_size": "varchar(255)",
    "longitude": "decimal(9,6)",
    "mastercard_enabled": "smallint",
    "move_out_days_restriction": "int",
    "name": "varchar(255)",
    "new_renter_instructions": "string",
    "notes": "string",
    "notifications_email": "varchar(255)",
    "notify_at": "timestamp",
    "office_hours": "string",
    "parafin_activated_at": "timestamp",
    "payrix_account_id": "bigint",
    "phone": "varchar(255)",
    "physical_address": "varchar(255)",
    "physical_city": "varchar(255)",
    "physical_state": "varchar(255)",
    "physical_zip": "varchar(255)",
    "primary_theme_color": "varchar(255)",
    "process_billing_at": "timestamp",
    "prodatakey": "string",
    "proposal_archived_at": "timestamp",
    "proposal_signed_at": "timestamp",
    "quickbooks_credentials": "string",
    "quickbooks_file_id": "varchar(255)",
    "quickbooks_owner_id": "varchar(255)",
    "quickbooks_password_hash": "varchar(255)",
    "quickbooks_qbo_downloaded_at": "timestamp",
    "quickbooks_settings": "string",
    "rate_management_settings": "string",
    "reminder_period": "int",
    "rent_rate_management_reminders_kind": "string",
    "rental_prorating_option_default": "varchar(255)",
    "reply_to_email": "varchar(255)",
    "require_approval_for_automatic_lock_out_removal": "smallint",
    "require_approval_for_manual_lock_out_removal": "smallint",
    "review_url": "varchar(255)",
    "routing_number": "varchar(255)",
    "save_unpaid_customer_rentals": "smallint",
    "secondary_theme_color": "varchar(255)",
    "send_invoice_site_reminder": "smallint",
    "sent_lock_out_report_at": "timestamp",
    "settings": "string",
    "site_map_height": "int",
    "site_map_is_public": "smallint",
    "site_map_width": "int",
    "sparefoot_enabled": "smallint",
    "sparefoot_facility_id": "string",
    "state": "varchar(255)",
    "sticky_header": "smallint",
    "storsmart_enabled": "smallint",
    "storsmart_settings": "string",
    "stripe_account_id": "bigint",
    "subdomain": "varchar(255)",
    "tenant_protection_addendum": "string",
    "time_zone": "varchar(255)",
    "transferred_ownership_at": "timestamp",
    "twilio_sms_phone_number": "varchar(255)",
    "twitter_url": "varchar(255)",
    "two_way_texting_enabled_at": "timestamp",
    "txt_owner_on_credit_without_payment": "smallint",
    "txt_owner_on_new_rental": "smallint",
    "unit_status_colors": "string",
    "units_updated_at": "timestamp",
    "updated_at": "timestamp",
    "updater_id": "int",
    "visa_enabled": "smallint",
    "website_menu_font_size": "int",
    "website_settings": "string",
    "yelp_url": "varchar(255)",
    "youtube_url": "varchar(255)",
    "zip": "varchar(255)"
}
  • created: 2023-06-15 18:30:47
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `easy_storage_payments_status`  int , `transferred_ownership_at`  timestamp , `process_billing_at`  timestamp , `parafin_activated_at`  timestamp , `notify_at`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2023-06-15/1686871845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2021-07-12 13:44:02",
        "disabled": false,
        "format": "raw",
        "id": 1119,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "ess_esscore_sites"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_number": "varchar(255)",
            "ach_enabled": "smallint",
            "additional_deposits_enabled": "smallint",
            "address": "varchar(255)",
            "agreed_to_terms_at": "timestamp",
            "allow_duplicate_gate_keys": "smallint",
            "alt_phone": "varchar(255)",
            "american_express_enabled": "smallint",
            "analytics_code": "string",
            "api_key": "varchar(255)",
            "auto_approve_rentals": "smallint",
            "billing_period": "int",
            "blue_moon_credentials": "string",
            "canceled_at": "timestamp",
            "changed_gate_code_report_url": "varchar(255)",
            "city": "varchar(255)",
            "company_id": "bigint",
            "country": "varchar(255)",
            "created_at": "timestamp",
            "creator_id": "int",
            "customer_rental_prorating": "varchar(255)",
            "customers_can_edit_payment_accounts": "smallint",
            "customers_can_prepay": "smallint",
            "customers_can_schedule_move_outs": "smallint",
            "customers_updated_at": "timestamp",
            "discover_enabled": "smallint",
            "domain": "varchar(255)",
            "easy_storage_payments_status": "int",
            "email": "varchar(255)",
            "email_manager_lockout_reports": "smallint",
            "email_manager_on_charge": "smallint",
            "email_manager_on_customer_lockout_removal": "smallint",
            "email_manager_on_move_in": "smallint",
            "email_owner_on_credit_without_payment": "smallint",
            "facebook_url": "varchar(255)",
            "favicon": "varchar(255)",
            "footer_image": "varchar(255)",
            "footer_image_link": "varchar(255)",
            "form_updated_at": "timestamp",
            "form_updater_id": "int",
            "gate_account_name": "varchar(255)",
            "gate_company": "varchar(255)",
            "gate_key_enabled": "smallint",
            "gate_keypad_zone": "int",
            "gate_security_level": "varchar(255)",
            "gate_time_zone": "int",
            "gateway_credentials": "string",
            "gateway_name": "varchar(255)",
            "google_plus_url": "varchar(255)",
            "has_card_swiper": "smallint",
            "home_page_dropdown_name": "varchar(255)",
            "id": "int",
            "iframe_urls": "string",
            "instagram_url": "varchar(255)",
            "latitude": "decimal(9,6)",
            "linkedin_url": "varchar(255)",
            "locale": "varchar(255)",
            "login_button_text": "varchar(255)",
            "logo": "varchar(255)",
            "logo_size": "varchar(255)",
            "longitude": "decimal(9,6)",
            "mastercard_enabled": "smallint",
            "move_out_days_restriction": "int",
            "name": "varchar(255)",
            "new_renter_instructions": "string",
            "notes": "string",
            "notifications_email": "varchar(255)",
            "notify_at": "timestamp",
            "office_hours": "string",
            "parafin_activated_at": "timestamp",
            "payrix_account_id": "bigint",
            "phone": "varchar(255)",
            "physical_address": "varchar(255)",
            "physical_city": "varchar(255)",
            "physical_state": "varchar(255)",
            "physical_zip": "varchar(255)",
            "primary_theme_color": "varchar(255)",
            "process_billing_at": "timestamp",
            "prodatakey": "string",
            "proposal_archived_at": "timestamp",
            "proposal_signed_at": "timestamp",
            "quickbooks_credentials": "string",
            "quickbooks_file_id": "varchar(255)",
            "quickbooks_owner_id": "varchar(255)",
            "quickbooks_password_hash": "varchar(255)",
            "quickbooks_qbo_downloaded_at": "timestamp",
            "quickbooks_settings": "string",
            "rate_management_settings": "string",
            "reminder_period": "int",
            "rent_rate_management_reminders_kind": "string",
            "rental_prorating_option_default": "varchar(255)",
            "reply_to_email": "varchar(255)",
            "require_approval_for_automatic_lock_out_removal": "smallint",
            "require_approval_for_manual_lock_out_removal": "smallint",
            "review_url": "varchar(255)",
            "routing_number": "varchar(255)",
            "save_unpaid_customer_rentals": "smallint",
            "secondary_theme_color": "varchar(255)",
            "send_invoice_site_reminder": "smallint",
            "sent_lock_out_report_at": "timestamp",
            "settings": "string",
            "site_map_height": "int",
            "site_map_is_public": "smallint",
            "site_map_width": "int",
            "sparefoot_enabled": "smallint",
            "sparefoot_facility_id": "string",
            "state": "varchar(255)",
            "sticky_header": "smallint",
            "storsmart_enabled": "smallint",
            "storsmart_settings": "string",
            "stripe_account_id": "bigint",
            "subdomain": "varchar(255)",
            "tenant_protection_addendum": "string",
            "time_zone": "varchar(255)",
            "transferred_ownership_at": "timestamp",
            "twilio_sms_phone_number": "varchar(255)",
            "twitter_url": "varchar(255)",
            "two_way_texting_enabled_at": "timestamp",
            "txt_owner_on_credit_without_payment": "smallint",
            "txt_owner_on_new_rental": "smallint",
            "unit_status_colors": "string",
            "units_updated_at": "timestamp",
            "updated_at": "timestamp",
            "updater_id": "int",
            "visa_enabled": "smallint",
            "website_menu_font_size": "int",
            "website_settings": "string",
            "yelp_url": "varchar(255)",
            "youtube_url": "varchar(255)",
            "zip": "varchar(255)"
        },
        "created": "2023-06-15 18:30:47",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.ess_esscore_sites`\n(\n `id`  int , `name`  varchar(255) , `address`  varchar(255) , `city`  varchar(255) , `state`  varchar(255) , `zip`  varchar(255) , `email`  varchar(255) , `phone`  varchar(255) , `alt_phone`  varchar(255) , `domain`  varchar(255) , `subdomain`  varchar(255) , `notes`  string , `created_at`  timestamp , `updated_at`  timestamp , `creator_id`  int , `updater_id`  int , `billing_period`  int , `gate_key_enabled`  smallint , `gateway_credentials`  string , `notifications_email`  varchar(255) , `gateway_name`  varchar(255) , `new_renter_instructions`  string , `routing_number`  varchar(255) , `account_number`  varchar(255) , `email_manager_on_charge`  smallint , `physical_address`  varchar(255) , `physical_city`  varchar(255) , `physical_state`  varchar(255) , `physical_zip`  varchar(255) , `canceled_at`  timestamp , `reminder_period`  int , `gate_time_zone`  int , `gate_keypad_zone`  int , `analytics_code`  string , `locale`  varchar(255) , `gate_account_name`  varchar(255) , `gate_security_level`  varchar(255) , `send_invoice_site_reminder`  smallint , `quickbooks_password_hash`  varchar(255) , `customers_can_prepay`  smallint , `has_card_swiper`  smallint , `save_unpaid_customer_rentals`  smallint , `customer_rental_prorating`  varchar(255) , `additional_deposits_enabled`  smallint , `blue_moon_credentials`  string , `site_map_width`  int , `site_map_height`  int , `site_map_is_public`  smallint , `email_owner_on_credit_without_payment`  smallint , `txt_owner_on_credit_without_payment`  smallint , `api_key`  varchar(255) , `gate_company`  varchar(255) , `email_manager_on_customer_lockout_removal`  smallint , `allow_duplicate_gate_keys`  smallint , `require_approval_for_automatic_lock_out_removal`  smallint , `customers_can_edit_payment_accounts`  smallint , `quickbooks_owner_id`  varchar(255) , `quickbooks_file_id`  varchar(255) , `reply_to_email`  varchar(255) , `ach_enabled`  smallint , `mastercard_enabled`  smallint , `visa_enabled`  smallint , `discover_enabled`  smallint , `american_express_enabled`  smallint , `email_manager_on_move_in`  smallint , `google_plus_url`  varchar(255) , `facebook_url`  varchar(255) , `twitter_url`  varchar(255) , `linkedin_url`  varchar(255) , `instagram_url`  varchar(255) , `office_hours`  string , `primary_theme_color`  varchar(255) , `secondary_theme_color`  varchar(255) , `favicon`  varchar(255) , `logo`  varchar(255) , `changed_gate_code_report_url`  varchar(255) , `auto_approve_rentals`  smallint , `home_page_dropdown_name`  varchar(255) , `txt_owner_on_new_rental`  smallint , `storsmart_enabled`  smallint , `login_button_text`  varchar(255) , `quickbooks_settings`  string , `unit_status_colors`  string , `quickbooks_credentials`  string , `quickbooks_qbo_downloaded_at`  timestamp , `sent_lock_out_report_at`  timestamp , `require_approval_for_manual_lock_out_removal`  smallint , `review_url`  varchar(255) , `website_menu_font_size`  int , `iframe_urls`  string , `prodatakey`  string , `time_zone`  varchar(255) , `customers_updated_at`  timestamp , `units_updated_at`  timestamp , `youtube_url`  varchar(255) , `yelp_url`  varchar(255) , `footer_image`  varchar(255) , `footer_image_link`  varchar(255) , `customers_can_schedule_move_outs`  smallint , `sticky_header`  smallint , `logo_size`  varchar(255) , `rental_prorating_option_default`  varchar(255) , `website_settings`  string , `sparefoot_enabled`  smallint , `storsmart_settings`  string , `email_manager_lockout_reports`  smallint , `settings`  string , `move_out_days_restriction`  int , `rate_management_settings`  string , `agreed_to_terms_at`  timestamp , `latitude`  decimal(9,6) , `longitude`  decimal(9,6) , `tenant_protection_addendum`  string , `twilio_sms_phone_number`  varchar(255) , `two_way_texting_enabled_at`  timestamp , `country`  varchar(255) , `stripe_account_id`  bigint , `proposal_archived_at`  timestamp , `form_updater_id`  int , `form_updated_at`  timestamp , `company_id`  bigint , `proposal_signed_at`  timestamp , `payrix_account_id`  bigint , `easy_storage_payments_status`  int , `transferred_ownership_at`  timestamp , `process_billing_at`  timestamp , `parafin_activated_at`  timestamp , `notify_at`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '~', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-ess-stage/raw/esscore_sites/2023-06-15/1686871845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.ess_esscore_sites`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.ess_esscore_sites"
        }
    },
    "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