Skip to content
Integrations

Connect the Snowflake Data Share integration

Last updated: November 1, 2021

Applies to:

Operations Hub Enterprise

HubSpot's integration with Snowflake allows you to access all your HubSpot data in Snowflake.

Using Snowflake Data Sharing, you can retrieve HubSpot data In Snowflake by running SQL queries. Learn more about querying HubSpot data in Snowflake.

Requirements

  • To use this feature, you must have an active Snowflake account. If you do not currently have an account, you can sign up for one on Snowflake's website. You will be responsible for all Snowflake costs incurred while accessing HubSpot’s Data Share. Please see Snowflake’s Terms of Service for more information and pricing details

  • HubSpot’s integration with Snowflake Data Sharing is currently available only if your Snowflake account region matches the region of HubSpot’s Snowflake account. For HubSpot accounts in the EU data center, this means EU_CENTRAL_1_AWS. For all other HubSpot accounts, this means US_EAST_1_AWS.

Set up the integration

  • In your HubSpot account, click the Marketplace icon marketplace in the main navigation bar.
  • Click App Marketplace.
  • Use the search bar to locate and select the Snowflake integration.
  • In the upper right, click Install app.
  • Click the Snowflake account region dropdown menu, then select your Snowflake account region. Then, in the Snowflake account name field, enter your Snowflake account name.
    • To find your account details, navigate to your Snowflake account, then run the following commands:
      • To find your account name, run: SELECT CURRENT_ACCOUNT();
      • To find your account region, run: SELECT CURRENT_REGION(); 

snowflake-create-database-setup2
  • Click Install.  
  • In the dialog box, click Allow and install.
The integration will then begin processing your HubSpot data. If you have larger amount of data, this process will take longer.

Create a database in Snowflake

Once connected, you can create a database in Snowflake for your HubSpot data:

  • In Snowflake, navigate to Shares

    snowflake-create-database-create-share0
  • Click the HubSpot share you just connected, then click Create Database From Secure Share.
    snowflake-create-database-setup1
  • In the dialog box, configure the database details:
    • In the Database name field, enter a name for the database.
    • Click the Grant access to dropdown menu and select the roles that will be able to access the database. 

      snowflake-create-database-setup2
  • Click Create database.
  • Click the Snowflake icon in the top left of your account to return to the main screen. Then click the Refresh icon to display your new database. 

    snowflake-worksheet-refresh-databases0

Next, learn how to set up your Snowflake environment and query your HubSpot data.