We are running an identical database environment which contains test data which isn’t considered live but is still real data.
A lot of people are interested in viewing this data so either want to use an existing dashboard to do this or create new content which can see both production and QA data.
Can this be done using parameters so in the dashboard the user can pick production/QA and then this filter value is passed into the connection declaration in the model file?
Can someone offer any tips regarding workflow around how best to do something like this if parameters wouldn’t work?
I have thought about lookml dashboards but these are tied to a model file and therefore a connection so we would end up with duplicated lookml file with different model file declarations, even if i extend the original dashboard I still need to list every single element & filter to override the modelname.