Category: Redshift

Below is the query to return day of week from Redshift database. It returns a numeric output . 1 for

getdate function can be used to return the current timestamp. select getdate();

Use the below sql query to get a list of all superusers in Redshift database. select usename from pg_user_info where

You can query pg_user system catalog table for a list of all the database users in Redshit database. select usename

You can drop a database from Redshift cluster using below command where databasename is the name of the database that

Below is the syntax to drop a table in Redshift database where tablename is the name of the table that

Use the below sql query to list all the users of a group where groupname is the name of the

Run the below command to get current month from current date in Redshift database. For current date: select CURRENT_DATE; For

Use the getdate function to get today’s date. Add or Subtract days as required from today’s date. Example, to get

Run the below query to view all the dependent objects of a table in Redshift where schemaname and tablename are