Category: Redshift

DDL of views can be obtained from information_schema.views. Below is the sql to get the view definition where schemaname is

Run the below query to list all the non-system views in a Redshift database. select table_schema, table_name from information_schema.views where

Below is the syntax to add a new column to an existing table in Redshift. alter table schemaname.tablename add columnname

Use the below sql statement to view the recent 100 queries run by a user ordered by the most recent

You might encounter the below error while trying to modify a column in Redshift database from SQL Workbench. [Amazon](500310) Invalid

You can modify the distribution style of a table using below sql command: alter table tablename alter diststyle AUTO|ALL|EVEN|KEY DISTKEY

You can query the SVV_TABLE_INFO view to determine the distribution style of a table. select “database”, “schema”, “table”, “diststyle” from

Use the Top function to query only the top 10 rows. Syntax is as below: Select top 10 * from

You can revoke the super user privileges previously granted to a database user by running the below sql command where

To grant super user privileges to an existing database user, login as a super user (master user created during the