Putting this here as I’m not sure if it’s possible to do this currently.
The title says it all, basically. Let’s say we have two tables from two distinct schemas, is it possible to join the two tables together?
-- table "users" belongs to schema "static" -- table "events" belongs to schema "analytics" -- editing a query with the schema "analytics" open SELECT u.id, e.timestamp, e.label FROM events e LEFT JOIN static.users u ON u.id = e.user_id
Using a PostgreSQL database with Redash.
When querying Postgres directly (e.g. via a terminal or a client), it is perfectly fine to join a table from a different schema, however any way I’ve tried to do it from Redash didn’t bring any successful result.