Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_landing_pages
  • created: 2022-12-01 13:34:41
  • disabled: False
  • format: raw
  • id: 1241
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "hubspot_molo_landing_pages"
}
  • type: drivethrujson
Schema Versions: 15
    • created: 2026-04-17 07:21:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-17/1776428508'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-17/1776428508
    • id: 1718118
    • 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: 1241
    • schema_scan_id: 162173158
    • updated: 2026-04-17 07:22:09
    • created: 2026-04-16 07:17:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-16/1776341829'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-16/1776341829
    • id: 1716890
    • 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: 1241
    • schema_scan_id: 162117413
    • updated: 2026-04-16 07:17:30
    • created: 2026-04-15 07:23:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-15/1776255771'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-15/1776255771
    • id: 1715701
    • 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: 1241
    • schema_scan_id: 162061889
    • updated: 2026-04-15 07:23:46
    • created: 2026-04-14 07:16:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-14/1776168967'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-14/1776168967
    • id: 1714500
    • 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: 1241
    • schema_scan_id: 162006447
    • updated: 2026-04-14 07:16:39
    • created: 2026-04-13 07:18:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-13/1776082636'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-13/1776082636
    • id: 1713278
    • 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: 1241
    • schema_scan_id: 161948404
    • updated: 2026-04-13 07:18:39
    • created: 2026-04-12 07:16:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-12/1775996173'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-12/1775996173
    • id: 1712098
    • 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: 1241
    • schema_scan_id: 161899593
    • updated: 2026-04-12 07:16:33
    • created: 2026-04-11 07:19:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-11/1775909692'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-11/1775909692
    • id: 1710882
    • 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: 1241
    • schema_scan_id: 161846915
    • updated: 2026-04-11 07:19:21
    • created: 2026-04-10 07:17:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-10/1775823468'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-10/1775823468
    • id: 1709699
    • 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: 1241
    • schema_scan_id: 161792143
    • updated: 2026-04-10 07:18:08
    • created: 2026-04-09 07:19:57
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-09/1775737183'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-09/1775737183
    • id: 1708555
    • 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: 1241
    • schema_scan_id: 161736326
    • updated: 2026-04-09 07:20:11
    • created: 2026-04-08 07:16:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-08/1775650587'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-08/1775650587
    • id: 1707369
    • 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: 1241
    • schema_scan_id: 161681496
    • updated: 2026-04-08 07:17:01
    • created: 2026-04-07 07:17:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-07/1775564235'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-07/1775564235
    • id: 1706173
    • 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: 1241
    • schema_scan_id: 161625265
    • updated: 2026-04-07 07:17:38
    • created: 2026-04-06 07:19:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-06/1775477953'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-06/1775477953
    • id: 1704965
    • 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: 1241
    • schema_scan_id: 161567413
    • updated: 2026-04-06 07:19:30
    • created: 2026-04-05 07:19:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-05/1775391582'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-05/1775391582
    • id: 1703729
    • 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: 1241
    • schema_scan_id: 161520028
    • updated: 2026-04-05 07:20:06
    • created: 2026-04-04 07:17:58
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-04/1775304911'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-04/1775304911
    • id: 1702596
    • 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: 1241
    • schema_scan_id: 161466491
    • updated: 2026-04-04 07:18:09
    • created: 2026-04-03 07:20:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-03/1775218803'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-03/1775218803
    • id: 1701397
    • 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: 1241
    • schema_scan_id: 161408657
    • updated: 2026-04-03 07:20:48
Schema Scans: 15
Last at 2026-04-17 07:21:51
    • duration: 0:00:17.300628
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173158
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-17/1776428508",
        "key": "raw/hubspot_molo_landing_pages/2026-04-17/1776428508/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13244710456897186056,
        "service_name": "drive-thru",
        "span_id": 17572328075019268724,
        "trace_id": 901348732042656729
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-17 07:21:51
    • success: True
    • trace_id: 901348732042656729
    • duration: 0:00:17.227305
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117413
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-16/1776341829",
        "key": "raw/hubspot_molo_landing_pages/2026-04-16/1776341829/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2989460771154703979,
        "service_name": "drive-thru",
        "span_id": 5775505174543476619,
        "trace_id": 11760627095149926213
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-16 07:17:13
    • success: True
    • trace_id: 11760627095149926213
    • duration: 0:00:17.079818
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061889
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-15/1776255771",
        "key": "raw/hubspot_molo_landing_pages/2026-04-15/1776255771/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16209701415247899866,
        "service_name": "drive-thru",
        "span_id": 14172280024412738705,
        "trace_id": 8477835299521638811
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-15 07:23:29
    • success: True
    • trace_id: 8477835299521638811
    • duration: 0:00:14.751422
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006447
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-14/1776168967",
        "key": "raw/hubspot_molo_landing_pages/2026-04-14/1776168967/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9776056666120677716,
        "service_name": "drive-thru",
        "span_id": 17487229452290377156,
        "trace_id": 8885349888504648879
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-14 07:16:25
    • success: True
    • trace_id: 8885349888504648879
    • duration: 0:00:17.048724
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948404
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-13/1776082636",
        "key": "raw/hubspot_molo_landing_pages/2026-04-13/1776082636/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6495926984803703681,
        "service_name": "drive-thru",
        "span_id": 5034888240324888037,
        "trace_id": 11974614023748109336
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-13 07:18:22
    • success: True
    • trace_id: 11974614023748109336
    • duration: 0:00:14.474088
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899593
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-12/1775996173",
        "key": "raw/hubspot_molo_landing_pages/2026-04-12/1775996173/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9256741795623165319,
        "service_name": "drive-thru",
        "span_id": 3103837602826800896,
        "trace_id": 12917884580462660064
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-12 07:16:19
    • success: True
    • trace_id: 12917884580462660064
    • duration: 0:00:16.921060
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846915
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-11/1775909692",
        "key": "raw/hubspot_molo_landing_pages/2026-04-11/1775909692/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11957502762992323316,
        "service_name": "drive-thru",
        "span_id": 1209603223055173490,
        "trace_id": 14579839376581069885
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-11 07:19:04
    • success: True
    • trace_id: 14579839376581069885
    • duration: 0:00:17.200908
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792143
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-10/1775823468",
        "key": "raw/hubspot_molo_landing_pages/2026-04-10/1775823468/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15253742536586724380,
        "service_name": "drive-thru",
        "span_id": 15529512607204869325,
        "trace_id": 15676544763215503844
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-10 07:17:51
    • success: True
    • trace_id: 15676544763215503844
    • duration: 0:00:17.004557
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736326
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-09/1775737183",
        "key": "raw/hubspot_molo_landing_pages/2026-04-09/1775737183/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2157541978744898728,
        "service_name": "drive-thru",
        "span_id": 5228811062634866439,
        "trace_id": 2329838379099415030
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-09 07:19:54
    • success: True
    • trace_id: 2329838379099415030
    • duration: 0:00:17.113348
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681496
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-08/1775650587",
        "key": "raw/hubspot_molo_landing_pages/2026-04-08/1775650587/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6646783345885052674,
        "service_name": "drive-thru",
        "span_id": 4318487646730327036,
        "trace_id": 3798871512334096992
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-08 07:16:44
    • success: True
    • trace_id: 3798871512334096992
    • duration: 0:00:16.892051
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625265
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-07/1775564235",
        "key": "raw/hubspot_molo_landing_pages/2026-04-07/1775564235/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11144100472972738231,
        "service_name": "drive-thru",
        "span_id": 4485101290482534590,
        "trace_id": 11334453813661118107
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-07 07:17:22
    • success: True
    • trace_id: 11334453813661118107
    • duration: 0:00:14.577646
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567413
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-06/1775477953",
        "key": "raw/hubspot_molo_landing_pages/2026-04-06/1775477953/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6800548250957233741,
        "service_name": "drive-thru",
        "span_id": 11683974294773093686,
        "trace_id": 8541409891793527063
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-06 07:19:15
    • success: True
    • trace_id: 8541409891793527063
    • duration: 0:00:17.115376
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161520028
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-05/1775391582",
        "key": "raw/hubspot_molo_landing_pages/2026-04-05/1775391582/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9170540504955726479,
        "service_name": "drive-thru",
        "span_id": 1872817296968141652,
        "trace_id": 14442927530541886051
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-05 07:19:49
    • success: True
    • trace_id: 14442927530541886051
    • duration: 0:00:14.448715
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466491
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-04/1775304911",
        "key": "raw/hubspot_molo_landing_pages/2026-04-04/1775304911/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6493764407773468812,
        "service_name": "drive-thru",
        "span_id": 10930971255339649532,
        "trace_id": 295053515174843283
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-04 07:17:55
    • success: True
    • trace_id: 295053515174843283
    • duration: 0:00:14.469142
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408657
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_landing_pages/2026-04-03/1775218803",
        "key": "raw/hubspot_molo_landing_pages/2026-04-03/1775218803/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_landing_pages",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9861096776329830907,
        "service_name": "drive-thru",
        "span_id": 3320841076003109493,
        "trace_id": 10118317015027870731
    }
}
    • running: False
    • schema_name_id: 1241
    • start_time: 2026-04-03 07:20:33
    • success: True
    • trace_id: 10118317015027870731
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:21:55
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-17/1776428508'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-12-01 13:34:41",
        "disabled": false,
        "format": "raw",
        "id": 1241,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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:21:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_landing_pages/2026-04-17/1776428508'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_landing_pages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_landing_pages"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform