Did you all use data engineers to create the pipelines, or did you use a dedicated reverse ETL platform like Census or Hightouch?
Is dbt part of that process as well?
We use Snowflake but are exploring bigquery.
Thx a bunch!
Hi Sam,
Thanks for reaching out about this. Looker is able to connect directly to your Snowflake or BigQuery warehouse through JDBC. Regarding your questions about ETL + DBT, whether you use data engineers or a dedicated reverse ETL platform like Census or Hightouch for your Looker integration depends heavily on your organization's resources, skillset, and the complexity of your data workflows.
Looker is also architected with a built in modeling layer that will complement any ETL processes by adding a semantic layer. This layer sits on top of your data warehouse and allows you to define business logic, metrics, and relationships in a way that's easily understood by business users. Think of it as translating your raw, technical data into a language that your business teams can readily grasp and use.
Hope this helps!
LinkedIn
Twitter