Connect Hubspot to Snowflake Data Share

Connecting Hubspot to Snowflake with the HubSpot Data Share feature lets you access analytics data directly in your cloud data warehouse. This guide walks you through prerequisites, activation, and safe use of the integration so your team can run advanced reporting and modeling on reliable event data.

What is the Hubspot Snowflake data share?

The HubSpot Data Share is a managed connection that exposes your analytics events from Hubspot directly into a Snowflake account you control. It is not a traditional ETL pipeline. Instead, Snowflake uses its secure data sharing capabilities so you can query near real-time data without copying it into another system.

With this data share, you can:

• Join Hubspot analytics with other business data in Snowflake.
• Build custom dashboards and models in BI tools on top of Snowflake.
• Avoid maintaining complex sync jobs for raw event data.

The integration is designed for read-only access. You query the data in Snowflake and keep Hubspot as the source of truth for marketing and CRM events.

Prerequisites for connecting Hubspot and Snowflake

Before you create the HubSpot Data Share, make sure your account and Snowflake environment meet these requirements.

Hubspot account requirements

• You must have an eligible Hubspot subscription that includes the Snowflake data share feature.
• You need Super Admin or equivalent permissions to access data management and integrations settings.
• Analytics tracking must be correctly installed on your site, and event data should already be flowing into Hubspot.

Snowflake account requirements

• A Snowflake account in a supported cloud region.
• Role-based access control configured so a designated role can create and manage database objects for the share.
• Network and security policies aligned with your organization’s standards.

Your data team or Snowflake administrator should confirm these items before you start configuring anything from the Hubspot side.

How to enable the Hubspot Snowflake data share

Once your prerequisites are in place, follow these steps to activate the connection and accept the data share inside Snowflake.

Step 1: Start the setup in Hubspot

1. Sign in to your Hubspot account with a user that has the necessary admin permissions.
2. Navigate to your settings area and open the section that manages data exports or data shares.
3. Locate the HubSpot Data Share for Snowflake option and click to start the configuration workflow.

During this first step, Hubspot will ask you to confirm that you want to expose analytics data to Snowflake and present any applicable usage terms.

Step 2: Configure Snowflake details in Hubspot

Within the setup wizard, you provide the Snowflake account information needed to create the share. Typically this includes:

• Your Snowflake account name and region identifier.
• The Snowflake role that should own the database created from the share.
• The default warehouse you want to use when running queries.

After you submit this information, Hubspot will create a secure data share in Snowflake tied to your account. You will then complete the remaining tasks directly in Snowflake.

Step 3: Accept the data share in Snowflake

Log in to Snowflake with the admin or role specified during setup. Then:

1. Locate the incoming share that corresponds to your HubSpot Data Share. It will appear under the list of available data shares in Snowflake.
2. Create a database from the share so you can query the shared objects.
3. Grant usage and read permissions on this database to the roles or users who need access to Hubspot analytics data.

Once the database is created and permissions are applied, you can test access by running a simple query against one of the shared tables.

Understanding the Hubspot data available in Snowflake

The HubSpot Data Share focuses on analytics event data. This may include page views, sessions, and engagement events that Hubspot has collected from your tracked assets.

Typical characteristics of the shared data include:

• Read-only tables managed by Hubspot, not by your internal team.
• Columns for event identifiers, timestamps, URLs, visitor or contact references, and performance metrics.
• Schema changes controlled by Hubspot, with updates communicated through product documentation.

Use this dataset as the foundation for modeling marketing attribution, funnel performance, and cross-channel engagement when combined with your other Snowflake-hosted sources.

Manage permissions for Hubspot data in Snowflake

Proper role configuration is critical for keeping Hubspot analytics secure while still enabling flexible access for analysts and stakeholders.

Recommended permission strategy

• Create a dedicated database in Snowflake from the HubSpot Data Share.
• Assign a steward role that can manage grants on this database.
• Grant USAGE on the database and SELECT on the schemas and tables to analyst roles.
• Avoid granting write permissions, as shared objects from Hubspot should remain immutable.

By separating steward and analyst roles, you maintain centralized control while keeping day-to-day access friction low.

Aligning Hubspot permissions with internal policies

Work with your security and governance teams to ensure that Snowflake roles accessing Hubspot data meet your internal compliance rules. Consider:

• Limiting access to sensitive event fields that may contain personal identifiers.
• Applying row-level or column-level security in downstream views where appropriate.
• Documenting who has access to the Hubspot analytics database and why.

This approach helps you respect privacy and regulatory requirements while still leveraging rich analytics data from Hubspot.

Best practices for using Hubspot analytics in Snowflake

Once the integration is live, you can build robust analytics pipelines around the data share.

• Create semantic views that join Hubspot event tables with CRM, sales, and product usage data.
• Schedule materialized views or downstream tables for dashboards in BI tools.
• Monitor query performance and costs to ensure your chosen warehouse size is appropriate.
• Document the key tables, fields, and relationships derived from the Hubspot share.

Keeping a clear data catalog makes it easier for new analysts and business users to explore the Hubspot dataset confidently.

Where to find official Hubspot Snowflake documentation

For the most detailed and current configuration instructions, always refer to the official product documentation. The authoritative guide for this integration is available on the Hubspot knowledge base at Connect Snowflake data share. Review it regularly for any changes to supported regions, schema definitions, or permission recommendations.

Get expert help with your Hubspot data stack

If you need assistance designing an end-to-end analytics architecture around Hubspot and Snowflake, consider working with experienced consultants. The team at Consultevo helps organizations connect CRM and marketing data, build scalable models in Snowflake, and optimize reporting workflows across tools.

By combining Hubspot’s rich analytics data with Snowflake’s scalable warehouse and sound governance practices, you can create a reliable foundation for advanced marketing and revenue analytics across your entire organization.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`