Last updated: May 25, 2023
HubSpot's integration with Snowflake allows you to access all your HubSpot data in Snowflake. You can retrieve HubSpot data in Snowflake by running SQL queries. Learn more about querying HubSpot data in Snowflake.
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.
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.
The integration will then begin processing your HubSpot data. If you have larger amount of data, this process will take longer.
If you encounter the following error Share ‘HUBSPOT_PRODUCT.HUB_12345’ cannot be imported because the terms for the associated listing ‘GZSOZ4LK70’ in data exchange ‘SNOWFLAKE_DATA_MARKETPLACE’ have not been accepted, do the following:
Once connected, you can create a database in Snowflake for your HubSpot data:
Next, learn how to set up your Snowflake environment and query your HubSpot data.
HubSpot customers hosting data in all major AWS regions can install the data share integration. In addition, the integration supports Snowflake data with Google Cloud Platform (GCP) and Microsoft Azure. The list of supported regions include: