The SQL commands listed here are either different from standard SQL implementations due to Redshift needs or are otherwise important to highlight. This is not a SQL reference; most SQL that you will run in Redshift will function as you would expect it to normally.
ALTER: This command is at the table level only; there are no alter column commands (see Chapter 5, Querying Data).
ANALYZE: The command used to capture statistical information about a table for use by the query planner (see Chapter 4, Managing Your Data).
COPY: The following screenshot shows the syntax of this command (see Chapter 3, Loading Your Data to Redshift):
CREATE TABLE: Here is a command reference for this SQL statement (see Chapter 3, Loading Your Data to Redshift):
GRANT: Used to allow specific permissions to an object or schema. The syntax is
GRANT [permission] on [object] to [username]
.CREATE GROUP: Used to associate users to a logical grouping. The syntax is
CREATE GROUP group_name [ [with] [USER username(s)]]
.CREATE SCHEMA: Used to isolate objects. The syntax is
CREATE SCHEMA schema_name [ AUTHORIAZATION username] [schema_element(s)]
.VACUUM: A process to physically reorganize tables after load activity (see Chapter 4, Managing Your Data).