Schema Info

Schema Name: sfdl_dev_mongo.storedge_voyager_blogcategories

created: 2019-03-20 15:42:08
disabled: False
format: raw
id: 1221
is_partitioned: False
is_schema_datatyped: False

name:

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

type: mongo

Schema Versions: 3

Version 4684178

created: 2020-11-05 17:03:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_blogcategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_blogcategories`\n(\n`name`STRING,`posts`array,`slug`:STRING,`content`:struct<`blocks`:array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`id`:STRING,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING,`target`:STRING,`rel`:STRING,`href`:STRING,`width`:STRING,`src`:STRING,`height`:STRING,`alt`:STRING,`title`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING,`href`:STRING,`target`:STRING,`rel`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`3`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`4`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`5`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`6`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`7`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`8`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`9`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`10`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`11`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`12`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`13`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>,`14`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>>>,`id`:STRING,`snippet`:STRING,`author`:STRING>>,`_id`struct<`_oid`:STRING>,`slug`STRING,`__v`STRING,`companyId`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_blogcategories/2020-11-05/1604617314'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_blogcategories"
]

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_blogcategories/2020-11-05/1604617314
id: 4684178
processed: 1

raw_data:

{ "__v": 1, "_id": { "_oid": "59c90e9acc91396ff6c19896" }, "companyId": "bb8797be-b8e2-4b85-b9a9-2682fedadfbb", "name": "GENERAL", "posts": [ { "author": null, "body": "

--- Garage and Canopy storage for your RV/Boats! ---

We are very excited about our 2016 - big things are in store. We are making a significant purchase and starting a very aggressive building project. We will be making available to our customers both fully enclosed garages as well as canopy covered parking for your boat/RV/trailers beginning in June 2016. We look forward to being able to provide this extra protection for your vehicles.

Our enclosed garages will be available in three sizes 40x16, 50x16 and 60x16. Our garages will have both the garage door as well as a man door on the side. We are going to continue our practice of angling the entry 60 degrees from the isle to ease your entry and exit.

Our Canopy spaces will be available in a wider variety of sizes. They will range from 15-60' long and all will be 15' wide. (The normal width of storage spaces varies, but the vast majority of our competitors is around 12' 6\") Our canopies will be angled at 60 degrees to the isle and we will have a variety of back-in and drive through spaces. Many of our spaces will have access to trickle feed power to keep your batteries charged and ready to go.

If you would like to be placed on a notification list for either Canopy or Garage storage please email us at indoor

[email protected] and give us your name, telephone and preferred type of storage. We look forward to your business in 2016!

\n", "content": { "blocks": [ { "data": { "align": "left" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 1, "offset": 351 } ], "inlineStyleRanges": [ { "length": 47, "offset": 3, "style": "BOLD" } ], "key": "bkj2s", "text": "Students at New York University who go home for the summer often have the same question. Should I store my stuff or bring it home with me?", "type": "unstyled" } ], "entityMap": { "0": { "data": { "alt": "why carports aren't enough protection", "height": "450", "href": "https://www.clutter.com/", "rel": "noopener noreferrer", "src": "https://www.siouxcitystorage.com/wp-content/uploads/2018/09/things-2609870_1920-e1537548654149.jpg", "target": "_blank", "title": "CDA Chamber of Commerce", "url": "https://www.clutter.com/", "width": "900" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://www.garageliving.com/blog/garage-parking-benefits/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/climate-control" }, "mutability": "MUTABLE", "type": "LINK" }, "10": { "data": { "href": "https://www.modernstorage.com/info/security-features", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "11": { "data": { "href": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28", "url": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28" }, "mutability": "MUTABLE", "type": "LINK" }, "12": { "data": { "href": "https://www.modernstorage.com/", "url": "https://www.modernstorage.com/" }, "mutability": "MUTABLE", "type": "LINK" }, "13": { "data": { "href": "https://www.cdc.gov/coronavirus/2019-ncov/downloads/workplace-school-and-home-guidance.pdf", "url": "https://www.cdc.gov/coronavirus/2019-ncov/downloads/workplace-school-and-home-guidance.pdf" }, "mutability": "MUTABLE", "type": "LINK" }, "14": { "data": { "href": "https://www.cdc.gov/coronavirus/2019-ncov/prepare/cleaning-disinfection.html?CDC_AA_refVal=https%3A%2F%2Fwww.cdc.gov%2Fcoronavirus%2F2019-ncov%2Fcommunity%2Fhome%2Fcleaning-disinfection.html&kbid=93121", "url": "https://www.cdc.gov/coronavirus/2019-ncov/prepare/cleaning-disinfection.html?CDC_AA_refVal=https%3A%2F%2Fwww.cdc.gov%2Fcoronavirus%2F2019-ncov%2Fcommunity%2Fhome%2Fcleaning-disinfection.html&kbid=93121" }, "mutability": "MUTABLE", "type": "LINK" }, "2": { "data": { "href": "https://www.seguinstorage.net/size-guide", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "3": { "data": { "href": "https://www.seguinstorage.net/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "4": { "data": { "href": "https://www.seguinstorage.net/1301-e-kingsbury-st-seguin-tx-78155", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "5": { "data": { "href": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0", "url": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0" }, "mutability": "MUTABLE", "type": "LINK" }, "6": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198" }, "mutability": "MUTABLE", "type": "LINK" }, "7": { "data": { "href": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458", "url": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458" }, "mutability": "MUTABLE", "type": "LINK" }, "8": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355" }, "mutability": "MUTABLE", "type": "LINK" }, "9": { "data": { "href": "https://www.modernstorage.com/about", "url": "https://www.modernstorage.com/about" }, "mutability": "MUTABLE", "type": "LINK" } }, "id": "70a51823-3dd8-404d-8eb1-011088087ed4" }, "id": "fbb1079e-8d3b-43b6-acaa-75647cf12d4d", "slug": "rvvault-is-expanding-in-centennial", "snippet": " --- Garage and Canopy storage for your RV/Boats! --- We are very excited about our 2016 - big things are in store. We are making a significant purchase and starting a very aggressive building project. We will be making available to our customers both fully enclosed garages as well as canopy covered parking for your ...", "timestamp": { "_date": "2017-09-25T14:11:38.380Z" }, "title": "Canopy and Garage storage Available June 2016" } ], "slug": "general" }

schema_attributes:

{
    "__v": "string",
    "_id._oid": "string",
    "companyId": "string",
    "name": "string",
    "posts": [
        {
            "author": "string",
            "body": "string",
            "content.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"
                }
            ],
            "content.entityMap.0.data.alt": "string",
            "content.entityMap.0.data.height": "string",
            "content.entityMap.0.data.href": "string",
            "content.entityMap.0.data.rel": "string",
            "content.entityMap.0.data.src": "string",
            "content.entityMap.0.data.target": "string",
            "content.entityMap.0.data.title": "string",
            "content.entityMap.0.data.url": "string",
            "content.entityMap.0.data.width": "string",
            "content.entityMap.0.mutability": "string",
            "content.entityMap.0.type": "string",
            "content.entityMap.1.data.href": "string",
            "content.entityMap.1.data.rel": "string",
            "content.entityMap.1.data.target": "string",
            "content.entityMap.1.data.url": "string",
            "content.entityMap.1.mutability": "string",
            "content.entityMap.1.type": "string",
            "content.entityMap.10.data.href": "string",
            "content.entityMap.10.data.url": "string",
            "content.entityMap.10.mutability": "string",
            "content.entityMap.10.type": "string",
            "content.entityMap.11.data.href": "string",
            "content.entityMap.11.data.url": "string",
            "content.entityMap.11.mutability": "string",
            "content.entityMap.11.type": "string",
            "content.entityMap.12.data.href": "string",
            "content.entityMap.12.data.url": "string",
            "content.entityMap.12.mutability": "string",
            "content.entityMap.12.type": "string",
            "content.entityMap.13.data.href": "string",
            "content.entityMap.13.data.url": "string",
            "content.entityMap.13.mutability": "string",
            "content.entityMap.13.type": "string",
            "content.entityMap.14.data.href": "string",
            "content.entityMap.14.data.url": "string",
            "content.entityMap.14.mutability": "string",
            "content.entityMap.14.type": "string",
            "content.entityMap.2.data.href": "string",
            "content.entityMap.2.data.rel": "string",
            "content.entityMap.2.data.target": "string",
            "content.entityMap.2.data.url": "string",
            "content.entityMap.2.mutability": "string",
            "content.entityMap.2.type": "string",
            "content.entityMap.3.data.href": "string",
            "content.entityMap.3.data.rel": "string",
            "content.entityMap.3.data.target": "string",
            "content.entityMap.3.data.url": "string",
            "content.entityMap.3.mutability": "string",
            "content.entityMap.3.type": "string",
            "content.entityMap.4.data.href": "string",
            "content.entityMap.4.data.rel": "string",
            "content.entityMap.4.data.target": "string",
            "content.entityMap.4.data.url": "string",
            "content.entityMap.4.mutability": "string",
            "content.entityMap.4.type": "string",
            "content.entityMap.5.data.href": "string",
            "content.entityMap.5.data.url": "string",
            "content.entityMap.5.mutability": "string",
            "content.entityMap.5.type": "string",
            "content.entityMap.6.data.href": "string",
            "content.entityMap.6.data.url": "string",
            "content.entityMap.6.mutability": "string",
            "content.entityMap.6.type": "string",
            "content.entityMap.7.data.href": "string",
            "content.entityMap.7.data.url": "string",
            "content.entityMap.7.mutability": "string",
            "content.entityMap.7.type": "string",
            "content.entityMap.8.data.href": "string",
            "content.entityMap.8.data.url": "string",
            "content.entityMap.8.mutability": "string",
            "content.entityMap.8.type": "string",
            "content.entityMap.9.data.href": "string",
            "content.entityMap.9.data.url": "string",
            "content.entityMap.9.mutability": "string",
            "content.entityMap.9.type": "string",
            "content.id": "string",
            "id": "string",
            "slug": "string",
            "snippet": "string",
            "timestamp._date": "string",
            "title": "string"
        }
    ],
    "slug": "string"
}

schema_name_id: 1221
schema_scan_id: 5718514
updated: 2020-11-05 17:03:44

Version 4679078

created: 2020-06-14 12:02:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_blogcategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_blogcategories`\n(\n`companyId`STRING,`slug`STRING,`_id`struct<`_oid`:STRING>,`posts`array,`slug`:STRING,`content`:struct<`blocks`:array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`id`:STRING,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING,`target`:STRING,`rel`:STRING,`href`:STRING,`width`:STRING,`src`:STRING,`height`:STRING,`alt`:STRING,`title`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING,`href`:STRING,`target`:STRING,`rel`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`3`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`4`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`5`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`6`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`7`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`8`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`9`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`10`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`11`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`12`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>>>,`id`:STRING,`snippet`:STRING,`author`:STRING>>,`name`STRING,`__v`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_blogcategories/2020-06-14/1592154129'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_blogcategories"
]

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_blogcategories/2020-06-14/1592154129
id: 4679078
processed: 1

raw_data:

{ "__v": 1, "_id": { "_oid": "59c90e9acc91396ff6c19896" }, "companyId": "bb8797be-b8e2-4b85-b9a9-2682fedadfbb", "name": "GENERAL", "posts": [ { "author": null, "body": "

--- Garage and Canopy storage for your RV/Boats! ---

If you would like to be placed on a notification list for either Canopy or Garage storage please email us at indoor

[email protected] and give us your name, telephone and preferred type of storage. We look forward to your business in 2016!

\n", "content": { "blocks": [ { "data": { "align": "left" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 1, "offset": 351 } ], "inlineStyleRanges": [ { "length": 47, "offset": 3, "style": "BOLD" } ], "key": "bkj2s", "text": "Students at New York University who go home for the summer often have the same question. Should I store my stuff or bring it home with me?", "type": "unstyled" } ], "entityMap": { "0": { "data": { "alt": "why carports aren't enough protection", "height": "450", "href": "https://www.clutter.com/", "rel": "noopener noreferrer", "src": "https://www.siouxcitystorage.com/wp-content/uploads/2018/09/things-2609870_1920-e1537548654149.jpg", "target": "_blank", "title": "CDA Chamber of Commerce", "url": "https://www.clutter.com/", "width": "900" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://www.garageliving.com/blog/garage-parking-benefits/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/climate-control" }, "mutability": "MUTABLE", "type": "LINK" }, "10": { "data": { "href": "https://www.modernstorage.com/info/security-features", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "11": { "data": { "href": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28", "url": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28" }, "mutability": "MUTABLE", "type": "LINK" }, "12": { "data": { "href": "https://www.modernstorage.com/", "url": "https://www.modernstorage.com/" }, "mutability": "MUTABLE", "type": "LINK" }, "2": { "data": { "href": "https://www.seguinstorage.net/size-guide", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "3": { "data": { "href": "https://www.seguinstorage.net/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "4": { "data": { "href": "https://www.seguinstorage.net/1301-e-kingsbury-st-seguin-tx-78155", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "5": { "data": { "href": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0", "url": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0" }, "mutability": "MUTABLE", "type": "LINK" }, "6": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198" }, "mutability": "MUTABLE", "type": "LINK" }, "7": { "data": { "href": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458", "url": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458" }, "mutability": "MUTABLE", "type": "LINK" }, "8": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355" }, "mutability": "MUTABLE", "type": "LINK" }, "9": { "data": { "href": "https://www.modernstorage.com/about", "url": "https://www.modernstorage.com/about" }, "mutability": "MUTABLE", "type": "LINK" } }, "id": "70a51823-3dd8-404d-8eb1-011088087ed4" }, "id": "fbb1079e-8d3b-43b6-acaa-75647cf12d4d", "slug": "rvvault-is-expanding-in-centennial", "snippet": " --- Garage and Canopy storage for your RV/Boats! --- We are very excited about our 2016 - big things are in store. We are making a significant purchase and starting a very aggressive building project. We will be making available to our customers both fully enclosed garages as well as canopy covered parking for your ...", "timestamp": { "_date": "2017-09-25T14:11:38.380Z" }, "title": "Canopy and Garage storage Available June 2016" } ], "slug": "general" }

schema_attributes:

{
    "__v": "string",
    "_id._oid": "string",
    "companyId": "string",
    "name": "string",
    "posts": [
        {
            "author": "string",
            "body": "string",
            "content.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"
                }
            ],
            "content.entityMap.0.data.alt": "string",
            "content.entityMap.0.data.height": "string",
            "content.entityMap.0.data.href": "string",
            "content.entityMap.0.data.rel": "string",
            "content.entityMap.0.data.src": "string",
            "content.entityMap.0.data.target": "string",
            "content.entityMap.0.data.title": "string",
            "content.entityMap.0.data.url": "string",
            "content.entityMap.0.data.width": "string",
            "content.entityMap.0.mutability": "string",
            "content.entityMap.0.type": "string",
            "content.entityMap.1.data.href": "string",
            "content.entityMap.1.data.rel": "string",
            "content.entityMap.1.data.target": "string",
            "content.entityMap.1.data.url": "string",
            "content.entityMap.1.mutability": "string",
            "content.entityMap.1.type": "string",
            "content.entityMap.10.data.href": "string",
            "content.entityMap.10.data.url": "string",
            "content.entityMap.10.mutability": "string",
            "content.entityMap.10.type": "string",
            "content.entityMap.11.data.href": "string",
            "content.entityMap.11.data.url": "string",
            "content.entityMap.11.mutability": "string",
            "content.entityMap.11.type": "string",
            "content.entityMap.12.data.href": "string",
            "content.entityMap.12.data.url": "string",
            "content.entityMap.12.mutability": "string",
            "content.entityMap.12.type": "string",
            "content.entityMap.2.data.href": "string",
            "content.entityMap.2.data.rel": "string",
            "content.entityMap.2.data.target": "string",
            "content.entityMap.2.data.url": "string",
            "content.entityMap.2.mutability": "string",
            "content.entityMap.2.type": "string",
            "content.entityMap.3.data.href": "string",
            "content.entityMap.3.data.rel": "string",
            "content.entityMap.3.data.target": "string",
            "content.entityMap.3.data.url": "string",
            "content.entityMap.3.mutability": "string",
            "content.entityMap.3.type": "string",
            "content.entityMap.4.data.href": "string",
            "content.entityMap.4.data.rel": "string",
            "content.entityMap.4.data.target": "string",
            "content.entityMap.4.data.url": "string",
            "content.entityMap.4.mutability": "string",
            "content.entityMap.4.type": "string",
            "content.entityMap.5.data.href": "string",
            "content.entityMap.5.data.url": "string",
            "content.entityMap.5.mutability": "string",
            "content.entityMap.5.type": "string",
            "content.entityMap.6.data.href": "string",
            "content.entityMap.6.data.url": "string",
            "content.entityMap.6.mutability": "string",
            "content.entityMap.6.type": "string",
            "content.entityMap.7.data.href": "string",
            "content.entityMap.7.data.url": "string",
            "content.entityMap.7.mutability": "string",
            "content.entityMap.7.type": "string",
            "content.entityMap.8.data.href": "string",
            "content.entityMap.8.data.url": "string",
            "content.entityMap.8.mutability": "string",
            "content.entityMap.8.type": "string",
            "content.entityMap.9.data.href": "string",
            "content.entityMap.9.data.url": "string",
            "content.entityMap.9.mutability": "string",
            "content.entityMap.9.type": "string",
            "content.id": "string",
            "id": "string",
            "slug": "string",
            "snippet": "string",
            "timestamp._date": "string",
            "title": "string"
        }
    ],
    "slug": "string"
}

schema_name_id: 1221
schema_scan_id: 5627158
updated: 2020-06-14 12:02:30

Version 4679070

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_blogcategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_voyager_blogcategories`\n(\n`companyId`STRING,`slug`STRING,`_id`struct<`_oid`:STRING>,`posts`array,`slug`:STRING,`content`:struct<`blocks`:array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`id`:STRING,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING,`target`:STRING,`rel`:STRING,`href`:STRING,`width`:STRING,`src`:STRING,`height`:STRING,`alt`:STRING,`title`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING,`href`:STRING,`target`:STRING,`rel`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`3`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`4`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`5`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`6`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`7`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`8`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`9`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`10`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`11`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`12`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>>>,`id`:STRING,`snippet`:STRING,`author`:STRING>>,`name`STRING,`__v`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_blogcategories/2020-06-13/1592083336'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_blogcategories"
]

hive_path: s3://sfdl-mongo-storedge-dev/raw/voyager_blogcategories/2020-06-13/1592083336
id: 4679070
processed: 1

raw_data:

{ "__v": 1, "_id": { "_oid": "59c90e9acc91396ff6c19896" }, "companyId": "bb8797be-b8e2-4b85-b9a9-2682fedadfbb", "name": "GENERAL", "posts": [ { "author": null, "body": "

--- Garage and Canopy storage for your RV/Boats! ---

If you would like to be placed on a notification list for either Canopy or Garage storage please email us at indoor

[email protected] and give us your name, telephone and preferred type of storage. We look forward to your business in 2016!

\n", "content": { "blocks": [ { "data": { "align": "left" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 1, "offset": 351 } ], "inlineStyleRanges": [ { "length": 47, "offset": 3, "style": "BOLD" } ], "key": "bkj2s", "text": "Students at New York University who go home for the summer often have the same question. Should I store my stuff or bring it home with me?", "type": "unstyled" } ], "entityMap": { "0": { "data": { "alt": "why carports aren't enough protection", "height": "450", "href": "https://www.clutter.com/", "rel": "noopener noreferrer", "src": "https://www.siouxcitystorage.com/wp-content/uploads/2018/09/things-2609870_1920-e1537548654149.jpg", "target": "_blank", "title": "CDA Chamber of Commerce", "url": "https://www.clutter.com/", "width": "900" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://www.garageliving.com/blog/garage-parking-benefits/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/climate-control" }, "mutability": "MUTABLE", "type": "LINK" }, "10": { "data": { "href": "https://www.modernstorage.com/info/security-features", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "11": { "data": { "href": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28", "url": "https://www.modernstorage.com/news/how-to-select-the-best-parking-storage-space-28" }, "mutability": "MUTABLE", "type": "LINK" }, "12": { "data": { "href": "https://www.modernstorage.com/", "url": "https://www.modernstorage.com/" }, "mutability": "MUTABLE", "type": "LINK" }, "2": { "data": { "href": "https://www.seguinstorage.net/size-guide", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "3": { "data": { "href": "https://www.seguinstorage.net/", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/security-features" }, "mutability": "MUTABLE", "type": "LINK" }, "4": { "data": { "href": "https://www.seguinstorage.net/1301-e-kingsbury-st-seguin-tx-78155", "rel": "noopener", "target": "_blank", "url": "https://www.modernstorage.com/info/business-storage" }, "mutability": "MUTABLE", "type": "LINK" }, "5": { "data": { "href": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0", "url": "https://www.modernstorage.com/news/how-modern-storage-is-changing-the-face-of-storage-0" }, "mutability": "MUTABLE", "type": "LINK" }, "6": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f5198" }, "mutability": "MUTABLE", "type": "LINK" }, "7": { "data": { "href": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458", "url": "https://www.modernstorage.com/self-storage-maumelle-ar-f9458" }, "mutability": "MUTABLE", "type": "LINK" }, "8": { "data": { "href": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355", "url": "https://www.modernstorage.com/self-storage-little-rock-ar-f8355" }, "mutability": "MUTABLE", "type": "LINK" }, "9": { "data": { "href": "https://www.modernstorage.com/about", "url": "https://www.modernstorage.com/about" }, "mutability": "MUTABLE", "type": "LINK" } }, "id": "70a51823-3dd8-404d-8eb1-011088087ed4" }, "id": "fbb1079e-8d3b-43b6-acaa-75647cf12d4d", "slug": "rvvault-is-expanding-in-centennial", "snippet": " --- Garage and Canopy storage for your RV/Boats! --- We are very excited about our 2016 - big things are in store. We are making a significant purchase and starting a very aggressive building project. We will be making available to our customers both fully enclosed garages as well as canopy covered parking for your ...", "timestamp": { "_date": "2017-09-25T14:11:38.380Z" }, "title": "Canopy and Garage storage Available June 2016" } ], "slug": "general" }

schema_attributes:

{
    "__v": "string",
    "_id._oid": "string",
    "companyId": "string",
    "name": "string",
    "posts": [
        {
            "author": "string",
            "body": "string",
            "content.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"
                }
            ],
            "content.entityMap.0.data.alt": "string",
            "content.entityMap.0.data.height": "string",
            "content.entityMap.0.data.href": "string",
            "content.entityMap.0.data.rel": "string",
            "content.entityMap.0.data.src": "string",
            "content.entityMap.0.data.target": "string",
            "content.entityMap.0.data.title": "string",
            "content.entityMap.0.data.url": "string",
            "content.entityMap.0.data.width": "string",
            "content.entityMap.0.mutability": "string",
            "content.entityMap.0.type": "string",
            "content.entityMap.1.data.href": "string",
            "content.entityMap.1.data.rel": "string",
            "content.entityMap.1.data.target": "string",
            "content.entityMap.1.data.url": "string",
            "content.entityMap.1.mutability": "string",
            "content.entityMap.1.type": "string",
            "content.entityMap.10.data.href": "string",
            "content.entityMap.10.data.url": "string",
            "content.entityMap.10.mutability": "string",
            "content.entityMap.10.type": "string",
            "content.entityMap.11.data.href": "string",
            "content.entityMap.11.data.url": "string",
            "content.entityMap.11.mutability": "string",
            "content.entityMap.11.type": "string",
            "content.entityMap.12.data.href": "string",
            "content.entityMap.12.data.url": "string",
            "content.entityMap.12.mutability": "string",
            "content.entityMap.12.type": "string",
            "content.entityMap.2.data.href": "string",
            "content.entityMap.2.data.rel": "string",
            "content.entityMap.2.data.target": "string",
            "content.entityMap.2.data.url": "string",
            "content.entityMap.2.mutability": "string",
            "content.entityMap.2.type": "string",
            "content.entityMap.3.data.href": "string",
            "content.entityMap.3.data.rel": "string",
            "content.entityMap.3.data.target": "string",
            "content.entityMap.3.data.url": "string",
            "content.entityMap.3.mutability": "string",
            "content.entityMap.3.type": "string",
            "content.entityMap.4.data.href": "string",
            "content.entityMap.4.data.rel": "string",
            "content.entityMap.4.data.target": "string",
            "content.entityMap.4.data.url": "string",
            "content.entityMap.4.mutability": "string",
            "content.entityMap.4.type": "string",
            "content.entityMap.5.data.href": "string",
            "content.entityMap.5.data.url": "string",
            "content.entityMap.5.mutability": "string",
            "content.entityMap.5.type": "string",
            "content.entityMap.6.data.href": "string",
            "content.entityMap.6.data.url": "string",
            "content.entityMap.6.mutability": "string",
            "content.entityMap.6.type": "string",
            "content.entityMap.7.data.href": "string",
            "content.entityMap.7.data.url": "string",
            "content.entityMap.7.mutability": "string",
            "content.entityMap.7.type": "string",
            "content.entityMap.8.data.href": "string",
            "content.entityMap.8.data.url": "string",
            "content.entityMap.8.mutability": "string",
            "content.entityMap.8.type": "string",
            "content.entityMap.9.data.href": "string",
            "content.entityMap.9.data.url": "string",
            "content.entityMap.9.mutability": "string",
            "content.entityMap.9.type": "string",
            "content.id": "string",
            "id": "string",
            "slug": "string",
            "snippet": "string",
            "timestamp._date": "string",
            "title": "string"
        }
    ],
    "slug": "string"
}

schema_name_id: 1221
schema_scan_id: 5627099
updated: 2020-06-13 16:23:22

Schema Scans: 3

Last at 2020-11-05 17:03:33

Scan 5718514

duration: 0:00:16.378455

exit_message:

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

id: 5718514

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_blogcategories/2020-11-05/1604617314",
        "key": "raw/voyager_blogcategories/2020-11-05/1604617314/blogcategories_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_blogcategories",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 17936144561281680954,
        "service_name": "preloading",
        "span_id": 5350448023158794015,
        "trace_id": 6112369120461499106
    }
}

running: False
schema_name_id: 1221
start_time: 2020-11-05 17:03:33
success: True
trace_id: 6112369120461499106

Scan 5627158

duration: 0:00:13.830218

exit_message:

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

id: 5627158

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_blogcategories/2020-06-14/1592154129",
        "key": "raw/voyager_blogcategories/2020-06-14/1592154129/blogcategories_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_blogcategories",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 10153297114182601760,
        "service_name": "preloading",
        "span_id": 7568085351863473558,
        "trace_id": 1445678987074264860
    }
}

running: False
schema_name_id: 1221
start_time: 2020-06-14 12:02:19
success: True
trace_id: 1445678987074264860

Scan 5627099

duration: 0:00:14.169394

exit_message:

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

id: 5627099

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_blogcategories/2020-06-13/1592083336",
        "key": "raw/voyager_blogcategories/2020-06-13/1592083336/blogcategories_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_voyager_blogcategories",
        "type": "mongo"
    },
    "trace_context": {
        "parent_id": 18292868620485187550,
        "service_name": "preloading",
        "span_id": 17459158058910203081,
        "trace_id": 20763686744671641
    }
}

running: False
schema_name_id: 1221
start_time: 2020-06-13 16:23:10
success: True
trace_id: 20763686744671641

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "__v": "string",
    "_id._oid": "string",
    "companyId": "string",
    "name": "string",
    "posts": [
        {
            "author": "string",
            "body": "string",
            "content.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"
                }
            ],
            "content.entityMap.0.data.alt": "string",
            "content.entityMap.0.data.height": "string",
            "content.entityMap.0.data.href": "string",
            "content.entityMap.0.data.rel": "string",
            "content.entityMap.0.data.src": "string",
            "content.entityMap.0.data.target": "string",
            "content.entityMap.0.data.title": "string",
            "content.entityMap.0.data.url": "string",
            "content.entityMap.0.data.width": "string",
            "content.entityMap.0.mutability": "string",
            "content.entityMap.0.type": "string",
            "content.entityMap.1.data.href": "string",
            "content.entityMap.1.data.rel": "string",
            "content.entityMap.1.data.target": "string",
            "content.entityMap.1.data.url": "string",
            "content.entityMap.1.mutability": "string",
            "content.entityMap.1.type": "string",
            "content.entityMap.10.data.href": "string",
            "content.entityMap.10.data.url": "string",
            "content.entityMap.10.mutability": "string",
            "content.entityMap.10.type": "string",
            "content.entityMap.11.data.href": "string",
            "content.entityMap.11.data.url": "string",
            "content.entityMap.11.mutability": "string",
            "content.entityMap.11.type": "string",
            "content.entityMap.12.data.href": "string",
            "content.entityMap.12.data.url": "string",
            "content.entityMap.12.mutability": "string",
            "content.entityMap.12.type": "string",
            "content.entityMap.13.data.href": "string",
            "content.entityMap.13.data.url": "string",
            "content.entityMap.13.mutability": "string",
            "content.entityMap.13.type": "string",
            "content.entityMap.14.data.href": "string",
            "content.entityMap.14.data.url": "string",
            "content.entityMap.14.mutability": "string",
            "content.entityMap.14.type": "string",
            "content.entityMap.2.data.href": "string",
            "content.entityMap.2.data.rel": "string",
            "content.entityMap.2.data.target": "string",
            "content.entityMap.2.data.url": "string",
            "content.entityMap.2.mutability": "string",
            "content.entityMap.2.type": "string",
            "content.entityMap.3.data.href": "string",
            "content.entityMap.3.data.rel": "string",
            "content.entityMap.3.data.target": "string",
            "content.entityMap.3.data.url": "string",
            "content.entityMap.3.mutability": "string",
            "content.entityMap.3.type": "string",
            "content.entityMap.4.data.href": "string",
            "content.entityMap.4.data.rel": "string",
            "content.entityMap.4.data.target": "string",
            "content.entityMap.4.data.url": "string",
            "content.entityMap.4.mutability": "string",
            "content.entityMap.4.type": "string",
            "content.entityMap.5.data.href": "string",
            "content.entityMap.5.data.url": "string",
            "content.entityMap.5.mutability": "string",
            "content.entityMap.5.type": "string",
            "content.entityMap.6.data.href": "string",
            "content.entityMap.6.data.url": "string",
            "content.entityMap.6.mutability": "string",
            "content.entityMap.6.type": "string",
            "content.entityMap.7.data.href": "string",
            "content.entityMap.7.data.url": "string",
            "content.entityMap.7.mutability": "string",
            "content.entityMap.7.type": "string",
            "content.entityMap.8.data.href": "string",
            "content.entityMap.8.data.url": "string",
            "content.entityMap.8.mutability": "string",
            "content.entityMap.8.type": "string",
            "content.entityMap.9.data.href": "string",
            "content.entityMap.9.data.url": "string",
            "content.entityMap.9.mutability": "string",
            "content.entityMap.9.type": "string",
            "content.id": "string",
            "id": "string",
            "slug": "string",
            "snippet": "string",
            "timestamp._date": "string",
            "title": "string"
        }
    ],
    "slug": "string"
}

created: 2020-11-05 17:03:33

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_blogcategories`\n(\n`name`STRING,`posts`array,`slug`:STRING,`content`:struct<`blocks`:array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`id`:STRING,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING,`target`:STRING,`rel`:STRING,`href`:STRING,`width`:STRING,`src`:STRING,`height`:STRING,`alt`:STRING,`title`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING,`href`:STRING,`target`:STRING,`rel`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`3`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`4`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`5`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`6`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`7`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`8`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`9`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`10`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`11`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`12`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`13`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>,`14`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>>>,`id`:STRING,`snippet`:STRING,`author`:STRING>>,`_id`struct<`_oid`:STRING>,`slug`STRING,`__v`STRING,`companyId`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_blogcategories/2020-11-05/1604617314'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_blogcategories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_blogcategories"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-03-20 15:42:08",
        "disabled": false,
        "format": "raw",
        "id": 1221,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_mongo",
            "table": "storedge_voyager_blogcategories"
        },
        "type": "mongo"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "__v": "string",
            "_id._oid": "string",
            "companyId": "string",
            "name": "string",
            "posts": [
                {
                    "author": "string",
                    "body": "string",
                    "content.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"
                        }
                    ],
                    "content.entityMap.0.data.alt": "string",
                    "content.entityMap.0.data.height": "string",
                    "content.entityMap.0.data.href": "string",
                    "content.entityMap.0.data.rel": "string",
                    "content.entityMap.0.data.src": "string",
                    "content.entityMap.0.data.target": "string",
                    "content.entityMap.0.data.title": "string",
                    "content.entityMap.0.data.url": "string",
                    "content.entityMap.0.data.width": "string",
                    "content.entityMap.0.mutability": "string",
                    "content.entityMap.0.type": "string",
                    "content.entityMap.1.data.href": "string",
                    "content.entityMap.1.data.rel": "string",
                    "content.entityMap.1.data.target": "string",
                    "content.entityMap.1.data.url": "string",
                    "content.entityMap.1.mutability": "string",
                    "content.entityMap.1.type": "string",
                    "content.entityMap.10.data.href": "string",
                    "content.entityMap.10.data.url": "string",
                    "content.entityMap.10.mutability": "string",
                    "content.entityMap.10.type": "string",
                    "content.entityMap.11.data.href": "string",
                    "content.entityMap.11.data.url": "string",
                    "content.entityMap.11.mutability": "string",
                    "content.entityMap.11.type": "string",
                    "content.entityMap.12.data.href": "string",
                    "content.entityMap.12.data.url": "string",
                    "content.entityMap.12.mutability": "string",
                    "content.entityMap.12.type": "string",
                    "content.entityMap.13.data.href": "string",
                    "content.entityMap.13.data.url": "string",
                    "content.entityMap.13.mutability": "string",
                    "content.entityMap.13.type": "string",
                    "content.entityMap.14.data.href": "string",
                    "content.entityMap.14.data.url": "string",
                    "content.entityMap.14.mutability": "string",
                    "content.entityMap.14.type": "string",
                    "content.entityMap.2.data.href": "string",
                    "content.entityMap.2.data.rel": "string",
                    "content.entityMap.2.data.target": "string",
                    "content.entityMap.2.data.url": "string",
                    "content.entityMap.2.mutability": "string",
                    "content.entityMap.2.type": "string",
                    "content.entityMap.3.data.href": "string",
                    "content.entityMap.3.data.rel": "string",
                    "content.entityMap.3.data.target": "string",
                    "content.entityMap.3.data.url": "string",
                    "content.entityMap.3.mutability": "string",
                    "content.entityMap.3.type": "string",
                    "content.entityMap.4.data.href": "string",
                    "content.entityMap.4.data.rel": "string",
                    "content.entityMap.4.data.target": "string",
                    "content.entityMap.4.data.url": "string",
                    "content.entityMap.4.mutability": "string",
                    "content.entityMap.4.type": "string",
                    "content.entityMap.5.data.href": "string",
                    "content.entityMap.5.data.url": "string",
                    "content.entityMap.5.mutability": "string",
                    "content.entityMap.5.type": "string",
                    "content.entityMap.6.data.href": "string",
                    "content.entityMap.6.data.url": "string",
                    "content.entityMap.6.mutability": "string",
                    "content.entityMap.6.type": "string",
                    "content.entityMap.7.data.href": "string",
                    "content.entityMap.7.data.url": "string",
                    "content.entityMap.7.mutability": "string",
                    "content.entityMap.7.type": "string",
                    "content.entityMap.8.data.href": "string",
                    "content.entityMap.8.data.url": "string",
                    "content.entityMap.8.mutability": "string",
                    "content.entityMap.8.type": "string",
                    "content.entityMap.9.data.href": "string",
                    "content.entityMap.9.data.url": "string",
                    "content.entityMap.9.mutability": "string",
                    "content.entityMap.9.type": "string",
                    "content.id": "string",
                    "id": "string",
                    "slug": "string",
                    "snippet": "string",
                    "timestamp._date": "string",
                    "title": "string"
                }
            ],
            "slug": "string"
        },
        "created": "2020-11-05 17:03:33",
        "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_blogcategories`\n(\n`name`STRING,`posts`array,`slug`:STRING,`content`:struct<`blocks`:array>,`inlineStyleRanges`:array>,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`align`:STRING>>>,`id`:STRING,`entityMap`:struct<`0`:struct<`data`:struct<`url`:STRING,`target`:STRING,`rel`:STRING,`href`:STRING,`width`:STRING,`src`:STRING,`height`:STRING,`alt`:STRING,`title`:STRING>,`mutability`:STRING,`type`:STRING>,`1`:struct<`data`:struct<`url`:STRING,`href`:STRING,`target`:STRING,`rel`:STRING>,`mutability`:STRING,`type`:STRING>,`2`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`3`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`4`:struct<`data`:struct<`url`:STRING,`href`:STRING,`rel`:STRING,`target`:STRING>,`mutability`:STRING,`type`:STRING>,`5`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`6`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`7`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`8`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`9`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`10`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`11`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`12`:struct<`data`:struct<`url`:STRING,`href`:STRING>,`mutability`:STRING,`type`:STRING>,`13`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>,`14`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`url`:STRING>>>>,`id`:STRING,`snippet`:STRING,`author`:STRING>>,`_id`struct<`_oid`:STRING>,`slug`STRING,`__v`STRING,`companyId`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_blogcategories/2020-11-05/1604617314'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_voyager_blogcategories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_voyager_blogcategories"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}