Read the same tables
Polytomic connects to the warehouse Looker queries, so the numbers match.
Looker
Polytomic connects the data warehouse behind Looker to your SaaS tools for reverse ETL. Because Looker models sit on your data warehouse, Polytomic can read the same tables your dashboards read and sync the results into Salesforce, HubSpot, and dozens of other tools, without writing code.
Dashboards into action
Send the metric to the CRM instead of asking people to check a chart.
One definition
The model stays in your data warehouse rather than being rebuilt per tool.
Example workflows
Push modelled metrics onto CRM records
What you can sync
Polytomic connects to the data warehouse or database that Looker reads from, then syncs those modelled tables into your SaaS tools.
From your sources
Snowflake
BigQuery
Redshift
Databricks
PostgreSQL and other databases
To your destinations
CRMs including Salesforce, HubSpot, and Attio
Support tools including Intercom and Zendesk
Ad platforms including Google, LinkedIn, and Meta
Marketing tools including Customer.io, Iterable, and Marketo
Spreadsheets including Google Sheets
How it works
Looker is a modelling and visualization layer over a data warehouse. It does not store your data; Snowflake, BigQuery, Redshift, or Databricks does. Polytomic connects to that same warehouse, which means anything you can see in a Look or dashboard is available to sync out.
In practice you point Polytomic at the tables or views your LookML is built on, or materialize the model you care about as a table, then map its columns onto the SaaS tool that needs them. The metric your team already trusts ends up on the CRM record rather than in a chart someone has to remember to open.
- Connect the data warehouse or database that Looker reads from
- Build a model over the same tables or views your LookML uses
- Or materialize a Looker derived table and sync from that
- Map model columns onto fields in your SaaS tools
- Choose write mode and identity matching per destination
- Monitor sync health, record volume, and failures from one interface
How to set up
Setup is a data warehouse connection rather than a Looker connection. Use the same data warehouse instance Looker is pointed at, ideally with a dedicated read only role, then build models over the tables your Looker content is based on.
How to get connected
- 1Identify the data warehouse Looker is connected to
- 2Create a read only role for Polytomic on that warehouse
- 3In Polytomic, add that data warehouse as a connection
- 4Build a model over the tables or views behind your Looker content
- 5Map the model to a destination and choose identity matching
- 6Set a schedule and click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Looker in minutes
No credit card required. Free trial available.