Schema Info

Schema Name: sfdl_dev_mongo.storedge_clifftestvoyager_facilities

created: 2020-06-11 12:23:33
disabled: False
format: raw
id: 1479
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_mongo",
    "table": "storedge_clifftestvoyager_facilities"
}

type: mongo

Schema Versions: 2

Version 4679052

created: 2020-06-11 14:42:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_facilities`\n(\n`address`struct<`postal`:STRING,`country`:STRING,`latitude`:STRING,`state`:STRING,`city`:STRING,`address1`:STRING,`address2`:STRING,`longitude`:STRING>,`phone`STRING,`logo`struct<`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`href`:STRING,`_id`:struct<`_oid`:STRING>>,`alt`:STRING,`title`:STRING>,`brandName`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`unitSummary`array>,`facilityType`STRING,`hours`struct<`access`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>,`office`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>>,`tenantPortalUrl`STRING,`reservationWindow`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,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`deleted`STRING,`email`STRING,`linkOutUrl`STRING,`amenities`array>,`updatedAt`struct<`_date`:STRING>,`theme`struct<`colors`:struct<`primary`:STRING,`_id`:struct<`_oid`:STRING>,`secondary`:STRING,`tertiary`:STRING>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`:STRING>>,`promoBanner`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`_id`STRING,`settings`struct<`softwareProvider`:STRING,`hidePricingDisplayCall`:STRING,`enableMoveIns`:STRING,`showUnavailableUnits`:STRING,`tagline`:STRING,`callActionThreshold`:STRING,`reservationConfirmation`:STRING,`showAvailableUnitCountThreshold`:STRING,`enableDueAtMoveIn`:STRING,`reservationDisclaimer`:STRING,`showAvailableUnitCount`:STRING,`businessNameOverride`:STRING,`voyagerOnly`:STRING,`businessAddressDescription`:STRING,`enablePublicDescription`:STRING,`enableUsePromoModifiedPricing`:STRING,`disableReservations`:STRING,`enableManagedRates`:STRING,`bannerToken`:STRING>,`defaultImageDeleted`STRING,`currencySymbol`STRING,`overrides`struct<`address`:struct<`longitude`:STRING,`latitude`:STRING>>,`primaryLink`STRING,`googlePlaceId`STRING,`expirationWindow`STRING,`name`STRING,`primaryTitle`STRING,`discountPlans`array>>>,`companyId`STRING,`primaryAlt`STRING,`enabled`STRING,`__v`STRING,`hasRentalCenter`STRING,`rentalCenterUrl`STRING,`pageStatus`STRING,`useExpirationWindow`STRING,`createdAt`struct<`_date`:STRING>,`primaryTarget`STRING,`primaryImage`STRING,`useReservationWindow`STRING,`storeNumber`STRING,`directPhone`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-dev/raw/clifftestvoyager_facilities/2020-06-11/1591904550'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_facilities"
]

hive_path: s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_facilities/2020-06-11/1591904550
id: 4679052
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": "0b5dbf82-5610-4a22-b7bc-eed01d4030de",
            "name": "Clean",
            "sort": 5
        }
    ],
    "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": "ChIJtWwYeWLhmoARb7uriEwe2WU",
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5ee07b0e296b2b0525067793"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5ee07b0e296b2b052506779a"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "5ee07b0e296b2b05250677a1"
        },
        "coordinates": [
            -85.102404,
            33.6041219
        ],
        "type": "Point"
    },
    "logo": {
        "_id": {
            "_oid": "5e4c3b1512752b07e4fdb5ef"
        },
        "alt": "",
        "link": {
            "_id": {
                "_oid": "5e4c3b1512752b07e4fdb5f0"
            },
            "href": "/",
            "target": "_self"
        },
        "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",
    "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": "Five Stars. Jeffry has very good customer service skills!",
            "email": "[email protected]",
            "id": "20c146e2-37e1-4e8d-a684-f6ce4f8fb145",
            "ip": "24.237.133.13",
            "name": "C. Tadda",
            "rating": 5,
            "reply": null,
            "timestamp": {
                "_date": "2019-06-26T18:25:19.200Z"
            }
        }
    ],
    "settings": {
        "bannerToken": "",
        "businessAddressDescription": "",
        "businessNameOverride": "",
        "callActionThreshold": 1,
        "disableReservations": false,
        "enableDueAtMoveIn": false,
        "enableManagedRates": true,
        "enableMoveIns": true,
        "enablePublicDescription": true,
        "enableUsePromoModifiedPricing": true,
        "hidePricingDisplayCall": false,
        "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
    },
    "storeNumber": "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": "ce76fbb9-7abd-4246-b0e3-33a2429abed9",
                    "name": "Ground Inside Climate Controlled",
                    "token": null
                }
            ],
            "area": 50,
            "availableUnitsCount": 6,
            "category": "7daf5649-0cec-4dcd-8821-6085592d0a77",
            "categoryName": "small",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "48e7d6a3-4105-450e-9887-8f9606488078",
                    "apiAssociationIds": [
                        "cd350722-ba07-4d53-8fdb-a33132ad99d5",
                        "8f1dfdfa-d2fc-4983-9b06-971b08a33ee4"
                    ],
                    "autoApply": true,
                    "availabilityText": "8/8/2019",
                    "availableForAllFacilities": false,
                    "clientApplications": [
                        {
                            "channelRates": false,
                            "id": "e9d6fd20-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "storEDGE Unified Platform"
                        },
                        {
                            "channelRates": false,
                            "id": "e6f1b080-78fa-0134-c043-0a9b5cc99ca5",
                            "name": "FMS"
                        }
                    ],
                    "createdAt": "2019-08-08T13:50:57.601-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "3 months half off",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 50,
                            "createdAt": "2019-08-08T13:50:57.618-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "percent",
                            "id": "66eddf4c-33a3-433f-be33-a20ac3755a09",
                            "monthNumber": 2,
                            "updatedAt": "2019-08-08T13:50:57.618-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [
                        {
                            "id": "93014935-6874-4eec-abd6-93f7da3dfa5a"
                        }
                    ],
                    "facilityIds": [
                        "ff46bba8-3c9e-41e7-b5ea-5190a3c5eb7f",
                        "b9dc5123-5f6f-4aa1-9927-23991d09dd04",
                        "79480fb2-7798-4ef7-9606-2ab97e2a660f",
                        "ca8a6f27-4ab0-41c3-991c-d4d23e99dcd9",
                        "4069054b-06c5-4ecc-bc12-d1b0732957eb"
                    ],
                    "hideFromWebsite": false,
                    "id": "ba6aaa15-b5f9-4913-8920-183d6e8d439c",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "3MONTHS1/2OFF",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "3 months half off",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2019-08-08",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2020-05-26T07:04:30.064-10:00"
                }
            ],
            "discountedPrice": null,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 119,
            "dueMonthly": 119,
            "height": 8,
            "id": "b7844491-56e2-4e21-959f-ef9b2a5daffa",
            "isWeekly": false,
            "leadOnly": null,
            "length": 10,
            "moveInUrl": "https://rental-center.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/move-in/000d2d98-7259-40ed-9111-60cce9662b03/b7844491-56e2-4e21-959f-ef9b2a5daffa",
            "name": "5x10x8 - $119.00 - 75124 - 1",
            "popular": false,
            "price": 119,
            "priceWeekly": null,
            "promoId": null,
            "reservationUrl": "https://rental-center.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/reserve/b7844491-56e2-4e21-959f-ef9b2a5daffa",
            "sort": null,
            "standardRate": 119,
            "totalUnitsCount": 6,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 5
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 6,
            "id": "412b818e-f2c8-4685-bf06-bbab6f9bd249",
            "maxPrice": 199,
            "minArea": 200,
            "minPrice": 199,
            "minSize": "10x20",
            "name": "Large",
            "siteUnitCategoryId": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "totalUnitsCount": 6
        }
    ],
    "updatedAt": {
        "_date": "2020-05-20T15:17:39.091Z"
    },
    "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.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "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.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "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",
            "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",
            "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: 1479
schema_scan_id: 5624887
updated: 2020-06-11 14:42:46

Version 4679046

created: 2020-06-11 12:23:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_facilities`\n(\n`_id`STRING,`__v`STRING,`address`struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`state`:STRING,`postal`:STRING,`country`:STRING,`latitude`:STRING,`longitude`:STRING>,`amenities`array>,`brandName`STRING,`companyId`STRING,`currencySymbol`STRING,`defaultImageDeleted`STRING,`directPhone`STRING,`discountPlans`array>>>,`email`STRING,`enabled`STRING,`expirationWindow`STRING,`facilityType`STRING,`googlePlaceId`STRING,`hasRentalCenter`STRING,`hours`struct<`office`:struct<`hours`:array,`close`:STRING,`day`:STRING,`open`:STRING>>,`note`:STRING>,`access`:struct<`hours`:array,`close`:STRING,`day`:STRING,`open`:STRING>>,`note`:STRING>>,`linkOutUrl`STRING,`location`struct<`coordinates`:array,`_id`:struct<`_oid`:STRING>,`type`:STRING>,`name`STRING,`phone`STRING,`rentalCenterUrl`STRING,`reservationFeeRequired`STRING,`reservationWindow`STRING,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`:STRING>>,`settings`struct<`enablePublicDescription`:STRING,`disableReservations`:STRING,`showAvailableUnitCount`:STRING,`enableMoveIns`:STRING,`enableUsePromoModifiedPricing`:STRING,`enableManagedRates`:STRING,`hidePricingDisplayCall`:STRING,`showUnavailableUnits`:STRING,`callActionThreshold`:STRING,`voyagerOnly`:STRING,`softwareProvider`:STRING,`showAvailableUnitCountThreshold`:STRING,`reservationDisclaimer`:STRING,`reservationConfirmation`:STRING,`businessNameOverride`:STRING,`businessAddressDescription`:STRING,`tagline`:STRING,`bannerToken`:STRING,`enableDueAtMoveIn`:STRING>,`storeNumber`STRING,`tenantPortalUrl`STRING,`theme`struct<`enabled`:STRING,`colors`:struct<`_id`:struct<`_oid`:STRING>,`primary`:STRING,`secondary`:STRING,`tertiary`:STRING>,`_id`:struct<`_oid`:STRING>>,`timezone`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>,`createdAt`:STRING,`updatedAt`:STRING,`deleted`:STRING,`deletedBy`:STRING,`deletedOn`:STRING,`facilityIds`: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,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`unitSummary`array>,`useExpirationWindow`STRING,`useReservationWindow`STRING,`pageStatus`STRING,`primaryAlt`STRING,`primaryImage`STRING,`primaryLink`STRING,`primaryTarget`STRING,`primaryTitle`STRING,`createdAt`struct<`_date`:STRING>,`updatedAt`struct<`_date`:STRING>,`logo`struct<`_id`:struct<`_oid`:STRING>,`alt`:STRING,`link`:struct<`_id`:struct<`_oid`:STRING>,`href`:STRING,`target`:STRING>,`path`:STRING,`title`:STRING>,`promoBanner`STRING,`deleted`STRING,`overrides`struct<`address`:struct<`longitude`:STRING,`latitude`: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-dev/raw/clifftestvoyager_facilities/2020-06-11/1591896211'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_facilities"
]

hive_path: s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_facilities/2020-06-11/1591896211
id: 4679046
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": "69fd5d67-a99d-4d88-9bb2-33cb701a9100",
            "name": "Gated Access",
            "sort": 5
        }
    ],
    "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": "ChIJtWwYeWLhmoARb7uriEwe2WU",
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5edfa0026a348204edb182dd"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5edfa0026a348204edb182e4"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "5edfa0026a348204edb182eb"
        },
        "coordinates": [
            -85.102404,
            33.6041219
        ],
        "type": "Point"
    },
    "logo": {
        "_id": {
            "_oid": "5e4c3b1512752b07e4fdb5ef"
        },
        "alt": "",
        "link": {
            "_id": {
                "_oid": "5e4c3b1512752b07e4fdb5f0"
            },
            "href": "/",
            "target": "_self"
        },
        "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",
    "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": "Five Stars. Jeffry has very good customer service skills!",
            "email": "[email protected]",
            "id": "20c146e2-37e1-4e8d-a684-f6ce4f8fb145",
            "ip": "24.237.133.13",
            "name": "C. Tadda",
            "rating": 5,
            "reply": null,
            "timestamp": {
                "_date": "2019-06-26T18:25:19.200Z"
            }
        }
    ],
    "settings": {
        "bannerToken": "",
        "businessAddressDescription": "",
        "businessNameOverride": "",
        "callActionThreshold": 1,
        "disableReservations": false,
        "enableDueAtMoveIn": false,
        "enableManagedRates": true,
        "enableMoveIns": true,
        "enablePublicDescription": true,
        "enableUsePromoModifiedPricing": true,
        "hidePricingDisplayCall": false,
        "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
    },
    "storeNumber": "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": "ce76fbb9-7abd-4246-b0e3-33a2429abed9",
                    "name": "Ground Inside Climate Controlled",
                    "token": null
                }
            ],
            "area": 25,
            "availableUnitsCount": 0,
            "category": "7daf5649-0cec-4dcd-8821-6085592d0a77",
            "categoryName": "small",
            "discountPlans": [
                {
                    "alwaysDiscountPlanDiscountId": "48e7d6a3-4105-450e-9887-8f9606488078",
                    "apiAssociationIds": [
                        "cd350722-ba07-4d53-8fdb-a33132ad99d5",
                        "8f1dfdfa-d2fc-4983-9b06-971b08a33ee4"
                    ],
                    "autoApply": true,
                    "availabilityText": "8/8/2019",
                    "availableForAllFacilities": false,
                    "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-04-10T11:51:08.200-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "3 months half off",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 50,
                            "createdAt": "2018-04-10T11:51:08.236-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "percent",
                            "id": "a1c60062-c9ca-4de5-ab54-13214e42a2c3",
                            "monthNumber": 2,
                            "updatedAt": "2018-04-10T11:51:08.236-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [
                        {
                            "id": "02620a89-9e0e-4611-82e4-745105751f15"
                        }
                    ],
                    "facilityIds": [
                        "bccf6ef6-6baa-4eef-965a-c9b7a562aded",
                        "fe487b45-c909-4d66-8433-75beb6bb1f14",
                        "a7f5bfa6-9b16-4c7f-ac72-8bc65d5c9ff0",
                        "f230a892-81da-4ef1-b6a3-fad1dceb9ae4"
                    ],
                    "hideFromWebsite": false,
                    "id": "d38776bd-5fbd-41ac-b3af-d19e695b03fe",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "3MONTHS1/2OFF",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "3 months half off",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2019-08-08",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2018-04-10T11:51:08.200-10:00"
                }
            ],
            "discountedPrice": 34,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 34,
            "dueMonthly": 45,
            "height": 0,
            "id": "9c0a3cdf-05b3-4c8a-9105-1870530a684a",
            "isWeekly": false,
            "leadOnly": null,
            "length": 5,
            "moveInUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?sCorpCode=CCMQ&sLocationCode=L088&unit=91470&concession=10154&reservation=false&channeltype=0",
            "name": "5x5",
            "popular": null,
            "price": 45,
            "priceWeekly": null,
            "promoId": null,
            "reservationUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?sCorpCode=CCMQ&sLocationCode=L088&unit=91470&concession=10154&reservation=true&channeltype=0",
            "sort": null,
            "standardRate": 45,
            "totalUnitsCount": 6,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 5
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 6,
            "id": "c6cccbbd-5cac-4976-9eda-aff1c9d0b53e",
            "maxPrice": 199,
            "minArea": 200,
            "minPrice": 199,
            "minSize": "10x20",
            "name": "Large",
            "siteUnitCategoryId": "359f1ffe-f9c0-45ac-b6a3-0757416c0153",
            "totalUnitsCount": 6
        }
    ],
    "updatedAt": {
        "_date": "2020-05-20T15:17:39.091Z"
    },
    "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.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "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.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "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",
            "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",
            "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: 1479
schema_scan_id: 5624747
updated: 2020-06-11 12:23:46

Schema Scans: 2

Last at 2020-06-11 14:42:32

Scan 5624887
- duration: 0:00:16.940445
- exit_message:
```
{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
```
- id: 5624887
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-dev",
        "hive_path": "s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_facilities/2020-06-11/1591904550",
        "key": "raw/clifftestvoyager_facilities/2020-06-11/1591904550/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_clifftestvoyager_facilities",
        "type": "mongo"
    }
}
```
- running: False
- schema_name_id: 1479
- start_time: 2020-06-11 14:42:32
- success: True
- trace_id: 16268375095240824710

Scan 5624747
- duration: 0:00:16.640997
- exit_message:
```
{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
```
- id: 5624747
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-dev",
        "hive_path": "s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_facilities/2020-06-11/1591896211",
        "key": "raw/clifftestvoyager_facilities/2020-06-11/1591896211/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_clifftestvoyager_facilities",
        "type": "mongo"
    }
}
```
- running: False
- schema_name_id: 1479
- start_time: 2020-06-11 12:23:32
- success: True
- trace_id: 14739001619977783736

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.path": "string",
    "logo.title": "string",
    "name": "string",
    "overrides.address.latitude": "string",
    "overrides.address.longitude": "string",
    "pageStatus": "string",
    "phone": "string",
    "primaryAlt": "string",
    "primaryImage": "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.reservationConfirmation": "string",
    "settings.reservationDisclaimer": "string",
    "settings.showAvailableUnitCount": "string",
    "settings.showAvailableUnitCountThreshold": "string",
    "settings.showUnavailableUnits": "string",
    "settings.softwareProvider": "string",
    "settings.tagline": "string",
    "settings.voyagerOnly": "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",
            "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",
            "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: 2020-06-11 14:42:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_facilities`\n(\n`address`struct<`postal`:STRING,`country`:STRING,`latitude`:STRING,`state`:STRING,`city`:STRING,`address1`:STRING,`address2`:STRING,`longitude`:STRING>,`phone`STRING,`logo`struct<`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`href`:STRING,`_id`:struct<`_oid`:STRING>>,`alt`:STRING,`title`:STRING>,`brandName`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`unitSummary`array>,`facilityType`STRING,`hours`struct<`access`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>,`office`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>>,`tenantPortalUrl`STRING,`reservationWindow`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,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`deleted`STRING,`email`STRING,`linkOutUrl`STRING,`amenities`array>,`updatedAt`struct<`_date`:STRING>,`theme`struct<`colors`:struct<`primary`:STRING,`_id`:struct<`_oid`:STRING>,`secondary`:STRING,`tertiary`:STRING>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`:STRING>>,`promoBanner`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`_id`STRING,`settings`struct<`softwareProvider`:STRING,`hidePricingDisplayCall`:STRING,`enableMoveIns`:STRING,`showUnavailableUnits`:STRING,`tagline`:STRING,`callActionThreshold`:STRING,`reservationConfirmation`:STRING,`showAvailableUnitCountThreshold`:STRING,`enableDueAtMoveIn`:STRING,`reservationDisclaimer`:STRING,`showAvailableUnitCount`:STRING,`businessNameOverride`:STRING,`voyagerOnly`:STRING,`businessAddressDescription`:STRING,`enablePublicDescription`:STRING,`enableUsePromoModifiedPricing`:STRING,`disableReservations`:STRING,`enableManagedRates`:STRING,`bannerToken`:STRING>,`defaultImageDeleted`STRING,`currencySymbol`STRING,`overrides`struct<`address`:struct<`longitude`:STRING,`latitude`:STRING>>,`primaryLink`STRING,`googlePlaceId`STRING,`expirationWindow`STRING,`name`STRING,`primaryTitle`STRING,`discountPlans`array>>>,`companyId`STRING,`primaryAlt`STRING,`enabled`STRING,`__v`STRING,`hasRentalCenter`STRING,`rentalCenterUrl`STRING,`pageStatus`STRING,`useExpirationWindow`STRING,`createdAt`struct<`_date`:STRING>,`primaryTarget`STRING,`primaryImage`STRING,`useReservationWindow`STRING,`storeNumber`STRING,`directPhone`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-dev/raw/clifftestvoyager_facilities/2020-06-11/1591904550'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_facilities"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2020-06-11 12:23:33",
        "disabled": false,
        "format": "raw",
        "id": 1479,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_mongo",
            "table": "storedge_clifftestvoyager_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.path": "string",
            "logo.title": "string",
            "name": "string",
            "overrides.address.latitude": "string",
            "overrides.address.longitude": "string",
            "pageStatus": "string",
            "phone": "string",
            "primaryAlt": "string",
            "primaryImage": "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.reservationConfirmation": "string",
            "settings.reservationDisclaimer": "string",
            "settings.showAvailableUnitCount": "string",
            "settings.showAvailableUnitCountThreshold": "string",
            "settings.showUnavailableUnits": "string",
            "settings.softwareProvider": "string",
            "settings.tagline": "string",
            "settings.voyagerOnly": "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",
                    "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",
                    "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": "2020-06-11 14:42:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_facilities`\n(\n`address`struct<`postal`:STRING,`country`:STRING,`latitude`:STRING,`state`:STRING,`city`:STRING,`address1`:STRING,`address2`:STRING,`longitude`:STRING>,`phone`STRING,`logo`struct<`_id`:struct<`_oid`:STRING>,`path`:STRING,`link`:struct<`target`:STRING,`href`:STRING,`_id`:struct<`_oid`:STRING>>,`alt`:STRING,`title`:STRING>,`brandName`STRING,`location`struct<`coordinates`:array,`type`:STRING,`_id`:struct<`_oid`:STRING>>,`unitSummary`array>,`facilityType`STRING,`hours`struct<`access`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>,`office`:struct<`note`:STRING,`hours`:array,`day`:STRING,`open`:STRING,`close`:STRING>>>>,`tenantPortalUrl`STRING,`reservationWindow`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,`category`:STRING,`categoryName`:STRING,`priceWeekly`:STRING,`dueAtMoveIn`:STRING>>,`deleted`STRING,`email`STRING,`linkOutUrl`STRING,`amenities`array>,`updatedAt`struct<`_date`:STRING>,`theme`struct<`colors`:struct<`primary`:STRING,`_id`:struct<`_oid`:STRING>,`secondary`:STRING,`tertiary`:STRING>,`_id`:struct<`_oid`:STRING>,`enabled`:STRING>,`reviews`array,`id`:STRING,`rating`:STRING,`name`:STRING,`email`:STRING,`ip`:STRING,`body`:STRING,`reply`:STRING>>,`promoBanner`STRING,`reservationFeeRequired`STRING,`timezone`STRING,`_id`STRING,`settings`struct<`softwareProvider`:STRING,`hidePricingDisplayCall`:STRING,`enableMoveIns`:STRING,`showUnavailableUnits`:STRING,`tagline`:STRING,`callActionThreshold`:STRING,`reservationConfirmation`:STRING,`showAvailableUnitCountThreshold`:STRING,`enableDueAtMoveIn`:STRING,`reservationDisclaimer`:STRING,`showAvailableUnitCount`:STRING,`businessNameOverride`:STRING,`voyagerOnly`:STRING,`businessAddressDescription`:STRING,`enablePublicDescription`:STRING,`enableUsePromoModifiedPricing`:STRING,`disableReservations`:STRING,`enableManagedRates`:STRING,`bannerToken`:STRING>,`defaultImageDeleted`STRING,`currencySymbol`STRING,`overrides`struct<`address`:struct<`longitude`:STRING,`latitude`:STRING>>,`primaryLink`STRING,`googlePlaceId`STRING,`expirationWindow`STRING,`name`STRING,`primaryTitle`STRING,`discountPlans`array>>>,`companyId`STRING,`primaryAlt`STRING,`enabled`STRING,`__v`STRING,`hasRentalCenter`STRING,`rentalCenterUrl`STRING,`pageStatus`STRING,`useExpirationWindow`STRING,`createdAt`struct<`_date`:STRING>,`primaryTarget`STRING,`primaryImage`STRING,`useReservationWindow`STRING,`storeNumber`STRING,`directPhone`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-dev/raw/clifftestvoyager_facilities/2020-06-11/1591904550'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_facilities"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}