0

I've got two databases in google bigquery: company.prod.db and company.stg.db I want to have a dashboard that my stakeholders can see the prod data, while I edit stuff in the dev side. So my lookml dashboards can pull data, and I can even update the data it pulls by manually changing the lookml files.

I've already enabled the advanced deploy, and can deploy from my personal branch, or a collaborative team branch to the main branch. But I'd like to be able to automatically update databases when I changed branches.

Mohammad Athar
  • 1,953
  • 1
  • 15
  • 31

1 Answers1

0

Although this is not a CI/CD based solution, you may find the "if dev" conditional SQL helpful here:

https://cloud.google.com/looker/docs/derived-tables#working_faster_in_development_mode

Here's another example that also works in user attributes:

https://discourse.getdbt.com/t/looker-user-attributes-and-if-dev-to-auto-switch-between-dev-prod-schemas/54

Fabio Beltramini
  • 1