So we use LSP in an enterprise environment. I have data in dev, uat and prod environments in BigQuery, in separate GCP projects.
I am trying to get a LSP report to display data from the different environments depending on a parameter.
I tried to have a BigQuery custom query set as:
IF @env=“prod” THEN
ELIF @env=“uat” THEN
< query for uat>
END IF;
But the BQ connector does not support procedural functions. BQ does not support functions in table names either.
How do you do it?