Category: Redshift

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

Below is the query to identify all columns (and their default values) that have a default value defined in Redshift

Run the below select statement to list all the tables of a schema where schemaname is the name of the

Run the below select statement to obtain the username of the current session in Redshift. select current_user;