AWS bytes

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

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