Menu
I want to list out all the existing databases within a Redshift cluster. How can I do that.
What SQL query can I fire such that it sends me a list of all the databases within the AWS cluster
768
If you don't see Database Navigator tab than click on the Window -> Database Navigator.
To query databases hosted by your Amazon Redshift cluster, you have two options: Connect to your cluster and run queries on the AWS Management Console with the query editor. If you use the query editor on the Amazon Redshift console, you don't have to download and set up a SQL client application.
Amazon Redshift enforces these limits for databases: Maximum of 60 user-defined databases per cluster.
Data is organized across multiple databases in Amazon Redshift clusters to support multi-tenant configurations. However, you often need to query and join across these datasets by allowing read access.
Please try this.
SELECT * FROM pg_database;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
