Skip to content
Integrations

Connect the Snowflake Data Share integration

Last updated: August 12, 2022

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 available to all Snowflake account regions, and will be regularly updated to support newly added regions.
    • To check the region of your Snowflake account, run the following command in Snowflake: SELECT CURRENT_REGION();. The command will return your account region, such as AWS_US_EAST_1 . Learn more about this command in Snowflake’s documentation.

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.

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.