Schema Info
Schema Name: sfdl_dev_mongo.storedge_voyager_pagelayouts
- created: 2019-03-20 15:41:51
- disabled: False
- format: raw
- id: 1219
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_mongo", "table": "storedge_voyager_pagelayouts" } - type: mongo
Schema Versions: 3
-
Version 4684174
- created: 2020-11-05 17:02:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`", "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_pagelayouts`\n(\n`typeId`struct<`_oid`:STRING>,`versions`array,`id`:STRING,`sections`:array ,`id`:STRING,`widgets`:array ,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:struct<`_date`:STRING>,`updatedAt`:struct<`_date`:STRING>,`styles`:STRING>>,`_id`struct<`_oid`:STRING>,`metadata`struct<`_id`:struct<`_oid`:STRING>,`locale`:STRING,`pageType`:STRING>,`boilerplate`STRING,`updatedAt`struct<`_date`:STRING>,`createdAt`struct<`_date`:STRING>,`localeCode`STRING,`companyId`STRING,`__v`STRING,`live`STRING,`title`STRING,`publishedVersion`struct<`_id`:struct<`_oid`:STRING>,`styles`:STRING,`updatedAt`:struct<`_date`:STRING>,`sections`:array ,`id`:STRING,`widgets`:array ,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:STRING,`id`:STRING,`tag`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-11-05/1604617313'\n", "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_pagelayouts" ] - hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-11-05/1604617313
- id: 4684174
- processed: 1
- raw_data:
{ "__v": 5, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-06-22T22:29:45.968Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5ef14522a2e1130048e47e36" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "b9a49c3b-a5a1-476d-abdb-31e8218adf43", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef983" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef14522a2e1130048e47e37" }, "componentId": "9e2b21be-28fb-46ee-9f40-bc38c004853d", "id": "585bf4db-d38a-4f6f-8a12-2b90d3bc8279", "payload": null, "type": "Navigation" } ] } ], "styles": null, "updatedAt": { "_date": "2020-06-22T22:29:45.967Z" } }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-06-22T22:29:45.968Z" }, "versions": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97b" }, "createdAt": { "_date": "2018-07-10T13:12:50.346Z" }, "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97c" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef14522a2e1130048e47e38" }, "componentId": "9e2b21be-28fb-46ee-9f40-bc38c004853d", "id": "c85c3421-9142-4ab7-8f57-fe977583c395", "payload": null, "type": "Navigation" } ] } ], "styles": null, "updatedAt": { "_date": "2018-07-10T13:12:50.346Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 1219
- schema_scan_id: 5718510
- updated: 2020-11-05 17:02:28
-
Version 4679083
- created: 2020-06-14 12:09:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`", "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_pagelayouts`\n(\n`_id`struct<`_oid`:STRING>,`live`STRING,`metadata`struct<`locale`:STRING,`_id`:struct<`_oid`:STRING>,`pageType`:STRING>,`versions`array>,`entityRanges`:array >,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`href`:STRING,`target`:STRING,`key`:STRING,`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>>>,`text`:STRING,`rawContent`:struct<`blocks`:array ,`entityRanges`:array >,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING,`target`:STRING,`replacement`:STRING>>>>,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`80s8c`: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<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`: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>>,`redoStack`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array >>>>,`undoStack`: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>>>>>,`otherImages`:array >,`href`:STRING,`images`:array >,`target`:STRING>,`id`:STRING,`_id`:struct<`_oid`:STRING>>>,`type`:STRING,`data`:STRING,`payload`:STRING,`_id`:struct<`_oid`:STRING>>>,`createdAt`:STRING,`styles`:STRING,`_id`:struct<`_oid`:STRING>,`updatedAt`:struct<`_date`:STRING>>>,`updatedAt`struct<`_date`:STRING>,`__v`STRING,`localeCode`STRING,`typeId`struct<`_oid`:STRING>,`companyId`STRING,`createdAt`struct<`_date`:STRING>,`publishedVersion`struct<`_id`:struct<`_oid`:STRING>,`createdAt`:STRING,`styles`:STRING,`sections`:array >,`entityRanges`:array >,`data`:struct<`align`:STRING>>>>,`rawContent`:struct<`blocks`:array >,`inlineStyleRanges`:array ,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`80s8c`:array >,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array ,`nativelyRenderedContent`: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<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`80s8c`: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<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`href`:STRING,`images`:array >,`target`:STRING>,`type`:STRING,`_id`:struct<`_oid`:STRING>>>,`payload`:STRING,`data`:STRING,`_id`:struct<`_oid`:STRING>>>,`updatedAt`:struct<`_date`:STRING>,`tag`:STRING,`id`:STRING>,`title`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-dev/raw/voyager_pagelayouts/2020-06-14/1592154534'\n", "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_pagelayouts" ] - hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-06-14/1592154534
- id: 4679083
- processed: 1
- raw_data:
{ "__v": 4, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-03-10T14:12:40.742Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5e837d71a8b54f066bb2f600" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "7084800f-dd73-461f-9be6-b888a5fd2ba5", "sections": [ { "_id": { "_oid": "5e837d71a8b54f066bb2f601" }, "data": null, "id": "0e9399ad-b8d6-47de-bd44-6dd2338f4c27", "payload": null, "type": "ChildBlock", "widgets": [ { "_id": { "_oid": "5e8f9c3fdd5fe80643eafd32" }, "id": "8beaa7d6-8dce-4a72-a7f9-b6d3523434f3", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "target": "_self", "title": "SafeSecure Self Storage" } ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "e5tt6", "text": "Call Now: (505) 933-7288 ", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [ { "length": 5, "offset": 0, "style": "FONT_SIZE:30" } ], "key": "6auh3", "text": "Call Now (270) 776-9376", "type": "header-two" } ], "entityMap": {} }, "target": "_self", "text": "(865) 635-4579
\n" }, "type": "HeaderText" } ] } ], "styles": null, "tag": null, "updatedAt": { "_date": "2020-03-31T17:27:18.204Z" } }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-02-11T15:24:45.909Z" }, "versions": [ { "_id": { "_oid": "5e42c73699b50900442ef175" }, "createdAt": "2018-07-10T13:12:50.346Z", "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5e42c73699b50900442ef183" }, "data": null, "id": "d9c50ce0-1404-4a0a-8229-27439bd76c19", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5e42c73699b50900442ef184" }, "id": "5f564fc7-a53e-420b-a6b7-b67d6deb32a2", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "target": "_self", "title": "SafeSecure Self Storage" } ], "otherImages": [ { "alt": "Hoosier Storage Office", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-28-am.png" }, { "alt": "Boxes & Supplies Available at Hoosier Storage in Noblesville, IN", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-40-am.png" }, {}, {} ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [ { "length": 5, "offset": 0, "style": "FONT_SIZE:30" } ], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418", "key": "phone", "target": "_self", "url": "https://www.storage-mart.com/covid-19" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "mailto:[email protected]", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_self", "text": "Call Now: (505) 933-7288
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2020-03-10T14:12:48.762Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 1219
- schema_scan_id: 5627164
- updated: 2020-06-14 12:09:17
-
Version 4679073
- created: 2020-06-13 16:23:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`", "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_pagelayouts`\n(\n`_id`struct<`_oid`:STRING>,`live`STRING,`metadata`struct<`locale`:STRING,`_id`:struct<`_oid`:STRING>,`pageType`:STRING>,`versions`array>,`entityRanges`:array >,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`href`:STRING,`target`:STRING,`key`:STRING,`url`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>>>,`text`:STRING,`rawContent`:struct<`blocks`:array ,`entityRanges`:array >,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING,`target`:STRING,`replacement`:STRING>>>>,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`80s8c`: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<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`: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>>,`redoStack`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array >>>>,`undoStack`: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>>>>>,`otherImages`:array >,`href`:STRING,`images`:array >,`target`:STRING>,`id`:STRING,`_id`:struct<`_oid`:STRING>>>,`type`:STRING,`data`:STRING,`payload`:STRING,`_id`:struct<`_oid`:STRING>>>,`createdAt`:STRING,`styles`:STRING,`_id`:struct<`_oid`:STRING>,`updatedAt`:struct<`_date`:STRING>>>,`updatedAt`struct<`_date`:STRING>,`__v`STRING,`localeCode`STRING,`typeId`struct<`_oid`:STRING>,`companyId`STRING,`createdAt`struct<`_date`:STRING>,`publishedVersion`struct<`createdAt`:STRING,`styles`:STRING,`_id`:struct<`_oid`:STRING>,`sections`:array >,`entityRanges`:array >,`data`:struct<`align`:STRING>>>>,`rawContent`:struct<`blocks`:array >,`inlineStyleRanges`:array ,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`80s8c`:array >,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array ,`nativelyRenderedContent`: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<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`80s8c`: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<`80s8c`:struct<`depth`:STRING,`characterList`:array >>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`href`:STRING,`images`:array >,`target`:STRING>,`type`:STRING,`_id`:struct<`_oid`:STRING>>>,`payload`:STRING,`data`:STRING,`_id`:struct<`_oid`:STRING>>>,`updatedAt`:struct<`_date`:STRING>,`tag`:STRING,`id`:STRING>,`title`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-dev/raw/voyager_pagelayouts/2020-06-13/1592083345'\n", "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_pagelayouts" ] - hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-06-13/1592083345
- id: 4679073
- processed: 1
- raw_data:
{ "__v": 4, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-03-10T14:12:40.742Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5e837d71a8b54f066bb2f600" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "7084800f-dd73-461f-9be6-b888a5fd2ba5", "sections": [ { "_id": { "_oid": "5e837d71a8b54f066bb2f601" }, "data": null, "id": "0e9399ad-b8d6-47de-bd44-6dd2338f4c27", "payload": null, "type": "ChildBlock", "widgets": [ { "_id": { "_oid": "5e8f9c3fdd5fe80643eafd32" }, "id": "8beaa7d6-8dce-4a72-a7f9-b6d3523434f3", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "target": "_self", "title": "SafeSecure Self Storage" } ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "e5tt6", "text": "Call Now: (505) 933-7288 ", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [ { "length": 5, "offset": 0, "style": "FONT_SIZE:30" } ], "key": "6auh3", "text": "Call Now (270) 776-9376", "type": "header-two" } ], "entityMap": {} }, "target": "_self", "text": "(865) 635-4579
\n" }, "type": "HeaderText" } ] } ], "styles": null, "tag": null, "updatedAt": { "_date": "2020-03-31T17:27:18.204Z" } }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-02-11T15:24:45.909Z" }, "versions": [ { "_id": { "_oid": "5e42c73699b50900442ef175" }, "createdAt": "2018-07-10T13:12:50.346Z", "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5e42c73699b50900442ef183" }, "data": null, "id": "d9c50ce0-1404-4a0a-8229-27439bd76c19", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5e42c73699b50900442ef184" }, "id": "5f564fc7-a53e-420b-a6b7-b67d6deb32a2", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "target": "_self", "title": "SafeSecure Self Storage" } ], "otherImages": [ { "alt": "Hoosier Storage Office", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-28-am.png" }, { "alt": "Boxes & Supplies Available at Hoosier Storage in Noblesville, IN", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-40-am.png" }, {}, {} ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [ { "length": 5, "offset": 0, "style": "FONT_SIZE:30" } ], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418", "key": "phone", "target": "_self", "url": "https://www.storage-mart.com/covid-19" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "mailto:[email protected]", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_self", "text": "Call Now: (505) 933-7288
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2020-03-10T14:12:48.762Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 1219
- schema_scan_id: 5627102
- updated: 2020-06-13 16:24:08
Schema Scans: 3
Last at 2020-11-05 17:02:15
-
Scan 5718510
- duration: 0:00:15.075892
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5718510
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-dev", "hive_path": "s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-11-05/1604617313", "key": "raw/voyager_pagelayouts/2020-11-05/1604617313/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_dev_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 18065822242733952003, "service_name": "preloading", "span_id": 8732148713398235735, "trace_id": 6112369120461499106 } } - running: False
- schema_name_id: 1219
- start_time: 2020-11-05 17:02:15
- success: True
- trace_id: 6112369120461499106
-
Scan 5627164
- duration: 0:00:14.674848
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5627164
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-dev", "hive_path": "s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-06-14/1592154534", "key": "raw/voyager_pagelayouts/2020-06-14/1592154534/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_dev_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 13478655319582498773, "service_name": "preloading", "span_id": 7932538357420156273, "trace_id": 1445678987074264860 } } - running: False
- schema_name_id: 1219
- start_time: 2020-06-14 12:09:05
- success: True
- trace_id: 1445678987074264860
-
Scan 5627102
- duration: 0:00:14.498971
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 5627102
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-dev", "hive_path": "s3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-06-13/1592083345", "key": "raw/voyager_pagelayouts/2020-06-13/1592083345/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_dev_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 3363909870986828333, "service_name": "preloading", "span_id": 17218462745319266072, "trace_id": 20763686744671641 } } - running: False
- schema_name_id: 1219
- start_time: 2020-06-13 16:23:56
- success: True
- trace_id: 20763686744671641
- attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - created: 2020-11-05 17:02:17
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_pagelayouts`\n(\n`typeId`struct<`_oid`:STRING>,`versions`array,`id`:STRING,`sections`:array ,`id`:STRING,`widgets`:array ,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:struct<`_date`:STRING>,`updatedAt`:struct<`_date`:STRING>,`styles`:STRING>>,`_id`struct<`_oid`:STRING>,`metadata`struct<`_id`:struct<`_oid`:STRING>,`locale`:STRING,`pageType`:STRING>,`boilerplate`STRING,`updatedAt`struct<`_date`:STRING>,`createdAt`struct<`_date`:STRING>,`localeCode`STRING,`companyId`STRING,`__v`STRING,`live`STRING,`title`STRING,`publishedVersion`struct<`_id`:struct<`_oid`:STRING>,`styles`:STRING,`updatedAt`:struct<`_date`:STRING>,`sections`:array ,`id`:STRING,`widgets`:array ,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:STRING,`id`:STRING,`tag`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-11-05/1604617313'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_pagelayouts`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_pagelayouts" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2019-03-20 15:41:51",
"disabled": false,
"format": "raw",
"id": 1219,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_mongo",
"table": "storedge_voyager_pagelayouts"
},
"type": "mongo"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"__v": "string",
"_id._oid": "string",
"boilerplate": "string",
"companyId": "string",
"createdAt._date": "string",
"live": "string",
"localeCode": "string",
"metadata._id._oid": "string",
"metadata.locale": "string",
"metadata.pageType": "string",
"publishedVersion._id._oid": "string",
"publishedVersion.createdAt": "string",
"publishedVersion.id": "string",
"publishedVersion.sections": [
{
"_id._oid": "string",
"data": "string",
"id": "string",
"payload": "string",
"type": "string",
"widgets": [
{
"_id._oid": "string",
"componentId": "string",
"id": "string",
"payload": "string",
"type": "string"
}
]
}
],
"publishedVersion.styles": "string",
"publishedVersion.tag": "string",
"publishedVersion.updatedAt._date": "string",
"title": "string",
"typeId._oid": "string",
"updatedAt._date": "string",
"versions": [
{
"_id._oid": "string",
"createdAt._date": "string",
"id": "string",
"sections": [
{
"_id._oid": "string",
"data": "string",
"id": "string",
"payload": "string",
"type": "string",
"widgets": [
{
"_id._oid": "string",
"componentId": "string",
"id": "string",
"payload": "string",
"type": "string"
}
]
}
],
"styles": "string",
"updatedAt._date": "string"
}
]
},
"created": "2020-11-05 17:02:17",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_pagelayouts`\n(\n`typeId`struct<`_oid`:STRING>,`versions`array,`id`:STRING,`sections`:array,`id`:STRING,`widgets`:array,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:struct<`_date`:STRING>,`updatedAt`:struct<`_date`:STRING>,`styles`:STRING>>,`_id`struct<`_oid`:STRING>,`metadata`struct<`_id`:struct<`_oid`:STRING>,`locale`:STRING,`pageType`:STRING>,`boilerplate`STRING,`updatedAt`struct<`_date`:STRING>,`createdAt`struct<`_date`:STRING>,`localeCode`STRING,`companyId`STRING,`__v`STRING,`live`STRING,`title`STRING,`publishedVersion`struct<`_id`:struct<`_oid`:STRING>,`styles`:STRING,`updatedAt`:struct<`_date`:STRING>,`sections`:array,`id`:STRING,`widgets`:array,`id`:STRING,`type`:STRING,`componentId`:STRING,`payload`:STRING>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:STRING,`id`:STRING,`tag`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-mongo-storedge-dev/raw/voyager_pagelayouts/2020-11-05/1604617313'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_pagelayouts`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_pagelayouts"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}