Schema Info

Schema Name: sfdl_dev_drivethru.hubspot_molo_landing_pages
  • created: 2022-11-30 12:58:50
  • disabled: False
  • format: raw
  • id: 2170
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "hubspot_molo_landing_pages"
}
  • type: drivethrujson
Schema Versions: 4
    • created: 2023-02-09 09:27:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-09/1675956409'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-09/1675956409
    • id: 4692830
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [],
    "authorName": "Alyssa Jones",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "deletedAt": "1970-01-01T00:00:00Z",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "layoutSections": {},
    "metaDescription": "You have spaces to fill and revenue to generate. Let us handle your contacts, reservations, payments and reporting.\u00a0",
    "name": "space-LP",
    "pageExpiryEnabled": false,
    "pageRedirected": false,
    "publicAccessRules": [],
    "publicAccessRulesEnabled": false,
    "publishDate": "2022-08-30T20:27:52Z",
    "publishImmediately": true,
    "published": false,
    "slug": "sample-offer",
    "state": "DRAFT",
    "subcategory": "landing_page",
    "templatePath": "generated_layouts/5218978429.html",
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "http://2753955.hs-sites.com/sample-offer",
    "useFeaturedImage": false,
    "widgetContainers": {
        "module_1395325301989437": {
            "label": "Left Column",
            "lineNumber": 75,
            "name": "module_1395325301989437",
            "widgets": [
                {
                    "body": {
                        "html": "\"\""
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815997,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        },
        "module_1395325309464440": {
            "label": "Center Column",
            "lineNumber": 91,
            "name": "module_1395325309464440",
            "widgets": [
                {
                    "body": {
                        "html": "
      Easy to build. 
      \n
      Even easier to love.
      \n
      Welcome to your shiny new landing page. Use this text to highlight the benefits of your most alluring offer. Customize the headline and image to your heart's content. 
      \n
      And use a list to:
      \n
        \n
      • Enliven your copy
        • \n
      • Expand on the details
        • \n
      • Encourage conversions
        • \n
      \n
      It really is that easy.
      "
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815995,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        }
    },
    "widgets": {
        "module_13885066546126190": {
            "body": {
                "form_to_use": "",
                "notifications_are_overridden": "false",
                "notifications_override_email_addresses": [],
                "tag": "form",
                "title": "",
                "type": "form",
                "wrapping_html": ""
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Sidebar Form",
            "lineNumber": 117,
            "name": "module_13885066546126190",
            "overrideable": true,
            "type": "form"
        },
        "module_140605127917621669": {
            "body": {
                "value": "Vast Three Column Landing Page"
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Page Title",
            "lineNumber": 51,
            "name": "module_140605127917621669",
            "overrideable": true,
            "type": "header"
        }
    }
}
    • schema_attributes: 
      {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        "string"
    ],
    "authorName": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "htmlTitle": "string",
    "id": "string",
    "metaDescription": "string",
    "name": "string",
    "pageExpiryEnabled": "string",
    "pageRedirected": "string",
    "publicAccessRules": [
        "string"
    ],
    "publicAccessRulesEnabled": "string",
    "publishDate": "string",
    "publishImmediately": "string",
    "published": "string",
    "slug": "string",
    "state": "string",
    "subcategory": "string",
    "templatePath": "string",
    "updatedAt": "string",
    "updatedById": "string",
    "url": "string",
    "useFeaturedImage": "string",
    "widgetContainers.module_1395325301989437.label": "string",
    "widgetContainers.module_1395325301989437.lineNumber": "string",
    "widgetContainers.module_1395325301989437.name": "string",
    "widgetContainers.module_1395325301989437.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgetContainers.module_1395325309464440.label": "string",
    "widgetContainers.module_1395325309464440.lineNumber": "string",
    "widgetContainers.module_1395325309464440.name": "string",
    "widgetContainers.module_1395325309464440.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgets.module_13885066546126190.body.form_to_use": "string",
    "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
    "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
        "string"
    ],
    "widgets.module_13885066546126190.body.tag": "string",
    "widgets.module_13885066546126190.body.title": "string",
    "widgets.module_13885066546126190.body.type": "string",
    "widgets.module_13885066546126190.body.wrapping_html": "string",
    "widgets.module_13885066546126190.exportToTemplateContext": "string",
    "widgets.module_13885066546126190.isGlobal": "string",
    "widgets.module_13885066546126190.label": "string",
    "widgets.module_13885066546126190.lineNumber": "string",
    "widgets.module_13885066546126190.name": "string",
    "widgets.module_13885066546126190.overrideable": "string",
    "widgets.module_13885066546126190.type": "string",
    "widgets.module_140605127917621669.body.value": "string",
    "widgets.module_140605127917621669.exportToTemplateContext": "string",
    "widgets.module_140605127917621669.isGlobal": "string",
    "widgets.module_140605127917621669.label": "string",
    "widgets.module_140605127917621669.lineNumber": "string",
    "widgets.module_140605127917621669.name": "string",
    "widgets.module_140605127917621669.overrideable": "string",
    "widgets.module_140605127917621669.type": "string"
}
    • schema_name_id: 2170
    • schema_scan_id: 6108978
    • updated: 2023-02-09 09:27:54
    • created: 2023-02-08 11:02:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-08/1675875450'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-08/1675875450
    • id: 4692802
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [],
    "authorName": "Alyssa Jones",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "deletedAt": "1970-01-01T00:00:00Z",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "layoutSections": {},
    "metaDescription": "You have spaces to fill and revenue to generate. Let us handle your contacts, reservations, payments and reporting.\u00a0",
    "name": "space-LP",
    "pageExpiryEnabled": false,
    "pageRedirected": false,
    "publicAccessRules": [],
    "publicAccessRulesEnabled": false,
    "publishDate": "2022-08-30T20:27:52Z",
    "publishImmediately": true,
    "published": false,
    "slug": "sample-offer",
    "state": "DRAFT",
    "subcategory": "landing_page",
    "templatePath": "generated_layouts/5218978429.html",
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "http://2753955.hs-sites.com/sample-offer",
    "useFeaturedImage": false,
    "widgetContainers": {
        "module_1395325301989437": {
            "label": "Left Column",
            "lineNumber": 75,
            "name": "module_1395325301989437",
            "widgets": [
                {
                    "body": {
                        "html": "\"\""
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815997,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        },
        "module_1395325309464440": {
            "label": "Center Column",
            "lineNumber": 91,
            "name": "module_1395325309464440",
            "widgets": [
                {
                    "body": {
                        "html": "
      Easy to build. 
      \n
      Even easier to love.
      \n
      Welcome to your shiny new landing page. Use this text to highlight the benefits of your most alluring offer. Customize the headline and image to your heart's content. 
      \n
      And use a list to:
      \n
        \n
      • Enliven your copy
        • \n
      • Expand on the details
        • \n
      • Encourage conversions
        • \n
      \n
      It really is that easy.
      "
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815995,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        }
    },
    "widgets": {
        "module_13885066546126190": {
            "body": {
                "form_to_use": "",
                "notifications_are_overridden": "false",
                "notifications_override_email_addresses": [],
                "tag": "form",
                "title": "",
                "type": "form",
                "wrapping_html": ""
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Sidebar Form",
            "lineNumber": 117,
            "name": "module_13885066546126190",
            "overrideable": true,
            "type": "form"
        },
        "module_140605127917621669": {
            "body": {
                "value": "Vast Three Column Landing Page"
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Page Title",
            "lineNumber": 51,
            "name": "module_140605127917621669",
            "overrideable": true,
            "type": "header"
        }
    }
}
    • schema_attributes: 
      {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        "string"
    ],
    "authorName": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "htmlTitle": "string",
    "id": "string",
    "metaDescription": "string",
    "name": "string",
    "pageExpiryEnabled": "string",
    "pageRedirected": "string",
    "publicAccessRules": [
        "string"
    ],
    "publicAccessRulesEnabled": "string",
    "publishDate": "string",
    "publishImmediately": "string",
    "published": "string",
    "slug": "string",
    "state": "string",
    "subcategory": "string",
    "templatePath": "string",
    "updatedAt": "string",
    "updatedById": "string",
    "url": "string",
    "useFeaturedImage": "string",
    "widgetContainers.module_1395325301989437.label": "string",
    "widgetContainers.module_1395325301989437.lineNumber": "string",
    "widgetContainers.module_1395325301989437.name": "string",
    "widgetContainers.module_1395325301989437.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgetContainers.module_1395325309464440.label": "string",
    "widgetContainers.module_1395325309464440.lineNumber": "string",
    "widgetContainers.module_1395325309464440.name": "string",
    "widgetContainers.module_1395325309464440.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgets.module_13885066546126190.body.form_to_use": "string",
    "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
    "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
        "string"
    ],
    "widgets.module_13885066546126190.body.tag": "string",
    "widgets.module_13885066546126190.body.title": "string",
    "widgets.module_13885066546126190.body.type": "string",
    "widgets.module_13885066546126190.body.wrapping_html": "string",
    "widgets.module_13885066546126190.exportToTemplateContext": "string",
    "widgets.module_13885066546126190.isGlobal": "string",
    "widgets.module_13885066546126190.label": "string",
    "widgets.module_13885066546126190.lineNumber": "string",
    "widgets.module_13885066546126190.name": "string",
    "widgets.module_13885066546126190.overrideable": "string",
    "widgets.module_13885066546126190.type": "string",
    "widgets.module_140605127917621669.body.value": "string",
    "widgets.module_140605127917621669.exportToTemplateContext": "string",
    "widgets.module_140605127917621669.isGlobal": "string",
    "widgets.module_140605127917621669.label": "string",
    "widgets.module_140605127917621669.lineNumber": "string",
    "widgets.module_140605127917621669.name": "string",
    "widgets.module_140605127917621669.overrideable": "string",
    "widgets.module_140605127917621669.type": "string"
}
    • schema_name_id: 2170
    • schema_scan_id: 6106937
    • updated: 2023-02-08 11:02:15
    • created: 2023-01-09 16:25:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673303128'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673303128
    • id: 4692005
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [],
    "authorName": "Alyssa Jones",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "deletedAt": "1970-01-01T00:00:00Z",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "layoutSections": {},
    "metaDescription": "You have spaces to fill and revenue to generate. Let us handle your contacts, reservations, payments and reporting.\u00a0",
    "name": "space-LP",
    "pageExpiryEnabled": false,
    "pageRedirected": false,
    "publicAccessRules": [],
    "publicAccessRulesEnabled": false,
    "publishDate": "2022-08-30T20:27:52Z",
    "publishImmediately": true,
    "published": false,
    "slug": "sample-offer",
    "state": "DRAFT",
    "subcategory": "landing_page",
    "templatePath": "generated_layouts/5218978429.html",
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "http://2753955.hs-sites.com/sample-offer",
    "useFeaturedImage": false,
    "widgetContainers": {
        "module_1395325301989437": {
            "label": "Left Column",
            "lineNumber": 75,
            "name": "module_1395325301989437",
            "widgets": [
                {
                    "body": {
                        "html": "\"\""
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815997,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        },
        "module_1395325309464440": {
            "label": "Center Column",
            "lineNumber": 91,
            "name": "module_1395325309464440",
            "widgets": [
                {
                    "body": {
                        "html": "
      Easy to build. 
      \n
      Even easier to love.
      \n
      Welcome to your shiny new landing page. Use this text to highlight the benefits of your most alluring offer. Customize the headline and image to your heart's content. 
      \n
      And use a list to:
      \n
        \n
      • Enliven your copy
        • \n
      • Expand on the details
        • \n
      • Encourage conversions
        • \n
      \n
      It really is that easy.
      "
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815995,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        }
    },
    "widgets": {
        "module_13885066546126190": {
            "body": {
                "form_to_use": "",
                "notifications_are_overridden": "false",
                "notifications_override_email_addresses": [],
                "tag": "form",
                "title": "",
                "type": "form",
                "wrapping_html": ""
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Sidebar Form",
            "lineNumber": 117,
            "name": "module_13885066546126190",
            "overrideable": true,
            "type": "form"
        },
        "module_140605127917621669": {
            "body": {
                "value": "Vast Three Column Landing Page"
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Page Title",
            "lineNumber": 51,
            "name": "module_140605127917621669",
            "overrideable": true,
            "type": "header"
        }
    }
}
    • schema_attributes: 
      {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        "string"
    ],
    "authorName": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "htmlTitle": "string",
    "id": "string",
    "metaDescription": "string",
    "name": "string",
    "pageExpiryEnabled": "string",
    "pageRedirected": "string",
    "publicAccessRules": [
        "string"
    ],
    "publicAccessRulesEnabled": "string",
    "publishDate": "string",
    "publishImmediately": "string",
    "published": "string",
    "slug": "string",
    "state": "string",
    "subcategory": "string",
    "templatePath": "string",
    "updatedAt": "string",
    "updatedById": "string",
    "url": "string",
    "useFeaturedImage": "string",
    "widgetContainers.module_1395325301989437.label": "string",
    "widgetContainers.module_1395325301989437.lineNumber": "string",
    "widgetContainers.module_1395325301989437.name": "string",
    "widgetContainers.module_1395325301989437.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgetContainers.module_1395325309464440.label": "string",
    "widgetContainers.module_1395325309464440.lineNumber": "string",
    "widgetContainers.module_1395325309464440.name": "string",
    "widgetContainers.module_1395325309464440.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgets.module_13885066546126190.body.form_to_use": "string",
    "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
    "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
        "string"
    ],
    "widgets.module_13885066546126190.body.tag": "string",
    "widgets.module_13885066546126190.body.title": "string",
    "widgets.module_13885066546126190.body.type": "string",
    "widgets.module_13885066546126190.body.wrapping_html": "string",
    "widgets.module_13885066546126190.exportToTemplateContext": "string",
    "widgets.module_13885066546126190.isGlobal": "string",
    "widgets.module_13885066546126190.label": "string",
    "widgets.module_13885066546126190.lineNumber": "string",
    "widgets.module_13885066546126190.name": "string",
    "widgets.module_13885066546126190.overrideable": "string",
    "widgets.module_13885066546126190.type": "string",
    "widgets.module_140605127917621669.body.value": "string",
    "widgets.module_140605127917621669.exportToTemplateContext": "string",
    "widgets.module_140605127917621669.isGlobal": "string",
    "widgets.module_140605127917621669.label": "string",
    "widgets.module_140605127917621669.lineNumber": "string",
    "widgets.module_140605127917621669.name": "string",
    "widgets.module_140605127917621669.overrideable": "string",
    "widgets.module_140605127917621669.type": "string"
}
    • schema_name_id: 2170
    • schema_scan_id: 6067198
    • updated: 2023-01-09 16:26:06
    • created: 2023-01-09 15:52:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673301051'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673301051
    • id: 4691998
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [],
    "authorName": "Alyssa Jones",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "deletedAt": "1970-01-01T00:00:00Z",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "layoutSections": {},
    "metaDescription": "You have spaces to fill and revenue to generate. Let us handle your contacts, reservations, payments and reporting.\u00a0",
    "name": "space-LP",
    "pageExpiryEnabled": false,
    "pageRedirected": false,
    "publicAccessRules": [],
    "publicAccessRulesEnabled": false,
    "publishDate": "2022-08-30T20:27:52Z",
    "publishImmediately": true,
    "published": false,
    "slug": "sample-offer",
    "state": "DRAFT",
    "subcategory": "landing_page",
    "templatePath": "generated_layouts/5218978429.html",
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "http://2753955.hs-sites.com/sample-offer",
    "useFeaturedImage": false,
    "widgetContainers": {
        "module_1395325301989437": {
            "label": "Left Column",
            "lineNumber": 75,
            "name": "module_1395325301989437",
            "widgets": [
                {
                    "body": {
                        "html": "\"\""
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815997,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        },
        "module_1395325309464440": {
            "label": "Center Column",
            "lineNumber": 91,
            "name": "module_1395325309464440",
            "widgets": [
                {
                    "body": {
                        "html": "
      Easy to build. 
      \n
      Even easier to love.
      \n
      Welcome to your shiny new landing page. Use this text to highlight the benefits of your most alluring offer. Customize the headline and image to your heart's content. 
      \n
      And use a list to:
      \n
        \n
      • Enliven your copy
        • \n
      • Expand on the details
        • \n
      • Encourage conversions
        • \n
      \n
      It really is that easy.
      "
                    },
                    "exportToTemplateContext": false,
                    "id": 5218815995,
                    "isGlobal": false,
                    "label": "Rich Text",
                    "lineNumber": 0,
                    "overrideable": true,
                    "type": "rich_text"
                }
            ]
        }
    },
    "widgets": {
        "module_13885066546126190": {
            "body": {
                "form_to_use": "",
                "notifications_are_overridden": "false",
                "notifications_override_email_addresses": [],
                "tag": "form",
                "title": "",
                "type": "form",
                "wrapping_html": ""
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Sidebar Form",
            "lineNumber": 117,
            "name": "module_13885066546126190",
            "overrideable": true,
            "type": "form"
        },
        "module_140605127917621669": {
            "body": {
                "value": "Vast Three Column Landing Page"
            },
            "exportToTemplateContext": false,
            "isGlobal": false,
            "label": "Page Title",
            "lineNumber": 51,
            "name": "module_140605127917621669",
            "overrideable": true,
            "type": "header"
        }
    }
}
    • schema_attributes: 
      {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        "string"
    ],
    "authorName": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "htmlTitle": "string",
    "id": "string",
    "metaDescription": "string",
    "name": "string",
    "pageExpiryEnabled": "string",
    "pageRedirected": "string",
    "publicAccessRules": [
        "string"
    ],
    "publicAccessRulesEnabled": "string",
    "publishDate": "string",
    "publishImmediately": "string",
    "published": "string",
    "slug": "string",
    "state": "string",
    "subcategory": "string",
    "templatePath": "string",
    "updatedAt": "string",
    "updatedById": "string",
    "url": "string",
    "useFeaturedImage": "string",
    "widgetContainers.module_1395325301989437.label": "string",
    "widgetContainers.module_1395325301989437.lineNumber": "string",
    "widgetContainers.module_1395325301989437.name": "string",
    "widgetContainers.module_1395325301989437.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgetContainers.module_1395325309464440.label": "string",
    "widgetContainers.module_1395325309464440.lineNumber": "string",
    "widgetContainers.module_1395325309464440.name": "string",
    "widgetContainers.module_1395325309464440.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgets.module_13885066546126190.body.form_to_use": "string",
    "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
    "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
        "string"
    ],
    "widgets.module_13885066546126190.body.tag": "string",
    "widgets.module_13885066546126190.body.title": "string",
    "widgets.module_13885066546126190.body.type": "string",
    "widgets.module_13885066546126190.body.wrapping_html": "string",
    "widgets.module_13885066546126190.exportToTemplateContext": "string",
    "widgets.module_13885066546126190.isGlobal": "string",
    "widgets.module_13885066546126190.label": "string",
    "widgets.module_13885066546126190.lineNumber": "string",
    "widgets.module_13885066546126190.name": "string",
    "widgets.module_13885066546126190.overrideable": "string",
    "widgets.module_13885066546126190.type": "string",
    "widgets.module_140605127917621669.body.value": "string",
    "widgets.module_140605127917621669.exportToTemplateContext": "string",
    "widgets.module_140605127917621669.isGlobal": "string",
    "widgets.module_140605127917621669.label": "string",
    "widgets.module_140605127917621669.lineNumber": "string",
    "widgets.module_140605127917621669.name": "string",
    "widgets.module_140605127917621669.overrideable": "string",
    "widgets.module_140605127917621669.type": "string"
}
    • schema_name_id: 2170
    • schema_scan_id: 6067144
    • updated: 2023-01-09 15:52:45
Schema Scans: 4
Last at 2023-02-09 09:27:41
    • duration: 0:00:13.377923
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6108978
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-09/1675956409",
        "key": "raw/hubspot_molo_landing_pages/2023-02-09/1675956409/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7649955569482856270,
        "service_name": "drive-thru",
        "span_id": 14748112125309032106,
        "trace_id": 9657324012519448946
    }
}
    • running: False
    • schema_name_id: 2170
    • start_time: 2023-02-09 09:27:41
    • success: True
    • trace_id: 9657324012519448946
    • duration: 0:00:13.324117
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6106937
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-08/1675875450",
        "key": "raw/hubspot_molo_landing_pages/2023-02-08/1675875450/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11700100962763307614,
        "service_name": "drive-thru",
        "span_id": 15942575590107893637,
        "trace_id": 13224583532211630487
    }
}
    • running: False
    • schema_name_id: 2170
    • start_time: 2023-02-08 11:02:02
    • success: True
    • trace_id: 13224583532211630487
    • duration: 0:00:13.283723
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6067198
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673303128",
        "key": "raw/hubspot_molo_landing_pages/2023-01-09/1673303128/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16288272145523217038,
        "service_name": "drive-thru",
        "span_id": 13509405528977678795,
        "trace_id": 922166051870342907
    }
}
    • running: False
    • schema_name_id: 2170
    • start_time: 2023-01-09 16:25:53
    • success: True
    • trace_id: 922166051870342907
    • duration: 0:00:13.343497
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6067144
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-01-09/1673301051",
        "key": "raw/hubspot_molo_landing_pages/2023-01-09/1673301051/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2298405439423739625,
        "service_name": "drive-thru",
        "span_id": 6548784140099920368,
        "trace_id": 7357277930204394709
    }
}
    • running: False
    • schema_name_id: 2170
    • start_time: 2023-01-09 15:52:32
    • success: True
    • trace_id: 7357277930204394709
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        "string"
    ],
    "authorName": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "htmlTitle": "string",
    "id": "string",
    "metaDescription": "string",
    "name": "string",
    "pageExpiryEnabled": "string",
    "pageRedirected": "string",
    "publicAccessRules": [
        "string"
    ],
    "publicAccessRulesEnabled": "string",
    "publishDate": "string",
    "publishImmediately": "string",
    "published": "string",
    "slug": "string",
    "state": "string",
    "subcategory": "string",
    "templatePath": "string",
    "updatedAt": "string",
    "updatedById": "string",
    "url": "string",
    "useFeaturedImage": "string",
    "widgetContainers.module_1395325301989437.label": "string",
    "widgetContainers.module_1395325301989437.lineNumber": "string",
    "widgetContainers.module_1395325301989437.name": "string",
    "widgetContainers.module_1395325301989437.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgetContainers.module_1395325309464440.label": "string",
    "widgetContainers.module_1395325309464440.lineNumber": "string",
    "widgetContainers.module_1395325309464440.name": "string",
    "widgetContainers.module_1395325309464440.widgets": [
        {
            "body.html": "string",
            "exportToTemplateContext": "string",
            "id": "string",
            "isGlobal": "string",
            "label": "string",
            "lineNumber": "string",
            "overrideable": "string",
            "type": "string"
        }
    ],
    "widgets.module_13885066546126190.body.form_to_use": "string",
    "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
    "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
        "string"
    ],
    "widgets.module_13885066546126190.body.tag": "string",
    "widgets.module_13885066546126190.body.title": "string",
    "widgets.module_13885066546126190.body.type": "string",
    "widgets.module_13885066546126190.body.wrapping_html": "string",
    "widgets.module_13885066546126190.exportToTemplateContext": "string",
    "widgets.module_13885066546126190.isGlobal": "string",
    "widgets.module_13885066546126190.label": "string",
    "widgets.module_13885066546126190.lineNumber": "string",
    "widgets.module_13885066546126190.name": "string",
    "widgets.module_13885066546126190.overrideable": "string",
    "widgets.module_13885066546126190.type": "string",
    "widgets.module_140605127917621669.body.value": "string",
    "widgets.module_140605127917621669.exportToTemplateContext": "string",
    "widgets.module_140605127917621669.isGlobal": "string",
    "widgets.module_140605127917621669.label": "string",
    "widgets.module_140605127917621669.lineNumber": "string",
    "widgets.module_140605127917621669.name": "string",
    "widgets.module_140605127917621669.overrideable": "string",
    "widgets.module_140605127917621669.type": "string"
}
  • created: 2023-02-09 09:27:43
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-09/1675956409'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2022-11-30 12:58:50",
        "disabled": false,
        "format": "raw",
        "id": 2170,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "hubspot_molo_landing_pages"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "archivedAt": "string",
            "archivedInDashboard": "string",
            "attachedStylesheets": [
                "string"
            ],
            "authorName": "string",
            "categoryId": "string",
            "contentTypeCategory": "string",
            "createdAt": "string",
            "createdById": "string",
            "currentState": "string",
            "deletedAt": "string",
            "domain": "string",
            "featuredImage": "string",
            "featuredImageAltText": "string",
            "htmlTitle": "string",
            "id": "string",
            "metaDescription": "string",
            "name": "string",
            "pageExpiryEnabled": "string",
            "pageRedirected": "string",
            "publicAccessRules": [
                "string"
            ],
            "publicAccessRulesEnabled": "string",
            "publishDate": "string",
            "publishImmediately": "string",
            "published": "string",
            "slug": "string",
            "state": "string",
            "subcategory": "string",
            "templatePath": "string",
            "updatedAt": "string",
            "updatedById": "string",
            "url": "string",
            "useFeaturedImage": "string",
            "widgetContainers.module_1395325301989437.label": "string",
            "widgetContainers.module_1395325301989437.lineNumber": "string",
            "widgetContainers.module_1395325301989437.name": "string",
            "widgetContainers.module_1395325301989437.widgets": [
                {
                    "body.html": "string",
                    "exportToTemplateContext": "string",
                    "id": "string",
                    "isGlobal": "string",
                    "label": "string",
                    "lineNumber": "string",
                    "overrideable": "string",
                    "type": "string"
                }
            ],
            "widgetContainers.module_1395325309464440.label": "string",
            "widgetContainers.module_1395325309464440.lineNumber": "string",
            "widgetContainers.module_1395325309464440.name": "string",
            "widgetContainers.module_1395325309464440.widgets": [
                {
                    "body.html": "string",
                    "exportToTemplateContext": "string",
                    "id": "string",
                    "isGlobal": "string",
                    "label": "string",
                    "lineNumber": "string",
                    "overrideable": "string",
                    "type": "string"
                }
            ],
            "widgets.module_13885066546126190.body.form_to_use": "string",
            "widgets.module_13885066546126190.body.notifications_are_overridden": "string",
            "widgets.module_13885066546126190.body.notifications_override_email_addresses": [
                "string"
            ],
            "widgets.module_13885066546126190.body.tag": "string",
            "widgets.module_13885066546126190.body.title": "string",
            "widgets.module_13885066546126190.body.type": "string",
            "widgets.module_13885066546126190.body.wrapping_html": "string",
            "widgets.module_13885066546126190.exportToTemplateContext": "string",
            "widgets.module_13885066546126190.isGlobal": "string",
            "widgets.module_13885066546126190.label": "string",
            "widgets.module_13885066546126190.lineNumber": "string",
            "widgets.module_13885066546126190.name": "string",
            "widgets.module_13885066546126190.overrideable": "string",
            "widgets.module_13885066546126190.type": "string",
            "widgets.module_140605127917621669.body.value": "string",
            "widgets.module_140605127917621669.exportToTemplateContext": "string",
            "widgets.module_140605127917621669.isGlobal": "string",
            "widgets.module_140605127917621669.label": "string",
            "widgets.module_140605127917621669.lineNumber": "string",
            "widgets.module_140605127917621669.name": "string",
            "widgets.module_140605127917621669.overrideable": "string",
            "widgets.module_140605127917621669.type": "string"
        },
        "created": "2023-02-09 09:27:43",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_landing_pages`\n(\n`archived`STRING,`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`STRING,`deletedAt`STRING,`domain`STRING,`featuredImage`STRING,`featuredImageAltText`STRING,`htmlTitle`STRING,`id`STRING,`name`STRING,`pageRedirected`STRING,`publicAccessRules`array,`publicAccessRulesEnabled`STRING,`publishDate`STRING,`published`STRING,`slug`STRING,`state`STRING,`subcategory`STRING,`templatePath`STRING,`updatedAt`STRING,`updatedById`STRING,`url`STRING,`useFeaturedImage`STRING,`widgetContainers`struct<`module_1395325301989437`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>,`module_1395325309464440`:struct<`label`:STRING,`lineNumber`:STRING,`name`:STRING,`widgets`:array,`exportToTemplateContext`:STRING,`id`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`overrideable`:STRING,`type`:STRING>>>>,`widgets`struct<`module_13885066546126190`:struct<`body`:struct<`form_to_use`:STRING,`notifications_are_overridden`:STRING,`notifications_override_email_addresses`:array,`tag`:STRING,`title`:STRING,`type`:STRING,`wrapping_html`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>,`module_140605127917621669`:struct<`body`:struct<`value`:STRING>,`exportToTemplateContext`:STRING,`isGlobal`:STRING,`label`:STRING,`lineNumber`:STRING,`name`:STRING,`overrideable`:STRING,`type`:STRING>>,`createdById`STRING,`metaDescription`STRING,`publishImmediately`STRING,`pageExpiryEnabled`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-drivethrujson-drivethru-dev/raw/hubspot_molo_landing_pages/2023-02-09/1675956409'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_landing_pages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_landing_pages"
        }
    },
    "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