AWS bytes

Run the below query to lit all the materialized views in a schema in Redshift database. select name from STV_MV_INFO

Run the below query to return all tables and views of a schema in Redshift database where schemaname is the

Run the below query to return the name of the database you are currently connected to. select current_database();

Use the below query to view all active sessions in Redshift database. select distinct starttime , process , user_name ,

Run the below query to determine the version of Redshift as well as the operating system of the underlying host.

Run the below query to list all the databases in a Redshift cluster. select oid as db_id, datname as db_name,

You can list all the columns of a table using below query where tablename is the name of the table.

Use the below query to identify all the queries currently in process. select userid , query , pid , starttime

Run the below query to get the column count of all tables in Redshift database. select table_schema, table_name, count(*) from

Run the below query to obtain the row count of all tables in Redshift database select t1.table_schema, t1.table_name, t2.tbl_rows from