Surface Looker Explore prod/dev datasets in the SQL pane

[jilyat]

Would it be possible to generate a customisable LookML line of code (specified in the droughty_project.yaml file) beneath each view in the _base.layer.lkml file, in this instance to enable custom prod and development datasets to be surfaced in the Looker Explore SQL pane?

_base.layer.lkml example

view: <data_warehouse_table_name> {
sql_table_name: `<gcp_project_id>.{{ _user_attributes['<user_attribute_analytics_data_warehouse>'] }}.<data_warehouse_table_name>` ;;

drought_project.yaml

lookml_dataset: sql_table_name: `<gcp_project_id>.{{ _user_attributes['<user_attribute_analytics_data_warehouse>'] }}.<data_warehouse_table_name>` ;;

This would enable users to investigate queries in the data warehouse UI if needed, or check if the user is querying against production or development data.