All HubSpot editions
Works with HubSpot Starter, Professional, and Enterprise. All custom objects and properties included.
HubSpot Metabase Connector
Connect HubSpot to Metabase and sync 100+ data tables automatically — contacts, deals, campaigns, tickets, custom objects, and more. Point-and-click setup.
CONNECT TO METABASE
What is the HubSpot Metabase Connector?
The HubSpot Metabase Connector automatically syncs your HubSpot data into Metabase with three clicks. Build dynamic dashboards and reports with HubSpot data with ease.
Our service automatically provisions you with a 4 Vcore Azure SQL database, creates all the tables and schemas, then keeps them in sync on your chosen schedule. Connect HubSpot to Metabase in minutes — no ETL engineers or custom code required.
Works with HubSpot Starter, Professional, and Enterprise. All custom objects and properties included.
Metabase’s point-and-click query builder lets your sales and marketing teams build dashboards without writing SQL.
Access all 100+ tables and unlimited records for one flat monthly fee. No pay-per-record pricing.
Metabase is free to self-host under AGPL. Works equally well with Metabase Cloud, Pro, and Enterprise editions.
Data coverage
Every Metabase Connector subscription includes the complete HubSpot data model — contacts, deals, marketing campaigns, service tickets, commerce, web analytics, custom objects, and more. All tables include your custom HubSpot properties.
All tables include custom properties. Read the full table definitions here.
How it works
No ETL engineers. No coding. Point-and-click setup that takes under 5 minutes.
Authenticate your HubSpot portal via OAuth. Super Admin access required. Takes under two minutes.
Start your trial and add your provisioned database as a data source inside Metabase. Full setup instructions are available here.
Use Metabase’s point-and-click query builder or SQL editor to create dashboards. Set up automated alerts and share reports across your team via email or Slack.
Your HubSpot data should be in Metabase — not stuck in the platform.
Frequently asked questions
Everything you need to know before getting started.
A connector that automatically syncs your HubSpot CRM data into Metabase. 100+ tables, unlimited records, fixed price.
Datawarehouse.io syncs your HubSpot data into a dedicated Azure SQL database. You then connect Metabase to that database using the built-in SQL Database connector, select your tables, and build reports.
Your sync frequency depends on your plan: Lite syncs every 24 hours, Standard every 6 hours, Advanced every hour, and Max every 15 minutes. Standard, Advanced, and Max users can also set their preferred sync time.
Yes. Datawarehouse.io apps support more than just HubSpot as a data source. Additional sources such as Google Ads and LinkedIn Ads are available and included in your subscription.
Yes. All Datawarehouse.io apps allow you to add other users to your account or database. Users can be added in seconds through our self service user interface.
Yes. SOC 2 certified and GDPR compliant. All data is encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. Data is processed in Azure EU West or North America depending on your billing region.
Yes. Users on the Standard (6-hour), Advanced (1-hour), and Max (15-minute) plans can set their preferred sync time from the user panel.
Yes. Our apps have been independently reviewed by HubSpot and have met their standards for security and technical quality.
Yes. A 14-day free trial is available. A free Metabase dashboard template is also included to help you get started quickly.
Security
Independently audited security controls covering availability, confidentiality, and processing integrity.
All data encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. HubSpot authentication uses OAuth 2.0.
Data processed in Microsoft Azure EU West or North America depending on your billing region.
Independently reviewed by HubSpot for security and technical quality standards.
Join 10,000+ teams who’ve eliminated manual exports.
