I’m wondering how I can determine which schema is chosen for a query that reads from a table existing in multiple schemas. For example:
Schema a contains tables [table1, table2, table3] Schema b contains tables [table1, table10]
When I query Redshift directly with
SELECT * FROM table1;
I get ERRPR: relation “table1” does not exist, so I have to qualify it with either a.table1 or b.table1. However, when I run the above query in Metabase it seems like it just picks one of the schemas, and returns data from that table1. I’m wondering how I can tell which schema it picks by default?