Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_landing_pages
  • created: 2022-11-30 13:40:25
  • disabled: False
  • format: raw
  • id: 1510
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_drivethru",
    "table": "hubspot_molo_landing_pages"
}
  • type: drivethrujson
Schema Versions: 15
    • created: 2026-04-17 07:18:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-17/1776428295'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-17/1776428295
    • id: 906670
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6415287
    • updated: 2026-04-17 07:18:42
    • created: 2026-04-16 07:13:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-16/1776341605'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-16/1776341605
    • id: 906452
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6414739
    • updated: 2026-04-16 07:14:10
    • created: 2026-04-15 07:20:02
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-15/1776255582'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-15/1776255582
    • id: 906242
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6414254
    • updated: 2026-04-15 07:20:16
    • created: 2026-04-14 07:16:58
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-14/1776168971'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-14/1776168971
    • id: 906032
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6413766
    • updated: 2026-04-14 07:17:12
    • created: 2026-04-13 07:19:09
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-13/1776082700'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-13/1776082700
    • id: 905813
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6413208
    • updated: 2026-04-13 07:19:20
    • created: 2026-04-12 07:15:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-12/1775996126'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-12/1775996126
    • id: 905605
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6412789
    • updated: 2026-04-12 07:15:54
    • created: 2026-04-11 07:14:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-11/1775909633'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-11/1775909633
    • id: 905411
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6412418
    • updated: 2026-04-11 07:14:50
    • created: 2026-04-10 07:12:23
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-10/1775823131'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-10/1775823131
    • id: 905195
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6411942
    • updated: 2026-04-10 07:12:37
    • created: 2026-04-09 07:11:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-09/1775736694'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-09/1775736694
    • id: 904977
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6411424
    • updated: 2026-04-09 07:12:01
    • created: 2026-04-08 07:13:44
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-08/1775650402'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-08/1775650402
    • id: 904768
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6410926
    • updated: 2026-04-08 07:13:55
    • created: 2026-04-07 07:17:09
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-07/1775564173'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-07/1775564173
    • id: 904552
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6410415
    • updated: 2026-04-07 07:17:20
    • created: 2026-04-06 07:18:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-06/1775477870'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-06/1775477870
    • id: 904336
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6409866
    • updated: 2026-04-06 07:18:24
    • created: 2026-04-05 07:13:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-05/1775391166'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-05/1775391166
    • id: 904136
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6409463
    • updated: 2026-04-05 07:13:39
    • created: 2026-04-04 07:14:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-04/1775304858'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-04/1775304858
    • id: 903932
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6409082
    • updated: 2026-04-04 07:15:48
    • created: 2026-04-03 07:16:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-03/1775218580'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-03/1775218580
    • id: 903716
    • processed: 1
    • raw_data: 
      {
    "archivedAt": "1970-01-01T00:00:00Z",
    "archivedInDashboard": false,
    "attachedStylesheets": [
        {
            "id": 185342930441,
            "path": "Marine Copy/child.css",
            "type": "cos_extension_resource"
        }
    ],
    "authorName": "Heather Lopes",
    "campaign": "e90616f3-ed20-44d0-a9e6-f84d97b99e6a",
    "categoryId": 1,
    "contentTypeCategory": 1,
    "createdAt": "2022-09-15T13:53:27.930Z",
    "createdById": "44691737",
    "currentState": "PUBLISHED",
    "domain": "",
    "featuredImage": "",
    "featuredImageAltText": "",
    "headHtml": "",
    "htmlTitle": "Streamline your Marina",
    "id": "85047345222",
    "language": "en",
    "layoutSections": {},
    "linkRelCanonicalUrl": "",
    "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",
    "themeSettingsValues": {
        "forms_and_btns": {
            "button_bg_color": {
                "color": "#FFC658",
                "opacity": 100
            },
            "button_border_radius": 30,
            "button_text_color": {
                "color": "#141b4d",
                "opacity": 100
            }
        },
        "typography": {
            "body_font": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "size": {
                    "units": "px",
                    "value": 22
                },
                "styles": {},
                "variant": "regular"
            },
            "hx": {
                "color": "#141b4d",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link": {
                "color": "#009cb6",
                "fallback": "sans-serif",
                "font": "DM Sans",
                "font_set": "GOOGLE",
                "styles": {},
                "variant": "regular"
            },
            "link_active_color": {
                "color": "#65AEC1",
                "opacity": 100
            },
            "link_hover_color": {
                "color": "#009CB6",
                "opacity": 100
            },
            "link_visited_color": {
                "color": "#FFC658",
                "opacity": 100
            }
        }
    },
    "translations": {},
    "updatedAt": "2020-03-12T19:09:46.707Z",
    "updatedById": "100",
    "url": "https://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": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 1510
    • schema_scan_id: 6408606
    • updated: 2026-04-03 07:16:44
Schema Scans: 15
Last at 2026-04-17 07:18:27
    • duration: 0:00:15.032023
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6415287
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-17/1776428295",
        "key": "raw/hubspot_molo_landing_pages/2026-04-17/1776428295/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9442546706540009949,
        "service_name": "drive-thru",
        "span_id": 16361347453623280469,
        "trace_id": 10796583003129885733
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-17 07:18:27
    • success: True
    • trace_id: 10796583003129885733
    • duration: 0:00:15.151671
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414739
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-16/1776341605",
        "key": "raw/hubspot_molo_landing_pages/2026-04-16/1776341605/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4226863919431780202,
        "service_name": "drive-thru",
        "span_id": 13084044172245130942,
        "trace_id": 7985489086004209168
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-16 07:13:55
    • success: True
    • trace_id: 7985489086004209168
    • duration: 0:00:18.756164
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414254
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-15/1776255582",
        "key": "raw/hubspot_molo_landing_pages/2026-04-15/1776255582/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1112649931621031169,
        "service_name": "drive-thru",
        "span_id": 862733065260584495,
        "trace_id": 11811632600020473039
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-15 07:19:58
    • success: True
    • trace_id: 11811632600020473039
    • duration: 0:00:17.397593
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413766
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-14/1776168971",
        "key": "raw/hubspot_molo_landing_pages/2026-04-14/1776168971/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11389802529292736868,
        "service_name": "drive-thru",
        "span_id": 5844885419501408101,
        "trace_id": 8027612794720171833
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-14 07:16:54
    • success: True
    • trace_id: 8027612794720171833
    • duration: 0:00:14.615461
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413208
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-13/1776082700",
        "key": "raw/hubspot_molo_landing_pages/2026-04-13/1776082700/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14575573273619689698,
        "service_name": "drive-thru",
        "span_id": 16853364284609441014,
        "trace_id": 7762542269013831625
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-13 07:19:05
    • success: True
    • trace_id: 7762542269013831625
    • duration: 0:00:17.344402
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412789
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-12/1775996126",
        "key": "raw/hubspot_molo_landing_pages/2026-04-12/1775996126/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5662333047778225922,
        "service_name": "drive-thru",
        "span_id": 13683612122039269041,
        "trace_id": 12897373861220291814
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-12 07:15:37
    • success: True
    • trace_id: 12897373861220291814
    • duration: 0:00:17.134540
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412418
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-11/1775909633",
        "key": "raw/hubspot_molo_landing_pages/2026-04-11/1775909633/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16543581854023755581,
        "service_name": "drive-thru",
        "span_id": 6971777963593942291,
        "trace_id": 6279682704499674495
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-11 07:14:33
    • success: True
    • trace_id: 6279682704499674495
    • duration: 0:00:17.185206
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411942
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-10/1775823131",
        "key": "raw/hubspot_molo_landing_pages/2026-04-10/1775823131/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11262956290508899729,
        "service_name": "drive-thru",
        "span_id": 17886738903526549009,
        "trace_id": 14353718504216253771
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-10 07:12:19
    • success: True
    • trace_id: 14353718504216253771
    • duration: 0:00:14.915318
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411424
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-09/1775736694",
        "key": "raw/hubspot_molo_landing_pages/2026-04-09/1775736694/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7961294773839963346,
        "service_name": "drive-thru",
        "span_id": 17454616161054399990,
        "trace_id": 9570532400462700924
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-09 07:11:47
    • success: True
    • trace_id: 9570532400462700924
    • duration: 0:00:14.949434
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410926
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-08/1775650402",
        "key": "raw/hubspot_molo_landing_pages/2026-04-08/1775650402/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1308072070238915339,
        "service_name": "drive-thru",
        "span_id": 8796454960091921782,
        "trace_id": 7954961432265738656
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-08 07:13:40
    • success: True
    • trace_id: 7954961432265738656
    • duration: 0:00:15.184708
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410415
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-07/1775564173",
        "key": "raw/hubspot_molo_landing_pages/2026-04-07/1775564173/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15610416045892465192,
        "service_name": "drive-thru",
        "span_id": 3758274214251062373,
        "trace_id": 2613036981004140297
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-07 07:17:05
    • success: True
    • trace_id: 2613036981004140297
    • duration: 0:00:17.422515
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409866
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-06/1775477870",
        "key": "raw/hubspot_molo_landing_pages/2026-04-06/1775477870/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11130891834674523195,
        "service_name": "drive-thru",
        "span_id": 2914118020281501051,
        "trace_id": 3989279926945233934
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-06 07:18:07
    • success: True
    • trace_id: 3989279926945233934
    • duration: 0:00:17.428963
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409463
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-05/1775391166",
        "key": "raw/hubspot_molo_landing_pages/2026-04-05/1775391166/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2337575830521389450,
        "service_name": "drive-thru",
        "span_id": 10829857277045212829,
        "trace_id": 12628064689340101416
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-05 07:13:21
    • success: True
    • trace_id: 12628064689340101416
    • duration: 0:01:13.663311
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409082
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-04/1775304858",
        "key": "raw/hubspot_molo_landing_pages/2026-04-04/1775304858/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4611163980913939271,
        "service_name": "drive-thru",
        "span_id": 3675278076773037838,
        "trace_id": 5444371715437176811
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-04 07:14:35
    • success: True
    • trace_id: 5444371715437176811
    • duration: 0:00:14.928174
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408606
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_landing_pages/2026-04-03/1775218580",
        "key": "raw/hubspot_molo_landing_pages/2026-04-03/1775218580/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3780427418251951512,
        "service_name": "drive-thru",
        "span_id": 16419130267814346064,
        "trace_id": 16928745596555613163
    }
}
    • running: False
    • schema_name_id: 1510
    • start_time: 2026-04-03 07:16:29
    • success: True
    • trace_id: 16928745596555613163
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "archivedAt": "string",
    "archivedInDashboard": "string",
    "attachedStylesheets": [
        {
            "id": "string",
            "path": "string",
            "type": "string"
        }
    ],
    "authorName": "string",
    "campaign": "string",
    "categoryId": "string",
    "contentTypeCategory": "string",
    "createdAt": "string",
    "createdById": "string",
    "currentState": "string",
    "deletedAt": "string",
    "domain": "string",
    "featuredImage": "string",
    "featuredImageAltText": "string",
    "headHtml": "string",
    "htmlTitle": "string",
    "id": "string",
    "language": "string",
    "linkRelCanonicalUrl": "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",
    "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
    "themeSettingsValues.forms_and_btns.button_border_radius": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
    "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
    "themeSettingsValues.typography.body_font.color": "string",
    "themeSettingsValues.typography.body_font.fallback": "string",
    "themeSettingsValues.typography.body_font.font": "string",
    "themeSettingsValues.typography.body_font.font_set": "string",
    "themeSettingsValues.typography.body_font.size.units": "string",
    "themeSettingsValues.typography.body_font.size.value": "string",
    "themeSettingsValues.typography.body_font.variant": "string",
    "themeSettingsValues.typography.hx.color": "string",
    "themeSettingsValues.typography.hx.fallback": "string",
    "themeSettingsValues.typography.hx.font": "string",
    "themeSettingsValues.typography.hx.font_set": "string",
    "themeSettingsValues.typography.hx.variant": "string",
    "themeSettingsValues.typography.link.color": "string",
    "themeSettingsValues.typography.link.fallback": "string",
    "themeSettingsValues.typography.link.font": "string",
    "themeSettingsValues.typography.link.font_set": "string",
    "themeSettingsValues.typography.link.variant": "string",
    "themeSettingsValues.typography.link_active_color.color": "string",
    "themeSettingsValues.typography.link_active_color.opacity": "string",
    "themeSettingsValues.typography.link_hover_color.color": "string",
    "themeSettingsValues.typography.link_hover_color.opacity": "string",
    "themeSettingsValues.typography.link_visited_color.color": "string",
    "themeSettingsValues.typography.link_visited_color.opacity": "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: 2026-04-17 07:18:30
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-17/1776428295'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-11-30 13:40:25",
        "disabled": false,
        "format": "raw",
        "id": 1510,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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": [
                {
                    "id": "string",
                    "path": "string",
                    "type": "string"
                }
            ],
            "authorName": "string",
            "campaign": "string",
            "categoryId": "string",
            "contentTypeCategory": "string",
            "createdAt": "string",
            "createdById": "string",
            "currentState": "string",
            "deletedAt": "string",
            "domain": "string",
            "featuredImage": "string",
            "featuredImageAltText": "string",
            "headHtml": "string",
            "htmlTitle": "string",
            "id": "string",
            "language": "string",
            "linkRelCanonicalUrl": "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",
            "themeSettingsValues.forms_and_btns.button_bg_color.color": "string",
            "themeSettingsValues.forms_and_btns.button_bg_color.opacity": "string",
            "themeSettingsValues.forms_and_btns.button_border_radius": "string",
            "themeSettingsValues.forms_and_btns.button_text_color.color": "string",
            "themeSettingsValues.forms_and_btns.button_text_color.opacity": "string",
            "themeSettingsValues.typography.body_font.color": "string",
            "themeSettingsValues.typography.body_font.fallback": "string",
            "themeSettingsValues.typography.body_font.font": "string",
            "themeSettingsValues.typography.body_font.font_set": "string",
            "themeSettingsValues.typography.body_font.size.units": "string",
            "themeSettingsValues.typography.body_font.size.value": "string",
            "themeSettingsValues.typography.body_font.variant": "string",
            "themeSettingsValues.typography.hx.color": "string",
            "themeSettingsValues.typography.hx.fallback": "string",
            "themeSettingsValues.typography.hx.font": "string",
            "themeSettingsValues.typography.hx.font_set": "string",
            "themeSettingsValues.typography.hx.variant": "string",
            "themeSettingsValues.typography.link.color": "string",
            "themeSettingsValues.typography.link.fallback": "string",
            "themeSettingsValues.typography.link.font": "string",
            "themeSettingsValues.typography.link.font_set": "string",
            "themeSettingsValues.typography.link.variant": "string",
            "themeSettingsValues.typography.link_active_color.color": "string",
            "themeSettingsValues.typography.link_active_color.opacity": "string",
            "themeSettingsValues.typography.link_hover_color.color": "string",
            "themeSettingsValues.typography.link_hover_color.opacity": "string",
            "themeSettingsValues.typography.link_visited_color.color": "string",
            "themeSettingsValues.typography.link_visited_color.opacity": "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": "2026-04-17 07:18:30",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_landing_pages`\n(\n`archivedAt`STRING,`archivedInDashboard`STRING,`attachedStylesheets`array>,`authorName`STRING,`categoryId`STRING,`contentTypeCategory`STRING,`createdAt`STRING,`currentState`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,`linkRelCanonicalUrl`STRING,`campaign`STRING,`headHtml`STRING,`language`STRING,`themeSettingsValues`struct<`forms_and_btns`:struct<`button_bg_color`:struct<`color`:STRING,`opacity`:STRING>,`button_border_radius`:STRING,`button_text_color`:struct<`color`:STRING,`opacity`:STRING>>,`typography`:struct<`body_font`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`size`:struct<`units`:STRING,`value`:STRING>,`variant`:STRING>,`hx`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link`:struct<`color`:STRING,`fallback`:STRING,`font`:STRING,`font_set`:STRING,`variant`:STRING>,`link_active_color`:struct<`color`:STRING,`opacity`:STRING>,`link_hover_color`:struct<`color`:STRING,`opacity`:STRING>,`link_visited_color`:struct<`color`:STRING,`opacity`: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-stage/raw/hubspot_molo_landing_pages/2026-04-17/1776428295'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_landing_pages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_landing_pages"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform