Schema Info

Schema Name: sfdl_stage_couch.storedge_webworks_facilities

created: 2019-03-18 11:30:12
disabled: False
format: raw
id: 786
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_couch",
    "table": "storedge_webworks_facilities"
}

type: couch

Schema Versions: 3

Version 734067

created: 2024-08-12 11:37:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_couch`",
    "DROP TABLE IF EXISTS `sfdl_stage_couch.storedge_webworks_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_couch.storedge_webworks_facilities`\n(\n`id`STRING,`key`STRING,`value`struct<`_id`:STRING,`id`:STRING,`accepted_cc`:array,`address`:STRING,`address1`:STRING,`address2`:STRING,`api_config`:struct<`fms`:STRING,`facility`:STRING,`fms_company_id`:STRING,`user`:STRING,`pass`:STRING,`corpcode`:STRING,`loccode`:STRING,`use_push_rates`:STRING,`use_promo_pricing`:STRING,`default_unit_prefix`:STRING,`bank_account_disclaimer`:STRING,`disable_tenant_profile_editing`:STRING,`disable_tenant_payment_editing`:STRING,`post_account_activity_to_bulletin_board`:STRING,`disable_payment_emails_to_facility_manager`:STRING,`disable_partial_payments`:STRING,`show_unavailable_units`:STRING,`promotion_type`:STRING,`discount_availability`:STRING,`offer_line_from`:STRING,`use_fixed_promotion_price`:STRING,`use_any_promotion_price`:STRING,`allow_excess_reservations`:STRING,`description_field`:STRING,`sort_column`:STRING,`cue_admin_fee`:STRING,`reservation_threshold`:STRING,`enable_display_unit_count`:STRING,`enable_display_price_as_call`:STRING,`display_count_threshold`:STRING,`hide_unit_pricing`:STRING,`channel`:STRING,`reservation_type`:STRING,`cs_description_features`:STRING,`cs_description_access`:STRING,`cs_description_climate`:STRING,`cs_description_door`:STRING,`cs_ignore_type_economy`:STRING,`cs_ignore_type_standard`:STRING,`cs_ignore_type_premium`:STRING,`endpoint`:STRING,`move_ins_enabled`:STRING,`move_ins_insurance_required`:STRING,`move_ins_future_dates`:STRING,`move_ins_future_dates_num`:STRING,`move_ins_use_fms_map`:STRING,`move_ins_map`:STRING,`move_ins_contract`:STRING,`move_ins_show_gate_code`:STRING,`move_ins_instructions`:STRING,`move_ins_reserve_instructions`:STRING,`move_ins_storage_calc_link`:STRING,`move_ins_alternate_insurance_name`:STRING,`move_ins_hide_insurance_provider`:STRING,`non_overridable_fields`:STRING,`last_pulled_date`:STRING,`last_time_polled`:STRING,`lockDesc`:STRING,`lockPrice`:STRING,`siteID`:STRING,`orgID`:STRING,`csUser`:STRING,`csPass`:STRING,`csSiteName`:STRING,`pms`:STRING,`pushrate`:STRING,`_apisetup_`:STRING,`hardreservation`:STRING,`hideunavailable`:STRING,`showdescription`:STRING,`first_load`:STRING,`validated`:STRING,`validcredentials`:STRING,`prerent`:STRING,`postrent`:STRING,`_apicustom_`:STRING,`key`:STRING,`secret`:STRING,`application_id`:STRING,`apiKey`:STRING,`locationCode`:STRING,`cs31SiteID`:STRING,`cs31OrgID`:STRING,`use_standard_push_rates`:STRING,`rental_redirect_url`:STRING,`last_updated`:STRING,`sitename`:STRING,`URL`:STRING,`company_name`:STRING,`store`:STRING>,`city`:STRING,`city2`:STRING,`subregion`:STRING,`custom_type`:struct<`pay_url`:STRING,`pay_url_type`:STRING,`reserve_url`:STRING>,`current_promo_offer`:STRING,`current_promo_offer_color`:STRING,`state`:STRING,`state2`:STRING,`country`:STRING,`last_mod`:STRING,`logo`:STRING,`latitude`:STRING,`longitude`:STRING,`map_radius`:STRING,`map_zoom`:STRING,`iframe_scale`:STRING,`iframe_height`:STRING,`module_status`:STRING,`name`:STRING,`override_pay_url`:STRING,`pictures`:array>,`ns`:STRING,`phone`:STRING,`postal`:STRING,`review_links`:struct<`google_plus`:STRING,`yelp`:STRING,`yahoo`:STRING>,`sales_phone`:STRING,`seo`:struct<`title`:STRING,`HideNameInTitle`:STRING,`description`:STRING,`keywords`:STRING,`ss_link`:STRING,`ss_anchor`:STRING,`payonline`:struct<`title`:STRING,`description`:STRING,`keywords`:STRING>>,`showtax`:STRING,`callout`:STRING,`type`:STRING,`type_link`:STRING,`timezone`:STRING,`features`:array>,`unit_categories`:STRING,`unit_summary`:STRING,`coupons`:STRING,`coupon_copy`:STRING,`email`:STRING,`metro`:STRING,`name_modifier`:STRING,`owner`:STRING,`status`:STRING,`sales_phone_ppc`:STRING,`trust_phone`:STRING,`address_modifier`:STRING,`address_modifier_color`:STRING,`tenant_portal`:STRING,`sales_phone_mobile`:STRING,`service_region`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-12/1723480594'\n",
    "MSCK REPAIR TABLE sfdl_stage_couch.storedge_webworks_facilities"
]

hive_path: s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-12/1723480594
id: 734067
processed: 1

raw_data:

{
    "id": "facility-f1379",
    "key": "A-1 Self Storage",
    "value": {
        "_id": "facility-105620",
        "accepted_cc": [
            "visa",
            "mastercard",
            "americanexpress",
            "discover"
        ],
        "address": "10104 Durant Rd, Raleigh, NC, 27614, United-States",
        "address1": "10104 Durant Rd",
        "address2": "",
        "address_modifier": "",
        "address_modifier_color": "",
        "api_config": {
            "URL": "",
            "[apicustom]": true,
            "[apisetup]": true,
            "allow_excess_reservations": "0",
            "apiKey": "3f3c4cfe-a59a-4ad0-ba80-e16236bf1422",
            "application_id": "1bea2b2c-911e-4d47-a717-228c2d155862",
            "bank_account_disclaimer": false,
            "channel": false,
            "company_name": "storagehounds",
            "corpcode": "CXAZ",
            "cs31OrgID": "1000000032",
            "cs31SiteID": "1000000400",
            "csPass": "A@m3rC@n",
            "csSiteName": "aamerican_buena_park",
            "csUser": "storedge",
            "cs_description_access": "",
            "cs_description_climate": "",
            "cs_description_door": "",
            "cs_description_features": "",
            "cs_ignore_type_economy": "",
            "cs_ignore_type_premium": "",
            "cs_ignore_type_standard": "",
            "cue_admin_fee": "",
            "default_unit_prefix": false,
            "description_field": "description",
            "disable_partial_payments": false,
            "disable_payment_emails_to_facility_manager": false,
            "disable_tenant_payment_editing": false,
            "disable_tenant_profile_editing": false,
            "discount_availability": "everywhere_website",
            "display_count_threshold": 0,
            "enable_display_price_as_call": "0",
            "enable_display_unit_count": "0",
            "endpoint": false,
            "facility": "2f850c12-e441-4c4a-ad95-6e3b154ebffb",
            "first_load": "false",
            "fms": "sl",
            "fms_company_id": "2853794b-8d7c-4568-bf94-afee8841397b",
            "hardreservation": "yes",
            "hide_unit_pricing": false,
            "hideunavailable": "yes",
            "key": "M10AhJyv0DTkoBf7aUvMjPEkdi5moF9cRYNoWxcm",
            "last_pulled_date": 1610727807,
            "last_time_polled": "637463066100748726",
            "last_updated": 1485376841,
            "locationCode": "024712",
            "loccode": "L002",
            "lockDesc": "",
            "lockPrice": "",
            "move_ins_alternate_insurance_name": false,
            "move_ins_contract": false,
            "move_ins_enabled": false,
            "move_ins_future_dates": "0",
            "move_ins_future_dates_num": 0,
            "move_ins_hide_insurance_provider": "0",
            "move_ins_instructions": "",
            "move_ins_insurance_required": "0",
            "move_ins_map": "nomap",
            "move_ins_reserve_instructions": "",
            "move_ins_show_gate_code": "0",
            "move_ins_storage_calc_link": "0",
            "move_ins_use_fms_map": "0",
            "non_overridable_fields": null,
            "offer_line_from": "plan_name",
            "orgID": "1000000090",
            "pass": "alek5",
            "pms": "sl",
            "post_account_activity_to_bulletin_board": false,
            "postrent": "You have completed the reservation process and your deposit transaction was successful.  One of our representatives will contact you to complete your storage rental.",
            "prerent": "After completing this registration you will be contacted to schedule an appointment at our facility to finish the rental process and receive security codes to access your new storage.",
            "promotion_type": "None",
            "pushrate": "yes",
            "rental_redirect_url": "",
            "reservation_threshold": false,
            "reservation_type": false,
            "secret": "aSDhQcGLAlS6Z74kqvBKxejvdWeeAY0NiYHyeIAv",
            "show_unavailable_units": "0",
            "showdescription": "yes",
            "siteID": "1000000555",
            "sitename": "",
            "sort_column": "size",
            "store": "248",
            "use_any_promotion_price": false,
            "use_fixed_promotion_price": "0",
            "use_promo_pricing": false,
            "use_push_rates": "0",
            "use_standard_push_rates": false,
            "user": "dan",
            "validated": true,
            "validcredentials": true
        },
        "callout": "",
        "city": "Raleigh",
        "city2": "",
        "country": "United-States",
        "coupon_copy": null,
        "coupons": null,
        "current_promo_offer": "Discount and Truck",
        "current_promo_offer_color": false,
        "custom_type": {
            "pay_url": "https://rental-center.storedge.com?companyId=2853794b-8d7c-4568-bf94-afee8841397b&facilityId=2f850c12-e441-4c4a-ad95-6e3b154ebffb#/login",
            "pay_url_type": "iframe",
            "reserve_url": ""
        },
        "email": "",
        "features": [
            {
                "_couch_id": "power",
                "desc": "",
                "order": 27,
                "visible": "False"
            }
        ],
        "id": "105620",
        "iframe_height": "",
        "iframe_scale": "",
        "last_mod": 1721116925,
        "latitude": 35.903781,
        "logo": "",
        "longitude": -78.582395,
        "map_radius": "",
        "map_zoom": "10",
        "metro": "",
        "module_status": null,
        "name": "A-1 Personal Storage",
        "name_modifier": "",
        "ns": "facility",
        "override_pay_url": "",
        "owner": 0,
        "phone": "5633328875",
        "pictures": [
            {
                "description": false,
                "file": "105620/slide-602ae3561da300.81867296--slide-5acb887ed3b335.20769187--durant-and-wake-forest-stuff-027.jpg",
                "image": "/client/resources/uploads/115077/slide0-5127876c29d010.47492587--wt-storagepic-couplemoving.jpg",
                "link": "",
                "title": "Self Storage"
            }
        ],
        "postal": "52722",
        "review_links": {
            "google_plus": "",
            "yahoo": "",
            "yelp": ""
        },
        "sales_phone": null,
        "sales_phone_mobile": null,
        "sales_phone_ppc": null,
        "seo": {
            "HideNameInTitle": "",
            "description": "Looking for affordable self storage in the Quad Cities area? Look no further! A-1 Self Storage offers secure, convenient 24-hour accessible storage units at great prices. Call today!",
            "keywords": "",
            "payonline": {
                "description": "",
                "keywords": "",
                "title": ""
            },
            "ss_anchor": "",
            "ss_link": "",
            "title": "Storage Units in Bettendorf, IA 52722"
        },
        "service_region": false,
        "showtax": "",
        "state": "NC",
        "state2": "",
        "status": 0,
        "subregion": "",
        "tenant-portal": null,
        "timezone": "America/Chicago",
        "trust_phone": "k6dwdwdwd9d5drmgdwdyd9dtd5",
        "type": "market_pro",
        "type_link": "http://",
        "unit_categories": null,
        "unit_summary": null
    }
}

schema_attributes:

{
    "id": "string",
    "key": "string",
    "value._id": "string",
    "value.accepted_cc": [
        "string"
    ],
    "value.address": "string",
    "value.address1": "string",
    "value.address2": "string",
    "value.address_modifier": "string",
    "value.address_modifier_color": "string",
    "value.api_config.URL": "string",
    "value.api_config._apicustom_": "string",
    "value.api_config._apisetup_": "string",
    "value.api_config.allow_excess_reservations": "string",
    "value.api_config.apiKey": "string",
    "value.api_config.application_id": "string",
    "value.api_config.bank_account_disclaimer": "string",
    "value.api_config.channel": "string",
    "value.api_config.company_name": "string",
    "value.api_config.corpcode": "string",
    "value.api_config.cs31OrgID": "string",
    "value.api_config.cs31SiteID": "string",
    "value.api_config.csPass": "string",
    "value.api_config.csSiteName": "string",
    "value.api_config.csUser": "string",
    "value.api_config.cs_description_access": "string",
    "value.api_config.cs_description_climate": "string",
    "value.api_config.cs_description_door": "string",
    "value.api_config.cs_description_features": "string",
    "value.api_config.cs_ignore_type_economy": "string",
    "value.api_config.cs_ignore_type_premium": "string",
    "value.api_config.cs_ignore_type_standard": "string",
    "value.api_config.cue_admin_fee": "string",
    "value.api_config.default_unit_prefix": "string",
    "value.api_config.description_field": "string",
    "value.api_config.disable_partial_payments": "string",
    "value.api_config.disable_payment_emails_to_facility_manager": "string",
    "value.api_config.disable_tenant_payment_editing": "string",
    "value.api_config.disable_tenant_profile_editing": "string",
    "value.api_config.discount_availability": "string",
    "value.api_config.display_count_threshold": "string",
    "value.api_config.enable_display_price_as_call": "string",
    "value.api_config.enable_display_unit_count": "string",
    "value.api_config.endpoint": "string",
    "value.api_config.facility": "string",
    "value.api_config.first_load": "string",
    "value.api_config.fms": "string",
    "value.api_config.fms_company_id": "string",
    "value.api_config.hardreservation": "string",
    "value.api_config.hide_unit_pricing": "string",
    "value.api_config.hideunavailable": "string",
    "value.api_config.key": "string",
    "value.api_config.last_pulled_date": "string",
    "value.api_config.last_time_polled": "string",
    "value.api_config.last_updated": "string",
    "value.api_config.locationCode": "string",
    "value.api_config.loccode": "string",
    "value.api_config.lockDesc": "string",
    "value.api_config.lockPrice": "string",
    "value.api_config.move_ins_alternate_insurance_name": "string",
    "value.api_config.move_ins_contract": "string",
    "value.api_config.move_ins_enabled": "string",
    "value.api_config.move_ins_future_dates": "string",
    "value.api_config.move_ins_future_dates_num": "string",
    "value.api_config.move_ins_hide_insurance_provider": "string",
    "value.api_config.move_ins_instructions": "string",
    "value.api_config.move_ins_insurance_required": "string",
    "value.api_config.move_ins_map": "string",
    "value.api_config.move_ins_reserve_instructions": "string",
    "value.api_config.move_ins_show_gate_code": "string",
    "value.api_config.move_ins_storage_calc_link": "string",
    "value.api_config.move_ins_use_fms_map": "string",
    "value.api_config.non_overridable_fields": "string",
    "value.api_config.offer_line_from": "string",
    "value.api_config.orgID": "string",
    "value.api_config.pass": "string",
    "value.api_config.pms": "string",
    "value.api_config.post_account_activity_to_bulletin_board": "string",
    "value.api_config.postrent": "string",
    "value.api_config.prerent": "string",
    "value.api_config.promotion_type": "string",
    "value.api_config.pushrate": "string",
    "value.api_config.rental_redirect_url": "string",
    "value.api_config.reservation_threshold": "string",
    "value.api_config.reservation_type": "string",
    "value.api_config.secret": "string",
    "value.api_config.show_unavailable_units": "string",
    "value.api_config.showdescription": "string",
    "value.api_config.siteID": "string",
    "value.api_config.sitename": "string",
    "value.api_config.sort_column": "string",
    "value.api_config.store": "string",
    "value.api_config.use_any_promotion_price": "string",
    "value.api_config.use_fixed_promotion_price": "string",
    "value.api_config.use_promo_pricing": "string",
    "value.api_config.use_push_rates": "string",
    "value.api_config.use_standard_push_rates": "string",
    "value.api_config.user": "string",
    "value.api_config.validated": "string",
    "value.api_config.validcredentials": "string",
    "value.callout": "string",
    "value.city": "string",
    "value.city2": "string",
    "value.country": "string",
    "value.coupon_copy": "string",
    "value.coupons": "string",
    "value.current_promo_offer": "string",
    "value.current_promo_offer_color": "string",
    "value.custom_type.pay_url": "string",
    "value.custom_type.pay_url_type": "string",
    "value.custom_type.reserve_url": "string",
    "value.email": "string",
    "value.features": [
        {
            "_couch_id": "string",
            "desc": "string",
            "order": "string",
            "visible": "string"
        }
    ],
    "value.id": "string",
    "value.iframe_height": "string",
    "value.iframe_scale": "string",
    "value.last_mod": "string",
    "value.latitude": "string",
    "value.logo": "string",
    "value.longitude": "string",
    "value.map_radius": "string",
    "value.map_zoom": "string",
    "value.metro": "string",
    "value.module_status": "string",
    "value.name": "string",
    "value.name_modifier": "string",
    "value.ns": "string",
    "value.override_pay_url": "string",
    "value.owner": "string",
    "value.phone": "string",
    "value.pictures": [
        {
            "description": "string",
            "file": "string",
            "image": "string",
            "link": "string",
            "title": "string"
        }
    ],
    "value.postal": "string",
    "value.review_links.google_plus": "string",
    "value.review_links.yahoo": "string",
    "value.review_links.yelp": "string",
    "value.sales_phone": "string",
    "value.sales_phone_mobile": "string",
    "value.sales_phone_ppc": "string",
    "value.seo.HideNameInTitle": "string",
    "value.seo.description": "string",
    "value.seo.keywords": "string",
    "value.seo.payonline.description": "string",
    "value.seo.payonline.keywords": "string",
    "value.seo.payonline.title": "string",
    "value.seo.ss_anchor": "string",
    "value.seo.ss_link": "string",
    "value.seo.title": "string",
    "value.service_region": "string",
    "value.showtax": "string",
    "value.state": "string",
    "value.state2": "string",
    "value.status": "string",
    "value.subregion": "string",
    "value.tenant_portal": "string",
    "value.timezone": "string",
    "value.trust_phone": "string",
    "value.type": "string",
    "value.type_link": "string",
    "value.unit_categories": "string",
    "value.unit_summary": "string"
}

schema_name_id: 786
schema_scan_id: 5924779
updated: 2024-08-12 11:37:18

Version 733535

created: 2024-08-11 07:52:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_couch`",
    "DROP TABLE IF EXISTS `sfdl_stage_couch.storedge_webworks_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_couch.storedge_webworks_facilities`\n(\n`id`STRING,`key`STRING,`value`struct<`_id`:STRING,`id`:STRING,`accepted_cc`:array,`address`:STRING,`address1`:STRING,`address2`:STRING,`api_config`:struct<`fms`:STRING,`facility`:STRING,`fms_company_id`:STRING,`user`:STRING,`pass`:STRING,`corpcode`:STRING,`loccode`:STRING,`use_push_rates`:STRING,`use_promo_pricing`:STRING,`default_unit_prefix`:STRING,`bank_account_disclaimer`:STRING,`disable_tenant_profile_editing`:STRING,`disable_tenant_payment_editing`:STRING,`post_account_activity_to_bulletin_board`:STRING,`disable_payment_emails_to_facility_manager`:STRING,`disable_partial_payments`:STRING,`show_unavailable_units`:STRING,`promotion_type`:STRING,`discount_availability`:STRING,`offer_line_from`:STRING,`use_fixed_promotion_price`:STRING,`use_any_promotion_price`:STRING,`allow_excess_reservations`:STRING,`description_field`:STRING,`sort_column`:STRING,`cue_admin_fee`:STRING,`reservation_threshold`:STRING,`enable_display_unit_count`:STRING,`enable_display_price_as_call`:STRING,`display_count_threshold`:STRING,`hide_unit_pricing`:STRING,`channel`:STRING,`reservation_type`:STRING,`cs_description_features`:STRING,`cs_description_access`:STRING,`cs_description_climate`:STRING,`cs_description_door`:STRING,`cs_ignore_type_economy`:STRING,`cs_ignore_type_standard`:STRING,`cs_ignore_type_premium`:STRING,`endpoint`:STRING,`move_ins_enabled`:STRING,`move_ins_insurance_required`:STRING,`move_ins_future_dates`:STRING,`move_ins_future_dates_num`:STRING,`move_ins_use_fms_map`:STRING,`move_ins_map`:STRING,`move_ins_contract`:STRING,`move_ins_show_gate_code`:STRING,`move_ins_instructions`:STRING,`move_ins_reserve_instructions`:STRING,`move_ins_storage_calc_link`:STRING,`move_ins_alternate_insurance_name`:STRING,`move_ins_hide_insurance_provider`:STRING,`non_overridable_fields`:STRING,`last_pulled_date`:STRING,`last_time_polled`:STRING,`lockDesc`:STRING,`lockPrice`:STRING,`siteID`:STRING,`orgID`:STRING,`csUser`:STRING,`csPass`:STRING,`csSiteName`:STRING,`pms`:STRING,`pushrate`:STRING,`_apisetup_`:STRING,`hardreservation`:STRING,`hideunavailable`:STRING,`showdescription`:STRING,`first_load`:STRING,`validated`:STRING,`validcredentials`:STRING,`prerent`:STRING,`postrent`:STRING,`_apicustom_`:STRING,`key`:STRING,`secret`:STRING,`application_id`:STRING,`apiKey`:STRING,`locationCode`:STRING,`cs31SiteID`:STRING,`cs31OrgID`:STRING,`use_standard_push_rates`:STRING,`rental_redirect_url`:STRING,`last_updated`:STRING,`sitename`:STRING,`URL`:STRING,`company_name`:STRING,`store`:STRING>,`city`:STRING,`city2`:STRING,`subregion`:STRING,`custom_type`:struct<`pay_url`:STRING,`pay_url_type`:STRING,`reserve_url`:STRING>,`current_promo_offer`:STRING,`current_promo_offer_color`:STRING,`state`:STRING,`state2`:STRING,`country`:STRING,`last_mod`:STRING,`logo`:STRING,`latitude`:STRING,`longitude`:STRING,`map_radius`:STRING,`map_zoom`:STRING,`iframe_scale`:STRING,`iframe_height`:STRING,`module_status`:STRING,`name`:STRING,`override_pay_url`:STRING,`pictures`:array>,`ns`:STRING,`phone`:STRING,`postal`:STRING,`review_links`:struct<`google_plus`:STRING,`yelp`:STRING,`yahoo`:STRING>,`sales_phone`:STRING,`seo`:struct<`title`:STRING,`HideNameInTitle`:STRING,`description`:STRING,`keywords`:STRING,`ss_link`:STRING,`ss_anchor`:STRING,`payonline`:struct<`title`:STRING,`description`:STRING,`keywords`:STRING>>,`showtax`:STRING,`callout`:STRING,`type`:STRING,`type_link`:STRING,`timezone`:STRING,`features`:array>,`unit_categories`:STRING,`unit_summary`:STRING,`coupons`:STRING,`coupon_copy`:STRING,`email`:STRING,`metro`:STRING,`name_modifier`:STRING,`owner`:STRING,`status`:STRING,`sales_phone_ppc`:STRING,`trust_phone`:STRING,`address_modifier`:STRING,`address_modifier_color`:STRING,`tenant_portal`:STRING,`sales_phone_mobile`:STRING,`service_region`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-11/1723380704'\n",
    "MSCK REPAIR TABLE sfdl_stage_couch.storedge_webworks_facilities"
]

hive_path: s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-11/1723380704
id: 733535
processed: 1

raw_data:

{
    "id": "facility-f1379",
    "key": "A-1 Self Storage",
    "value": {
        "_id": "facility-105620",
        "accepted_cc": [
            "visa",
            "mastercard",
            "americanexpress",
            "discover"
        ],
        "address": "10104 Durant Rd, Raleigh, NC, 27614, United-States",
        "address1": "10104 Durant Rd",
        "address2": "",
        "address_modifier": "",
        "address_modifier_color": "",
        "api_config": {
            "URL": "",
            "[apicustom]": true,
            "[apisetup]": true,
            "allow_excess_reservations": "0",
            "apiKey": "3f3c4cfe-a59a-4ad0-ba80-e16236bf1422",
            "application_id": "1bea2b2c-911e-4d47-a717-228c2d155862",
            "bank_account_disclaimer": false,
            "channel": false,
            "company_name": "storagehounds",
            "corpcode": "CXAZ",
            "cs31OrgID": "1000000032",
            "cs31SiteID": "1000000400",
            "csPass": "A@m3rC@n",
            "csSiteName": "aamerican_buena_park",
            "csUser": "storedge",
            "cs_description_access": "",
            "cs_description_climate": "",
            "cs_description_door": "",
            "cs_description_features": "",
            "cs_ignore_type_economy": "",
            "cs_ignore_type_premium": "",
            "cs_ignore_type_standard": "",
            "cue_admin_fee": "",
            "default_unit_prefix": false,
            "description_field": "description",
            "disable_partial_payments": false,
            "disable_payment_emails_to_facility_manager": false,
            "disable_tenant_payment_editing": false,
            "disable_tenant_profile_editing": false,
            "discount_availability": "everywhere_website",
            "display_count_threshold": 0,
            "enable_display_price_as_call": "0",
            "enable_display_unit_count": "0",
            "endpoint": false,
            "facility": "2f850c12-e441-4c4a-ad95-6e3b154ebffb",
            "first_load": "false",
            "fms": "sl",
            "fms_company_id": "2853794b-8d7c-4568-bf94-afee8841397b",
            "hardreservation": "yes",
            "hide_unit_pricing": false,
            "hideunavailable": "yes",
            "key": "M10AhJyv0DTkoBf7aUvMjPEkdi5moF9cRYNoWxcm",
            "last_pulled_date": 1610727807,
            "last_time_polled": "637463066100748726",
            "last_updated": 1485376841,
            "locationCode": "024712",
            "loccode": "L002",
            "lockDesc": "",
            "lockPrice": "",
            "move_ins_alternate_insurance_name": false,
            "move_ins_contract": false,
            "move_ins_enabled": false,
            "move_ins_future_dates": "0",
            "move_ins_future_dates_num": 0,
            "move_ins_hide_insurance_provider": "0",
            "move_ins_instructions": "",
            "move_ins_insurance_required": "0",
            "move_ins_map": "nomap",
            "move_ins_reserve_instructions": "",
            "move_ins_show_gate_code": "0",
            "move_ins_storage_calc_link": "0",
            "move_ins_use_fms_map": "0",
            "non_overridable_fields": null,
            "offer_line_from": "plan_name",
            "orgID": "1000000090",
            "pass": "alek5",
            "pms": "sl",
            "post_account_activity_to_bulletin_board": false,
            "postrent": "You have completed the reservation process and your deposit transaction was successful.  One of our representatives will contact you to complete your storage rental.",
            "prerent": "After completing this registration you will be contacted to schedule an appointment at our facility to finish the rental process and receive security codes to access your new storage.",
            "promotion_type": "None",
            "pushrate": "yes",
            "rental_redirect_url": "",
            "reservation_threshold": false,
            "reservation_type": false,
            "secret": "aSDhQcGLAlS6Z74kqvBKxejvdWeeAY0NiYHyeIAv",
            "show_unavailable_units": "0",
            "showdescription": "yes",
            "siteID": "1000000555",
            "sitename": "",
            "sort_column": "size",
            "store": "248",
            "use_any_promotion_price": false,
            "use_fixed_promotion_price": "0",
            "use_promo_pricing": false,
            "use_push_rates": "0",
            "use_standard_push_rates": false,
            "user": "dan",
            "validated": true,
            "validcredentials": true
        },
        "callout": "",
        "city": "Raleigh",
        "city2": "",
        "country": "United-States",
        "coupon_copy": null,
        "coupons": null,
        "current_promo_offer": "Discount and Truck",
        "current_promo_offer_color": false,
        "custom_type": {
            "pay_url": "https://rental-center.storedge.com?companyId=2853794b-8d7c-4568-bf94-afee8841397b&facilityId=2f850c12-e441-4c4a-ad95-6e3b154ebffb#/login",
            "pay_url_type": "iframe",
            "reserve_url": ""
        },
        "email": "",
        "features": [
            {
                "_couch_id": "power",
                "desc": "",
                "order": 27,
                "visible": "False"
            }
        ],
        "id": "105620",
        "iframe_height": "",
        "iframe_scale": "",
        "last_mod": 1721116925,
        "latitude": 35.903781,
        "logo": "",
        "longitude": -78.582395,
        "map_radius": "",
        "map_zoom": "10",
        "metro": "",
        "module_status": null,
        "name": "A-1 Personal Storage",
        "name_modifier": "",
        "ns": "facility",
        "override_pay_url": "",
        "owner": 0,
        "phone": "5633328875",
        "pictures": [
            {
                "description": false,
                "file": "105620/slide-602ae3561da300.81867296--slide-5acb887ed3b335.20769187--durant-and-wake-forest-stuff-027.jpg",
                "image": "/client/resources/uploads/115077/slide0-5127876c29d010.47492587--wt-storagepic-couplemoving.jpg",
                "link": "",
                "title": "Self Storage"
            }
        ],
        "postal": "52722",
        "review_links": {
            "google_plus": "",
            "yahoo": "",
            "yelp": ""
        },
        "sales_phone": null,
        "sales_phone_mobile": null,
        "sales_phone_ppc": null,
        "seo": {
            "HideNameInTitle": "",
            "description": "Looking for affordable self storage in the Quad Cities area? Look no further! A-1 Self Storage offers secure, convenient 24-hour accessible storage units at great prices. Call today!",
            "keywords": "",
            "payonline": {
                "description": "",
                "keywords": "",
                "title": ""
            },
            "ss_anchor": "",
            "ss_link": "",
            "title": "Storage Units in Bettendorf, IA 52722"
        },
        "service_region": false,
        "showtax": "",
        "state": "NC",
        "state2": "",
        "status": 0,
        "subregion": "",
        "tenant-portal": null,
        "timezone": "America/Chicago",
        "trust_phone": "k6dwdwdwd9d5drmgdwdyd9dtd5",
        "type": "market_pro",
        "type_link": "http://",
        "unit_categories": null,
        "unit_summary": null
    }
}

schema_attributes:

{
    "id": "string",
    "key": "string",
    "value._id": "string",
    "value.accepted_cc": [
        "string"
    ],
    "value.address": "string",
    "value.address1": "string",
    "value.address2": "string",
    "value.address_modifier": "string",
    "value.address_modifier_color": "string",
    "value.api_config.URL": "string",
    "value.api_config._apicustom_": "string",
    "value.api_config._apisetup_": "string",
    "value.api_config.allow_excess_reservations": "string",
    "value.api_config.apiKey": "string",
    "value.api_config.application_id": "string",
    "value.api_config.bank_account_disclaimer": "string",
    "value.api_config.channel": "string",
    "value.api_config.company_name": "string",
    "value.api_config.corpcode": "string",
    "value.api_config.cs31OrgID": "string",
    "value.api_config.cs31SiteID": "string",
    "value.api_config.csPass": "string",
    "value.api_config.csSiteName": "string",
    "value.api_config.csUser": "string",
    "value.api_config.cs_description_access": "string",
    "value.api_config.cs_description_climate": "string",
    "value.api_config.cs_description_door": "string",
    "value.api_config.cs_description_features": "string",
    "value.api_config.cs_ignore_type_economy": "string",
    "value.api_config.cs_ignore_type_premium": "string",
    "value.api_config.cs_ignore_type_standard": "string",
    "value.api_config.cue_admin_fee": "string",
    "value.api_config.default_unit_prefix": "string",
    "value.api_config.description_field": "string",
    "value.api_config.disable_partial_payments": "string",
    "value.api_config.disable_payment_emails_to_facility_manager": "string",
    "value.api_config.disable_tenant_payment_editing": "string",
    "value.api_config.disable_tenant_profile_editing": "string",
    "value.api_config.discount_availability": "string",
    "value.api_config.display_count_threshold": "string",
    "value.api_config.enable_display_price_as_call": "string",
    "value.api_config.enable_display_unit_count": "string",
    "value.api_config.endpoint": "string",
    "value.api_config.facility": "string",
    "value.api_config.first_load": "string",
    "value.api_config.fms": "string",
    "value.api_config.fms_company_id": "string",
    "value.api_config.hardreservation": "string",
    "value.api_config.hide_unit_pricing": "string",
    "value.api_config.hideunavailable": "string",
    "value.api_config.key": "string",
    "value.api_config.last_pulled_date": "string",
    "value.api_config.last_time_polled": "string",
    "value.api_config.last_updated": "string",
    "value.api_config.locationCode": "string",
    "value.api_config.loccode": "string",
    "value.api_config.lockDesc": "string",
    "value.api_config.lockPrice": "string",
    "value.api_config.move_ins_alternate_insurance_name": "string",
    "value.api_config.move_ins_contract": "string",
    "value.api_config.move_ins_enabled": "string",
    "value.api_config.move_ins_future_dates": "string",
    "value.api_config.move_ins_future_dates_num": "string",
    "value.api_config.move_ins_hide_insurance_provider": "string",
    "value.api_config.move_ins_instructions": "string",
    "value.api_config.move_ins_insurance_required": "string",
    "value.api_config.move_ins_map": "string",
    "value.api_config.move_ins_reserve_instructions": "string",
    "value.api_config.move_ins_show_gate_code": "string",
    "value.api_config.move_ins_storage_calc_link": "string",
    "value.api_config.move_ins_use_fms_map": "string",
    "value.api_config.non_overridable_fields": "string",
    "value.api_config.offer_line_from": "string",
    "value.api_config.orgID": "string",
    "value.api_config.pass": "string",
    "value.api_config.pms": "string",
    "value.api_config.post_account_activity_to_bulletin_board": "string",
    "value.api_config.postrent": "string",
    "value.api_config.prerent": "string",
    "value.api_config.promotion_type": "string",
    "value.api_config.pushrate": "string",
    "value.api_config.rental_redirect_url": "string",
    "value.api_config.reservation_threshold": "string",
    "value.api_config.reservation_type": "string",
    "value.api_config.secret": "string",
    "value.api_config.show_unavailable_units": "string",
    "value.api_config.showdescription": "string",
    "value.api_config.siteID": "string",
    "value.api_config.sitename": "string",
    "value.api_config.sort_column": "string",
    "value.api_config.store": "string",
    "value.api_config.use_any_promotion_price": "string",
    "value.api_config.use_fixed_promotion_price": "string",
    "value.api_config.use_promo_pricing": "string",
    "value.api_config.use_push_rates": "string",
    "value.api_config.use_standard_push_rates": "string",
    "value.api_config.user": "string",
    "value.api_config.validated": "string",
    "value.api_config.validcredentials": "string",
    "value.callout": "string",
    "value.city": "string",
    "value.city2": "string",
    "value.country": "string",
    "value.coupon_copy": "string",
    "value.coupons": "string",
    "value.current_promo_offer": "string",
    "value.current_promo_offer_color": "string",
    "value.custom_type.pay_url": "string",
    "value.custom_type.pay_url_type": "string",
    "value.custom_type.reserve_url": "string",
    "value.email": "string",
    "value.features": [
        {
            "_couch_id": "string",
            "desc": "string",
            "order": "string",
            "visible": "string"
        }
    ],
    "value.id": "string",
    "value.iframe_height": "string",
    "value.iframe_scale": "string",
    "value.last_mod": "string",
    "value.latitude": "string",
    "value.logo": "string",
    "value.longitude": "string",
    "value.map_radius": "string",
    "value.map_zoom": "string",
    "value.metro": "string",
    "value.module_status": "string",
    "value.name": "string",
    "value.name_modifier": "string",
    "value.ns": "string",
    "value.override_pay_url": "string",
    "value.owner": "string",
    "value.phone": "string",
    "value.pictures": [
        {
            "description": "string",
            "file": "string",
            "image": "string",
            "link": "string",
            "title": "string"
        }
    ],
    "value.postal": "string",
    "value.review_links.google_plus": "string",
    "value.review_links.yahoo": "string",
    "value.review_links.yelp": "string",
    "value.sales_phone": "string",
    "value.sales_phone_mobile": "string",
    "value.sales_phone_ppc": "string",
    "value.seo.HideNameInTitle": "string",
    "value.seo.description": "string",
    "value.seo.keywords": "string",
    "value.seo.payonline.description": "string",
    "value.seo.payonline.keywords": "string",
    "value.seo.payonline.title": "string",
    "value.seo.ss_anchor": "string",
    "value.seo.ss_link": "string",
    "value.seo.title": "string",
    "value.service_region": "string",
    "value.showtax": "string",
    "value.state": "string",
    "value.state2": "string",
    "value.status": "string",
    "value.subregion": "string",
    "value.tenant_portal": "string",
    "value.timezone": "string",
    "value.trust_phone": "string",
    "value.type": "string",
    "value.type_link": "string",
    "value.unit_categories": "string",
    "value.unit_summary": "string"
}

schema_name_id: 786
schema_scan_id: 5922396
updated: 2024-08-11 07:52:37

Version 733091

created: 2024-08-10 07:52:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_couch`",
    "DROP TABLE IF EXISTS `sfdl_stage_couch.storedge_webworks_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_couch.storedge_webworks_facilities`\n(\n`id`STRING,`key`STRING,`value`struct<`_id`:STRING,`id`:STRING,`accepted_cc`:array,`address`:STRING,`address1`:STRING,`address2`:STRING,`api_config`:struct<`fms`:STRING,`facility`:STRING,`fms_company_id`:STRING,`user`:STRING,`pass`:STRING,`corpcode`:STRING,`loccode`:STRING,`use_push_rates`:STRING,`use_promo_pricing`:STRING,`default_unit_prefix`:STRING,`bank_account_disclaimer`:STRING,`disable_tenant_profile_editing`:STRING,`disable_tenant_payment_editing`:STRING,`post_account_activity_to_bulletin_board`:STRING,`disable_payment_emails_to_facility_manager`:STRING,`disable_partial_payments`:STRING,`show_unavailable_units`:STRING,`promotion_type`:STRING,`discount_availability`:STRING,`offer_line_from`:STRING,`use_fixed_promotion_price`:STRING,`use_any_promotion_price`:STRING,`allow_excess_reservations`:STRING,`description_field`:STRING,`sort_column`:STRING,`cue_admin_fee`:STRING,`reservation_threshold`:STRING,`enable_display_unit_count`:STRING,`enable_display_price_as_call`:STRING,`display_count_threshold`:STRING,`hide_unit_pricing`:STRING,`channel`:STRING,`reservation_type`:STRING,`cs_description_features`:STRING,`cs_description_access`:STRING,`cs_description_climate`:STRING,`cs_description_door`:STRING,`cs_ignore_type_economy`:STRING,`cs_ignore_type_standard`:STRING,`cs_ignore_type_premium`:STRING,`endpoint`:STRING,`move_ins_enabled`:STRING,`move_ins_insurance_required`:STRING,`move_ins_future_dates`:STRING,`move_ins_future_dates_num`:STRING,`move_ins_use_fms_map`:STRING,`move_ins_map`:STRING,`move_ins_contract`:STRING,`move_ins_show_gate_code`:STRING,`move_ins_instructions`:STRING,`move_ins_reserve_instructions`:STRING,`move_ins_storage_calc_link`:STRING,`move_ins_alternate_insurance_name`:STRING,`move_ins_hide_insurance_provider`:STRING,`non_overridable_fields`:STRING,`last_pulled_date`:STRING,`last_time_polled`:STRING,`lockDesc`:STRING,`lockPrice`:STRING,`siteID`:STRING,`orgID`:STRING,`csUser`:STRING,`csPass`:STRING,`csSiteName`:STRING,`pms`:STRING,`pushrate`:STRING,`_apisetup_`:STRING,`hardreservation`:STRING,`hideunavailable`:STRING,`showdescription`:STRING,`first_load`:STRING,`validated`:STRING,`validcredentials`:STRING,`prerent`:STRING,`postrent`:STRING,`_apicustom_`:STRING,`key`:STRING,`secret`:STRING,`application_id`:STRING,`apiKey`:STRING,`locationCode`:STRING,`cs31SiteID`:STRING,`cs31OrgID`:STRING,`use_standard_push_rates`:STRING,`rental_redirect_url`:STRING,`last_updated`:STRING,`sitename`:STRING,`URL`:STRING,`company_name`:STRING,`store`:STRING>,`city`:STRING,`city2`:STRING,`subregion`:STRING,`custom_type`:struct<`pay_url`:STRING,`pay_url_type`:STRING,`reserve_url`:STRING>,`current_promo_offer`:STRING,`current_promo_offer_color`:STRING,`state`:STRING,`state2`:STRING,`country`:STRING,`last_mod`:STRING,`logo`:STRING,`latitude`:STRING,`longitude`:STRING,`map_radius`:STRING,`map_zoom`:STRING,`iframe_scale`:STRING,`iframe_height`:STRING,`module_status`:STRING,`name`:STRING,`override_pay_url`:STRING,`pictures`:array>,`ns`:STRING,`phone`:STRING,`postal`:STRING,`review_links`:struct<`google_plus`:STRING,`yelp`:STRING,`yahoo`:STRING>,`sales_phone`:STRING,`seo`:struct<`title`:STRING,`HideNameInTitle`:STRING,`description`:STRING,`keywords`:STRING,`ss_link`:STRING,`ss_anchor`:STRING,`payonline`:struct<`title`:STRING,`description`:STRING,`keywords`:STRING>>,`showtax`:STRING,`callout`:STRING,`type`:STRING,`type_link`:STRING,`timezone`:STRING,`features`:array>,`unit_categories`:STRING,`unit_summary`:STRING,`coupons`:STRING,`coupon_copy`:STRING,`email`:STRING,`metro`:STRING,`name_modifier`:STRING,`owner`:STRING,`status`:STRING,`sales_phone_ppc`:STRING,`trust_phone`:STRING,`address_modifier`:STRING,`address_modifier_color`:STRING,`tenant_portal`:STRING,`sales_phone_mobile`:STRING,`service_region`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-10/1723294294'\n",
    "MSCK REPAIR TABLE sfdl_stage_couch.storedge_webworks_facilities"
]

hive_path: s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-10/1723294294
id: 733091
processed: 1

raw_data:

{
    "id": "facility-f1379",
    "key": "A-1 Self Storage",
    "value": {
        "_id": "facility-105620",
        "accepted_cc": [
            "visa",
            "mastercard",
            "americanexpress",
            "discover"
        ],
        "address": "10104 Durant Rd, Raleigh, NC, 27614, United-States",
        "address1": "10104 Durant Rd",
        "address2": "",
        "address_modifier": "",
        "address_modifier_color": "",
        "api_config": {
            "URL": "",
            "[apicustom]": true,
            "[apisetup]": true,
            "allow_excess_reservations": "0",
            "apiKey": "3f3c4cfe-a59a-4ad0-ba80-e16236bf1422",
            "application_id": "1bea2b2c-911e-4d47-a717-228c2d155862",
            "bank_account_disclaimer": false,
            "channel": false,
            "company_name": "storagehounds",
            "corpcode": "CXAZ",
            "cs31OrgID": "1000000032",
            "cs31SiteID": "1000000400",
            "csPass": "A@m3rC@n",
            "csSiteName": "aamerican_buena_park",
            "csUser": "storedge",
            "cs_description_access": "",
            "cs_description_climate": "",
            "cs_description_door": "",
            "cs_description_features": "",
            "cs_ignore_type_economy": "",
            "cs_ignore_type_premium": "",
            "cs_ignore_type_standard": "",
            "cue_admin_fee": "",
            "default_unit_prefix": false,
            "description_field": "description",
            "disable_partial_payments": false,
            "disable_payment_emails_to_facility_manager": false,
            "disable_tenant_payment_editing": false,
            "disable_tenant_profile_editing": false,
            "discount_availability": "everywhere_website",
            "display_count_threshold": 0,
            "enable_display_price_as_call": "0",
            "enable_display_unit_count": "0",
            "endpoint": false,
            "facility": "2f850c12-e441-4c4a-ad95-6e3b154ebffb",
            "first_load": "false",
            "fms": "sl",
            "fms_company_id": "2853794b-8d7c-4568-bf94-afee8841397b",
            "hardreservation": "yes",
            "hide_unit_pricing": false,
            "hideunavailable": "yes",
            "key": "M10AhJyv0DTkoBf7aUvMjPEkdi5moF9cRYNoWxcm",
            "last_pulled_date": 1610727807,
            "last_time_polled": "637463066100748726",
            "last_updated": 1485376841,
            "locationCode": "024712",
            "loccode": "L002",
            "lockDesc": "",
            "lockPrice": "",
            "move_ins_alternate_insurance_name": false,
            "move_ins_contract": false,
            "move_ins_enabled": false,
            "move_ins_future_dates": "0",
            "move_ins_future_dates_num": 0,
            "move_ins_hide_insurance_provider": "0",
            "move_ins_instructions": "",
            "move_ins_insurance_required": "0",
            "move_ins_map": "nomap",
            "move_ins_reserve_instructions": "",
            "move_ins_show_gate_code": "0",
            "move_ins_storage_calc_link": "0",
            "move_ins_use_fms_map": "0",
            "non_overridable_fields": null,
            "offer_line_from": "plan_name",
            "orgID": "1000000090",
            "pass": "alek5",
            "pms": "sl",
            "post_account_activity_to_bulletin_board": false,
            "postrent": "You have completed the reservation process and your deposit transaction was successful.  One of our representatives will contact you to complete your storage rental.",
            "prerent": "After completing this registration you will be contacted to schedule an appointment at our facility to finish the rental process and receive security codes to access your new storage.",
            "promotion_type": "None",
            "pushrate": "yes",
            "rental_redirect_url": "",
            "reservation_threshold": false,
            "reservation_type": false,
            "secret": "aSDhQcGLAlS6Z74kqvBKxejvdWeeAY0NiYHyeIAv",
            "show_unavailable_units": "0",
            "showdescription": "yes",
            "siteID": "1000000555",
            "sitename": "",
            "sort_column": "size",
            "store": "248",
            "use_any_promotion_price": false,
            "use_fixed_promotion_price": "0",
            "use_promo_pricing": false,
            "use_push_rates": "0",
            "use_standard_push_rates": false,
            "user": "dan",
            "validated": true,
            "validcredentials": true
        },
        "callout": "",
        "city": "Raleigh",
        "city2": "",
        "country": "United-States",
        "coupon_copy": null,
        "coupons": null,
        "current_promo_offer": "Discount and Truck",
        "current_promo_offer_color": false,
        "custom_type": {
            "pay_url": "https://rental-center.storedge.com?companyId=2853794b-8d7c-4568-bf94-afee8841397b&facilityId=2f850c12-e441-4c4a-ad95-6e3b154ebffb#/login",
            "pay_url_type": "iframe",
            "reserve_url": ""
        },
        "email": "",
        "features": [
            {
                "_couch_id": "power",
                "desc": "",
                "order": 27,
                "visible": "False"
            }
        ],
        "id": "105620",
        "iframe_height": "",
        "iframe_scale": "",
        "last_mod": 1721116925,
        "latitude": 35.903781,
        "logo": "",
        "longitude": -78.582395,
        "map_radius": "",
        "map_zoom": "10",
        "metro": "",
        "module_status": null,
        "name": "A-1 Personal Storage",
        "name_modifier": "",
        "ns": "facility",
        "override_pay_url": "",
        "owner": 0,
        "phone": "5633328875",
        "pictures": [
            {
                "description": false,
                "file": "105620/slide-602ae3561da300.81867296--slide-5acb887ed3b335.20769187--durant-and-wake-forest-stuff-027.jpg",
                "image": "/client/resources/uploads/115077/slide0-5127876c29d010.47492587--wt-storagepic-couplemoving.jpg",
                "link": "",
                "title": "Self Storage"
            }
        ],
        "postal": "52722",
        "review_links": {
            "google_plus": "",
            "yahoo": "",
            "yelp": ""
        },
        "sales_phone": null,
        "sales_phone_mobile": null,
        "sales_phone_ppc": null,
        "seo": {
            "HideNameInTitle": "",
            "description": "Looking for affordable self storage in the Quad Cities area? Look no further! A-1 Self Storage offers secure, convenient 24-hour accessible storage units at great prices. Call today!",
            "keywords": "",
            "payonline": {
                "description": "",
                "keywords": "",
                "title": ""
            },
            "ss_anchor": "",
            "ss_link": "",
            "title": "Storage Units in Bettendorf, IA 52722"
        },
        "service_region": false,
        "showtax": "",
        "state": "NC",
        "state2": "",
        "status": 0,
        "subregion": "",
        "tenant-portal": null,
        "timezone": "America/Chicago",
        "trust_phone": "k6dwdwdwd9d5drmgdwdyd9dtd5",
        "type": "market_pro",
        "type_link": "http://",
        "unit_categories": null,
        "unit_summary": null
    }
}

schema_attributes:

{
    "id": "string",
    "key": "string",
    "value._id": "string",
    "value.accepted_cc": [
        "string"
    ],
    "value.address": "string",
    "value.address1": "string",
    "value.address2": "string",
    "value.address_modifier": "string",
    "value.address_modifier_color": "string",
    "value.api_config.URL": "string",
    "value.api_config._apicustom_": "string",
    "value.api_config._apisetup_": "string",
    "value.api_config.allow_excess_reservations": "string",
    "value.api_config.apiKey": "string",
    "value.api_config.application_id": "string",
    "value.api_config.bank_account_disclaimer": "string",
    "value.api_config.channel": "string",
    "value.api_config.company_name": "string",
    "value.api_config.corpcode": "string",
    "value.api_config.cs31OrgID": "string",
    "value.api_config.cs31SiteID": "string",
    "value.api_config.csPass": "string",
    "value.api_config.csSiteName": "string",
    "value.api_config.csUser": "string",
    "value.api_config.cs_description_access": "string",
    "value.api_config.cs_description_climate": "string",
    "value.api_config.cs_description_door": "string",
    "value.api_config.cs_description_features": "string",
    "value.api_config.cs_ignore_type_economy": "string",
    "value.api_config.cs_ignore_type_premium": "string",
    "value.api_config.cs_ignore_type_standard": "string",
    "value.api_config.cue_admin_fee": "string",
    "value.api_config.default_unit_prefix": "string",
    "value.api_config.description_field": "string",
    "value.api_config.disable_partial_payments": "string",
    "value.api_config.disable_payment_emails_to_facility_manager": "string",
    "value.api_config.disable_tenant_payment_editing": "string",
    "value.api_config.disable_tenant_profile_editing": "string",
    "value.api_config.discount_availability": "string",
    "value.api_config.display_count_threshold": "string",
    "value.api_config.enable_display_price_as_call": "string",
    "value.api_config.enable_display_unit_count": "string",
    "value.api_config.endpoint": "string",
    "value.api_config.facility": "string",
    "value.api_config.first_load": "string",
    "value.api_config.fms": "string",
    "value.api_config.fms_company_id": "string",
    "value.api_config.hardreservation": "string",
    "value.api_config.hide_unit_pricing": "string",
    "value.api_config.hideunavailable": "string",
    "value.api_config.key": "string",
    "value.api_config.last_pulled_date": "string",
    "value.api_config.last_time_polled": "string",
    "value.api_config.last_updated": "string",
    "value.api_config.locationCode": "string",
    "value.api_config.loccode": "string",
    "value.api_config.lockDesc": "string",
    "value.api_config.lockPrice": "string",
    "value.api_config.move_ins_alternate_insurance_name": "string",
    "value.api_config.move_ins_contract": "string",
    "value.api_config.move_ins_enabled": "string",
    "value.api_config.move_ins_future_dates": "string",
    "value.api_config.move_ins_future_dates_num": "string",
    "value.api_config.move_ins_hide_insurance_provider": "string",
    "value.api_config.move_ins_instructions": "string",
    "value.api_config.move_ins_insurance_required": "string",
    "value.api_config.move_ins_map": "string",
    "value.api_config.move_ins_reserve_instructions": "string",
    "value.api_config.move_ins_show_gate_code": "string",
    "value.api_config.move_ins_storage_calc_link": "string",
    "value.api_config.move_ins_use_fms_map": "string",
    "value.api_config.non_overridable_fields": "string",
    "value.api_config.offer_line_from": "string",
    "value.api_config.orgID": "string",
    "value.api_config.pass": "string",
    "value.api_config.pms": "string",
    "value.api_config.post_account_activity_to_bulletin_board": "string",
    "value.api_config.postrent": "string",
    "value.api_config.prerent": "string",
    "value.api_config.promotion_type": "string",
    "value.api_config.pushrate": "string",
    "value.api_config.rental_redirect_url": "string",
    "value.api_config.reservation_threshold": "string",
    "value.api_config.reservation_type": "string",
    "value.api_config.secret": "string",
    "value.api_config.show_unavailable_units": "string",
    "value.api_config.showdescription": "string",
    "value.api_config.siteID": "string",
    "value.api_config.sitename": "string",
    "value.api_config.sort_column": "string",
    "value.api_config.store": "string",
    "value.api_config.use_any_promotion_price": "string",
    "value.api_config.use_fixed_promotion_price": "string",
    "value.api_config.use_promo_pricing": "string",
    "value.api_config.use_push_rates": "string",
    "value.api_config.use_standard_push_rates": "string",
    "value.api_config.user": "string",
    "value.api_config.validated": "string",
    "value.api_config.validcredentials": "string",
    "value.callout": "string",
    "value.city": "string",
    "value.city2": "string",
    "value.country": "string",
    "value.coupon_copy": "string",
    "value.coupons": "string",
    "value.current_promo_offer": "string",
    "value.current_promo_offer_color": "string",
    "value.custom_type.pay_url": "string",
    "value.custom_type.pay_url_type": "string",
    "value.custom_type.reserve_url": "string",
    "value.email": "string",
    "value.features": [
        {
            "_couch_id": "string",
            "desc": "string",
            "order": "string",
            "visible": "string"
        }
    ],
    "value.id": "string",
    "value.iframe_height": "string",
    "value.iframe_scale": "string",
    "value.last_mod": "string",
    "value.latitude": "string",
    "value.logo": "string",
    "value.longitude": "string",
    "value.map_radius": "string",
    "value.map_zoom": "string",
    "value.metro": "string",
    "value.module_status": "string",
    "value.name": "string",
    "value.name_modifier": "string",
    "value.ns": "string",
    "value.override_pay_url": "string",
    "value.owner": "string",
    "value.phone": "string",
    "value.pictures": [
        {
            "description": "string",
            "file": "string",
            "image": "string",
            "link": "string",
            "title": "string"
        }
    ],
    "value.postal": "string",
    "value.review_links.google_plus": "string",
    "value.review_links.yahoo": "string",
    "value.review_links.yelp": "string",
    "value.sales_phone": "string",
    "value.sales_phone_mobile": "string",
    "value.sales_phone_ppc": "string",
    "value.seo.HideNameInTitle": "string",
    "value.seo.description": "string",
    "value.seo.keywords": "string",
    "value.seo.payonline.description": "string",
    "value.seo.payonline.keywords": "string",
    "value.seo.payonline.title": "string",
    "value.seo.ss_anchor": "string",
    "value.seo.ss_link": "string",
    "value.seo.title": "string",
    "value.service_region": "string",
    "value.showtax": "string",
    "value.state": "string",
    "value.state2": "string",
    "value.status": "string",
    "value.subregion": "string",
    "value.tenant_portal": "string",
    "value.timezone": "string",
    "value.trust_phone": "string",
    "value.type": "string",
    "value.type_link": "string",
    "value.unit_categories": "string",
    "value.unit_summary": "string"
}

schema_name_id: 786
schema_scan_id: 5920567
updated: 2024-08-10 07:52:20

Schema Scans: 3

Last at 2024-08-12 11:36:42

Scan 5924779

duration: 0:00:36.117615

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 5924779

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-couch-storedge-stage",
        "hive_path": "s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-12/1723480594",
        "key": "raw/webworks_facilities/2024-08-12/1723480594/facilities.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_couch.storedge_webworks_facilities",
        "type": "couch"
    },
    "trace_context": {
        "parent_id": 5409080971479751122,
        "service_name": "preloading",
        "span_id": 5559253515329945514,
        "trace_id": 170962626563822740
    }
}

running: False
schema_name_id: 786
start_time: 2024-08-12 11:36:42
success: True
trace_id: 170962626563822740

Scan 5922396

duration: 0:00:36.038742

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 5922396

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-couch-storedge-stage",
        "hive_path": "s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-11/1723380704",
        "key": "raw/webworks_facilities/2024-08-11/1723380704/facilities.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_couch.storedge_webworks_facilities",
        "type": "couch"
    },
    "trace_context": {
        "parent_id": 15080943639015507277,
        "service_name": "preloading",
        "span_id": 11041006967445314780,
        "trace_id": 6281865032177690502
    }
}

running: False
schema_name_id: 786
start_time: 2024-08-11 07:52:01
success: True
trace_id: 6281865032177690502

Scan 5920567

duration: 0:00:34.716878

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 5920567

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-couch-storedge-stage",
        "hive_path": "s3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-10/1723294294",
        "key": "raw/webworks_facilities/2024-08-10/1723294294/facilities.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_couch.storedge_webworks_facilities",
        "type": "couch"
    },
    "trace_context": {
        "parent_id": 4941323933354068695,
        "service_name": "preloading",
        "span_id": 7311297322293834857,
        "trace_id": 6303545784984828269
    }
}

running: False
schema_name_id: 786
start_time: 2024-08-10 07:51:46
success: True
trace_id: 6303545784984828269

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "id": "string",
    "key": "string",
    "value._id": "string",
    "value.accepted_cc": [
        "string"
    ],
    "value.address": "string",
    "value.address1": "string",
    "value.address2": "string",
    "value.address_modifier": "string",
    "value.address_modifier_color": "string",
    "value.api_config.URL": "string",
    "value.api_config._apicustom_": "string",
    "value.api_config._apisetup_": "string",
    "value.api_config.allow_excess_reservations": "string",
    "value.api_config.apiKey": "string",
    "value.api_config.application_id": "string",
    "value.api_config.bank_account_disclaimer": "string",
    "value.api_config.channel": "string",
    "value.api_config.company_name": "string",
    "value.api_config.corpcode": "string",
    "value.api_config.cs31OrgID": "string",
    "value.api_config.cs31SiteID": "string",
    "value.api_config.csPass": "string",
    "value.api_config.csSiteName": "string",
    "value.api_config.csUser": "string",
    "value.api_config.cs_description_access": "string",
    "value.api_config.cs_description_climate": "string",
    "value.api_config.cs_description_door": "string",
    "value.api_config.cs_description_features": "string",
    "value.api_config.cs_ignore_type_economy": "string",
    "value.api_config.cs_ignore_type_premium": "string",
    "value.api_config.cs_ignore_type_standard": "string",
    "value.api_config.cue_admin_fee": "string",
    "value.api_config.default_unit_prefix": "string",
    "value.api_config.description_field": "string",
    "value.api_config.disable_partial_payments": "string",
    "value.api_config.disable_payment_emails_to_facility_manager": "string",
    "value.api_config.disable_tenant_payment_editing": "string",
    "value.api_config.disable_tenant_profile_editing": "string",
    "value.api_config.discount_availability": "string",
    "value.api_config.display_count_threshold": "string",
    "value.api_config.enable_display_price_as_call": "string",
    "value.api_config.enable_display_unit_count": "string",
    "value.api_config.endpoint": "string",
    "value.api_config.facility": "string",
    "value.api_config.first_load": "string",
    "value.api_config.fms": "string",
    "value.api_config.fms_company_id": "string",
    "value.api_config.hardreservation": "string",
    "value.api_config.hide_unit_pricing": "string",
    "value.api_config.hideunavailable": "string",
    "value.api_config.key": "string",
    "value.api_config.last_pulled_date": "string",
    "value.api_config.last_time_polled": "string",
    "value.api_config.last_updated": "string",
    "value.api_config.locationCode": "string",
    "value.api_config.loccode": "string",
    "value.api_config.lockDesc": "string",
    "value.api_config.lockPrice": "string",
    "value.api_config.move_ins_alternate_insurance_name": "string",
    "value.api_config.move_ins_contract": "string",
    "value.api_config.move_ins_enabled": "string",
    "value.api_config.move_ins_future_dates": "string",
    "value.api_config.move_ins_future_dates_num": "string",
    "value.api_config.move_ins_hide_insurance_provider": "string",
    "value.api_config.move_ins_instructions": "string",
    "value.api_config.move_ins_insurance_required": "string",
    "value.api_config.move_ins_map": "string",
    "value.api_config.move_ins_reserve_instructions": "string",
    "value.api_config.move_ins_show_gate_code": "string",
    "value.api_config.move_ins_storage_calc_link": "string",
    "value.api_config.move_ins_use_fms_map": "string",
    "value.api_config.non_overridable_fields": "string",
    "value.api_config.offer_line_from": "string",
    "value.api_config.orgID": "string",
    "value.api_config.pass": "string",
    "value.api_config.pms": "string",
    "value.api_config.post_account_activity_to_bulletin_board": "string",
    "value.api_config.postrent": "string",
    "value.api_config.prerent": "string",
    "value.api_config.promotion_type": "string",
    "value.api_config.pushrate": "string",
    "value.api_config.rental_redirect_url": "string",
    "value.api_config.reservation_threshold": "string",
    "value.api_config.reservation_type": "string",
    "value.api_config.secret": "string",
    "value.api_config.show_unavailable_units": "string",
    "value.api_config.showdescription": "string",
    "value.api_config.siteID": "string",
    "value.api_config.sitename": "string",
    "value.api_config.sort_column": "string",
    "value.api_config.store": "string",
    "value.api_config.use_any_promotion_price": "string",
    "value.api_config.use_fixed_promotion_price": "string",
    "value.api_config.use_promo_pricing": "string",
    "value.api_config.use_push_rates": "string",
    "value.api_config.use_standard_push_rates": "string",
    "value.api_config.user": "string",
    "value.api_config.validated": "string",
    "value.api_config.validcredentials": "string",
    "value.callout": "string",
    "value.city": "string",
    "value.city2": "string",
    "value.country": "string",
    "value.coupon_copy": "string",
    "value.coupons": "string",
    "value.current_promo_offer": "string",
    "value.current_promo_offer_color": "string",
    "value.custom_type.pay_url": "string",
    "value.custom_type.pay_url_type": "string",
    "value.custom_type.reserve_url": "string",
    "value.email": "string",
    "value.features": [
        {
            "_couch_id": "string",
            "desc": "string",
            "order": "string",
            "visible": "string"
        }
    ],
    "value.id": "string",
    "value.iframe_height": "string",
    "value.iframe_scale": "string",
    "value.last_mod": "string",
    "value.latitude": "string",
    "value.logo": "string",
    "value.longitude": "string",
    "value.map_radius": "string",
    "value.map_zoom": "string",
    "value.metro": "string",
    "value.module_status": "string",
    "value.name": "string",
    "value.name_modifier": "string",
    "value.ns": "string",
    "value.override_pay_url": "string",
    "value.owner": "string",
    "value.phone": "string",
    "value.pictures": [
        {
            "description": "string",
            "file": "string",
            "image": "string",
            "link": "string",
            "title": "string"
        }
    ],
    "value.postal": "string",
    "value.review_links.google_plus": "string",
    "value.review_links.yahoo": "string",
    "value.review_links.yelp": "string",
    "value.sales_phone": "string",
    "value.sales_phone_mobile": "string",
    "value.sales_phone_ppc": "string",
    "value.seo.HideNameInTitle": "string",
    "value.seo.description": "string",
    "value.seo.keywords": "string",
    "value.seo.payonline.description": "string",
    "value.seo.payonline.keywords": "string",
    "value.seo.payonline.title": "string",
    "value.seo.ss_anchor": "string",
    "value.seo.ss_link": "string",
    "value.seo.title": "string",
    "value.service_region": "string",
    "value.showtax": "string",
    "value.state": "string",
    "value.state2": "string",
    "value.status": "string",
    "value.subregion": "string",
    "value.tenant_portal": "string",
    "value.timezone": "string",
    "value.trust_phone": "string",
    "value.type": "string",
    "value.type_link": "string",
    "value.unit_categories": "string",
    "value.unit_summary": "string"
}

created: 2024-08-12 11:37:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_couch`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_couch.storedge_webworks_facilities`\n(\n`id`STRING,`key`STRING,`value`struct<`_id`:STRING,`id`:STRING,`accepted_cc`:array,`address`:STRING,`address1`:STRING,`address2`:STRING,`api_config`:struct<`fms`:STRING,`facility`:STRING,`fms_company_id`:STRING,`user`:STRING,`pass`:STRING,`corpcode`:STRING,`loccode`:STRING,`use_push_rates`:STRING,`use_promo_pricing`:STRING,`default_unit_prefix`:STRING,`bank_account_disclaimer`:STRING,`disable_tenant_profile_editing`:STRING,`disable_tenant_payment_editing`:STRING,`post_account_activity_to_bulletin_board`:STRING,`disable_payment_emails_to_facility_manager`:STRING,`disable_partial_payments`:STRING,`show_unavailable_units`:STRING,`promotion_type`:STRING,`discount_availability`:STRING,`offer_line_from`:STRING,`use_fixed_promotion_price`:STRING,`use_any_promotion_price`:STRING,`allow_excess_reservations`:STRING,`description_field`:STRING,`sort_column`:STRING,`cue_admin_fee`:STRING,`reservation_threshold`:STRING,`enable_display_unit_count`:STRING,`enable_display_price_as_call`:STRING,`display_count_threshold`:STRING,`hide_unit_pricing`:STRING,`channel`:STRING,`reservation_type`:STRING,`cs_description_features`:STRING,`cs_description_access`:STRING,`cs_description_climate`:STRING,`cs_description_door`:STRING,`cs_ignore_type_economy`:STRING,`cs_ignore_type_standard`:STRING,`cs_ignore_type_premium`:STRING,`endpoint`:STRING,`move_ins_enabled`:STRING,`move_ins_insurance_required`:STRING,`move_ins_future_dates`:STRING,`move_ins_future_dates_num`:STRING,`move_ins_use_fms_map`:STRING,`move_ins_map`:STRING,`move_ins_contract`:STRING,`move_ins_show_gate_code`:STRING,`move_ins_instructions`:STRING,`move_ins_reserve_instructions`:STRING,`move_ins_storage_calc_link`:STRING,`move_ins_alternate_insurance_name`:STRING,`move_ins_hide_insurance_provider`:STRING,`non_overridable_fields`:STRING,`last_pulled_date`:STRING,`last_time_polled`:STRING,`lockDesc`:STRING,`lockPrice`:STRING,`siteID`:STRING,`orgID`:STRING,`csUser`:STRING,`csPass`:STRING,`csSiteName`:STRING,`pms`:STRING,`pushrate`:STRING,`_apisetup_`:STRING,`hardreservation`:STRING,`hideunavailable`:STRING,`showdescription`:STRING,`first_load`:STRING,`validated`:STRING,`validcredentials`:STRING,`prerent`:STRING,`postrent`:STRING,`_apicustom_`:STRING,`key`:STRING,`secret`:STRING,`application_id`:STRING,`apiKey`:STRING,`locationCode`:STRING,`cs31SiteID`:STRING,`cs31OrgID`:STRING,`use_standard_push_rates`:STRING,`rental_redirect_url`:STRING,`last_updated`:STRING,`sitename`:STRING,`URL`:STRING,`company_name`:STRING,`store`:STRING>,`city`:STRING,`city2`:STRING,`subregion`:STRING,`custom_type`:struct<`pay_url`:STRING,`pay_url_type`:STRING,`reserve_url`:STRING>,`current_promo_offer`:STRING,`current_promo_offer_color`:STRING,`state`:STRING,`state2`:STRING,`country`:STRING,`last_mod`:STRING,`logo`:STRING,`latitude`:STRING,`longitude`:STRING,`map_radius`:STRING,`map_zoom`:STRING,`iframe_scale`:STRING,`iframe_height`:STRING,`module_status`:STRING,`name`:STRING,`override_pay_url`:STRING,`pictures`:array>,`ns`:STRING,`phone`:STRING,`postal`:STRING,`review_links`:struct<`google_plus`:STRING,`yelp`:STRING,`yahoo`:STRING>,`sales_phone`:STRING,`seo`:struct<`title`:STRING,`HideNameInTitle`:STRING,`description`:STRING,`keywords`:STRING,`ss_link`:STRING,`ss_anchor`:STRING,`payonline`:struct<`title`:STRING,`description`:STRING,`keywords`:STRING>>,`showtax`:STRING,`callout`:STRING,`type`:STRING,`type_link`:STRING,`timezone`:STRING,`features`:array>,`unit_categories`:STRING,`unit_summary`:STRING,`coupons`:STRING,`coupon_copy`:STRING,`email`:STRING,`metro`:STRING,`name_modifier`:STRING,`owner`:STRING,`status`:STRING,`sales_phone_ppc`:STRING,`trust_phone`:STRING,`address_modifier`:STRING,`address_modifier_color`:STRING,`tenant_portal`:STRING,`sales_phone_mobile`:STRING,`service_region`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-12/1723480594'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_couch.storedge_webworks_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_couch.storedge_webworks_facilities"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2019-03-18 11:30:12",
        "disabled": false,
        "format": "raw",
        "id": 786,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_couch",
            "table": "storedge_webworks_facilities"
        },
        "type": "couch"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "key": "string",
            "value._id": "string",
            "value.accepted_cc": [
                "string"
            ],
            "value.address": "string",
            "value.address1": "string",
            "value.address2": "string",
            "value.address_modifier": "string",
            "value.address_modifier_color": "string",
            "value.api_config.URL": "string",
            "value.api_config._apicustom_": "string",
            "value.api_config._apisetup_": "string",
            "value.api_config.allow_excess_reservations": "string",
            "value.api_config.apiKey": "string",
            "value.api_config.application_id": "string",
            "value.api_config.bank_account_disclaimer": "string",
            "value.api_config.channel": "string",
            "value.api_config.company_name": "string",
            "value.api_config.corpcode": "string",
            "value.api_config.cs31OrgID": "string",
            "value.api_config.cs31SiteID": "string",
            "value.api_config.csPass": "string",
            "value.api_config.csSiteName": "string",
            "value.api_config.csUser": "string",
            "value.api_config.cs_description_access": "string",
            "value.api_config.cs_description_climate": "string",
            "value.api_config.cs_description_door": "string",
            "value.api_config.cs_description_features": "string",
            "value.api_config.cs_ignore_type_economy": "string",
            "value.api_config.cs_ignore_type_premium": "string",
            "value.api_config.cs_ignore_type_standard": "string",
            "value.api_config.cue_admin_fee": "string",
            "value.api_config.default_unit_prefix": "string",
            "value.api_config.description_field": "string",
            "value.api_config.disable_partial_payments": "string",
            "value.api_config.disable_payment_emails_to_facility_manager": "string",
            "value.api_config.disable_tenant_payment_editing": "string",
            "value.api_config.disable_tenant_profile_editing": "string",
            "value.api_config.discount_availability": "string",
            "value.api_config.display_count_threshold": "string",
            "value.api_config.enable_display_price_as_call": "string",
            "value.api_config.enable_display_unit_count": "string",
            "value.api_config.endpoint": "string",
            "value.api_config.facility": "string",
            "value.api_config.first_load": "string",
            "value.api_config.fms": "string",
            "value.api_config.fms_company_id": "string",
            "value.api_config.hardreservation": "string",
            "value.api_config.hide_unit_pricing": "string",
            "value.api_config.hideunavailable": "string",
            "value.api_config.key": "string",
            "value.api_config.last_pulled_date": "string",
            "value.api_config.last_time_polled": "string",
            "value.api_config.last_updated": "string",
            "value.api_config.locationCode": "string",
            "value.api_config.loccode": "string",
            "value.api_config.lockDesc": "string",
            "value.api_config.lockPrice": "string",
            "value.api_config.move_ins_alternate_insurance_name": "string",
            "value.api_config.move_ins_contract": "string",
            "value.api_config.move_ins_enabled": "string",
            "value.api_config.move_ins_future_dates": "string",
            "value.api_config.move_ins_future_dates_num": "string",
            "value.api_config.move_ins_hide_insurance_provider": "string",
            "value.api_config.move_ins_instructions": "string",
            "value.api_config.move_ins_insurance_required": "string",
            "value.api_config.move_ins_map": "string",
            "value.api_config.move_ins_reserve_instructions": "string",
            "value.api_config.move_ins_show_gate_code": "string",
            "value.api_config.move_ins_storage_calc_link": "string",
            "value.api_config.move_ins_use_fms_map": "string",
            "value.api_config.non_overridable_fields": "string",
            "value.api_config.offer_line_from": "string",
            "value.api_config.orgID": "string",
            "value.api_config.pass": "string",
            "value.api_config.pms": "string",
            "value.api_config.post_account_activity_to_bulletin_board": "string",
            "value.api_config.postrent": "string",
            "value.api_config.prerent": "string",
            "value.api_config.promotion_type": "string",
            "value.api_config.pushrate": "string",
            "value.api_config.rental_redirect_url": "string",
            "value.api_config.reservation_threshold": "string",
            "value.api_config.reservation_type": "string",
            "value.api_config.secret": "string",
            "value.api_config.show_unavailable_units": "string",
            "value.api_config.showdescription": "string",
            "value.api_config.siteID": "string",
            "value.api_config.sitename": "string",
            "value.api_config.sort_column": "string",
            "value.api_config.store": "string",
            "value.api_config.use_any_promotion_price": "string",
            "value.api_config.use_fixed_promotion_price": "string",
            "value.api_config.use_promo_pricing": "string",
            "value.api_config.use_push_rates": "string",
            "value.api_config.use_standard_push_rates": "string",
            "value.api_config.user": "string",
            "value.api_config.validated": "string",
            "value.api_config.validcredentials": "string",
            "value.callout": "string",
            "value.city": "string",
            "value.city2": "string",
            "value.country": "string",
            "value.coupon_copy": "string",
            "value.coupons": "string",
            "value.current_promo_offer": "string",
            "value.current_promo_offer_color": "string",
            "value.custom_type.pay_url": "string",
            "value.custom_type.pay_url_type": "string",
            "value.custom_type.reserve_url": "string",
            "value.email": "string",
            "value.features": [
                {
                    "_couch_id": "string",
                    "desc": "string",
                    "order": "string",
                    "visible": "string"
                }
            ],
            "value.id": "string",
            "value.iframe_height": "string",
            "value.iframe_scale": "string",
            "value.last_mod": "string",
            "value.latitude": "string",
            "value.logo": "string",
            "value.longitude": "string",
            "value.map_radius": "string",
            "value.map_zoom": "string",
            "value.metro": "string",
            "value.module_status": "string",
            "value.name": "string",
            "value.name_modifier": "string",
            "value.ns": "string",
            "value.override_pay_url": "string",
            "value.owner": "string",
            "value.phone": "string",
            "value.pictures": [
                {
                    "description": "string",
                    "file": "string",
                    "image": "string",
                    "link": "string",
                    "title": "string"
                }
            ],
            "value.postal": "string",
            "value.review_links.google_plus": "string",
            "value.review_links.yahoo": "string",
            "value.review_links.yelp": "string",
            "value.sales_phone": "string",
            "value.sales_phone_mobile": "string",
            "value.sales_phone_ppc": "string",
            "value.seo.HideNameInTitle": "string",
            "value.seo.description": "string",
            "value.seo.keywords": "string",
            "value.seo.payonline.description": "string",
            "value.seo.payonline.keywords": "string",
            "value.seo.payonline.title": "string",
            "value.seo.ss_anchor": "string",
            "value.seo.ss_link": "string",
            "value.seo.title": "string",
            "value.service_region": "string",
            "value.showtax": "string",
            "value.state": "string",
            "value.state2": "string",
            "value.status": "string",
            "value.subregion": "string",
            "value.tenant_portal": "string",
            "value.timezone": "string",
            "value.trust_phone": "string",
            "value.type": "string",
            "value.type_link": "string",
            "value.unit_categories": "string",
            "value.unit_summary": "string"
        },
        "created": "2024-08-12 11:37:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_couch`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_couch.storedge_webworks_facilities`\n(\n`id`STRING,`key`STRING,`value`struct<`_id`:STRING,`id`:STRING,`accepted_cc`:array,`address`:STRING,`address1`:STRING,`address2`:STRING,`api_config`:struct<`fms`:STRING,`facility`:STRING,`fms_company_id`:STRING,`user`:STRING,`pass`:STRING,`corpcode`:STRING,`loccode`:STRING,`use_push_rates`:STRING,`use_promo_pricing`:STRING,`default_unit_prefix`:STRING,`bank_account_disclaimer`:STRING,`disable_tenant_profile_editing`:STRING,`disable_tenant_payment_editing`:STRING,`post_account_activity_to_bulletin_board`:STRING,`disable_payment_emails_to_facility_manager`:STRING,`disable_partial_payments`:STRING,`show_unavailable_units`:STRING,`promotion_type`:STRING,`discount_availability`:STRING,`offer_line_from`:STRING,`use_fixed_promotion_price`:STRING,`use_any_promotion_price`:STRING,`allow_excess_reservations`:STRING,`description_field`:STRING,`sort_column`:STRING,`cue_admin_fee`:STRING,`reservation_threshold`:STRING,`enable_display_unit_count`:STRING,`enable_display_price_as_call`:STRING,`display_count_threshold`:STRING,`hide_unit_pricing`:STRING,`channel`:STRING,`reservation_type`:STRING,`cs_description_features`:STRING,`cs_description_access`:STRING,`cs_description_climate`:STRING,`cs_description_door`:STRING,`cs_ignore_type_economy`:STRING,`cs_ignore_type_standard`:STRING,`cs_ignore_type_premium`:STRING,`endpoint`:STRING,`move_ins_enabled`:STRING,`move_ins_insurance_required`:STRING,`move_ins_future_dates`:STRING,`move_ins_future_dates_num`:STRING,`move_ins_use_fms_map`:STRING,`move_ins_map`:STRING,`move_ins_contract`:STRING,`move_ins_show_gate_code`:STRING,`move_ins_instructions`:STRING,`move_ins_reserve_instructions`:STRING,`move_ins_storage_calc_link`:STRING,`move_ins_alternate_insurance_name`:STRING,`move_ins_hide_insurance_provider`:STRING,`non_overridable_fields`:STRING,`last_pulled_date`:STRING,`last_time_polled`:STRING,`lockDesc`:STRING,`lockPrice`:STRING,`siteID`:STRING,`orgID`:STRING,`csUser`:STRING,`csPass`:STRING,`csSiteName`:STRING,`pms`:STRING,`pushrate`:STRING,`_apisetup_`:STRING,`hardreservation`:STRING,`hideunavailable`:STRING,`showdescription`:STRING,`first_load`:STRING,`validated`:STRING,`validcredentials`:STRING,`prerent`:STRING,`postrent`:STRING,`_apicustom_`:STRING,`key`:STRING,`secret`:STRING,`application_id`:STRING,`apiKey`:STRING,`locationCode`:STRING,`cs31SiteID`:STRING,`cs31OrgID`:STRING,`use_standard_push_rates`:STRING,`rental_redirect_url`:STRING,`last_updated`:STRING,`sitename`:STRING,`URL`:STRING,`company_name`:STRING,`store`:STRING>,`city`:STRING,`city2`:STRING,`subregion`:STRING,`custom_type`:struct<`pay_url`:STRING,`pay_url_type`:STRING,`reserve_url`:STRING>,`current_promo_offer`:STRING,`current_promo_offer_color`:STRING,`state`:STRING,`state2`:STRING,`country`:STRING,`last_mod`:STRING,`logo`:STRING,`latitude`:STRING,`longitude`:STRING,`map_radius`:STRING,`map_zoom`:STRING,`iframe_scale`:STRING,`iframe_height`:STRING,`module_status`:STRING,`name`:STRING,`override_pay_url`:STRING,`pictures`:array>,`ns`:STRING,`phone`:STRING,`postal`:STRING,`review_links`:struct<`google_plus`:STRING,`yelp`:STRING,`yahoo`:STRING>,`sales_phone`:STRING,`seo`:struct<`title`:STRING,`HideNameInTitle`:STRING,`description`:STRING,`keywords`:STRING,`ss_link`:STRING,`ss_anchor`:STRING,`payonline`:struct<`title`:STRING,`description`:STRING,`keywords`:STRING>>,`showtax`:STRING,`callout`:STRING,`type`:STRING,`type_link`:STRING,`timezone`:STRING,`features`:array>,`unit_categories`:STRING,`unit_summary`:STRING,`coupons`:STRING,`coupon_copy`:STRING,`email`:STRING,`metro`:STRING,`name_modifier`:STRING,`owner`:STRING,`status`:STRING,`sales_phone_ppc`:STRING,`trust_phone`:STRING,`address_modifier`:STRING,`address_modifier_color`:STRING,`tenant_portal`:STRING,`sales_phone_mobile`:STRING,`service_region`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-couch-storedge-stage/raw/webworks_facilities/2024-08-12/1723480594'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_couch.storedge_webworks_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_couch.storedge_webworks_facilities"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}