Construct dynamic query for embedded looker dashboard

  • 11 August 2022
  • 0 replies

Is there a way in looker to execute dynamic queries
i.e I have a mapping table which can tell me the preferred column name for each client.
Based on the column name from the mapping table , I have to query another table

@set mapped_column_name = select column from mapping_table where client_id =”client 1”;
select * from another_table group by (mapped_column_name).

Does looker support this?

This topic has been closed for comments