Schema Info

Schema Name: sfdl_stage_mongo.storedge_voyager_pages
  • created: 2019-04-05 13:49:00
  • disabled: False
  • format: raw
  • id: 819
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_mongo",
    "table": "storedge_voyager_pages"
}
  • type: mongo
Schema Versions: 3
    • created: 2022-02-02 22:33:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pages`\n(\n`locale`STRING,`companyId`STRING,`parent`struct<`_oid`:STRING>,`live`STRING,`siblings`array,`customBreadcrumbs`array>,`disableEnUsPage`STRING,`createdAt`struct<`_date`:STRING>,`layout`struct<`_oid`:STRING>,`publishedVersion`struct<`styles`:STRING,`tag`:STRING,`sections`:array>,`entityRanges`:array>,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`leadSource`:STRING,`leadType`:STRING,`disableMobile`:STRING,`popUpTimer`:STRING,`popUpTrigger`:STRING,`thankYouButtonText`:STRING,`thankYouBodyText`:STRING,`thankYouHeaderText`:STRING,`bodyButtonText`:STRING,`includeFormFields`:STRING,`popUpBodyText`:STRING,`popUpHeaderText`:STRING,`customLeadText`:STRING,`featuredImage`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`thankYouBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`43uts`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`dl7jv`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`1rua6`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`fa6qn`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`2pjb2`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`5em44`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:STRING,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`43uts`:STRING,`dl7jv`:STRING,`1rua6`:STRING,`fa6qn`:STRING,`2pjb2`:STRING,`5em44`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`2pjb2`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`center`:struct<`longitude`:STRING,`latitude`:STRING>,`popupHeaderText`:STRING,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`href`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>>>,`id`:STRING,`payload`:STRING,`data`:STRING>>,`id`:STRING,`createdAt`:STRING>,`versions`array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`src`:STRING,`alt`:STRING,`href`:STRING,`key`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`href`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING>>>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`dl7jv`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`dl7jv`:STRING,`1rua6`:STRING,`5em44`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:STRING,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`dl7jv`:array>>>,`1rua6`:array>>>,`5em44`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`center`:struct<`latitude`:STRING,`longitude`:STRING>,`featuredImage`:STRING,`popupHeaderText`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`thankYouHeaderText`:STRING,`thankYouBodyContent`:struct<`blocks`:array,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`thankYouButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>,`id`:STRING>>,`id`:STRING,`data`:STRING,`payload`:struct<`heroImage`:struct<`alt`:STRING,`file`:STRING>,`sectionStyle`:struct<`backgroundColor`:STRING,`backgroundStyle`:STRING,`contentBackground`:STRING>,`heroImages`:array>,`displayStyle`:STRING,`color`:STRING,`numCols`:STRING,`mobileBehavior`:STRING,`backgroundColor`:STRING,`numItems`:STRING,`whitespace`:STRING>>>,`id`:STRING,`styles`:STRING>>,`childPageIds`array,`children`array,`__v`STRING,`metadata`struct<`noIndex`:STRING,`type`:STRING,`linkOut`:STRING,`customUrl`:STRING,`description`:STRING,`slug`:STRING,`title`:STRING,`titlePostfix`:STRING,`canonical`:STRING,`metaTags`:array>,`syncOGTags`:STRING,`internalPageName`:STRING>,`_id`struct<`_oid`:STRING>,`facilityId`STRING,`siteId`struct<`_oid`:STRING>,`alternativeLocales`array>,`typeId`struct<`_oid`:STRING>,`customBreadcrumb`STRING,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-02/1643862522'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pages"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-02/1643862522
    • id: 380513
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": {
        "_oid": "61852d71ae55040385a0e43d"
    },
    "boilerplate": false,
    "childPageIds": [],
    "companyId": "eedbd6b8-09ec-4263-b3ee-babd90fd3d9e",
    "createdAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "disableEnUsPage": false,
    "facilityId": "0a06cbd5-bff6-4fcb-a972-92a0520cd5bd",
    "layout": {
        "_oid": "59d508d746916614683a560f"
    },
    "live": true,
    "locale": "en-us",
    "metadata": {
        "canonical": null,
        "customUrl": true,
        "description": "Download the East Wenatchee Mini Storage app from Google Play or the App Store.",
        "internalPageName": "Download our app",
        "linkOut": null,
        "metaTags": [
            {
                "content": "Misc Page",
                "property": "og:title"
            }
        ],
        "noIndex": null,
        "slug": "app",
        "syncOGTags": null,
        "title": "Dowload Our App",
        "titlePostfix": "East Wenatchee Mini Storage",
        "type": "voyager/pages/types/MISC_PAGE"
    },
    "publishedVersion": {
        "createdAt": "2021-12-23T18:13:38.910Z",
        "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
        "sections": [
            {
                "data": null,
                "id": "4f382a70-ba2a-44b7-87eb-54ea6ed8382d",
                "payload": null,
                "type": "FacilityUnits",
                "widgets": [
                    {
                        "componentId": "88f72d83-138f-4e1f-b441-a73afbb18076",
                        "id": "ccba9201-87e4-4cbd-8c8f-42da1c02860d",
                        "payload": {
                            "align": "text-center",
                            "autoplay": true,
                            "bannerText": "24 Hour Access!",
                            "border": false,
                            "center": {
                                "latitude": 34.04152087796438,
                                "longitude": -117.81910649206543
                            },
                            "code": "",
                            "color": "#FFFFFF",
                            "columnHeadings": {
                                "price": "Price",
                                "size": "Size",
                                "unitDetails": "Unit Details"
                            },
                            "content": "https://www.google.com/maps/d/embed?mid=1ujI46Oe_W4jip1wjaHjOrwzK0Kbr4zCr&ehbc=2E312F",
                            "contentType": "iframe",
                            "currentOption": "amenities",
                            "errorCreatingLeadSource": "",
                            "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                            "featuredImage": "",
                            "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                            "height": "315",
                            "href": "http://placehold.it/150x150",
                            "icon": "icon icon-month-to-month-lease",
                            "images": [
                                {
                                    "mediumId": "61d8814f7c9753064e4b6227"
                                }
                            ],
                            "mediumId": "",
                            "otherImages": [
                                {
                                    "alt": "Small storage units",
                                    "file": "/img/grid-1.jpg",
                                    "filename": "/img/grid-1.jpg",
                                    "link": "",
                                    "mediumId": "61853cb14cc07a064126c913",
                                    "target": "_self",
                                    "title": ""
                                }
                            ],
                            "popupBodyContent": {
                                "blocks": [
                                    {
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 16,
                                                "offset": 163
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 16,
                                                "offset": 163,
                                                "style": "UNDERLINE"
                                            }
                                        ],
                                        "key": "dl71j",
                                        "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                        "type": "unstyled"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "http://www.papaswalk.ca/",
                                            "target": "_blank",
                                            "url": "http://www.papaswalk.ca/"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "popupButtonText": "Submit",
                            "popupHeaderText": "Opening Soon",
                            "popupImageAltText": "",
                            "popupImageTitleText": "",
                            "popupIncludeForm": true,
                            "rawContentState": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 20,
                                                "offset": 0
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 26,
                                                "offset": 0,
                                                "style": "FONT_SIZE:30"
                                            }
                                        ],
                                        "key": "db2mm",
                                        "text": "Contact Us",
                                        "type": "header-one"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                            "target": "_blank"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    },
                                    "1": {
                                        "data": {
                                            "href": "tel:2692562853"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "script": "",
                            "scrollbars": false,
                            "settingsLeadSource": "Inquiry",
                            "settingsMobile": true,
                            "settingsNewLeadSource": "",
                            "settingsTimer": "1",
                            "settingsTrigger": "time",
                            "showBanner": false,
                            "showColorField": true,
                            "target": "_self",
                            "thankYouBodyContent": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [],
                                        "inlineStyleRanges": [],
                                        "key": "dl71j",
                                        "text": "We look forward to helping you with all your storage needs. ",
                                        "type": "unstyled"
                                    }
                                ]
                            },
                            "thankYouButtonText": "Close",
                            "thankYouHeaderText": "Thank You!",
                            "zoom": 14
                        },
                        "type": "FacilityUnitsOne"
                    }
                ]
            }
        ],
        "styles": null
    },
    "siblings": [],
    "siteId": {
        "_oid": "617c0ec7a56b2e03693b24b8"
    },
    "typeId": {
        "_oid": "5e39775169acaf00442dc85d"
    },
    "updatedAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "versions": [
        {
            "createdAt": "2021-11-05T13:11:13.526Z",
            "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
            "sections": [
                {
                    "data": null,
                    "id": "4ffe27ed-a381-4736-81ea-503e170b4169",
                    "payload": null,
                    "type": "BigMap",
                    "widgets": [
                        {
                            "componentId": "01fd4e92-d4b7-437c-9700-2de6cb6dd2d8",
                            "id": "8764d901-d960-4f28-9218-69b9b89ca0cc",
                            "payload": {
                                "align": "text-center",
                                "autoplay": true,
                                "bannerText": "24 Hour Access!",
                                "border": false,
                                "center": {
                                    "latitude": 34.04152087796438,
                                    "longitude": -117.81910649206543
                                },
                                "code": "",
                                "color": "#FFFFFF",
                                "content": "https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3242.489480199412!2d-106.01642174950301!3d35.64031018010675!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x87185a4ba999b99b%3A0xf84207634b878df6!2sSentry%20Self-Storage!5e0!3m2!1sen!2sus!4v1636121760223!5m2!1sen!2sus",
                                "contentType": "iframe",
                                "currentOption": "amenities",
                                "errorCreatingLeadSource": "",
                                "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                                "featuredImage": "",
                                "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                                "height": "315",
                                "href": "http://placehold.it/150x150",
                                "icon": "icon icon-month-to-month-lease",
                                "images": [
                                    {
                                        "mediumId": "61d8814f7c9753064e4b6227"
                                    }
                                ],
                                "mediumId": "",
                                "otherImages": [
                                    {
                                        "alt": "Small storage units",
                                        "file": "/img/grid-1.jpg",
                                        "filename": "/img/grid-1.jpg",
                                        "link": "",
                                        "mediumId": "61853cb14cc07a064126c913",
                                        "target": "_self",
                                        "title": ""
                                    }
                                ],
                                "popupBodyContent": {
                                    "blocks": [
                                        {
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 16,
                                                    "offset": 163
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 16,
                                                    "offset": 163,
                                                    "style": "UNDERLINE"
                                                }
                                            ],
                                            "key": "dl71j",
                                            "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                            "type": "unstyled"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "http://www.papaswalk.ca/",
                                                "target": "_blank",
                                                "url": "http://www.papaswalk.ca/"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "popupButtonText": "Submit",
                                "popupHeaderText": "Opening Soon",
                                "popupImageAltText": "",
                                "popupImageTitleText": "",
                                "popupIncludeForm": true,
                                "rawContentState": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 20,
                                                    "offset": 0
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 26,
                                                    "offset": 0,
                                                    "style": "FONT_SIZE:30"
                                                }
                                            ],
                                            "key": "db2mm",
                                            "text": "Contact Us",
                                            "type": "header-one"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                                "target": "_blank"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        },
                                        "1": {
                                            "data": {
                                                "href": "tel:2692562853"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "script": "",
                                "scrollbars": false,
                                "settingsLeadSource": "Inquiry",
                                "settingsMobile": true,
                                "settingsNewLeadSource": "",
                                "settingsTimer": "1",
                                "settingsTrigger": "time",
                                "showBanner": false,
                                "showColorField": true,
                                "target": "_self",
                                "thankYouBodyContent": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [],
                                            "inlineStyleRanges": [],
                                            "key": "dl71j",
                                            "text": "We look forward to helping you with all your storage needs. ",
                                            "type": "unstyled"
                                        }
                                    ]
                                },
                                "thankYouButtonText": "Close",
                                "thankYouHeaderText": "Thank You!",
                                "zoom": 14
                            },
                            "type": "EmbedContent"
                        }
                    ]
                }
            ],
            "styles": null
        }
    ]
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id._oid": "string",
    "alternativeLocales": [
        {
            "id": "string",
            "locale": "string"
        }
    ],
    "boilerplate": "string",
    "childPageIds": [
        "string"
    ],
    "children": [
        "string"
    ],
    "companyId": "string",
    "createdAt._date": "string",
    "customBreadcrumb": "string",
    "customBreadcrumbs": [
        {
            "prettyName": "string",
            "slug": "string"
        }
    ],
    "disableEnUsPage": "string",
    "facilityId": "string",
    "layout._oid": "string",
    "live": "string",
    "locale": "string",
    "metadata.canonical": "string",
    "metadata.customUrl": "string",
    "metadata.description": "string",
    "metadata.internalPageName": "string",
    "metadata.linkOut": "string",
    "metadata.metaTags": [
        {
            "content": "string",
            "property": "string"
        }
    ],
    "metadata.noIndex": "string",
    "metadata.slug": "string",
    "metadata.syncOGTags": "string",
    "metadata.title": "string",
    "metadata.titlePostfix": "string",
    "metadata.type": "string",
    "parent._oid": "string",
    "siblings": [
        "string"
    ],
    "siteId._oid": "string",
    "typeId._oid": "string",
    "updatedAt._date": "string"
}
    • schema_name_id: 819
    • schema_scan_id: 3678043
    • updated: 2022-02-02 22:34:01
    • created: 2022-02-01 22:33:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pages`\n(\n`locale`STRING,`companyId`STRING,`parent`struct<`_oid`:STRING>,`live`STRING,`siblings`array,`customBreadcrumbs`array>,`disableEnUsPage`STRING,`createdAt`struct<`_date`:STRING>,`layout`struct<`_oid`:STRING>,`publishedVersion`struct<`styles`:STRING,`tag`:STRING,`sections`:array>,`entityRanges`:array>,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`leadSource`:STRING,`leadType`:STRING,`disableMobile`:STRING,`popUpTimer`:STRING,`popUpTrigger`:STRING,`thankYouButtonText`:STRING,`thankYouBodyText`:STRING,`thankYouHeaderText`:STRING,`bodyButtonText`:STRING,`includeFormFields`:STRING,`popUpBodyText`:STRING,`popUpHeaderText`:STRING,`customLeadText`:STRING,`featuredImage`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`thankYouBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`43uts`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`dl7jv`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`1rua6`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`fa6qn`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`2pjb2`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`5em44`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:STRING,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`43uts`:STRING,`dl7jv`:STRING,`1rua6`:STRING,`fa6qn`:STRING,`2pjb2`:STRING,`5em44`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`2pjb2`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`center`:struct<`longitude`:STRING,`latitude`:STRING>,`popupHeaderText`:STRING,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`href`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>>>,`id`:STRING,`payload`:STRING,`data`:STRING>>,`id`:STRING,`createdAt`:STRING>,`versions`array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`src`:STRING,`alt`:STRING,`href`:STRING,`key`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`href`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING>>>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`dl7jv`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`dl7jv`:STRING,`1rua6`:STRING,`5em44`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:STRING,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`dl7jv`:array>>>,`1rua6`:array>>>,`5em44`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`center`:struct<`latitude`:STRING,`longitude`:STRING>,`featuredImage`:STRING,`popupHeaderText`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`thankYouHeaderText`:STRING,`thankYouBodyContent`:struct<`blocks`:array,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`thankYouButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>,`id`:STRING>>,`id`:STRING,`data`:STRING,`payload`:struct<`heroImage`:struct<`alt`:STRING,`file`:STRING>,`sectionStyle`:struct<`backgroundColor`:STRING,`backgroundStyle`:STRING,`contentBackground`:STRING>,`heroImages`:array>,`displayStyle`:STRING,`color`:STRING,`numCols`:STRING,`mobileBehavior`:STRING,`backgroundColor`:STRING,`numItems`:STRING,`whitespace`:STRING>>>,`id`:STRING,`styles`:STRING>>,`childPageIds`array,`__v`STRING,`children`array,`metadata`struct<`metaTags`:array>,`noIndex`:STRING,`type`:STRING,`customUrl`:STRING,`description`:STRING,`slug`:STRING,`title`:STRING,`titlePostfix`:STRING,`canonical`:STRING,`linkOut`:STRING,`syncOGTags`:STRING,`internalPageName`:STRING>,`_id`struct<`_oid`:STRING>,`facilityId`STRING,`siteId`struct<`_oid`:STRING>,`alternativeLocales`array>,`typeId`struct<`_oid`:STRING>,`customBreadcrumb`STRING,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-01/1643776091'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pages"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-01/1643776091
    • id: 380344
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": {
        "_oid": "61852d71ae55040385a0e43d"
    },
    "boilerplate": false,
    "childPageIds": [],
    "companyId": "eedbd6b8-09ec-4263-b3ee-babd90fd3d9e",
    "createdAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "disableEnUsPage": false,
    "facilityId": "0a06cbd5-bff6-4fcb-a972-92a0520cd5bd",
    "layout": {
        "_oid": "59d508d746916614683a560f"
    },
    "live": true,
    "locale": "en-us",
    "metadata": {
        "canonical": null,
        "customUrl": true,
        "description": "Download the East Wenatchee Mini Storage app from Google Play or the App Store.",
        "internalPageName": "Download our app",
        "linkOut": null,
        "metaTags": [
            {
                "content": "Misc Page",
                "property": "og:title"
            }
        ],
        "noIndex": null,
        "slug": "app",
        "syncOGTags": null,
        "title": "Dowload Our App",
        "titlePostfix": "East Wenatchee Mini Storage",
        "type": "voyager/pages/types/MISC_PAGE"
    },
    "publishedVersion": {
        "createdAt": "2021-12-23T18:13:38.910Z",
        "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
        "sections": [
            {
                "data": null,
                "id": "4f382a70-ba2a-44b7-87eb-54ea6ed8382d",
                "payload": null,
                "type": "FacilityUnits",
                "widgets": [
                    {
                        "componentId": "88f72d83-138f-4e1f-b441-a73afbb18076",
                        "id": "ccba9201-87e4-4cbd-8c8f-42da1c02860d",
                        "payload": {
                            "align": "text-center",
                            "autoplay": true,
                            "bannerText": "24 Hour Access!",
                            "border": false,
                            "center": {
                                "latitude": 34.04152087796438,
                                "longitude": -117.81910649206543
                            },
                            "code": "",
                            "color": "#FFFFFF",
                            "columnHeadings": {
                                "price": "Price",
                                "size": "Size",
                                "unitDetails": "Unit Details"
                            },
                            "content": "https://www.google.com/maps/d/embed?mid=1ujI46Oe_W4jip1wjaHjOrwzK0Kbr4zCr&ehbc=2E312F",
                            "contentType": "iframe",
                            "currentOption": "amenities",
                            "errorCreatingLeadSource": "",
                            "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                            "featuredImage": "",
                            "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                            "height": "315",
                            "href": "http://placehold.it/150x150",
                            "icon": "icon icon-month-to-month-lease",
                            "images": [
                                {
                                    "mediumId": "61d8814f7c9753064e4b6227"
                                }
                            ],
                            "mediumId": "",
                            "otherImages": [
                                {
                                    "alt": "Small storage units",
                                    "file": "/img/grid-1.jpg",
                                    "filename": "/img/grid-1.jpg",
                                    "link": "",
                                    "mediumId": "61853cb14cc07a064126c913",
                                    "target": "_self",
                                    "title": ""
                                }
                            ],
                            "popupBodyContent": {
                                "blocks": [
                                    {
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 16,
                                                "offset": 163
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 16,
                                                "offset": 163,
                                                "style": "UNDERLINE"
                                            }
                                        ],
                                        "key": "dl71j",
                                        "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                        "type": "unstyled"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "http://www.papaswalk.ca/",
                                            "target": "_blank",
                                            "url": "http://www.papaswalk.ca/"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "popupButtonText": "Submit",
                            "popupHeaderText": "Opening Soon",
                            "popupImageAltText": "",
                            "popupImageTitleText": "",
                            "popupIncludeForm": true,
                            "rawContentState": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 20,
                                                "offset": 0
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 26,
                                                "offset": 0,
                                                "style": "FONT_SIZE:30"
                                            }
                                        ],
                                        "key": "db2mm",
                                        "text": "Contact Us",
                                        "type": "header-one"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                            "target": "_blank"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    },
                                    "1": {
                                        "data": {
                                            "href": "tel:2692562853"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "script": "",
                            "scrollbars": false,
                            "settingsLeadSource": "Inquiry",
                            "settingsMobile": true,
                            "settingsNewLeadSource": "",
                            "settingsTimer": "1",
                            "settingsTrigger": "time",
                            "showBanner": false,
                            "showColorField": true,
                            "target": "_self",
                            "thankYouBodyContent": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [],
                                        "inlineStyleRanges": [],
                                        "key": "dl71j",
                                        "text": "We look forward to helping you with all your storage needs. ",
                                        "type": "unstyled"
                                    }
                                ]
                            },
                            "thankYouButtonText": "Close",
                            "thankYouHeaderText": "Thank You!",
                            "zoom": 14
                        },
                        "type": "FacilityUnitsOne"
                    }
                ]
            }
        ],
        "styles": null
    },
    "siblings": [],
    "siteId": {
        "_oid": "617c0ec7a56b2e03693b24b8"
    },
    "typeId": {
        "_oid": "5e39775169acaf00442dc85d"
    },
    "updatedAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "versions": [
        {
            "createdAt": "2021-11-05T13:11:13.526Z",
            "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
            "sections": [
                {
                    "data": null,
                    "id": "4ffe27ed-a381-4736-81ea-503e170b4169",
                    "payload": null,
                    "type": "BigMap",
                    "widgets": [
                        {
                            "componentId": "01fd4e92-d4b7-437c-9700-2de6cb6dd2d8",
                            "id": "8764d901-d960-4f28-9218-69b9b89ca0cc",
                            "payload": {
                                "align": "text-center",
                                "autoplay": true,
                                "bannerText": "24 Hour Access!",
                                "border": false,
                                "center": {
                                    "latitude": 34.04152087796438,
                                    "longitude": -117.81910649206543
                                },
                                "code": "",
                                "color": "#FFFFFF",
                                "content": "https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3242.489480199412!2d-106.01642174950301!3d35.64031018010675!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x87185a4ba999b99b%3A0xf84207634b878df6!2sSentry%20Self-Storage!5e0!3m2!1sen!2sus!4v1636121760223!5m2!1sen!2sus",
                                "contentType": "iframe",
                                "currentOption": "amenities",
                                "errorCreatingLeadSource": "",
                                "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                                "featuredImage": "",
                                "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                                "height": "315",
                                "href": "http://placehold.it/150x150",
                                "icon": "icon icon-month-to-month-lease",
                                "images": [
                                    {
                                        "mediumId": "61d8814f7c9753064e4b6227"
                                    }
                                ],
                                "mediumId": "",
                                "otherImages": [
                                    {
                                        "alt": "Small storage units",
                                        "file": "/img/grid-1.jpg",
                                        "filename": "/img/grid-1.jpg",
                                        "link": "",
                                        "mediumId": "61853cb14cc07a064126c913",
                                        "target": "_self",
                                        "title": ""
                                    }
                                ],
                                "popupBodyContent": {
                                    "blocks": [
                                        {
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 16,
                                                    "offset": 163
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 16,
                                                    "offset": 163,
                                                    "style": "UNDERLINE"
                                                }
                                            ],
                                            "key": "dl71j",
                                            "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                            "type": "unstyled"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "http://www.papaswalk.ca/",
                                                "target": "_blank",
                                                "url": "http://www.papaswalk.ca/"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "popupButtonText": "Submit",
                                "popupHeaderText": "Opening Soon",
                                "popupImageAltText": "",
                                "popupImageTitleText": "",
                                "popupIncludeForm": true,
                                "rawContentState": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 20,
                                                    "offset": 0
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 26,
                                                    "offset": 0,
                                                    "style": "FONT_SIZE:30"
                                                }
                                            ],
                                            "key": "db2mm",
                                            "text": "Contact Us",
                                            "type": "header-one"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                                "target": "_blank"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        },
                                        "1": {
                                            "data": {
                                                "href": "tel:2692562853"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "script": "",
                                "scrollbars": false,
                                "settingsLeadSource": "Inquiry",
                                "settingsMobile": true,
                                "settingsNewLeadSource": "",
                                "settingsTimer": "1",
                                "settingsTrigger": "time",
                                "showBanner": false,
                                "showColorField": true,
                                "target": "_self",
                                "thankYouBodyContent": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [],
                                            "inlineStyleRanges": [],
                                            "key": "dl71j",
                                            "text": "We look forward to helping you with all your storage needs. ",
                                            "type": "unstyled"
                                        }
                                    ]
                                },
                                "thankYouButtonText": "Close",
                                "thankYouHeaderText": "Thank You!",
                                "zoom": 14
                            },
                            "type": "EmbedContent"
                        }
                    ]
                }
            ],
            "styles": null
        }
    ]
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id._oid": "string",
    "alternativeLocales": [
        {
            "id": "string",
            "locale": "string"
        }
    ],
    "boilerplate": "string",
    "childPageIds": [
        "string"
    ],
    "children": [
        "string"
    ],
    "companyId": "string",
    "createdAt._date": "string",
    "customBreadcrumb": "string",
    "customBreadcrumbs": [
        {
            "prettyName": "string",
            "slug": "string"
        }
    ],
    "disableEnUsPage": "string",
    "facilityId": "string",
    "layout._oid": "string",
    "live": "string",
    "locale": "string",
    "metadata.canonical": "string",
    "metadata.customUrl": "string",
    "metadata.description": "string",
    "metadata.internalPageName": "string",
    "metadata.linkOut": "string",
    "metadata.metaTags": [
        {
            "content": "string",
            "property": "string"
        }
    ],
    "metadata.noIndex": "string",
    "metadata.slug": "string",
    "metadata.syncOGTags": "string",
    "metadata.title": "string",
    "metadata.titlePostfix": "string",
    "metadata.type": "string",
    "parent._oid": "string",
    "siblings": [
        "string"
    ],
    "siteId._oid": "string",
    "typeId._oid": "string",
    "updatedAt._date": "string"
}
    • schema_name_id: 819
    • schema_scan_id: 3676437
    • updated: 2022-02-01 22:33:15
    • created: 2022-01-31 22:33:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pages`\n(\n`locale`STRING,`companyId`STRING,`parent`struct<`_oid`:STRING>,`live`STRING,`siblings`array,`customBreadcrumbs`array>,`disableEnUsPage`STRING,`createdAt`struct<`_date`:STRING>,`layout`struct<`_oid`:STRING>,`publishedVersion`struct<`styles`:STRING,`tag`:STRING,`sections`:array>,`entityRanges`:array>,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`leadSource`:STRING,`leadType`:STRING,`disableMobile`:STRING,`popUpTimer`:STRING,`popUpTrigger`:STRING,`thankYouButtonText`:STRING,`thankYouBodyText`:STRING,`thankYouHeaderText`:STRING,`bodyButtonText`:STRING,`includeFormFields`:STRING,`popUpBodyText`:STRING,`popUpHeaderText`:STRING,`customLeadText`:STRING,`featuredImage`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`thankYouBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`43uts`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`dl7jv`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`1rua6`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`fa6qn`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`2pjb2`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`5em44`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:STRING,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`43uts`:STRING,`dl7jv`:STRING,`1rua6`:STRING,`fa6qn`:STRING,`2pjb2`:STRING,`5em44`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`2pjb2`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`center`:struct<`longitude`:STRING,`latitude`:STRING>,`popupHeaderText`:STRING,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`href`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>>>,`id`:STRING,`payload`:STRING,`data`:STRING>>,`id`:STRING,`createdAt`:STRING>,`versions`array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`src`:STRING,`alt`:STRING,`href`:STRING,`key`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`href`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING>>>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`dl7jv`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`dl7jv`:STRING,`1rua6`:STRING,`5em44`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:STRING,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`dl7jv`:array>>>,`1rua6`:array>>>,`5em44`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`center`:struct<`latitude`:STRING,`longitude`:STRING>,`featuredImage`:STRING,`popupHeaderText`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`thankYouHeaderText`:STRING,`thankYouBodyContent`:struct<`blocks`:array,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`thankYouButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>,`id`:STRING>>,`id`:STRING,`data`:STRING,`payload`:struct<`heroImage`:struct<`alt`:STRING,`file`:STRING>,`sectionStyle`:struct<`backgroundColor`:STRING,`backgroundStyle`:STRING,`contentBackground`:STRING>,`heroImages`:array>,`displayStyle`:STRING,`color`:STRING,`numCols`:STRING,`mobileBehavior`:STRING,`backgroundColor`:STRING,`numItems`:STRING,`whitespace`:STRING>>>,`id`:STRING,`styles`:STRING>>,`childPageIds`array,`children`array,`__v`STRING,`metadata`struct<`noIndex`:STRING,`type`:STRING,`linkOut`:STRING,`customUrl`:STRING,`description`:STRING,`slug`:STRING,`title`:STRING,`titlePostfix`:STRING,`canonical`:STRING,`metaTags`:array>,`syncOGTags`:STRING,`internalPageName`:STRING>,`_id`struct<`_oid`:STRING>,`facilityId`STRING,`siteId`struct<`_oid`:STRING>,`alternativeLocales`array>,`typeId`struct<`_oid`:STRING>,`customBreadcrumb`STRING,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-01-31/1643689735'\n",
    "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pages"
]
    • hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-01-31/1643689735
    • id: 380177
    • processed: 1
    • raw_data: 
      {
    "__v": 0,
    "_id": {
        "_oid": "61852d71ae55040385a0e43d"
    },
    "boilerplate": false,
    "childPageIds": [],
    "companyId": "eedbd6b8-09ec-4263-b3ee-babd90fd3d9e",
    "createdAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "disableEnUsPage": false,
    "facilityId": "0a06cbd5-bff6-4fcb-a972-92a0520cd5bd",
    "layout": {
        "_oid": "59d508d746916614683a560f"
    },
    "live": true,
    "locale": "en-us",
    "metadata": {
        "canonical": null,
        "customUrl": true,
        "description": "Download the East Wenatchee Mini Storage app from Google Play or the App Store.",
        "internalPageName": "Download our app",
        "linkOut": null,
        "metaTags": [
            {
                "content": "Misc Page",
                "property": "og:title"
            }
        ],
        "noIndex": null,
        "slug": "app",
        "syncOGTags": null,
        "title": "Dowload Our App",
        "titlePostfix": "East Wenatchee Mini Storage",
        "type": "voyager/pages/types/MISC_PAGE"
    },
    "publishedVersion": {
        "createdAt": "2021-12-23T18:13:38.910Z",
        "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
        "sections": [
            {
                "data": null,
                "id": "4f382a70-ba2a-44b7-87eb-54ea6ed8382d",
                "payload": null,
                "type": "FacilityUnits",
                "widgets": [
                    {
                        "componentId": "88f72d83-138f-4e1f-b441-a73afbb18076",
                        "id": "ccba9201-87e4-4cbd-8c8f-42da1c02860d",
                        "payload": {
                            "align": "text-center",
                            "autoplay": true,
                            "bannerText": "24 Hour Access!",
                            "border": false,
                            "center": {
                                "latitude": 34.04152087796438,
                                "longitude": -117.81910649206543
                            },
                            "code": "",
                            "color": "#FFFFFF",
                            "columnHeadings": {
                                "price": "Price",
                                "size": "Size",
                                "unitDetails": "Unit Details"
                            },
                            "content": "https://www.google.com/maps/d/embed?mid=1ujI46Oe_W4jip1wjaHjOrwzK0Kbr4zCr&ehbc=2E312F",
                            "contentType": "iframe",
                            "currentOption": "amenities",
                            "errorCreatingLeadSource": "",
                            "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                            "featuredImage": "",
                            "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                            "height": "315",
                            "href": "http://placehold.it/150x150",
                            "icon": "icon icon-month-to-month-lease",
                            "images": [
                                {
                                    "mediumId": "61d8814f7c9753064e4b6227"
                                }
                            ],
                            "mediumId": "",
                            "otherImages": [
                                {
                                    "alt": "Small storage units",
                                    "file": "/img/grid-1.jpg",
                                    "filename": "/img/grid-1.jpg",
                                    "link": "",
                                    "mediumId": "61853cb14cc07a064126c913",
                                    "target": "_self",
                                    "title": ""
                                }
                            ],
                            "popupBodyContent": {
                                "blocks": [
                                    {
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 16,
                                                "offset": 163
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 16,
                                                "offset": 163,
                                                "style": "UNDERLINE"
                                            }
                                        ],
                                        "key": "dl71j",
                                        "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                        "type": "unstyled"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "http://www.papaswalk.ca/",
                                            "target": "_blank",
                                            "url": "http://www.papaswalk.ca/"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "popupButtonText": "Submit",
                            "popupHeaderText": "Opening Soon",
                            "popupImageAltText": "",
                            "popupImageTitleText": "",
                            "popupIncludeForm": true,
                            "rawContentState": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [
                                            {
                                                "key": 0,
                                                "length": 20,
                                                "offset": 0
                                            }
                                        ],
                                        "inlineStyleRanges": [
                                            {
                                                "length": 26,
                                                "offset": 0,
                                                "style": "FONT_SIZE:30"
                                            }
                                        ],
                                        "key": "db2mm",
                                        "text": "Contact Us",
                                        "type": "header-one"
                                    }
                                ],
                                "entityMap": {
                                    "0": {
                                        "data": {
                                            "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                            "target": "_blank"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    },
                                    "1": {
                                        "data": {
                                            "href": "tel:2692562853"
                                        },
                                        "mutability": "MUTABLE",
                                        "type": "LINK"
                                    }
                                }
                            },
                            "script": "",
                            "scrollbars": false,
                            "settingsLeadSource": "Inquiry",
                            "settingsMobile": true,
                            "settingsNewLeadSource": "",
                            "settingsTimer": "1",
                            "settingsTrigger": "time",
                            "showBanner": false,
                            "showColorField": true,
                            "target": "_self",
                            "thankYouBodyContent": {
                                "blocks": [
                                    {
                                        "data": {
                                            "align": "center"
                                        },
                                        "depth": 0,
                                        "entityRanges": [],
                                        "inlineStyleRanges": [],
                                        "key": "dl71j",
                                        "text": "We look forward to helping you with all your storage needs. ",
                                        "type": "unstyled"
                                    }
                                ]
                            },
                            "thankYouButtonText": "Close",
                            "thankYouHeaderText": "Thank You!",
                            "zoom": 14
                        },
                        "type": "FacilityUnitsOne"
                    }
                ]
            }
        ],
        "styles": null
    },
    "siblings": [],
    "siteId": {
        "_oid": "617c0ec7a56b2e03693b24b8"
    },
    "typeId": {
        "_oid": "5e39775169acaf00442dc85d"
    },
    "updatedAt": {
        "_date": "2021-11-05T17:18:24.788Z"
    },
    "versions": [
        {
            "createdAt": "2021-11-05T13:11:13.526Z",
            "id": "b5d453a7-85ff-4cdb-b110-f51d8cacbce8",
            "sections": [
                {
                    "data": null,
                    "id": "4ffe27ed-a381-4736-81ea-503e170b4169",
                    "payload": null,
                    "type": "BigMap",
                    "widgets": [
                        {
                            "componentId": "01fd4e92-d4b7-437c-9700-2de6cb6dd2d8",
                            "id": "8764d901-d960-4f28-9218-69b9b89ca0cc",
                            "payload": {
                                "align": "text-center",
                                "autoplay": true,
                                "bannerText": "24 Hour Access!",
                                "border": false,
                                "center": {
                                    "latitude": 34.04152087796438,
                                    "longitude": -117.81910649206543
                                },
                                "code": "",
                                "color": "#FFFFFF",
                                "content": "https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3242.489480199412!2d-106.01642174950301!3d35.64031018010675!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x87185a4ba999b99b%3A0xf84207634b878df6!2sSentry%20Self-Storage!5e0!3m2!1sen!2sus!4v1636121760223!5m2!1sen!2sus",
                                "contentType": "iframe",
                                "currentOption": "amenities",
                                "errorCreatingLeadSource": "",
                                "facilityId": "313015ba-5155-4317-92ce-44226ad8c2b5",
                                "featuredImage": "",
                                "googlePlaceId": "ChIJHTfA2CTnmIARIVr7mit5cC4",
                                "height": "315",
                                "href": "http://placehold.it/150x150",
                                "icon": "icon icon-month-to-month-lease",
                                "images": [
                                    {
                                        "mediumId": "61d8814f7c9753064e4b6227"
                                    }
                                ],
                                "mediumId": "",
                                "otherImages": [
                                    {
                                        "alt": "Small storage units",
                                        "file": "/img/grid-1.jpg",
                                        "filename": "/img/grid-1.jpg",
                                        "link": "",
                                        "mediumId": "61853cb14cc07a064126c913",
                                        "target": "_self",
                                        "title": ""
                                    }
                                ],
                                "popupBodyContent": {
                                    "blocks": [
                                        {
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 16,
                                                    "offset": 163
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 16,
                                                    "offset": 163,
                                                    "style": "UNDERLINE"
                                                }
                                            ],
                                            "key": "dl71j",
                                            "text": "  Storage Towne of America  Germantown Located on the North West side of Hacks Cross and Players Club Parkway",
                                            "type": "unstyled"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "http://www.papaswalk.ca/",
                                                "target": "_blank",
                                                "url": "http://www.papaswalk.ca/"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "popupButtonText": "Submit",
                                "popupHeaderText": "Opening Soon",
                                "popupImageAltText": "",
                                "popupImageTitleText": "",
                                "popupIncludeForm": true,
                                "rawContentState": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [
                                                {
                                                    "key": 0,
                                                    "length": 20,
                                                    "offset": 0
                                                }
                                            ],
                                            "inlineStyleRanges": [
                                                {
                                                    "length": 26,
                                                    "offset": 0,
                                                    "style": "FONT_SIZE:30"
                                                }
                                            ],
                                            "key": "db2mm",
                                            "text": "Contact Us",
                                            "type": "header-one"
                                        }
                                    ],
                                    "entityMap": {
                                        "0": {
                                            "data": {
                                                "href": "https://www.google.com/maps/place/Boxer+Storage/@42.4722023,-85.7479086,17z/data=!4m13!1m7!3m6!1s0x8819d7dffa70ccc5:0x6b58213d3a7f3d85!2s714+Lincoln+Rd,+Otsego,+MI+49078!3b1!8m2!3d42.4722023!4d-85.7457199!3m4!1s0x8819d78c8069d3d7:0x7c8cfa23cdb04a99!8m2!3d42.4726222!4d-85.745534",
                                                "target": "_blank"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        },
                                        "1": {
                                            "data": {
                                                "href": "tel:2692562853"
                                            },
                                            "mutability": "MUTABLE",
                                            "type": "LINK"
                                        }
                                    }
                                },
                                "script": "",
                                "scrollbars": false,
                                "settingsLeadSource": "Inquiry",
                                "settingsMobile": true,
                                "settingsNewLeadSource": "",
                                "settingsTimer": "1",
                                "settingsTrigger": "time",
                                "showBanner": false,
                                "showColorField": true,
                                "target": "_self",
                                "thankYouBodyContent": {
                                    "blocks": [
                                        {
                                            "data": {
                                                "align": "center"
                                            },
                                            "depth": 0,
                                            "entityRanges": [],
                                            "inlineStyleRanges": [],
                                            "key": "dl71j",
                                            "text": "We look forward to helping you with all your storage needs. ",
                                            "type": "unstyled"
                                        }
                                    ]
                                },
                                "thankYouButtonText": "Close",
                                "thankYouHeaderText": "Thank You!",
                                "zoom": 14
                            },
                            "type": "EmbedContent"
                        }
                    ]
                }
            ],
            "styles": null
        }
    ]
}
    • schema_attributes: 
      {
    "__v": "string",
    "_id._oid": "string",
    "alternativeLocales": [
        {
            "id": "string",
            "locale": "string"
        }
    ],
    "boilerplate": "string",
    "childPageIds": [
        "string"
    ],
    "children": [
        "string"
    ],
    "companyId": "string",
    "createdAt._date": "string",
    "customBreadcrumb": "string",
    "customBreadcrumbs": [
        {
            "prettyName": "string",
            "slug": "string"
        }
    ],
    "disableEnUsPage": "string",
    "facilityId": "string",
    "layout._oid": "string",
    "live": "string",
    "locale": "string",
    "metadata.canonical": "string",
    "metadata.customUrl": "string",
    "metadata.description": "string",
    "metadata.internalPageName": "string",
    "metadata.linkOut": "string",
    "metadata.metaTags": [
        {
            "content": "string",
            "property": "string"
        }
    ],
    "metadata.noIndex": "string",
    "metadata.slug": "string",
    "metadata.syncOGTags": "string",
    "metadata.title": "string",
    "metadata.titlePostfix": "string",
    "metadata.type": "string",
    "parent._oid": "string",
    "siblings": [
        "string"
    ],
    "siteId._oid": "string",
    "typeId._oid": "string",
    "updatedAt._date": "string"
}
    • schema_name_id: 819
    • schema_scan_id: 3674863
    • updated: 2022-01-31 22:33:49
Schema Scans: 3
Last at 2022-02-02 22:29:18
    • duration: 0:04:45.435668
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3678043
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-02/1643862522",
        "key": "raw/voyager_pages/2022-02-02/1643862522/pages_7.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_pages",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 9385986858812759691,
        "service_name": "preloading",
        "span_id": 6453269635181770504,
        "trace_id": 15473495614570736574
    }
}
    • running: False
    • schema_name_id: 819
    • start_time: 2022-02-02 22:29:18
    • success: True
    • trace_id: 15473495614570736574
    • duration: 0:04:45.647642
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3676437
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-01/1643776091",
        "key": "raw/voyager_pages/2022-02-01/1643776091/pages_7.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_pages",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 12339242996419304806,
        "service_name": "preloading",
        "span_id": 15321519688694093918,
        "trace_id": 10644481336303180200
    }
}
    • running: False
    • schema_name_id: 819
    • start_time: 2022-02-01 22:28:32
    • success: True
    • trace_id: 10644481336303180200
    • duration: 0:04:46.500541
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 3674863
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-stage",
        "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-01-31/1643689735",
        "key": "raw/voyager_pages/2022-01-31/1643689735/pages_7.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_mongo.storedge_voyager_pages",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 16460628105574013832,
        "service_name": "preloading",
        "span_id": 12524466881368769188,
        "trace_id": 6206555519537656175
    }
}
    • running: False
    • schema_name_id: 819
    • start_time: 2022-01-31 22:29:05
    • success: True
    • trace_id: 6206555519537656175
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "__v": "string",
    "_id._oid": "string",
    "alternativeLocales": [
        {
            "id": "string",
            "locale": "string"
        }
    ],
    "boilerplate": "string",
    "childPageIds": [
        "string"
    ],
    "children": [
        "string"
    ],
    "companyId": "string",
    "createdAt._date": "string",
    "customBreadcrumb": "string",
    "customBreadcrumbs": [
        {
            "prettyName": "string",
            "slug": "string"
        }
    ],
    "disableEnUsPage": "string",
    "facilityId": "string",
    "layout._oid": "string",
    "live": "string",
    "locale": "string",
    "metadata.canonical": "string",
    "metadata.customUrl": "string",
    "metadata.description": "string",
    "metadata.internalPageName": "string",
    "metadata.linkOut": "string",
    "metadata.metaTags": [
        {
            "content": "string",
            "property": "string"
        }
    ],
    "metadata.noIndex": "string",
    "metadata.slug": "string",
    "metadata.syncOGTags": "string",
    "metadata.title": "string",
    "metadata.titlePostfix": "string",
    "metadata.type": "string",
    "parent._oid": "string",
    "siblings": [
        "string"
    ],
    "siteId._oid": "string",
    "typeId._oid": "string",
    "updatedAt._date": "string"
}
  • created: 2022-02-02 22:33:49
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pages`\n(\n`locale`STRING,`companyId`STRING,`parent`struct<`_oid`:STRING>,`live`STRING,`siblings`array,`customBreadcrumbs`array>,`disableEnUsPage`STRING,`createdAt`struct<`_date`:STRING>,`layout`struct<`_oid`:STRING>,`publishedVersion`struct<`styles`:STRING,`tag`:STRING,`sections`:array>,`entityRanges`:array>,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`leadSource`:STRING,`leadType`:STRING,`disableMobile`:STRING,`popUpTimer`:STRING,`popUpTrigger`:STRING,`thankYouButtonText`:STRING,`thankYouBodyText`:STRING,`thankYouHeaderText`:STRING,`bodyButtonText`:STRING,`includeFormFields`:STRING,`popUpBodyText`:STRING,`popUpHeaderText`:STRING,`customLeadText`:STRING,`featuredImage`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`thankYouBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`43uts`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`dl7jv`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`1rua6`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`fa6qn`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`2pjb2`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`5em44`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:STRING,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`43uts`:STRING,`dl7jv`:STRING,`1rua6`:STRING,`fa6qn`:STRING,`2pjb2`:STRING,`5em44`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`2pjb2`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`center`:struct<`longitude`:STRING,`latitude`:STRING>,`popupHeaderText`:STRING,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`href`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>>>,`id`:STRING,`payload`:STRING,`data`:STRING>>,`id`:STRING,`createdAt`:STRING>,`versions`array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`src`:STRING,`alt`:STRING,`href`:STRING,`key`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`href`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING>>>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`dl7jv`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`dl7jv`:STRING,`1rua6`:STRING,`5em44`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:STRING,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`dl7jv`:array>>>,`1rua6`:array>>>,`5em44`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`center`:struct<`latitude`:STRING,`longitude`:STRING>,`featuredImage`:STRING,`popupHeaderText`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`thankYouHeaderText`:STRING,`thankYouBodyContent`:struct<`blocks`:array,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`thankYouButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>,`id`:STRING>>,`id`:STRING,`data`:STRING,`payload`:struct<`heroImage`:struct<`alt`:STRING,`file`:STRING>,`sectionStyle`:struct<`backgroundColor`:STRING,`backgroundStyle`:STRING,`contentBackground`:STRING>,`heroImages`:array>,`displayStyle`:STRING,`color`:STRING,`numCols`:STRING,`mobileBehavior`:STRING,`backgroundColor`:STRING,`numItems`:STRING,`whitespace`:STRING>>>,`id`:STRING,`styles`:STRING>>,`childPageIds`array,`children`array,`__v`STRING,`metadata`struct<`noIndex`:STRING,`type`:STRING,`linkOut`:STRING,`customUrl`:STRING,`description`:STRING,`slug`:STRING,`title`:STRING,`titlePostfix`:STRING,`canonical`:STRING,`metaTags`:array>,`syncOGTags`:STRING,`internalPageName`:STRING>,`_id`struct<`_oid`:STRING>,`facilityId`STRING,`siteId`struct<`_oid`:STRING>,`alternativeLocales`array>,`typeId`struct<`_oid`:STRING>,`customBreadcrumb`STRING,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-02/1643862522'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pages`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pages"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2019-04-05 13:49:00",
        "disabled": false,
        "format": "raw",
        "id": 819,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_mongo",
            "table": "storedge_voyager_pages"
        },
        "type": "mongo"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "__v": "string",
            "_id._oid": "string",
            "alternativeLocales": [
                {
                    "id": "string",
                    "locale": "string"
                }
            ],
            "boilerplate": "string",
            "childPageIds": [
                "string"
            ],
            "children": [
                "string"
            ],
            "companyId": "string",
            "createdAt._date": "string",
            "customBreadcrumb": "string",
            "customBreadcrumbs": [
                {
                    "prettyName": "string",
                    "slug": "string"
                }
            ],
            "disableEnUsPage": "string",
            "facilityId": "string",
            "layout._oid": "string",
            "live": "string",
            "locale": "string",
            "metadata.canonical": "string",
            "metadata.customUrl": "string",
            "metadata.description": "string",
            "metadata.internalPageName": "string",
            "metadata.linkOut": "string",
            "metadata.metaTags": [
                {
                    "content": "string",
                    "property": "string"
                }
            ],
            "metadata.noIndex": "string",
            "metadata.slug": "string",
            "metadata.syncOGTags": "string",
            "metadata.title": "string",
            "metadata.titlePostfix": "string",
            "metadata.type": "string",
            "parent._oid": "string",
            "siblings": [
                "string"
            ],
            "siteId._oid": "string",
            "typeId._oid": "string",
            "updatedAt._date": "string"
        },
        "created": "2022-02-02 22:33:49",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pages`\n(\n`locale`STRING,`companyId`STRING,`parent`struct<`_oid`:STRING>,`live`STRING,`siblings`array,`customBreadcrumbs`array>,`disableEnUsPage`STRING,`createdAt`struct<`_date`:STRING>,`layout`struct<`_oid`:STRING>,`publishedVersion`struct<`styles`:STRING,`tag`:STRING,`sections`:array>,`entityRanges`:array>,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING>,`mutability`:STRING,`type`:STRING>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`leadSource`:STRING,`leadType`:STRING,`disableMobile`:STRING,`popUpTimer`:STRING,`popUpTrigger`:STRING,`thankYouButtonText`:STRING,`thankYouBodyText`:STRING,`thankYouHeaderText`:STRING,`bodyButtonText`:STRING,`includeFormFields`:STRING,`popUpBodyText`:STRING,`popUpHeaderText`:STRING,`customLeadText`:STRING,`featuredImage`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`thankYouBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`_empty_`:STRING>>>,`entityMap`:struct<`_empty_`:STRING>>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`43uts`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`dl7jv`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`1rua6`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`fa6qn`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`2pjb2`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>,`5em44`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:STRING,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`43uts`:STRING,`dl7jv`:STRING,`1rua6`:STRING,`fa6qn`:STRING,`2pjb2`:STRING,`5em44`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`43uts`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`dl7jv`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`1rua6`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`fa6qn`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`2pjb2`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>,`5em44`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`center`:struct<`longitude`:STRING,`latitude`:STRING>,`popupHeaderText`:STRING,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`href`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>>>,`id`:STRING,`payload`:STRING,`data`:STRING>>,`id`:STRING,`createdAt`:STRING>,`versions`array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`src`:STRING,`alt`:STRING,`href`:STRING,`key`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`href`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING>>>>,`facilityId`:STRING,`otherImages`:array>,`autoplay`:STRING,`bannerText`:STRING,`showBanner`:STRING,`rawContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING>>>>,`image`:struct<`file`:STRING,`alt`:STRING>,`columnHeadings`:struct<`size`:STRING,`unitDetails`:STRING,`price`:STRING,`specials`:STRING>,`images`:array>,`zoom`:STRING,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`dl7jv`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`dl7jv`:STRING,`1rua6`:STRING,`5em44`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:STRING,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`dl7jv`:array>>>,`1rua6`:array>>>,`5em44`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>,`1rua6`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>,`5em44`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`center`:struct<`latitude`:STRING,`longitude`:STRING>,`featuredImage`:STRING,`popupHeaderText`:STRING,`popupBodyContent`:struct<`blocks`:array>,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`popupIncludeForm`:STRING,`popupButtonText`:STRING,`thankYouHeaderText`:STRING,`thankYouBodyContent`:struct<`blocks`:array,`entityRanges`:array,`data`:struct<`align`:STRING>>>>,`thankYouButtonText`:STRING,`settingsTrigger`:STRING,`settingsTimer`:STRING,`settingsMobile`:STRING,`settingsLeadSource`:STRING,`errorCreatingLeadSource`:STRING,`settingsNewLeadSource`:STRING,`content`:STRING,`code`:STRING,`script`:STRING,`border`:STRING,`height`:STRING,`contentType`:STRING,`scrollbars`:STRING,`selectedPromos`:array>,`hideFromWebsite`:STRING,`name`:STRING,`priority`:STRING,`promotionType`:STRING,`turnedOn`:STRING,`startDate`:STRING,`endDate`:STRING>>,`fontColor`:STRING,`bgColor`:STRING,`displayStyle`:STRING,`color`:STRING,`icon`:STRING,`align`:STRING,`target`:STRING,`currentOption`:STRING,`showColorField`:STRING>,`id`:STRING>>,`id`:STRING,`data`:STRING,`payload`:struct<`heroImage`:struct<`alt`:STRING,`file`:STRING>,`sectionStyle`:struct<`backgroundColor`:STRING,`backgroundStyle`:STRING,`contentBackground`:STRING>,`heroImages`:array>,`displayStyle`:STRING,`color`:STRING,`numCols`:STRING,`mobileBehavior`:STRING,`backgroundColor`:STRING,`numItems`:STRING,`whitespace`:STRING>>>,`id`:STRING,`styles`:STRING>>,`childPageIds`array,`children`array,`__v`STRING,`metadata`struct<`noIndex`:STRING,`type`:STRING,`linkOut`:STRING,`customUrl`:STRING,`description`:STRING,`slug`:STRING,`title`:STRING,`titlePostfix`:STRING,`canonical`:STRING,`metaTags`:array>,`syncOGTags`:STRING,`internalPageName`:STRING>,`_id`struct<`_oid`:STRING>,`facilityId`STRING,`siteId`struct<`_oid`:STRING>,`alternativeLocales`array>,`typeId`struct<`_oid`:STRING>,`customBreadcrumb`STRING,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-stage/raw/voyager_pages/2022-02-02/1643862522'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pages"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform