Schema Info

Schema Name: sfdl_dev_mongo.storedge_voyager_facilities

created: 2019-04-05 14:16:03
disabled: False
format: raw
id: 1233
is_partitioned: False
is_schema_datatyped: False

name:

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

type: mongo

Schema Versions: 3

Version 4684176

created: 2020-11-05 17:02:53

ddl:

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

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_facilities/2020-11-05/1604617332
id: 4684176
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": "23c40528-9836-4458-bd93-e7e349d713b4",
            "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": "ChIJtWwYeWLhmoARb7uriEwe2WU",
    "hasRentalCenter": true,
    "hours": {
        "access": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5fa38a8baefa1e052d402309"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5fa38a8baefa1e052d402310"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "5fa38a8baefa1e052d402317"
        },
        "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": "4e2b636c-a920-499a-b0ea-6de38d05c950",
                    "name": "Heated",
                    "token": null
                }
            ],
            "area": 25,
            "availableUnitsCount": 4,
            "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": "1/23/2020",
                    "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": "2020-01-23T10:26:16.808-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "First 2 Months - 50% Off STD Trigger Unit Trigger",
                    "discountPlanControls": [],
                    "discountPlanDiscounts": [
                        {
                            "amount": 50,
                            "createdAt": "2020-01-23T10:26:16.826-10:00",
                            "deleted": false,
                            "deletedBy": null,
                            "deletedOn": null,
                            "discountType": "percent",
                            "id": "4aac996e-31e8-4a53-9ba0-45fdbb706935",
                            "monthNumber": 2,
                            "updatedAt": "2020-01-23T10:26:16.826-10:00"
                        }
                    ],
                    "endDate": null,
                    "existingTenantOnly": false,
                    "facilities": [],
                    "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": "05d6ede0-24b4-49f4-98a3-65179658b344",
                    "kind": "limited",
                    "minOccupancyMonths": 1,
                    "minOccupancyRequired": false,
                    "moveInOnly": false,
                    "name": "3.2",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "First 2 Months - 50% Off",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": "2020-01-23",
                    "tenantAccountKindId": null,
                    "turnedOn": true,
                    "updatedAt": "2020-10-30T04:17:33.158-10:00"
                }
            ],
            "discountedPrice": null,
            "dueAtMoveIn": 95,
            "dueAtMoveInWithoutFees": 59,
            "dueMonthly": 59,
            "height": 8,
            "id": "dd471a18-d39e-4d35-bb7c-1386b77fd9cd",
            "isWeekly": false,
            "leadOnly": null,
            "length": 5,
            "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/dd471a18-d39e-4d35-bb7c-1386b77fd9cd",
            "name": "5x5x8 - $59.00 - 75124 - 1",
            "popular": false,
            "price": 59,
            "priceWeekly": null,
            "promoId": null,
            "reservationUrl": "https://rental-center.staging.storedge.com?companyId=7773eb76-1bd9-4327-9de8-608cc534ac51&facilityId=000d2d98-7259-40ed-9111-60cce9662b03#/reserve/dd471a18-d39e-4d35-bb7c-1386b77fd9cd",
            "sort": null,
            "standardRate": 59,
            "totalUnitsCount": 8,
            "type": {
                "id": "29af16ba-5d7b-445a-9931-c5a864daacb6",
                "name": "Non climate"
            },
            "width": 5
        }
    ],
    "unitSummary": [
        {
            "availableUnitsCount": 5,
            "id": "7c874034-7669-48c1-8c92-5c9be2035288",
            "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",
    "promoBanner.defaultMessage": "string",
    "promoBanner.id": "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": [
                        "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: 1233
schema_scan_id: 5718512
updated: 2020-11-05 17:03:06

Version 4679082

created: 2020-06-14 12:03:20

ddl:

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

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_facilities/2020-06-14/1592154140
id: 4679082
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": "5ee46c58262f15055f59ae0d"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5ee46c58262f15055f59ae14"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "5ee46c58262f15055f59ae1b"
        },
        "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": "",
                    "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": "2019-08-08T13:50:57.601-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "25% Discount for 6 Mths",
                    "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": "a7f5bfa6-9b16-4c7f-ac72-8bc65d5c9ff0"
                        },
                        {
                            "id": "f230a892-81da-4ef1-b6a3-fad1dceb9ae4"
                        }
                    ],
                    "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": "25% Discount for 6 Mths",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "25% Discount for 6 Mths",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": null,
                    "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": [
        {
            "_id": {
                "_oid": "5ee2865013c8d308bc6b78dd"
            },
            "availableUnitsCount": 6,
            "id": "7d0941ae-cf9d-42ba-bc6c-34bff684e49d",
            "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",
    "promoBanner.defaultMessage": "string",
    "promoBanner.id": "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": [
        {
            "_id._oid": "string",
            "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: 1233
schema_scan_id: 5627162
updated: 2020-06-14 12:03:31

Version 4679072

created: 2020-06-13 16:23:42

ddl:

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

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_facilities/2020-06-13/1592083363
id: 4679072
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": "5ee31c6f6282f50512e69d90"
                    },
                    "close": 22,
                    "day": "Saturday",
                    "open": 6
                }
            ],
            "note": ""
        },
        "office": {
            "hours": [
                {
                    "_id": {
                        "_oid": "5ee31c6f6282f50512e69d97"
                    },
                    "close": 17,
                    "day": "Saturday",
                    "open": 8
                }
            ],
            "note": ""
        }
    },
    "linkOutUrl": "",
    "location": {
        "_id": {
            "_oid": "5ee31c6f6282f50512e69d9e"
        },
        "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": "",
                    "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": "2019-08-08T13:50:57.601-10:00",
                    "deleted": false,
                    "deletedBy": null,
                    "deletedOn": null,
                    "description": "25% Discount for 6 Mths",
                    "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": "bcf3d73f-dc8a-41fc-8e72-737281b79951"
                        }
                    ],
                    "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": "25% Discount for 6 Mths",
                    "prepayMonths": 3,
                    "prepayRequired": true,
                    "priority": null,
                    "promotionType": "promotion",
                    "publicDescription": "25% Discount for 6 Mths",
                    "requirementsText": "",
                    "roundToNearest": null,
                    "startDate": null,
                    "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": [
        {
            "_id": {
                "_oid": "5ee2865013c8d308bc6b78dd"
            },
            "availableUnitsCount": 6,
            "id": "8fbcb79f-ffd1-423c-8570-5f6459d1553e",
            "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",
    "promoBanner.defaultMessage": "string",
    "promoBanner.id": "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": [
        {
            "_id._oid": "string",
            "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: 1233
schema_scan_id: 5627101
updated: 2020-06-13 16:23:53

Schema Scans: 3

Last at 2020-11-05 17:02:49

Scan 5718512

duration: 0:00:22.561927

exit_message:

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

id: 5718512

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/voyager_facilities/2020-11-05/1604617332",
        "key": "raw/voyager_facilities/2020-11-05/1604617332/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 6063512889259977511,
        "service_name": "preloading",
        "span_id": 10464859293977340838,
        "trace_id": 6112369120461499106
    }
}

running: False
schema_name_id: 1233
start_time: 2020-11-05 17:02:49
success: True
trace_id: 6112369120461499106

Scan 5627162

duration: 0:00:16.934266

exit_message:

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

id: 5627162

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/voyager_facilities/2020-06-14/1592154140",
        "key": "raw/voyager_facilities/2020-06-14/1592154140/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 10839979562718606608,
        "service_name": "preloading",
        "span_id": 8116861058526219296,
        "trace_id": 1445678987074264860
    }
}

running: False
schema_name_id: 1233
start_time: 2020-06-14 12:03:17
success: True
trace_id: 1445678987074264860

Scan 5627101

duration: 0:00:16.914592

exit_message:

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

id: 5627101

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/voyager_facilities/2020-06-13/1592083363",
        "key": "raw/voyager_facilities/2020-06-13/1592083363/facilities_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_facilities",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 9019852988592501797,
        "service_name": "preloading",
        "span_id": 10269789882623377163,
        "trace_id": 20763686744671641
    }
}

running: False
schema_name_id: 1233
start_time: 2020-06-13 16:23:39
success: True
trace_id: 20763686744671641

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",
    "promoBanner.defaultMessage": "string",
    "promoBanner.id": "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": [
                        "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-11-05 17:02:53

ddl:

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