@Arran Thanks for the feedback - we will take this into consideration. No shareable plans to build integrations with these warehouses at the moment, but you are certainly not alone in this feedback! If you have other thoughts on Snowflake vs. Redshift vs. BigQuery let us know.
This is a topic that we have been looking into as well. I would be curious what you ended up doing?
We are wanting to pull HubSpot data into a Data Lake like Snowflake or Domo, and then Transform that data with our other marketing channels and our finance department to better identify marketing campaigns needs in advance.
Domo has a built in connector, but the overall platform is pricey, I like the idea of Snowflake because the costs are much lower and variable.
I would appreciate other resources from anyone that might be able to provide some insight.
I checked our HubSpot App Marketplace and it looks like there is an integration from Census that can sync your data from Snowflake to HubSpot. You can find it here.
Outside of our App Marketplace, I did a little searching and found that Stitch, Automate.io, and Xplentyalso created their own integrations between the two platforms.
If you're looking to create a custom integration, you'll want to check out our API overview and see what endpoints would best suit the type of data you would like to sync over. For example, you could usethis endpointto create a new contact in HubSpot.