How do I know which schema was chosen for an ambiguous query?

Hey all,

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?

Thanks!