Our database is set up with a different schema for each customer, but the table structures are identical.
For example, we have many tables named customerA.data, customerB.data, … customerZ.data.
Is it possible to access any one of these tables without creating 26 identical views?
So one approach might be a filter in an Explore or Dashboard where I would enter “K” and it would then generate and send the SQL:
“select * from customerK.data”
How would that be set up?