Learn how to build a reverse ETL pipeline in 10 min during our next live session. 🏎️💨 Register for free today
No items found.

Reverse ETL for Looker

Looker, now part of Google Cloud Platform, is a business intelligence and analytics platform with data visualization tools, turn insights into powerful data-driven experiences. In Looker's platform, you can build your complete customer data platform. Get your comprehensive unified customer profiles to sync them to your everyday business tools to build better customer experiences and drive business revenue.

Looker icon
Looker icon
Model data in Looker
Make the data accessible to Censu
Sync your Looker anywhere

What can you do with Looker and Census?

Sync your data models from Looker in just a few steps:

  • In Looker, model your data with "Persistent Derived Tables" ( or "PDTs" for the true believers.) These data models persist as tables in the data warehouse.
  • You can set a publish_as_db_view parameter on these data models, so that they are accessible by other tools (outside of Looker). Otherwise, their names change every day with naming that is only understandable to Looker.
  • Census can then access those PDTs that have been flagged for usage outside of Looker, just as normal SQL on the warehouse.

To learn more about how our customer, Fountain achieved it, read our post on the Looker blog

From your data warehouse to your favorite apps. Without code or engineers.

Start using Census today by booking a demo with one of our experts.

Illustration of a data stack from multiple data sources.