Last updated: November 1, 2021
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.
- To check your HubSpot account region, navigate to your account & billing settings.
- 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.
- To connect the integration, you must be a super admin or have App Marketplace permissions in your HubSpot account.
Set up the integration
- In your HubSpot account, click the Marketplace icon 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();
- To find your account name, run:
- To find your account details, navigate to your Snowflake account, then run the following commands:
- Click Install.
- In the dialog box, click Allow and install.
Create a database in Snowflake
Once connected, you can create a database in Snowflake for your HubSpot data:
- In Snowflake, navigate to Shares.
- Click the HubSpot share you just connected, then click Create Database From Secure Share.
- 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.
- 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.
Next, learn how to set up your Snowflake environment and query your HubSpot data.
