Schema Info

Schema Name: sfdl_stage_mongo.storedge_voyager_facilities
  • created: 2019-03-20 12:26:30
  • disabled: False
  • format: raw
  • id: 795
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_mongo",
    "table": "storedge_voyager_facilities"
}
  • type: mongo
Schema Versions: 3
    • created: 2022-02-02 22:22:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_facilities`\n(\n`companyId`STRING,`defaultImageDeleted`STRING,`primaryImageMediumId`STRING,`primaryImageMedium`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`mediumId`:STRING,`title`:STRING>,`phone`STRING,`tenantPortalUrl`STRING,`createdAt`struct<`_date`:STRING>,`promoBanner`STRING,`rentalCenterUrl`STRING,`overrides`struct<`address`:struct<`latitude`:STRING,`longitude`:STRING>>,`__v`STRING,`directPhone`STRING,`pageStatus`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`primaryTitle`STRING,`unitSummary`array>,`_id`STRING,`name`STRING,`primaryAlt`STRING,`socialMedia`struct<`platforms`:array>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`primaryTarget`STRING,`settings`struct<`disableReservations`:STRING,`bannerToken`:STRING,`businessAddressDescription`:STRING,`hidePricingDisplayCall`:STRING,`enableManagedRates`:STRING,`reservationConfirmation`:STRING,`callActionThreshold`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableDueAtMoveIn`:STRING,`showAvailableUnitCountThreshold`:STRING,`tagline`:STRING,`showUnavailableUnits`:STRING,`leaseUrl`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`reservationDisclaimer`:STRING,`enablePublicDescription`:STRING,`enableMoveIns`:STRING,`businessNameOverride`:STRING,`showAvailableUnitCount`:STRING>,`expirationWindow`STRING,`useReservationWindow`STRING,`updatedAt`struct<`_date`:STRING>,`unitGroups`array,`area`:STRING,`length`:STRING,`width`:STRING,`height`:STRING,`dueAtMoveInWithoutFees`:STRING,`availableUnitsCount`:STRING,`totalUnitsCount`:STRING,`standardRate`:STRING,`amenities`:array>,`discountPlans`:array,`discountPlanDiscounts`:array>,`facilities`:array>,`alwaysDiscountPlanDiscountId`:STRING,`clientApplications`:array>,`apiAssociationIds`:array,`discountPlanControls`:array,`existingTenantOnly`:STRING,`tenantAccountKindId`:STRING,`roundToNearest`:STRING,`prepayMonths`:STRING,`prepayRequired`:STRING,`minOccupancyMonths`:STRING,`minOccupancyRequired`:STRING,`kind`:STRING>>,`popular`:STRING,`leadOnly`:STRING,`promoId`:STRING,`moveInUrl`:STRING,`reservationUrl`:STRING,`sort`:STRING,`dueMonthly`:STRING,`price`:STRING,`discountedPrice`:STRING,`isWeekly`:STRING,`pricingTypeId`:STRING,`availablePricingTypes`:array>,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`googlePlaceId`STRING,`theme`struct<`colors`:struct<`tertiary`:STRING,`secondary`:STRING,`primary`:STRING,`_id`:struct<`_oid`:STRING>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`logo`struct<`title`:STRING,`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`_id`:struct<`_oid`:STRING>,`href`:STRING>,`mediumId`:STRING,`alt`:STRING>,`deleted`STRING,`currencySymbol`STRING,`linkOutUrl`STRING,`primaryLink`STRING,`enabled`STRING,`reservationWindow`STRING,`facilityType`STRING,`primaryImage`STRING,`hours`struct<`office`:struct<`note`:STRING,`hours`:array>>>,`access`:struct<`note`:STRING,`hours`:array>>>>,`address`struct<`state`:STRING,`country`:STRING,`city`:STRING,`latitude`:STRING,`longitude`:STRING,`address2`:STRING,`address1`:STRING,`postal`:STRING>,`storeNumber`STRING,`email`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`amenities`array>,`hasRentalCenter`STRING,`brandName`STRING,`useExpirationWindow`STRING,`discountPlans`array>>>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`: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-mongo-storedge-stage/raw/voyager_facilities/2022-02-02/1643861824'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_facilities"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-02-02/1643861824
    • id: 380511
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": "000eb7c0-a9e5-4979-a87f-8f692511752c",
    "address": {
        "address1": "440 Moores Lane",
        "address2": "",
        "city": "New Castle",
        "country": "US",
        "latitude": 39.6779546,
        "longitude": -75.5662651,
        "postal": "19720",
        "state": "DE"
    },
    "amenities": [
        {
            "id": "4515f794-bfef-4dce-8d9e-e33be10a4481",
            "name": "Gated Access",
            "sort": 0
        }
    ],
    "brandName": "",
    "companyId": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89",
    "createdAt": {
        "_date": "2020-05-20T15:17:39.091Z"
    },
    "currencySymbol": "$",
    "defaultImageDeleted": false,
    "deleted": false,
    "directPhone": "916-989-9217",
    "discountPlans": [
        {
            "autoApply": false,
            "availabilityText": "5/15/2020",
            "availableForAllFacilities": true,
            "description": "First Month Free",
            "discountPlanDiscounts": [
                {
                    "amount": 100,
                    "discountType": "percent",
                    "id": "984e9a4a-a351-4cc3-800e-fbd25cf1451c",
                    "monthNumber": 1
                }
            ],
            "endDate": null,
            "hideFromWebsite": false,
            "id": "40c28445-d9c1-4d50-a818-1fe05754d4da",
            "moveInOnly": false,
            "name": "1STMONTHFREE",
            "priority": null,
            "promotionType": "promotion",
            "publicDescription": "",
            "requirementsText": "",
            "startDate": "2020-05-15",
            "turnedOn": true
        }
    ],
    "email": "[email protected]",
    "enabled": true,
    "expirationWindow": 5,
    "facilityType": "full",
    "googlePlaceId": null,
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b021"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b028"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "61375cc110574d03af9fcab5"
        },
        "coordinates": [
            -135.081028,
            60.743223
        ],
        "type": "Point"
    },
    "logo": {
        "_id": {
            "_oid": "5e4c3b1512752b07e4fdb5ef"
        },
        "alt": "",
        "link": {
            "_id": {
                "_oid": "5e4c3b1512752b07e4fdb5f0"
            },
            "href": "/",
            "target": "_self"
        },
        "mediumId": "6089990886a61b0063db79f4",
        "path": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89/sentry-logo-6.jpg",
        "title": ""
    },
    "name": "Sentry Storage - Folsom Dam",
    "overrides": {
        "address": {
            "latitude": 33.5773130668816,
            "longitude": -96.17000877857208
        }
    },
    "pageStatus": "live",
    "phone": "(916) 975-7512",
    "primaryAlt": "Front",
    "primaryImage": "7773eb76-1bd9-4327-9de8-608cc534ac51/front-entrance-left-2.jpg",
    "primaryImageMediumId": "60898e3f86a61b0063d95720",
    "primaryLink": null,
    "primaryTarget": null,
    "primaryTitle": null,
    "promoBanner": null,
    "rentalCenterUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?sCorpCode=CCMQ&sLocationCode=L088&unit=&concession=&reservation=false&channeltype=",
    "reservationFeeRequired": false,
    "reservationWindow": 0,
    "reviews": [
        {
            "body": null,
            "email": null,
            "id": "b948a55a-0111-431f-b330-b368c8df30f1",
            "ip": "209.33.207.149",
            "name": null,
            "rating": 5,
            "reply": null,
            "timestamp": {
                "_date": "2021-08-12T17:55:15.836Z"
            }
        }
    ],
    "settings": {
        "bannerToken": "",
        "businessAddressDescription": "",
        "businessNameOverride": "",
        "callActionThreshold": 1,
        "disableReservations": false,
        "enableDueAtMoveIn": false,
        "enableManagedRates": true,
        "enableMoveIns": true,
        "enablePublicDescription": true,
        "enableUsePromoModifiedPricing": true,
        "hidePricingDisplayCall": false,
        "leaseUrl": "",
        "reservationConfirmation": "Please show this reservation when you come in. A copy has been emailed to you. Please note that online reservations cannot be guaranteed until availability has been confirmed by the facility.",
        "reservationDisclaimer": "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 unit.",
        "showAvailableUnitCount": false,
        "showAvailableUnitCountThreshold": 1,
        "showUnavailableUnits": true,
        "softwareProvider": "storedge",
        "tagline": "",
        "voyagerOnly": false
    },
    "socialMedia": {
        "_id": {
            "_oid": "6102f124d1e0e30645d59fe3"
        },
        "enabled": false,
        "platforms": [
            {
                "_id": {
                    "_oid": "61785788630f4b0643b0e765"
                },
                "enabled": true,
                "link": "https://business.google.com/u/2/dashboard/l/12588977188169164334",
                "provider": "Google"
            }
        ]
    },
    "storeNumber": "CCMQ-L088",
    "tenantPortalUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/login.aspx?sCorpCode=CCMQ&sLocationCode=L088",
    "theme": {
        "_id": {
            "_oid": "5e3c913f3ba0fe05e45d92de"
        },
        "colors": {
            "_id": {
                "_oid": "5e3c5d147c91ad05e5f3284f"
            },
            "primary": "#E3822E",
            "secondary": "#777777",
            "tertiary": "#e6e6e6"
        },
        "enabled": false
    },
    "timezone": "America/Los_Angeles",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "4e2b636c-a920-499a-b0ea-6de38d05c950",
                    "name": "Heated",
                    "token": null
                }
            ],
            "area": 200,
            "availablePricingTypes": [
                {
                    "marketRate": 77.99,
                    "marketRateWeekly": 18.01,
                    "pricingTypeId": 3,
                    "walkinRate": 82.99,
                    "walkinRateWeekly": 19.17
                }
            ],
            "availableUnitsCount": 0,
            "category": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "categoryName": "large",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "48e7d6a3-4105-450e-9887-8f9606488078",
                    "apiAssociationIds": [
                        "cd350722-ba07-4d53-8fdb-a33132ad99d5",
                        "8f1dfdfa-d2fc-4983-9b06-971b08a33ee4"
                    ],
                    "autoApply": true,
                    "availabilityText": "8/30/2018",
                    "availableForAllFacilities": true,
                    "clientApplications": [
                        {
                            "channelRates": false,
                            "id": "e9d6fd20-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "storEDGE Unified Platform"
                        },
                        {
                            "channelRates": false,
                            "id": "e6f1b080-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "FMS"
                        }
                    ],
                    "createdAt": "2018-08-30T09:10:33.664-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "One Month Free",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 100,
                            "createdAt": "2018-08-30T09:10:33.685-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "none",
                            "id": "0d8fefda-56e7-44a8-887e-de65490ba352",
                            "monthNumber": 1,
                            "updatedAt": "2018-09-18T12:52:35.518-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [
                        {
                            "id": "a61c01cc-49d2-4768-9613-0974e7889253"
                        },
                        {
                            "id": "1f70cae0-d793-4dab-b67d-7c5f767509a6"
                        },
                        {
                            "id": "c141b8f7-2a42-43b4-ab98-ad5734caf6b7"
                        },
                        {
                            "id": "e83ab373-6583-46c7-a71c-28a2f6d7236c"
                        },
                        {
                            "id": "b70fca4d-cbcf-4672-bb29-2ab1b2262f8e"
                        },
                        {
                            "id": "c8c91dc6-b285-45bf-85df-cf28ffa9b6d9"
                        },
                        {
                            "id": "48ae679c-aca6-4319-a7db-55e3d3a3ce06"
                        },
                        {
                            "id": "d0d04f4a-4347-4d2e-8c4d-63a3fc900810"
                        },
                        {
                            "id": "2ff6377e-9553-4c6e-9975-15fff472344a"
                        },
                        {
                            "id": "15957453-1388-4521-bb66-318d6fa47468"
                        },
                        {
                            "id": "cae9d1f7-a0b2-439f-a61b-7aa665397aa5"
                        },
                        {
                            "id": "9b143ec5-56d0-49b1-afa8-ee6e5d0a4c45"
                        },
                        {
                            "id": "98104cf8-657b-437f-a459-3564d749ab22"
                        },
                        {
                            "id": "194ed426-e6a1-48ef-b096-61e82df20a99"
                        },
                        {
                            "id": "029e5e04-38b7-42b4-bbc1-8d2d60625514"
                        },
                        {
                            "id": "e0a54728-f835-44c6-8c7e-92343072fc97"
                        },
                        {
                            "id": "efd3c33a-9c53-406f-baf2-6380034372f4"
                        },
                        {
                            "id": "9912d539-a67a-41c2-9637-1ae62e40aba5"
                        },
                        {
                            "id": "3cdc3f8e-43bb-4e31-b027-59249263f953"
                        },
                        {
                            "id": "81b61eda-f548-422f-918d-4337a23d518b"
                        },
                        {
                            "id": "531b4c45-2df6-4c92-8a49-19d562b4477f"
                        },
                        {
                            "id": "185039ae-4eaa-4d6f-936b-a9e6dcd19ca8"
                        },
                        {
                            "id": "b0ecc09b-4d2f-4340-b792-af0eaad84530"
                        },
                        {
                            "id": "ef1eaec7-94b2-466f-bb69-b9522c3da0f4"
                        },
                        {
                            "id": "10a90456-8244-42dc-8891-8c2f1da19293"
                        }
                    ],
                    "facilityIds": [
                        "6d6f5915-f311-4025-b9a6-c028872b9082",
                        "82dabcb7-8b13-44ab-bf27-80c9820f36e0",
                        "d41b5c03-82bb-4dc6-bd06-1f6c3324c3a7",
                        "ce1d8dc3-6641-40e9-9e7c-7b78845d2674",
                        "c5db3fc2-0bdc-46b0-b7dc-2e44eb20c9b9",
                        "b6fb9bb7-1944-46e6-9b61-9612f3bcdd7a",
                        "fc5eec50-ba54-4c68-b4c3-503995393e3b",
                        "1438968e-6346-472f-a11d-e04ceb9cee9d",
                        "59ceaf40-980a-4b76-a3a7-0435fc089cb3",
                        "ece54617-0944-43ff-bdf1-95c431536053",
                        "18ad62cb-055a-4cd5-bc50-9d2e889381cb",
                        "d75e0fde-4baa-4a01-a8e6-6f979696a450",
                        "77a5944c-408e-409a-a7fd-7cc545671717",
                        "1af5deb3-13c6-49a8-b859-e381d7716897",
                        "ff9f19ea-4407-48b2-9c68-c3d05fe95c64",
                        "df033046-9331-4185-85a2-5ddf1bc1eb50"
                    ],
                    "hideFromWebsite": false,
                    "id": "abe5b7a6-1465-4160-8da8-cc4990936c95",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "1MOFREECH",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "One Month Free",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2018-08-30",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2021-11-23T13:02:06.624-10:00"
                }
            ],
            "discountedPrice": null,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 219,
            "dueMonthly": 219,
            "height": 8,
            "id": "67e392c6-65ff-480a-9ee9-da3712158a06",
            "isWeekly": false,
            "leadOnly": null,
            "length": 10,
            "moveInUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/move-in/000d2d98-7259-40ed-9111-60cce9662b03/67e392c6-65ff-480a-9ee9-da3712158a06",
            "name": "20x10x8 - $219.00 - 75124 - 1",
            "popular": false,
            "price": 219,
            "priceWeekly": null,
            "pricingTypeId": null,
            "promoId": null,
            "reservationUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/reserve/67e392c6-65ff-480a-9ee9-da3712158a06",
            "sort": null,
            "standardRate": 219,
            "totalUnitsCount": 2,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 20
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 0,
            "id": "55e6b176-11d6-457b-b6ae-4efa3128485b",
            "maxPrice": 219,
            "minArea": 200,
            "minPrice": 219,
            "minSize": "10x20",
            "name": "Large",
            "siteUnitCategoryId": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "totalUnitsCount": 8
        }
    ],
    "updatedAt": {
        "_date": "2021-04-28T17:16:01.009Z"
    },
    "useExpirationWindow": false,
    "useReservationWindow": false
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id": "string",
    "address.address1": "string",
    "address.address2": "string",
    "address.city": "string",
    "address.country": "string",
    "address.latitude": "string",
    "address.longitude": "string",
    "address.postal": "string",
    "address.state": "string",
    "amenities": [
        {
            "id": "string",
            "name": "string",
            "sort": "string"
        }
    ],
    "brandName": "string",
    "companyId": "string",
    "createdAt._date": "string",
    "currencySymbol": "string",
    "defaultImageDeleted": "string",
    "deleted": "string",
    "directPhone": "string",
    "discountPlans": [
        {
            "autoApply": "string",
            "availabilityText": "string",
            "availableForAllFacilities": "string",
            "description": "string",
            "discountPlanDiscounts": [
                {
                    "amount": "string",
                    "discountType": "string",
                    "id": "string",
                    "monthNumber": "string"
                }
            ],
            "endDate": "string",
            "hideFromWebsite": "string",
            "id": "string",
            "moveInOnly": "string",
            "name": "string",
            "priority": "string",
            "promotionType": "string",
            "publicDescription": "string",
            "requirementsText": "string",
            "startDate": "string",
            "turnedOn": "string"
        }
    ],
    "email": "string",
    "enabled": "string",
    "expirationWindow": "string",
    "facilityType": "string",
    "googlePlaceId": "string",
    "hasRentalCenter": "string",
    "hours.access.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.access.note": "string",
    "hours.office.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.office.note": "string",
    "linkOutUrl": "string",
    "location._id._oid": "string",
    "location.coordinates": [
        "float"
    ],
    "location.type": "string",
    "logo._id._oid": "string",
    "logo.alt": "string",
    "logo.link._id._oid": "string",
    "logo.link.href": "string",
    "logo.link.target": "string",
    "logo.mediumId": "string",
    "logo.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "string",
    "primaryImageMedium._id._oid": "string",
    "primaryImageMedium.alt": "string",
    "primaryImageMedium.mediumId": "string",
    "primaryImageMedium.title": "string",
    "primaryImageMediumId": "string",
    "primaryLink": "string",
    "primaryTarget": "string",
    "primaryTitle": "string",
    "promoBanner": "string",
    "rentalCenterUrl": "string",
    "reservationFeeRequired": "string",
    "reservationWindow": "string",
    "reviews": [
        {
            "body": "string",
            "email": "string",
            "id": "string",
            "ip": "string",
            "name": "string",
            "rating": "string",
            "reply": "string",
            "timestamp._date": "string"
        }
    ],
    "settings.bannerToken": "string",
    "settings.businessAddressDescription": "string",
    "settings.businessNameOverride": "string",
    "settings.callActionThreshold": "string",
    "settings.disableReservations": "string",
    "settings.enableDueAtMoveIn": "string",
    "settings.enableManagedRates": "string",
    "settings.enableMoveIns": "string",
    "settings.enablePublicDescription": "string",
    "settings.enableUsePromoModifiedPricing": "string",
    "settings.hidePricingDisplayCall": "string",
    "settings.leaseUrl": "string",
    "settings.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "string",
    "socialMedia._id._oid": "string",
    "socialMedia.enabled": "string",
    "socialMedia.platforms": [
        {
            "_id._oid": "string",
            "enabled": "string",
            "link": "string",
            "provider": "string"
        }
    ],
    "storeNumber": "string",
    "tenantPortalUrl": "string",
    "theme._id._oid": "string",
    "theme.colors._id._oid": "string",
    "theme.colors.primary": "string",
    "theme.colors.secondary": "string",
    "theme.colors.tertiary": "string",
    "theme.enabled": "string",
    "timezone": "string",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "string",
                    "name": "string",
                    "token": "string"
                }
            ],
            "area": "string",
            "availablePricingTypes": [
                {
                    "marketRate": "string",
                    "marketRateWeekly": "string",
                    "pricingTypeId": "string",
                    "walkinRate": "string",
                    "walkinRateWeekly": "string"
                }
            ],
            "availableUnitsCount": "string",
            "category": "string",
            "categoryName": "string",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "string",
                    "apiAssociationIds": [
                        "string"
                    ],
                    "autoApply": "string",
                    "availabilityText": "string",
                    "availableForAllFacilities": "string",
                    "clientApplications": [
                        {
                            "channelRates": "string",
                            "id": "string",
                            "name": "string"
                        }
                    ],
                    "createdAt": "string",
                    "deleted": "string",
                    "deletedBy": "string",
                    "deletedOn": "string",
                    "description": "string",
                    "discountPlanControls": [
                        "string"
                    ],
                    "discountPlanDiscounts": [
                        {
                            "amount": "string",
                            "createdAt": "string",
                            "deleted": "string",
                            "deletedBy": "string",
                            "deletedOn": "string",
                            "discountType": "string",
                            "id": "string",
                            "monthNumber": "string",
                            "updatedAt": "string"
                        }
                    ],
                    "endDate": "string",
                    "existingTenantOnly": "string",
                    "facilities": [
                        {
                            "id": "string"
                        }
                    ],
                    "facilityIds": [
                        "string"
                    ],
                    "hideFromWebsite": "string",
                    "id": "string",
                    "kind": "string",
                    "minOccupancyMonths": "string",
                    "minOccupancyRequired": "string",
                    "moveInOnly": "string",
                    "name": "string",
                    "prepayMonths": "string",
                    "prepayRequired": "string",
                    "priority": "string",
                    "promotionType": "string",
                    "publicDescription": "string",
                    "requirementsText": "string",
                    "roundToNearest": "string",
                    "startDate": "string",
                    "tenantAccountKindId": "string",
                    "turnedOn": "string",
                    "updatedAt": "string"
                }
            ],
            "discountedPrice": "string",
            "dueAtMoveIn": "string",
            "dueAtMoveInWithoutFees": "string",
            "dueMonthly": "string",
            "height": "string",
            "id": "string",
            "isWeekly": "string",
            "leadOnly": "string",
            "length": "string",
            "moveInUrl": "string",
            "name": "string",
            "popular": "string",
            "price": "string",
            "priceWeekly": "string",
            "pricingTypeId": "string",
            "promoId": "string",
            "reservationUrl": "string",
            "sort": "string",
            "standardRate": "string",
            "totalUnitsCount": "string",
            "type.id": "string",
            "type.name": "string",
            "width": "string"
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": "string",
            "id": "string",
            "maxPrice": "string",
            "minArea": "string",
            "minPrice": "string",
            "minSize": "string",
            "name": "string",
            "siteUnitCategoryId": "string",
            "totalUnitsCount": "string"
        }
    ],
    "updatedAt._date": "string",
    "useExpirationWindow": "string",
    "useReservationWindow": "string"
}
    • schema_name_id: 795
    • schema_scan_id: 3678026
    • updated: 2022-02-02 22:22:38
    • created: 2022-02-01 22:21:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_facilities`\n(\n`companyId`STRING,`defaultImageDeleted`STRING,`primaryImageMediumId`STRING,`primaryImageMedium`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`mediumId`:STRING,`title`:STRING>,`phone`STRING,`tenantPortalUrl`STRING,`createdAt`struct<`_date`:STRING>,`promoBanner`STRING,`rentalCenterUrl`STRING,`overrides`struct<`address`:struct<`latitude`:STRING,`longitude`:STRING>>,`__v`STRING,`pageStatus`STRING,`directPhone`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`primaryTitle`STRING,`unitSummary`array>,`_id`STRING,`name`STRING,`primaryAlt`STRING,`socialMedia`struct<`platforms`:array>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`primaryTarget`STRING,`settings`struct<`disableReservations`:STRING,`bannerToken`:STRING,`businessAddressDescription`:STRING,`hidePricingDisplayCall`:STRING,`enableManagedRates`:STRING,`reservationConfirmation`:STRING,`callActionThreshold`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableDueAtMoveIn`:STRING,`showAvailableUnitCountThreshold`:STRING,`tagline`:STRING,`showUnavailableUnits`:STRING,`leaseUrl`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`reservationDisclaimer`:STRING,`enablePublicDescription`:STRING,`enableMoveIns`:STRING,`businessNameOverride`:STRING,`showAvailableUnitCount`:STRING>,`expirationWindow`STRING,`useReservationWindow`STRING,`updatedAt`struct<`_date`:STRING>,`unitGroups`array,`area`:STRING,`length`:STRING,`width`:STRING,`height`:STRING,`dueAtMoveInWithoutFees`:STRING,`availableUnitsCount`:STRING,`totalUnitsCount`:STRING,`standardRate`:STRING,`amenities`:array>,`discountPlans`:array,`discountPlanDiscounts`:array>,`facilities`:array>,`alwaysDiscountPlanDiscountId`:STRING,`clientApplications`:array>,`apiAssociationIds`:array,`discountPlanControls`:array,`existingTenantOnly`:STRING,`tenantAccountKindId`:STRING,`roundToNearest`:STRING,`prepayMonths`:STRING,`prepayRequired`:STRING,`minOccupancyMonths`:STRING,`minOccupancyRequired`:STRING,`kind`:STRING>>,`popular`:STRING,`leadOnly`:STRING,`promoId`:STRING,`moveInUrl`:STRING,`reservationUrl`:STRING,`sort`:STRING,`dueMonthly`:STRING,`price`:STRING,`discountedPrice`:STRING,`isWeekly`:STRING,`pricingTypeId`:STRING,`availablePricingTypes`:array>,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`googlePlaceId`STRING,`theme`struct<`colors`:struct<`tertiary`:STRING,`secondary`:STRING,`primary`:STRING,`_id`:struct<`_oid`:STRING>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`logo`struct<`title`:STRING,`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`_id`:struct<`_oid`:STRING>,`href`:STRING>,`mediumId`:STRING,`alt`:STRING>,`deleted`STRING,`currencySymbol`STRING,`linkOutUrl`STRING,`primaryLink`STRING,`enabled`STRING,`reservationWindow`STRING,`facilityType`STRING,`primaryImage`STRING,`hours`struct<`office`:struct<`note`:STRING,`hours`:array>>>,`access`:struct<`note`:STRING,`hours`:array>>>>,`address`struct<`state`:STRING,`country`:STRING,`city`:STRING,`latitude`:STRING,`longitude`:STRING,`address2`:STRING,`address1`:STRING,`postal`:STRING>,`storeNumber`STRING,`email`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`amenities`array>,`hasRentalCenter`STRING,`brandName`STRING,`useExpirationWindow`STRING,`discountPlans`array>>>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`: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-mongo-storedge-stage/raw/voyager_facilities/2022-02-01/1643775429'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_facilities"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-02-01/1643775429
    • id: 380342
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": "000eb7c0-a9e5-4979-a87f-8f692511752c",
    "address": {
        "address1": "440 Moores Lane",
        "address2": "",
        "city": "New Castle",
        "country": "US",
        "latitude": 39.6779546,
        "longitude": -75.5662651,
        "postal": "19720",
        "state": "DE"
    },
    "amenities": [
        {
            "id": "4515f794-bfef-4dce-8d9e-e33be10a4481",
            "name": "Gated Access",
            "sort": 0
        }
    ],
    "brandName": "",
    "companyId": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89",
    "createdAt": {
        "_date": "2020-05-20T15:17:39.091Z"
    },
    "currencySymbol": "$",
    "defaultImageDeleted": false,
    "deleted": false,
    "directPhone": "916-989-9217",
    "discountPlans": [
        {
            "autoApply": false,
            "availabilityText": "5/15/2020",
            "availableForAllFacilities": true,
            "description": "First Month Free",
            "discountPlanDiscounts": [
                {
                    "amount": 100,
                    "discountType": "percent",
                    "id": "984e9a4a-a351-4cc3-800e-fbd25cf1451c",
                    "monthNumber": 1
                }
            ],
            "endDate": null,
            "hideFromWebsite": false,
            "id": "40c28445-d9c1-4d50-a818-1fe05754d4da",
            "moveInOnly": false,
            "name": "1STMONTHFREE",
            "priority": null,
            "promotionType": "promotion",
            "publicDescription": "",
            "requirementsText": "",
            "startDate": "2020-05-15",
            "turnedOn": true
        }
    ],
    "email": "[email protected]",
    "enabled": true,
    "expirationWindow": 5,
    "facilityType": "full",
    "googlePlaceId": null,
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b021"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b028"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "61375cc110574d03af9fcab5"
        },
        "coordinates": [
            -135.081028,
            60.743223
        ],
        "type": "Point"
    },
    "logo": {
        "_id": {
            "_oid": "5e4c3b1512752b07e4fdb5ef"
        },
        "alt": "",
        "link": {
            "_id": {
                "_oid": "5e4c3b1512752b07e4fdb5f0"
            },
            "href": "/",
            "target": "_self"
        },
        "mediumId": "6089990886a61b0063db79f4",
        "path": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89/sentry-logo-6.jpg",
        "title": ""
    },
    "name": "Sentry Storage - Folsom Dam",
    "overrides": {
        "address": {
            "latitude": 33.5773130668816,
            "longitude": -96.17000877857208
        }
    },
    "pageStatus": "live",
    "phone": "(916) 975-7512",
    "primaryAlt": "Front",
    "primaryImage": "7773eb76-1bd9-4327-9de8-608cc534ac51/front-entrance-left-2.jpg",
    "primaryImageMediumId": "60898e3f86a61b0063d95720",
    "primaryLink": null,
    "primaryTarget": null,
    "primaryTitle": null,
    "promoBanner": null,
    "rentalCenterUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?sCorpCode=CCMQ&sLocationCode=L088&unit=&concession=&reservation=false&channeltype=",
    "reservationFeeRequired": false,
    "reservationWindow": 0,
    "reviews": [
        {
            "body": null,
            "email": null,
            "id": "b948a55a-0111-431f-b330-b368c8df30f1",
            "ip": "209.33.207.149",
            "name": null,
            "rating": 5,
            "reply": null,
            "timestamp": {
                "_date": "2021-08-12T17:55:15.836Z"
            }
        }
    ],
    "settings": {
        "bannerToken": "",
        "businessAddressDescription": "",
        "businessNameOverride": "",
        "callActionThreshold": 1,
        "disableReservations": false,
        "enableDueAtMoveIn": false,
        "enableManagedRates": true,
        "enableMoveIns": true,
        "enablePublicDescription": true,
        "enableUsePromoModifiedPricing": true,
        "hidePricingDisplayCall": false,
        "leaseUrl": "",
        "reservationConfirmation": "Please show this reservation when you come in. A copy has been emailed to you. Please note that online reservations cannot be guaranteed until availability has been confirmed by the facility.",
        "reservationDisclaimer": "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 unit.",
        "showAvailableUnitCount": false,
        "showAvailableUnitCountThreshold": 1,
        "showUnavailableUnits": true,
        "softwareProvider": "storedge",
        "tagline": "",
        "voyagerOnly": false
    },
    "socialMedia": {
        "_id": {
            "_oid": "6102f124d1e0e30645d59fe3"
        },
        "enabled": false,
        "platforms": [
            {
                "_id": {
                    "_oid": "61785788630f4b0643b0e765"
                },
                "enabled": true,
                "link": "https://business.google.com/u/2/dashboard/l/12588977188169164334",
                "provider": "Google"
            }
        ]
    },
    "storeNumber": "CCMQ-L088",
    "tenantPortalUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/login.aspx?sCorpCode=CCMQ&sLocationCode=L088",
    "theme": {
        "_id": {
            "_oid": "5e3c913f3ba0fe05e45d92de"
        },
        "colors": {
            "_id": {
                "_oid": "5e3c5d147c91ad05e5f3284f"
            },
            "primary": "#E3822E",
            "secondary": "#777777",
            "tertiary": "#e6e6e6"
        },
        "enabled": false
    },
    "timezone": "America/Los_Angeles",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "4e2b636c-a920-499a-b0ea-6de38d05c950",
                    "name": "Heated",
                    "token": null
                }
            ],
            "area": 200,
            "availablePricingTypes": [
                {
                    "marketRate": 77.99,
                    "marketRateWeekly": 18.01,
                    "pricingTypeId": 3,
                    "walkinRate": 82.99,
                    "walkinRateWeekly": 19.17
                }
            ],
            "availableUnitsCount": 0,
            "category": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "categoryName": "large",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "48e7d6a3-4105-450e-9887-8f9606488078",
                    "apiAssociationIds": [
                        "cd350722-ba07-4d53-8fdb-a33132ad99d5",
                        "8f1dfdfa-d2fc-4983-9b06-971b08a33ee4"
                    ],
                    "autoApply": true,
                    "availabilityText": "8/30/2018",
                    "availableForAllFacilities": true,
                    "clientApplications": [
                        {
                            "channelRates": false,
                            "id": "e9d6fd20-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "storEDGE Unified Platform"
                        },
                        {
                            "channelRates": false,
                            "id": "e6f1b080-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "FMS"
                        }
                    ],
                    "createdAt": "2018-08-30T09:10:33.664-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "One Month Free",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 100,
                            "createdAt": "2018-08-30T09:10:33.685-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "none",
                            "id": "0d8fefda-56e7-44a8-887e-de65490ba352",
                            "monthNumber": 1,
                            "updatedAt": "2018-09-18T12:52:35.518-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [
                        {
                            "id": "a61c01cc-49d2-4768-9613-0974e7889253"
                        },
                        {
                            "id": "1f70cae0-d793-4dab-b67d-7c5f767509a6"
                        },
                        {
                            "id": "c141b8f7-2a42-43b4-ab98-ad5734caf6b7"
                        },
                        {
                            "id": "e83ab373-6583-46c7-a71c-28a2f6d7236c"
                        },
                        {
                            "id": "b70fca4d-cbcf-4672-bb29-2ab1b2262f8e"
                        },
                        {
                            "id": "c8c91dc6-b285-45bf-85df-cf28ffa9b6d9"
                        },
                        {
                            "id": "48ae679c-aca6-4319-a7db-55e3d3a3ce06"
                        },
                        {
                            "id": "d0d04f4a-4347-4d2e-8c4d-63a3fc900810"
                        },
                        {
                            "id": "2ff6377e-9553-4c6e-9975-15fff472344a"
                        },
                        {
                            "id": "15957453-1388-4521-bb66-318d6fa47468"
                        },
                        {
                            "id": "cae9d1f7-a0b2-439f-a61b-7aa665397aa5"
                        },
                        {
                            "id": "9b143ec5-56d0-49b1-afa8-ee6e5d0a4c45"
                        },
                        {
                            "id": "98104cf8-657b-437f-a459-3564d749ab22"
                        },
                        {
                            "id": "194ed426-e6a1-48ef-b096-61e82df20a99"
                        },
                        {
                            "id": "029e5e04-38b7-42b4-bbc1-8d2d60625514"
                        },
                        {
                            "id": "e0a54728-f835-44c6-8c7e-92343072fc97"
                        },
                        {
                            "id": "efd3c33a-9c53-406f-baf2-6380034372f4"
                        },
                        {
                            "id": "9912d539-a67a-41c2-9637-1ae62e40aba5"
                        },
                        {
                            "id": "3cdc3f8e-43bb-4e31-b027-59249263f953"
                        },
                        {
                            "id": "81b61eda-f548-422f-918d-4337a23d518b"
                        },
                        {
                            "id": "531b4c45-2df6-4c92-8a49-19d562b4477f"
                        },
                        {
                            "id": "185039ae-4eaa-4d6f-936b-a9e6dcd19ca8"
                        },
                        {
                            "id": "b0ecc09b-4d2f-4340-b792-af0eaad84530"
                        },
                        {
                            "id": "ef1eaec7-94b2-466f-bb69-b9522c3da0f4"
                        },
                        {
                            "id": "10a90456-8244-42dc-8891-8c2f1da19293"
                        }
                    ],
                    "facilityIds": [
                        "6d6f5915-f311-4025-b9a6-c028872b9082",
                        "82dabcb7-8b13-44ab-bf27-80c9820f36e0",
                        "d41b5c03-82bb-4dc6-bd06-1f6c3324c3a7",
                        "ce1d8dc3-6641-40e9-9e7c-7b78845d2674",
                        "c5db3fc2-0bdc-46b0-b7dc-2e44eb20c9b9",
                        "b6fb9bb7-1944-46e6-9b61-9612f3bcdd7a",
                        "fc5eec50-ba54-4c68-b4c3-503995393e3b",
                        "1438968e-6346-472f-a11d-e04ceb9cee9d",
                        "59ceaf40-980a-4b76-a3a7-0435fc089cb3",
                        "ece54617-0944-43ff-bdf1-95c431536053",
                        "18ad62cb-055a-4cd5-bc50-9d2e889381cb",
                        "d75e0fde-4baa-4a01-a8e6-6f979696a450",
                        "77a5944c-408e-409a-a7fd-7cc545671717",
                        "1af5deb3-13c6-49a8-b859-e381d7716897",
                        "ff9f19ea-4407-48b2-9c68-c3d05fe95c64",
                        "df033046-9331-4185-85a2-5ddf1bc1eb50"
                    ],
                    "hideFromWebsite": false,
                    "id": "abe5b7a6-1465-4160-8da8-cc4990936c95",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "1MOFREECH",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "One Month Free",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2018-08-30",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2021-11-23T13:02:06.624-10:00"
                }
            ],
            "discountedPrice": null,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 219,
            "dueMonthly": 219,
            "height": 8,
            "id": "67e392c6-65ff-480a-9ee9-da3712158a06",
            "isWeekly": false,
            "leadOnly": null,
            "length": 10,
            "moveInUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/move-in/000d2d98-7259-40ed-9111-60cce9662b03/67e392c6-65ff-480a-9ee9-da3712158a06",
            "name": "20x10x8 - $219.00 - 75124 - 1",
            "popular": false,
            "price": 219,
            "priceWeekly": null,
            "pricingTypeId": null,
            "promoId": null,
            "reservationUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/reserve/67e392c6-65ff-480a-9ee9-da3712158a06",
            "sort": null,
            "standardRate": 219,
            "totalUnitsCount": 2,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 20
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 0,
            "id": "8bbf25e0-ab3a-4604-9345-47447f04e567",
            "maxPrice": 219,
            "minArea": 200,
            "minPrice": 219,
            "minSize": "10x20",
            "name": "Large",
            "siteUnitCategoryId": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "totalUnitsCount": 8
        }
    ],
    "updatedAt": {
        "_date": "2021-04-28T17:16:01.009Z"
    },
    "useExpirationWindow": false,
    "useReservationWindow": false
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id": "string",
    "address.address1": "string",
    "address.address2": "string",
    "address.city": "string",
    "address.country": "string",
    "address.latitude": "string",
    "address.longitude": "string",
    "address.postal": "string",
    "address.state": "string",
    "amenities": [
        {
            "id": "string",
            "name": "string",
            "sort": "string"
        }
    ],
    "brandName": "string",
    "companyId": "string",
    "createdAt._date": "string",
    "currencySymbol": "string",
    "defaultImageDeleted": "string",
    "deleted": "string",
    "directPhone": "string",
    "discountPlans": [
        {
            "autoApply": "string",
            "availabilityText": "string",
            "availableForAllFacilities": "string",
            "description": "string",
            "discountPlanDiscounts": [
                {
                    "amount": "string",
                    "discountType": "string",
                    "id": "string",
                    "monthNumber": "string"
                }
            ],
            "endDate": "string",
            "hideFromWebsite": "string",
            "id": "string",
            "moveInOnly": "string",
            "name": "string",
            "priority": "string",
            "promotionType": "string",
            "publicDescription": "string",
            "requirementsText": "string",
            "startDate": "string",
            "turnedOn": "string"
        }
    ],
    "email": "string",
    "enabled": "string",
    "expirationWindow": "string",
    "facilityType": "string",
    "googlePlaceId": "string",
    "hasRentalCenter": "string",
    "hours.access.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.access.note": "string",
    "hours.office.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.office.note": "string",
    "linkOutUrl": "string",
    "location._id._oid": "string",
    "location.coordinates": [
        "float"
    ],
    "location.type": "string",
    "logo._id._oid": "string",
    "logo.alt": "string",
    "logo.link._id._oid": "string",
    "logo.link.href": "string",
    "logo.link.target": "string",
    "logo.mediumId": "string",
    "logo.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "string",
    "primaryImageMedium._id._oid": "string",
    "primaryImageMedium.alt": "string",
    "primaryImageMedium.mediumId": "string",
    "primaryImageMedium.title": "string",
    "primaryImageMediumId": "string",
    "primaryLink": "string",
    "primaryTarget": "string",
    "primaryTitle": "string",
    "promoBanner": "string",
    "rentalCenterUrl": "string",
    "reservationFeeRequired": "string",
    "reservationWindow": "string",
    "reviews": [
        {
            "body": "string",
            "email": "string",
            "id": "string",
            "ip": "string",
            "name": "string",
            "rating": "string",
            "reply": "string",
            "timestamp._date": "string"
        }
    ],
    "settings.bannerToken": "string",
    "settings.businessAddressDescription": "string",
    "settings.businessNameOverride": "string",
    "settings.callActionThreshold": "string",
    "settings.disableReservations": "string",
    "settings.enableDueAtMoveIn": "string",
    "settings.enableManagedRates": "string",
    "settings.enableMoveIns": "string",
    "settings.enablePublicDescription": "string",
    "settings.enableUsePromoModifiedPricing": "string",
    "settings.hidePricingDisplayCall": "string",
    "settings.leaseUrl": "string",
    "settings.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "string",
    "socialMedia._id._oid": "string",
    "socialMedia.enabled": "string",
    "socialMedia.platforms": [
        {
            "_id._oid": "string",
            "enabled": "string",
            "link": "string",
            "provider": "string"
        }
    ],
    "storeNumber": "string",
    "tenantPortalUrl": "string",
    "theme._id._oid": "string",
    "theme.colors._id._oid": "string",
    "theme.colors.primary": "string",
    "theme.colors.secondary": "string",
    "theme.colors.tertiary": "string",
    "theme.enabled": "string",
    "timezone": "string",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "string",
                    "name": "string",
                    "token": "string"
                }
            ],
            "area": "string",
            "availablePricingTypes": [
                {
                    "marketRate": "string",
                    "marketRateWeekly": "string",
                    "pricingTypeId": "string",
                    "walkinRate": "string",
                    "walkinRateWeekly": "string"
                }
            ],
            "availableUnitsCount": "string",
            "category": "string",
            "categoryName": "string",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "string",
                    "apiAssociationIds": [
                        "string"
                    ],
                    "autoApply": "string",
                    "availabilityText": "string",
                    "availableForAllFacilities": "string",
                    "clientApplications": [
                        {
                            "channelRates": "string",
                            "id": "string",
                            "name": "string"
                        }
                    ],
                    "createdAt": "string",
                    "deleted": "string",
                    "deletedBy": "string",
                    "deletedOn": "string",
                    "description": "string",
                    "discountPlanControls": [
                        "string"
                    ],
                    "discountPlanDiscounts": [
                        {
                            "amount": "string",
                            "createdAt": "string",
                            "deleted": "string",
                            "deletedBy": "string",
                            "deletedOn": "string",
                            "discountType": "string",
                            "id": "string",
                            "monthNumber": "string",
                            "updatedAt": "string"
                        }
                    ],
                    "endDate": "string",
                    "existingTenantOnly": "string",
                    "facilities": [
                        {
                            "id": "string"
                        }
                    ],
                    "facilityIds": [
                        "string"
                    ],
                    "hideFromWebsite": "string",
                    "id": "string",
                    "kind": "string",
                    "minOccupancyMonths": "string",
                    "minOccupancyRequired": "string",
                    "moveInOnly": "string",
                    "name": "string",
                    "prepayMonths": "string",
                    "prepayRequired": "string",
                    "priority": "string",
                    "promotionType": "string",
                    "publicDescription": "string",
                    "requirementsText": "string",
                    "roundToNearest": "string",
                    "startDate": "string",
                    "tenantAccountKindId": "string",
                    "turnedOn": "string",
                    "updatedAt": "string"
                }
            ],
            "discountedPrice": "string",
            "dueAtMoveIn": "string",
            "dueAtMoveInWithoutFees": "string",
            "dueMonthly": "string",
            "height": "string",
            "id": "string",
            "isWeekly": "string",
            "leadOnly": "string",
            "length": "string",
            "moveInUrl": "string",
            "name": "string",
            "popular": "string",
            "price": "string",
            "priceWeekly": "string",
            "pricingTypeId": "string",
            "promoId": "string",
            "reservationUrl": "string",
            "sort": "string",
            "standardRate": "string",
            "totalUnitsCount": "string",
            "type.id": "string",
            "type.name": "string",
            "width": "string"
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": "string",
            "id": "string",
            "maxPrice": "string",
            "minArea": "string",
            "minPrice": "string",
            "minSize": "string",
            "name": "string",
            "siteUnitCategoryId": "string",
            "totalUnitsCount": "string"
        }
    ],
    "updatedAt._date": "string",
    "useExpirationWindow": "string",
    "useReservationWindow": "string"
}
    • schema_name_id: 795
    • schema_scan_id: 3676417
    • updated: 2022-02-01 22:21:25
    • created: 2022-01-31 22:22:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_facilities`\n(\n`companyId`STRING,`defaultImageDeleted`STRING,`primaryImageMediumId`STRING,`primaryImageMedium`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`mediumId`:STRING,`title`:STRING>,`phone`STRING,`tenantPortalUrl`STRING,`createdAt`struct<`_date`:STRING>,`promoBanner`STRING,`rentalCenterUrl`STRING,`overrides`struct<`address`:struct<`latitude`:STRING,`longitude`:STRING>>,`__v`STRING,`directPhone`STRING,`pageStatus`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`primaryTitle`STRING,`unitSummary`array>,`_id`STRING,`name`STRING,`primaryAlt`STRING,`socialMedia`struct<`platforms`:array>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`primaryTarget`STRING,`settings`struct<`disableReservations`:STRING,`bannerToken`:STRING,`businessAddressDescription`:STRING,`hidePricingDisplayCall`:STRING,`enableManagedRates`:STRING,`reservationConfirmation`:STRING,`callActionThreshold`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableDueAtMoveIn`:STRING,`showAvailableUnitCountThreshold`:STRING,`tagline`:STRING,`showUnavailableUnits`:STRING,`leaseUrl`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`reservationDisclaimer`:STRING,`enablePublicDescription`:STRING,`enableMoveIns`:STRING,`businessNameOverride`:STRING,`showAvailableUnitCount`:STRING>,`expirationWindow`STRING,`useReservationWindow`STRING,`updatedAt`struct<`_date`:STRING>,`unitGroups`array,`area`:STRING,`length`:STRING,`width`:STRING,`height`:STRING,`dueAtMoveInWithoutFees`:STRING,`availableUnitsCount`:STRING,`totalUnitsCount`:STRING,`standardRate`:STRING,`amenities`:array>,`discountPlans`:array,`discountPlanDiscounts`:array>,`facilities`:array>,`alwaysDiscountPlanDiscountId`:STRING,`clientApplications`:array>,`apiAssociationIds`:array,`discountPlanControls`:array,`existingTenantOnly`:STRING,`tenantAccountKindId`:STRING,`roundToNearest`:STRING,`prepayMonths`:STRING,`prepayRequired`:STRING,`minOccupancyMonths`:STRING,`minOccupancyRequired`:STRING,`kind`:STRING>>,`popular`:STRING,`leadOnly`:STRING,`promoId`:STRING,`moveInUrl`:STRING,`reservationUrl`:STRING,`sort`:STRING,`dueMonthly`:STRING,`price`:STRING,`discountedPrice`:STRING,`isWeekly`:STRING,`pricingTypeId`:STRING,`availablePricingTypes`:array>,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`googlePlaceId`STRING,`theme`struct<`colors`:struct<`tertiary`:STRING,`secondary`:STRING,`primary`:STRING,`_id`:struct<`_oid`:STRING>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`logo`struct<`title`:STRING,`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`_id`:struct<`_oid`:STRING>,`href`:STRING>,`mediumId`:STRING,`alt`:STRING>,`deleted`STRING,`currencySymbol`STRING,`linkOutUrl`STRING,`primaryLink`STRING,`enabled`STRING,`reservationWindow`STRING,`facilityType`STRING,`primaryImage`STRING,`hours`struct<`office`:struct<`note`:STRING,`hours`:array>>>,`access`:struct<`note`:STRING,`hours`:array>>>>,`address`struct<`state`:STRING,`country`:STRING,`city`:STRING,`latitude`:STRING,`longitude`:STRING,`address2`:STRING,`address1`:STRING,`postal`:STRING>,`storeNumber`STRING,`email`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`amenities`array>,`hasRentalCenter`STRING,`brandName`STRING,`useExpirationWindow`STRING,`discountPlans`array>>>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`: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-mongo-storedge-stage/raw/voyager_facilities/2022-01-31/1643689054'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_facilities"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-01-31/1643689054
    • id: 380175
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": "000eb7c0-a9e5-4979-a87f-8f692511752c",
    "address": {
        "address1": "440 Moores Lane",
        "address2": "",
        "city": "New Castle",
        "country": "US",
        "latitude": 39.6779546,
        "longitude": -75.5662651,
        "postal": "19720",
        "state": "DE"
    },
    "amenities": [
        {
            "id": "4515f794-bfef-4dce-8d9e-e33be10a4481",
            "name": "Gated Access",
            "sort": 0
        }
    ],
    "brandName": "",
    "companyId": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89",
    "createdAt": {
        "_date": "2020-05-20T15:17:39.091Z"
    },
    "currencySymbol": "$",
    "defaultImageDeleted": false,
    "deleted": false,
    "directPhone": "916-989-9217",
    "discountPlans": [
        {
            "autoApply": false,
            "availabilityText": "5/15/2020",
            "availableForAllFacilities": true,
            "description": "First Month Free",
            "discountPlanDiscounts": [
                {
                    "amount": 100,
                    "discountType": "percent",
                    "id": "984e9a4a-a351-4cc3-800e-fbd25cf1451c",
                    "monthNumber": 1
                }
            ],
            "endDate": null,
            "hideFromWebsite": false,
            "id": "40c28445-d9c1-4d50-a818-1fe05754d4da",
            "moveInOnly": false,
            "name": "1STMONTHFREE",
            "priority": null,
            "promotionType": "promotion",
            "publicDescription": "",
            "requirementsText": "",
            "startDate": "2020-05-15",
            "turnedOn": true
        }
    ],
    "email": "[email protected]",
    "enabled": true,
    "expirationWindow": 5,
    "facilityType": "full",
    "googlePlaceId": null,
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b021"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5dbb36b91430aa0505f2b028"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "61375cc110574d03af9fcab5"
        },
        "coordinates": [
            -135.081028,
            60.743223
        ],
        "type": "Point"
    },
    "logo": {
        "_id": {
            "_oid": "5e4c3b1512752b07e4fdb5ef"
        },
        "alt": "",
        "link": {
            "_id": {
                "_oid": "5e4c3b1512752b07e4fdb5f0"
            },
            "href": "/",
            "target": "_self"
        },
        "mediumId": "6089990886a61b0063db79f4",
        "path": "d87dcb69-ef9a-4e2b-8b77-8ec96c55dd89/sentry-logo-6.jpg",
        "title": ""
    },
    "name": "Sentry Storage - Folsom Dam",
    "overrides": {
        "address": {
            "latitude": 33.5773130668816,
            "longitude": -96.17000877857208
        }
    },
    "pageStatus": "live",
    "phone": "(916) 975-7512",
    "primaryAlt": "Front",
    "primaryImage": "7773eb76-1bd9-4327-9de8-608cc534ac51/front-entrance-left-2.jpg",
    "primaryImageMediumId": "60898e3f86a61b0063d95720",
    "primaryLink": null,
    "primaryTarget": null,
    "primaryTitle": null,
    "promoBanner": null,
    "rentalCenterUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?sCorpCode=CCMQ&sLocationCode=L088&unit=&concession=&reservation=false&channeltype=",
    "reservationFeeRequired": false,
    "reservationWindow": 0,
    "reviews": [
        {
            "body": null,
            "email": null,
            "id": "b948a55a-0111-431f-b330-b368c8df30f1",
            "ip": "209.33.207.149",
            "name": null,
            "rating": 5,
            "reply": null,
            "timestamp": {
                "_date": "2021-08-12T17:55:15.836Z"
            }
        }
    ],
    "settings": {
        "bannerToken": "",
        "businessAddressDescription": "",
        "businessNameOverride": "",
        "callActionThreshold": 1,
        "disableReservations": false,
        "enableDueAtMoveIn": false,
        "enableManagedRates": true,
        "enableMoveIns": true,
        "enablePublicDescription": true,
        "enableUsePromoModifiedPricing": true,
        "hidePricingDisplayCall": false,
        "leaseUrl": "",
        "reservationConfirmation": "Please show this reservation when you come in. A copy has been emailed to you. Please note that online reservations cannot be guaranteed until availability has been confirmed by the facility.",
        "reservationDisclaimer": "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 unit.",
        "showAvailableUnitCount": false,
        "showAvailableUnitCountThreshold": 1,
        "showUnavailableUnits": true,
        "softwareProvider": "storedge",
        "tagline": "",
        "voyagerOnly": false
    },
    "socialMedia": {
        "_id": {
            "_oid": "6102f124d1e0e30645d59fe3"
        },
        "enabled": false,
        "platforms": [
            {
                "_id": {
                    "_oid": "61785788630f4b0643b0e765"
                },
                "enabled": true,
                "link": "https://business.google.com/u/2/dashboard/l/12588977188169164334",
                "provider": "Google"
            }
        ]
    },
    "storeNumber": "CCMQ-L088",
    "tenantPortalUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/login.aspx?sCorpCode=CCMQ&sLocationCode=L088",
    "theme": {
        "_id": {
            "_oid": "5e3c913f3ba0fe05e45d92de"
        },
        "colors": {
            "_id": {
                "_oid": "5e3c5d147c91ad05e5f3284f"
            },
            "primary": "#E3822E",
            "secondary": "#777777",
            "tertiary": "#e6e6e6"
        },
        "enabled": false
    },
    "timezone": "America/Los_Angeles",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "4e2b636c-a920-499a-b0ea-6de38d05c950",
                    "name": "Heated",
                    "token": null
                }
            ],
            "area": 200,
            "availablePricingTypes": [
                {
                    "marketRate": 77.99,
                    "marketRateWeekly": 18.01,
                    "pricingTypeId": 3,
                    "walkinRate": 82.99,
                    "walkinRateWeekly": 19.17
                }
            ],
            "availableUnitsCount": 0,
            "category": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "categoryName": "large",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "48e7d6a3-4105-450e-9887-8f9606488078",
                    "apiAssociationIds": [
                        "cd350722-ba07-4d53-8fdb-a33132ad99d5",
                        "8f1dfdfa-d2fc-4983-9b06-971b08a33ee4"
                    ],
                    "autoApply": true,
                    "availabilityText": "8/30/2018",
                    "availableForAllFacilities": true,
                    "clientApplications": [
                        {
                            "channelRates": false,
                            "id": "e9d6fd20-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "storEDGE Unified Platform"
                        },
                        {
                            "channelRates": false,
                            "id": "e6f1b080-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "FMS"
                        }
                    ],
                    "createdAt": "2018-08-30T09:10:33.664-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "One Month Free",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 100,
                            "createdAt": "2018-08-30T09:10:33.685-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "none",
                            "id": "0d8fefda-56e7-44a8-887e-de65490ba352",
                            "monthNumber": 1,
                            "updatedAt": "2018-09-18T12:52:35.518-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [
                        {
                            "id": "a61c01cc-49d2-4768-9613-0974e7889253"
                        },
                        {
                            "id": "1f70cae0-d793-4dab-b67d-7c5f767509a6"
                        },
                        {
                            "id": "c141b8f7-2a42-43b4-ab98-ad5734caf6b7"
                        },
                        {
                            "id": "e83ab373-6583-46c7-a71c-28a2f6d7236c"
                        },
                        {
                            "id": "b70fca4d-cbcf-4672-bb29-2ab1b2262f8e"
                        },
                        {
                            "id": "c8c91dc6-b285-45bf-85df-cf28ffa9b6d9"
                        },
                        {
                            "id": "48ae679c-aca6-4319-a7db-55e3d3a3ce06"
                        },
                        {
                            "id": "d0d04f4a-4347-4d2e-8c4d-63a3fc900810"
                        },
                        {
                            "id": "2ff6377e-9553-4c6e-9975-15fff472344a"
                        },
                        {
                            "id": "15957453-1388-4521-bb66-318d6fa47468"
                        },
                        {
                            "id": "cae9d1f7-a0b2-439f-a61b-7aa665397aa5"
                        },
                        {
                            "id": "9b143ec5-56d0-49b1-afa8-ee6e5d0a4c45"
                        },
                        {
                            "id": "98104cf8-657b-437f-a459-3564d749ab22"
                        },
                        {
                            "id": "194ed426-e6a1-48ef-b096-61e82df20a99"
                        },
                        {
                            "id": "029e5e04-38b7-42b4-bbc1-8d2d60625514"
                        },
                        {
                            "id": "e0a54728-f835-44c6-8c7e-92343072fc97"
                        },
                        {
                            "id": "efd3c33a-9c53-406f-baf2-6380034372f4"
                        },
                        {
                            "id": "9912d539-a67a-41c2-9637-1ae62e40aba5"
                        },
                        {
                            "id": "3cdc3f8e-43bb-4e31-b027-59249263f953"
                        },
                        {
                            "id": "81b61eda-f548-422f-918d-4337a23d518b"
                        },
                        {
                            "id": "531b4c45-2df6-4c92-8a49-19d562b4477f"
                        },
                        {
                            "id": "185039ae-4eaa-4d6f-936b-a9e6dcd19ca8"
                        },
                        {
                            "id": "b0ecc09b-4d2f-4340-b792-af0eaad84530"
                        },
                        {
                            "id": "ef1eaec7-94b2-466f-bb69-b9522c3da0f4"
                        },
                        {
                            "id": "10a90456-8244-42dc-8891-8c2f1da19293"
                        }
                    ],
                    "facilityIds": [
                        "6d6f5915-f311-4025-b9a6-c028872b9082",
                        "82dabcb7-8b13-44ab-bf27-80c9820f36e0",
                        "d41b5c03-82bb-4dc6-bd06-1f6c3324c3a7",
                        "ce1d8dc3-6641-40e9-9e7c-7b78845d2674",
                        "c5db3fc2-0bdc-46b0-b7dc-2e44eb20c9b9",
                        "b6fb9bb7-1944-46e6-9b61-9612f3bcdd7a",
                        "fc5eec50-ba54-4c68-b4c3-503995393e3b",
                        "1438968e-6346-472f-a11d-e04ceb9cee9d",
                        "59ceaf40-980a-4b76-a3a7-0435fc089cb3",
                        "ece54617-0944-43ff-bdf1-95c431536053",
                        "18ad62cb-055a-4cd5-bc50-9d2e889381cb",
                        "d75e0fde-4baa-4a01-a8e6-6f979696a450",
                        "77a5944c-408e-409a-a7fd-7cc545671717",
                        "1af5deb3-13c6-49a8-b859-e381d7716897",
                        "ff9f19ea-4407-48b2-9c68-c3d05fe95c64",
                        "df033046-9331-4185-85a2-5ddf1bc1eb50"
                    ],
                    "hideFromWebsite": false,
                    "id": "abe5b7a6-1465-4160-8da8-cc4990936c95",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "1MOFREECH",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "One Month Free",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2018-08-30",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2021-11-23T13:02:06.624-10:00"
                }
            ],
            "discountedPrice": null,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 219,
            "dueMonthly": 219,
            "height": 8,
            "id": "67e392c6-65ff-480a-9ee9-da3712158a06",
            "isWeekly": false,
            "leadOnly": null,
            "length": 10,
            "moveInUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/move-in/000d2d98-7259-40ed-9111-60cce9662b03/67e392c6-65ff-480a-9ee9-da3712158a06",
            "name": "20x10x8 - $219.00 - 75124 - 1",
            "popular": false,
            "price": 219,
            "priceWeekly": null,
            "pricingTypeId": null,
            "promoId": null,
            "reservationUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/reserve/67e392c6-65ff-480a-9ee9-da3712158a06",
            "sort": null,
            "standardRate": 219,
            "totalUnitsCount": 2,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 20
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 0,
            "id": "cd154e8d-87ba-4228-a6fb-169723804eef",
            "maxPrice": 219,
            "minArea": 200,
            "minPrice": 219,
            "minSize": "10x20",
            "name": "Large",
            "siteUnitCategoryId": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "totalUnitsCount": 8
        }
    ],
    "updatedAt": {
        "_date": "2021-04-28T17:16:01.009Z"
    },
    "useExpirationWindow": false,
    "useReservationWindow": false
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id": "string",
    "address.address1": "string",
    "address.address2": "string",
    "address.city": "string",
    "address.country": "string",
    "address.latitude": "string",
    "address.longitude": "string",
    "address.postal": "string",
    "address.state": "string",
    "amenities": [
        {
            "id": "string",
            "name": "string",
            "sort": "string"
        }
    ],
    "brandName": "string",
    "companyId": "string",
    "createdAt._date": "string",
    "currencySymbol": "string",
    "defaultImageDeleted": "string",
    "deleted": "string",
    "directPhone": "string",
    "discountPlans": [
        {
            "autoApply": "string",
            "availabilityText": "string",
            "availableForAllFacilities": "string",
            "description": "string",
            "discountPlanDiscounts": [
                {
                    "amount": "string",
                    "discountType": "string",
                    "id": "string",
                    "monthNumber": "string"
                }
            ],
            "endDate": "string",
            "hideFromWebsite": "string",
            "id": "string",
            "moveInOnly": "string",
            "name": "string",
            "priority": "string",
            "promotionType": "string",
            "publicDescription": "string",
            "requirementsText": "string",
            "startDate": "string",
            "turnedOn": "string"
        }
    ],
    "email": "string",
    "enabled": "string",
    "expirationWindow": "string",
    "facilityType": "string",
    "googlePlaceId": "string",
    "hasRentalCenter": "string",
    "hours.access.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.access.note": "string",
    "hours.office.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.office.note": "string",
    "linkOutUrl": "string",
    "location._id._oid": "string",
    "location.coordinates": [
        "float"
    ],
    "location.type": "string",
    "logo._id._oid": "string",
    "logo.alt": "string",
    "logo.link._id._oid": "string",
    "logo.link.href": "string",
    "logo.link.target": "string",
    "logo.mediumId": "string",
    "logo.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "string",
    "primaryImageMedium._id._oid": "string",
    "primaryImageMedium.alt": "string",
    "primaryImageMedium.mediumId": "string",
    "primaryImageMedium.title": "string",
    "primaryImageMediumId": "string",
    "primaryLink": "string",
    "primaryTarget": "string",
    "primaryTitle": "string",
    "promoBanner": "string",
    "rentalCenterUrl": "string",
    "reservationFeeRequired": "string",
    "reservationWindow": "string",
    "reviews": [
        {
            "body": "string",
            "email": "string",
            "id": "string",
            "ip": "string",
            "name": "string",
            "rating": "string",
            "reply": "string",
            "timestamp._date": "string"
        }
    ],
    "settings.bannerToken": "string",
    "settings.businessAddressDescription": "string",
    "settings.businessNameOverride": "string",
    "settings.callActionThreshold": "string",
    "settings.disableReservations": "string",
    "settings.enableDueAtMoveIn": "string",
    "settings.enableManagedRates": "string",
    "settings.enableMoveIns": "string",
    "settings.enablePublicDescription": "string",
    "settings.enableUsePromoModifiedPricing": "string",
    "settings.hidePricingDisplayCall": "string",
    "settings.leaseUrl": "string",
    "settings.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "string",
    "socialMedia._id._oid": "string",
    "socialMedia.enabled": "string",
    "socialMedia.platforms": [
        {
            "_id._oid": "string",
            "enabled": "string",
            "link": "string",
            "provider": "string"
        }
    ],
    "storeNumber": "string",
    "tenantPortalUrl": "string",
    "theme._id._oid": "string",
    "theme.colors._id._oid": "string",
    "theme.colors.primary": "string",
    "theme.colors.secondary": "string",
    "theme.colors.tertiary": "string",
    "theme.enabled": "string",
    "timezone": "string",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "string",
                    "name": "string",
                    "token": "string"
                }
            ],
            "area": "string",
            "availablePricingTypes": [
                {
                    "marketRate": "string",
                    "marketRateWeekly": "string",
                    "pricingTypeId": "string",
                    "walkinRate": "string",
                    "walkinRateWeekly": "string"
                }
            ],
            "availableUnitsCount": "string",
            "category": "string",
            "categoryName": "string",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "string",
                    "apiAssociationIds": [
                        "string"
                    ],
                    "autoApply": "string",
                    "availabilityText": "string",
                    "availableForAllFacilities": "string",
                    "clientApplications": [
                        {
                            "channelRates": "string",
                            "id": "string",
                            "name": "string"
                        }
                    ],
                    "createdAt": "string",
                    "deleted": "string",
                    "deletedBy": "string",
                    "deletedOn": "string",
                    "description": "string",
                    "discountPlanControls": [
                        "string"
                    ],
                    "discountPlanDiscounts": [
                        {
                            "amount": "string",
                            "createdAt": "string",
                            "deleted": "string",
                            "deletedBy": "string",
                            "deletedOn": "string",
                            "discountType": "string",
                            "id": "string",
                            "monthNumber": "string",
                            "updatedAt": "string"
                        }
                    ],
                    "endDate": "string",
                    "existingTenantOnly": "string",
                    "facilities": [
                        {
                            "id": "string"
                        }
                    ],
                    "facilityIds": [
                        "string"
                    ],
                    "hideFromWebsite": "string",
                    "id": "string",
                    "kind": "string",
                    "minOccupancyMonths": "string",
                    "minOccupancyRequired": "string",
                    "moveInOnly": "string",
                    "name": "string",
                    "prepayMonths": "string",
                    "prepayRequired": "string",
                    "priority": "string",
                    "promotionType": "string",
                    "publicDescription": "string",
                    "requirementsText": "string",
                    "roundToNearest": "string",
                    "startDate": "string",
                    "tenantAccountKindId": "string",
                    "turnedOn": "string",
                    "updatedAt": "string"
                }
            ],
            "discountedPrice": "string",
            "dueAtMoveIn": "string",
            "dueAtMoveInWithoutFees": "string",
            "dueMonthly": "string",
            "height": "string",
            "id": "string",
            "isWeekly": "string",
            "leadOnly": "string",
            "length": "string",
            "moveInUrl": "string",
            "name": "string",
            "popular": "string",
            "price": "string",
            "priceWeekly": "string",
            "pricingTypeId": "string",
            "promoId": "string",
            "reservationUrl": "string",
            "sort": "string",
            "standardRate": "string",
            "totalUnitsCount": "string",
            "type.id": "string",
            "type.name": "string",
            "width": "string"
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": "string",
            "id": "string",
            "maxPrice": "string",
            "minArea": "string",
            "minPrice": "string",
            "minSize": "string",
            "name": "string",
            "siteUnitCategoryId": "string",
            "totalUnitsCount": "string"
        }
    ],
    "updatedAt._date": "string",
    "useExpirationWindow": "string",
    "useReservationWindow": "string"
}
    • schema_name_id: 795
    • schema_scan_id: 3674824
    • updated: 2022-01-31 22:22:32
Schema Scans: 3
Last at 2022-02-02 22:18:34
    • duration: 0:04:06.405220
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3678026
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-02-02/1643861824",
        "key": "raw/voyager_facilities/2022-02-02/1643861824/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 10400495977845121160,
        "service_name": "preloading",
        "span_id": 8890937770809994797,
        "trace_id": 15473495614570736574
    }
}
    • running: False
    • schema_name_id: 795
    • start_time: 2022-02-02 22:18:34
    • success: True
    • trace_id: 15473495614570736574
    • duration: 0:04:05.594777
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3676417
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-02-01/1643775429",
        "key": "raw/voyager_facilities/2022-02-01/1643775429/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 17773637289058331486,
        "service_name": "preloading",
        "span_id": 13657459041820909592,
        "trace_id": 10644481336303180200
    }
}
    • running: False
    • schema_name_id: 795
    • start_time: 2022-02-01 22:17:22
    • success: True
    • trace_id: 10644481336303180200
    • duration: 0:04:03.992261
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3674824
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_facilities/2022-01-31/1643689054",
        "key": "raw/voyager_facilities/2022-01-31/1643689054/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 15106634079346820946,
        "service_name": "preloading",
        "span_id": 12247083579985984627,
        "trace_id": 6206555519537656175
    }
}
    • running: False
    • schema_name_id: 795
    • start_time: 2022-01-31 22:18:30
    • success: True
    • trace_id: 6206555519537656175
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "__v": "string",
    "_id": "string",
    "address.address1": "string",
    "address.address2": "string",
    "address.city": "string",
    "address.country": "string",
    "address.latitude": "string",
    "address.longitude": "string",
    "address.postal": "string",
    "address.state": "string",
    "amenities": [
        {
            "id": "string",
            "name": "string",
            "sort": "string"
        }
    ],
    "brandName": "string",
    "companyId": "string",
    "createdAt._date": "string",
    "currencySymbol": "string",
    "defaultImageDeleted": "string",
    "deleted": "string",
    "directPhone": "string",
    "discountPlans": [
        {
            "autoApply": "string",
            "availabilityText": "string",
            "availableForAllFacilities": "string",
            "description": "string",
            "discountPlanDiscounts": [
                {
                    "amount": "string",
                    "discountType": "string",
                    "id": "string",
                    "monthNumber": "string"
                }
            ],
            "endDate": "string",
            "hideFromWebsite": "string",
            "id": "string",
            "moveInOnly": "string",
            "name": "string",
            "priority": "string",
            "promotionType": "string",
            "publicDescription": "string",
            "requirementsText": "string",
            "startDate": "string",
            "turnedOn": "string"
        }
    ],
    "email": "string",
    "enabled": "string",
    "expirationWindow": "string",
    "facilityType": "string",
    "googlePlaceId": "string",
    "hasRentalCenter": "string",
    "hours.access.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.access.note": "string",
    "hours.office.hours": [
        {
            "_id._oid": "string",
            "close": "string",
            "day": "string",
            "open": "string"
        }
    ],
    "hours.office.note": "string",
    "linkOutUrl": "string",
    "location._id._oid": "string",
    "location.coordinates": [
        "float"
    ],
    "location.type": "string",
    "logo._id._oid": "string",
    "logo.alt": "string",
    "logo.link._id._oid": "string",
    "logo.link.href": "string",
    "logo.link.target": "string",
    "logo.mediumId": "string",
    "logo.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "string",
    "primaryImageMedium._id._oid": "string",
    "primaryImageMedium.alt": "string",
    "primaryImageMedium.mediumId": "string",
    "primaryImageMedium.title": "string",
    "primaryImageMediumId": "string",
    "primaryLink": "string",
    "primaryTarget": "string",
    "primaryTitle": "string",
    "promoBanner": "string",
    "rentalCenterUrl": "string",
    "reservationFeeRequired": "string",
    "reservationWindow": "string",
    "reviews": [
        {
            "body": "string",
            "email": "string",
            "id": "string",
            "ip": "string",
            "name": "string",
            "rating": "string",
            "reply": "string",
            "timestamp._date": "string"
        }
    ],
    "settings.bannerToken": "string",
    "settings.businessAddressDescription": "string",
    "settings.businessNameOverride": "string",
    "settings.callActionThreshold": "string",
    "settings.disableReservations": "string",
    "settings.enableDueAtMoveIn": "string",
    "settings.enableManagedRates": "string",
    "settings.enableMoveIns": "string",
    "settings.enablePublicDescription": "string",
    "settings.enableUsePromoModifiedPricing": "string",
    "settings.hidePricingDisplayCall": "string",
    "settings.leaseUrl": "string",
    "settings.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "string",
    "socialMedia._id._oid": "string",
    "socialMedia.enabled": "string",
    "socialMedia.platforms": [
        {
            "_id._oid": "string",
            "enabled": "string",
            "link": "string",
            "provider": "string"
        }
    ],
    "storeNumber": "string",
    "tenantPortalUrl": "string",
    "theme._id._oid": "string",
    "theme.colors._id._oid": "string",
    "theme.colors.primary": "string",
    "theme.colors.secondary": "string",
    "theme.colors.tertiary": "string",
    "theme.enabled": "string",
    "timezone": "string",
    "unitGroups": [
        {
            "amenities": [
                {
                    "id": "string",
                    "name": "string",
                    "token": "string"
                }
            ],
            "area": "string",
            "availablePricingTypes": [
                {
                    "marketRate": "string",
                    "marketRateWeekly": "string",
                    "pricingTypeId": "string",
                    "walkinRate": "string",
                    "walkinRateWeekly": "string"
                }
            ],
            "availableUnitsCount": "string",
            "category": "string",
            "categoryName": "string",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "string",
                    "apiAssociationIds": [
                        "string"
                    ],
                    "autoApply": "string",
                    "availabilityText": "string",
                    "availableForAllFacilities": "string",
                    "clientApplications": [
                        {
                            "channelRates": "string",
                            "id": "string",
                            "name": "string"
                        }
                    ],
                    "createdAt": "string",
                    "deleted": "string",
                    "deletedBy": "string",
                    "deletedOn": "string",
                    "description": "string",
                    "discountPlanControls": [
                        "string"
                    ],
                    "discountPlanDiscounts": [
                        {
                            "amount": "string",
                            "createdAt": "string",
                            "deleted": "string",
                            "deletedBy": "string",
                            "deletedOn": "string",
                            "discountType": "string",
                            "id": "string",
                            "monthNumber": "string",
                            "updatedAt": "string"
                        }
                    ],
                    "endDate": "string",
                    "existingTenantOnly": "string",
                    "facilities": [
                        {
                            "id": "string"
                        }
                    ],
                    "facilityIds": [
                        "string"
                    ],
                    "hideFromWebsite": "string",
                    "id": "string",
                    "kind": "string",
                    "minOccupancyMonths": "string",
                    "minOccupancyRequired": "string",
                    "moveInOnly": "string",
                    "name": "string",
                    "prepayMonths": "string",
                    "prepayRequired": "string",
                    "priority": "string",
                    "promotionType": "string",
                    "publicDescription": "string",
                    "requirementsText": "string",
                    "roundToNearest": "string",
                    "startDate": "string",
                    "tenantAccountKindId": "string",
                    "turnedOn": "string",
                    "updatedAt": "string"
                }
            ],
            "discountedPrice": "string",
            "dueAtMoveIn": "string",
            "dueAtMoveInWithoutFees": "string",
            "dueMonthly": "string",
            "height": "string",
            "id": "string",
            "isWeekly": "string",
            "leadOnly": "string",
            "length": "string",
            "moveInUrl": "string",
            "name": "string",
            "popular": "string",
            "price": "string",
            "priceWeekly": "string",
            "pricingTypeId": "string",
            "promoId": "string",
            "reservationUrl": "string",
            "sort": "string",
            "standardRate": "string",
            "totalUnitsCount": "string",
            "type.id": "string",
            "type.name": "string",
            "width": "string"
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": "string",
            "id": "string",
            "maxPrice": "string",
            "minArea": "string",
            "minPrice": "string",
            "minSize": "string",
            "name": "string",
            "siteUnitCategoryId": "string",
            "totalUnitsCount": "string"
        }
    ],
    "updatedAt._date": "string",
    "useExpirationWindow": "string",
    "useReservationWindow": "string"
}
  • created: 2022-02-02 22:22:26
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_facilities`\n(\n`companyId`STRING,`defaultImageDeleted`STRING,`primaryImageMediumId`STRING,`primaryImageMedium`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`mediumId`:STRING,`title`:STRING>,`phone`STRING,`tenantPortalUrl`STRING,`createdAt`struct<`_date`:STRING>,`promoBanner`STRING,`rentalCenterUrl`STRING,`overrides`struct<`address`:struct<`latitude`:STRING,`longitude`:STRING>>,`__v`STRING,`directPhone`STRING,`pageStatus`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`primaryTitle`STRING,`unitSummary`array>,`_id`STRING,`name`STRING,`primaryAlt`STRING,`socialMedia`struct<`platforms`:array>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`primaryTarget`STRING,`settings`struct<`disableReservations`:STRING,`bannerToken`:STRING,`businessAddressDescription`:STRING,`hidePricingDisplayCall`:STRING,`enableManagedRates`:STRING,`reservationConfirmation`:STRING,`callActionThreshold`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableDueAtMoveIn`:STRING,`showAvailableUnitCountThreshold`:STRING,`tagline`:STRING,`showUnavailableUnits`:STRING,`leaseUrl`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`reservationDisclaimer`:STRING,`enablePublicDescription`:STRING,`enableMoveIns`:STRING,`businessNameOverride`:STRING,`showAvailableUnitCount`:STRING>,`expirationWindow`STRING,`useReservationWindow`STRING,`updatedAt`struct<`_date`:STRING>,`unitGroups`array,`area`:STRING,`length`:STRING,`width`:STRING,`height`:STRING,`dueAtMoveInWithoutFees`:STRING,`availableUnitsCount`:STRING,`totalUnitsCount`:STRING,`standardRate`:STRING,`amenities`:array>,`discountPlans`:array,`discountPlanDiscounts`:array>,`facilities`:array>,`alwaysDiscountPlanDiscountId`:STRING,`clientApplications`:array>,`apiAssociationIds`:array,`discountPlanControls`:array,`existingTenantOnly`:STRING,`tenantAccountKindId`:STRING,`roundToNearest`:STRING,`prepayMonths`:STRING,`prepayRequired`:STRING,`minOccupancyMonths`:STRING,`minOccupancyRequired`:STRING,`kind`:STRING>>,`popular`:STRING,`leadOnly`:STRING,`promoId`:STRING,`moveInUrl`:STRING,`reservationUrl`:STRING,`sort`:STRING,`dueMonthly`:STRING,`price`:STRING,`discountedPrice`:STRING,`isWeekly`:STRING,`pricingTypeId`:STRING,`availablePricingTypes`:array>,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`googlePlaceId`STRING,`theme`struct<`colors`:struct<`tertiary`:STRING,`secondary`:STRING,`primary`:STRING,`_id`:struct<`_oid`:STRING>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`logo`struct<`title`:STRING,`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`_id`:struct<`_oid`:STRING>,`href`:STRING>,`mediumId`:STRING,`alt`:STRING>,`deleted`STRING,`currencySymbol`STRING,`linkOutUrl`STRING,`primaryLink`STRING,`enabled`STRING,`reservationWindow`STRING,`facilityType`STRING,`primaryImage`STRING,`hours`struct<`office`:struct<`note`:STRING,`hours`:array>>>,`access`:struct<`note`:STRING,`hours`:array>>>>,`address`struct<`state`:STRING,`country`:STRING,`city`:STRING,`latitude`:STRING,`longitude`:STRING,`address2`:STRING,`address1`:STRING,`postal`:STRING>,`storeNumber`STRING,`email`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`amenities`array>,`hasRentalCenter`STRING,`brandName`STRING,`useExpirationWindow`STRING,`discountPlans`array>>>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`: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-mongo-storedge-stage/raw/voyager_facilities/2022-02-02/1643861824'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_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-20 12:26:30",
        "disabled": false,
        "format": "raw",
        "id": 795,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_mongo",
            "table": "storedge_voyager_facilities"
        },
        "type": "mongo"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "__v": "string",
            "_id": "string",
            "address.address1": "string",
            "address.address2": "string",
            "address.city": "string",
            "address.country": "string",
            "address.latitude": "string",
            "address.longitude": "string",
            "address.postal": "string",
            "address.state": "string",
            "amenities": [
                {
                    "id": "string",
                    "name": "string",
                    "sort": "string"
                }
            ],
            "brandName": "string",
            "companyId": "string",
            "createdAt._date": "string",
            "currencySymbol": "string",
            "defaultImageDeleted": "string",
            "deleted": "string",
            "directPhone": "string",
            "discountPlans": [
                {
                    "autoApply": "string",
                    "availabilityText": "string",
                    "availableForAllFacilities": "string",
                    "description": "string",
                    "discountPlanDiscounts": [
                        {
                            "amount": "string",
                            "discountType": "string",
                            "id": "string",
                            "monthNumber": "string"
                        }
                    ],
                    "endDate": "string",
                    "hideFromWebsite": "string",
                    "id": "string",
                    "moveInOnly": "string",
                    "name": "string",
                    "priority": "string",
                    "promotionType": "string",
                    "publicDescription": "string",
                    "requirementsText": "string",
                    "startDate": "string",
                    "turnedOn": "string"
                }
            ],
            "email": "string",
            "enabled": "string",
            "expirationWindow": "string",
            "facilityType": "string",
            "googlePlaceId": "string",
            "hasRentalCenter": "string",
            "hours.access.hours": [
                {
                    "_id._oid": "string",
                    "close": "string",
                    "day": "string",
                    "open": "string"
                }
            ],
            "hours.access.note": "string",
            "hours.office.hours": [
                {
                    "_id._oid": "string",
                    "close": "string",
                    "day": "string",
                    "open": "string"
                }
            ],
            "hours.office.note": "string",
            "linkOutUrl": "string",
            "location._id._oid": "string",
            "location.coordinates": [
                "float"
            ],
            "location.type": "string",
            "logo._id._oid": "string",
            "logo.alt": "string",
            "logo.link._id._oid": "string",
            "logo.link.href": "string",
            "logo.link.target": "string",
            "logo.mediumId": "string",
            "logo.path": "string",
            "logo.title": "string",
            "name": "string",
            "overrides.address.latitude": "string",
            "overrides.address.longitude": "string",
            "pageStatus": "string",
            "phone": "string",
            "primaryAlt": "string",
            "primaryImage": "string",
            "primaryImageMedium._id._oid": "string",
            "primaryImageMedium.alt": "string",
            "primaryImageMedium.mediumId": "string",
            "primaryImageMedium.title": "string",
            "primaryImageMediumId": "string",
            "primaryLink": "string",
            "primaryTarget": "string",
            "primaryTitle": "string",
            "promoBanner": "string",
            "rentalCenterUrl": "string",
            "reservationFeeRequired": "string",
            "reservationWindow": "string",
            "reviews": [
                {
                    "body": "string",
                    "email": "string",
                    "id": "string",
                    "ip": "string",
                    "name": "string",
                    "rating": "string",
                    "reply": "string",
                    "timestamp._date": "string"
                }
            ],
            "settings.bannerToken": "string",
            "settings.businessAddressDescription": "string",
            "settings.businessNameOverride": "string",
            "settings.callActionThreshold": "string",
            "settings.disableReservations": "string",
            "settings.enableDueAtMoveIn": "string",
            "settings.enableManagedRates": "string",
            "settings.enableMoveIns": "string",
            "settings.enablePublicDescription": "string",
            "settings.enableUsePromoModifiedPricing": "string",
            "settings.hidePricingDisplayCall": "string",
            "settings.leaseUrl": "string",
            "settings.reservationConfirmation": "string",
            "settings.reservationDisclaimer": "string",
            "settings.showAvailableUnitCount": "string",
            "settings.showAvailableUnitCountThreshold": "string",
            "settings.showUnavailableUnits": "string",
            "settings.softwareProvider": "string",
            "settings.tagline": "string",
            "settings.voyagerOnly": "string",
            "socialMedia._id._oid": "string",
            "socialMedia.enabled": "string",
            "socialMedia.platforms": [
                {
                    "_id._oid": "string",
                    "enabled": "string",
                    "link": "string",
                    "provider": "string"
                }
            ],
            "storeNumber": "string",
            "tenantPortalUrl": "string",
            "theme._id._oid": "string",
            "theme.colors._id._oid": "string",
            "theme.colors.primary": "string",
            "theme.colors.secondary": "string",
            "theme.colors.tertiary": "string",
            "theme.enabled": "string",
            "timezone": "string",
            "unitGroups": [
                {
                    "amenities": [
                        {
                            "id": "string",
                            "name": "string",
                            "token": "string"
                        }
                    ],
                    "area": "string",
                    "availablePricingTypes": [
                        {
                            "marketRate": "string",
                            "marketRateWeekly": "string",
                            "pricingTypeId": "string",
                            "walkinRate": "string",
                            "walkinRateWeekly": "string"
                        }
                    ],
                    "availableUnitsCount": "string",
                    "category": "string",
                    "categoryName": "string",
                    "discountPlans": [
                        {
                            "alwaysDiscountPlanDiscountId": "string",
                            "apiAssociationIds": [
                                "string"
                            ],
                            "autoApply": "string",
                            "availabilityText": "string",
                            "availableForAllFacilities": "string",
                            "clientApplications": [
                                {
                                    "channelRates": "string",
                                    "id": "string",
                                    "name": "string"
                                }
                            ],
                            "createdAt": "string",
                            "deleted": "string",
                            "deletedBy": "string",
                            "deletedOn": "string",
                            "description": "string",
                            "discountPlanControls": [
                                "string"
                            ],
                            "discountPlanDiscounts": [
                                {
                                    "amount": "string",
                                    "createdAt": "string",
                                    "deleted": "string",
                                    "deletedBy": "string",
                                    "deletedOn": "string",
                                    "discountType": "string",
                                    "id": "string",
                                    "monthNumber": "string",
                                    "updatedAt": "string"
                                }
                            ],
                            "endDate": "string",
                            "existingTenantOnly": "string",
                            "facilities": [
                                {
                                    "id": "string"
                                }
                            ],
                            "facilityIds": [
                                "string"
                            ],
                            "hideFromWebsite": "string",
                            "id": "string",
                            "kind": "string",
                            "minOccupancyMonths": "string",
                            "minOccupancyRequired": "string",
                            "moveInOnly": "string",
                            "name": "string",
                            "prepayMonths": "string",
                            "prepayRequired": "string",
                            "priority": "string",
                            "promotionType": "string",
                            "publicDescription": "string",
                            "requirementsText": "string",
                            "roundToNearest": "string",
                            "startDate": "string",
                            "tenantAccountKindId": "string",
                            "turnedOn": "string",
                            "updatedAt": "string"
                        }
                    ],
                    "discountedPrice": "string",
                    "dueAtMoveIn": "string",
                    "dueAtMoveInWithoutFees": "string",
                    "dueMonthly": "string",
                    "height": "string",
                    "id": "string",
                    "isWeekly": "string",
                    "leadOnly": "string",
                    "length": "string",
                    "moveInUrl": "string",
                    "name": "string",
                    "popular": "string",
                    "price": "string",
                    "priceWeekly": "string",
                    "pricingTypeId": "string",
                    "promoId": "string",
                    "reservationUrl": "string",
                    "sort": "string",
                    "standardRate": "string",
                    "totalUnitsCount": "string",
                    "type.id": "string",
                    "type.name": "string",
                    "width": "string"
                }
            ],
            "unitSummary": [
                {
                    "availableUnitsCount": "string",
                    "id": "string",
                    "maxPrice": "string",
                    "minArea": "string",
                    "minPrice": "string",
                    "minSize": "string",
                    "name": "string",
                    "siteUnitCategoryId": "string",
                    "totalUnitsCount": "string"
                }
            ],
            "updatedAt._date": "string",
            "useExpirationWindow": "string",
            "useReservationWindow": "string"
        },
        "created": "2022-02-02 22:22:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_facilities`\n(\n`companyId`STRING,`defaultImageDeleted`STRING,`primaryImageMediumId`STRING,`primaryImageMedium`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`mediumId`:STRING,`title`:STRING>,`phone`STRING,`tenantPortalUrl`STRING,`createdAt`struct<`_date`:STRING>,`promoBanner`STRING,`rentalCenterUrl`STRING,`overrides`struct<`address`:struct<`latitude`:STRING,`longitude`:STRING>>,`__v`STRING,`directPhone`STRING,`pageStatus`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`primaryTitle`STRING,`unitSummary`array>,`_id`STRING,`name`STRING,`primaryAlt`STRING,`socialMedia`struct<`platforms`:array>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`primaryTarget`STRING,`settings`struct<`disableReservations`:STRING,`bannerToken`:STRING,`businessAddressDescription`:STRING,`hidePricingDisplayCall`:STRING,`enableManagedRates`:STRING,`reservationConfirmation`:STRING,`callActionThreshold`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableDueAtMoveIn`:STRING,`showAvailableUnitCountThreshold`:STRING,`tagline`:STRING,`showUnavailableUnits`:STRING,`leaseUrl`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`reservationDisclaimer`:STRING,`enablePublicDescription`:STRING,`enableMoveIns`:STRING,`businessNameOverride`:STRING,`showAvailableUnitCount`:STRING>,`expirationWindow`STRING,`useReservationWindow`STRING,`updatedAt`struct<`_date`:STRING>,`unitGroups`array,`area`:STRING,`length`:STRING,`width`:STRING,`height`:STRING,`dueAtMoveInWithoutFees`:STRING,`availableUnitsCount`:STRING,`totalUnitsCount`:STRING,`standardRate`:STRING,`amenities`:array>,`discountPlans`:array,`discountPlanDiscounts`:array>,`facilities`:array>,`alwaysDiscountPlanDiscountId`:STRING,`clientApplications`:array>,`apiAssociationIds`:array,`discountPlanControls`:array,`existingTenantOnly`:STRING,`tenantAccountKindId`:STRING,`roundToNearest`:STRING,`prepayMonths`:STRING,`prepayRequired`:STRING,`minOccupancyMonths`:STRING,`minOccupancyRequired`:STRING,`kind`:STRING>>,`popular`:STRING,`leadOnly`:STRING,`promoId`:STRING,`moveInUrl`:STRING,`reservationUrl`:STRING,`sort`:STRING,`dueMonthly`:STRING,`price`:STRING,`discountedPrice`:STRING,`isWeekly`:STRING,`pricingTypeId`:STRING,`availablePricingTypes`:array>,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`googlePlaceId`STRING,`theme`struct<`colors`:struct<`tertiary`:STRING,`secondary`:STRING,`primary`:STRING,`_id`:struct<`_oid`:STRING>>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`logo`struct<`title`:STRING,`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`_id`:struct<`_oid`:STRING>,`href`:STRING>,`mediumId`:STRING,`alt`:STRING>,`deleted`STRING,`currencySymbol`STRING,`linkOutUrl`STRING,`primaryLink`STRING,`enabled`STRING,`reservationWindow`STRING,`facilityType`STRING,`primaryImage`STRING,`hours`struct<`office`:struct<`note`:STRING,`hours`:array>>>,`access`:struct<`note`:STRING,`hours`:array>>>>,`address`struct<`state`:STRING,`country`:STRING,`city`:STRING,`latitude`:STRING,`longitude`:STRING,`address2`:STRING,`address1`:STRING,`postal`:STRING>,`storeNumber`STRING,`email`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`amenities`array>,`hasRentalCenter`STRING,`brandName`STRING,`useExpirationWindow`STRING,`discountPlans`array>>>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`: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-mongo-storedge-stage/raw/voyager_facilities/2022-02-02/1643861824'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_facilities"
        }
    },
    "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