Schema Info

Schema Name: sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories
  • created: 2020-06-11 12:24:14
  • disabled: False
  • format: raw
  • id: 1481
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_dev_mongo",
    "table": "storedge_clifftestvoyager_blogcategories"
}
  • type: mongo
Schema Versions: 2
    • created: 2020-06-11 14:50:40
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`\n(\n`companyId`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>>,`__v`STRING,`slug`STRING,`name`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591905039'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories"
]
    • hive_path: s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591905039
    • id: 4679054
    • 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!  --- 
      \n
      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.
      \n
      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.  
      \n
      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. 
      \n
      If you would like to be placed on a notification list for either Canopy or Garage storage please email us at indoor
      \n
      [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: 1481
    • schema_scan_id: 5624892
    • updated: 2020-06-11 14:50:51
    • created: 2020-06-11 12:24:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`\n(\n`_id`struct<`_oid`:STRING>,`name`STRING,`slug`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>>,`companyId`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/clifftestvoyager_blogcategories/2020-06-11/1591896253'\n",
    "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories"
]
    • hive_path: s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591896253
    • id: 4679048
    • 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!  --- 
      \n
      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.
      \n
      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.  
      \n
      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. 
      \n
      If you would like to be placed on a notification list for either Canopy or Garage storage please email us at indoor
      \n
      [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: 1481
    • schema_scan_id: 5624749
    • updated: 2020-06-11 12:24:26
Schema Scans: 2
Last at 2020-06-11 14:50:40
    • duration: 0:00:13.852696
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 5624892
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-dev",
        "hive_path": "s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591905039",
        "key": "raw/clifftestvoyager_blogcategories/2020-06-11/1591905039/blogcategories_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories",
        "type": "mongo"
    }
}
    • running: False
    • schema_name_id: 1481
    • start_time: 2020-06-11 14:50:40
    • success: True
    • trace_id: 7143183447334616621
    • duration: 0:00:14.077471
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 5624749
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-mongo-storedge-dev",
        "hive_path": "s3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591896253",
        "key": "raw/clifftestvoyager_blogcategories/2020-06-11/1591896253/blogcategories_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories",
        "type": "mongo"
    }
}
    • running: False
    • schema_name_id: 1481
    • start_time: 2020-06-11 12:24:14
    • success: True
    • trace_id: 13560213849924122940
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.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-06-11 14:50:40
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`\n(\n`companyId`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>>,`__v`STRING,`slug`STRING,`name`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591905039'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_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": "2020-06-11 12:24:14",
        "disabled": false,
        "format": "raw",
        "id": 1481,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_mongo",
            "table": "storedge_clifftestvoyager_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.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-06-11 14:50:40",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mongo`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`\n(\n`companyId`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>>,`__v`STRING,`slug`STRING,`name`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mongo-storedge-dev/raw/clifftestvoyager_blogcategories/2020-06-11/1591905039'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_mongo.storedge_clifftestvoyager_blogcategories"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform