About uwe

uwe · 04-22-2022

Hi everyone,we have a multi-stage ETL pipeline with the resulting tables living in different GCP projects in BigQuery as in the following example.Stages: unstable, staging, sandbox, prodGCP/BQ Setup:unstable-project.etl.my_event staging-project.etl.m...

uwe · 07-04-2022

Update: We are still using this solution.If you use it with SA-based access you need a single service account to access all stages.We gave our prod-SA access to all stages and treat all models exposed this way as production models. Works quite well s...

uwe · 04-25-2022

I found a solution using view parameters.First, I define a parameter stage and then use this to conditionally prefill the value of all views’ sql_table_name.The code could be out-sourced for reuse to a separate “abstract” view (i.e., with extension: ...

My Stats

uwe's Bio

Badges uwe Earned

Recent Activity

Allow Viewers to select GCP Project in Dashboard

Re: Allow Viewers to select GCP Project in Dashboard

Re: Allow Viewers to select GCP Project in Dashboard