Search code examples
amazon-web-servicesamazon-redshiftcluster-computingtalend

In AWS Redshift cluster i haved created a database now i want to see the database manually instead of querying it

i have created a database in Redshift cluster now i want see the database and its tables manually instead of querying it. Where can i see those database

create database example1;

Solution

  • With Redshift, there is no way to look at the data in any way except by issuing queries and commands against it. This is fairly common for most DBMS products.

    AWS "recommend" the free tool Sqlworkbench/J https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html

    In addition you can issue commands against Redshift using the AWS management console https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor.html

    My personal favorite (as a professional developer) is to use the Jetbrains DataGrip product.