Hubspot (Sales) to Snowflake
Last published
2024-05-20
Categories
Sales Crm
Integrates with
The Hubspot Kit combines data from multiple entities in the Hubspot API and provides a full data model for Hubspot Sales.
This kit includes
- Data ingestion from the following Hubspot entities:
- Logic that orchestrates and transforms raw Hubspot data to create a data model for easier consumption downstream
Minimum RPU Consumption: 6
Configuring this kit for use
Variables
In this Kit, there are three variables that are used to make for dynamic use of target configuration.
- {DB_Hubspot} is used in all Target configurations and queries as the target database name.
- {SCHEMA_Hubspot} is used in all Target configurations and queries as the target schema name.
Go to the Variables menu on the left side navigation bar and create variables for DB_Hubspot and SCHEMA_Hubspot. Then fill in the values as the Snowflake database and schema where you would like the data to land.
Connections
If there are already Connections for Hubspot and Snowflake, import these by following the Kit wizard after clicking 'Use Kit'. Otherwise, Kits are imported with ‘blank’ source and target connections. In this case, in order to use the kit, you have two options:
- Swap out blank connections with existing connections
- Add credentials to the blank connections that come with the imported Kit
