No items found.

Reverse ETL for Looker

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.