How to make cross database queries (same cluster, system tables) #894
Unanswered
alejandrofm
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi, I'm looking for querying some system tables on different databases on the same Redshift Cluster.
Because those are system tables I cannot do: database.svv_table_info or database.pg_system_table.svv_table_info.
Is there a way to select a database, given that Redshift doesn't have
USE database;.I'm trying to avoid making a new profile only for querying system tables.
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions