Redshift How-To Guides

Practical Redshift answers with statements you can copy and run.

• How to Create a Table in Redshift
• How to Rename a Table in Redshift
• How to Rename a Column in Redshift
• How to Add a Column in Redshift
• How to Drop a Column in Redshift
• How to Change a Column Type in Redshift
• How to Insert Data in Redshift
• How to Update Rows in Redshift
• How to Delete Rows in Redshift
• How to Truncate a Table in Redshift
• How to Duplicate a Table in Redshift
• How to Create a View in Redshift
• How to Create a Materialized View in Redshift
• How to List Tables in Redshift
• How to Describe a Table in Redshift
• How to Upsert in Redshift
• How to Get the Current Date in Redshift
• How to Use DATEDIFF in Redshift
• How to Use SPLIT_PART in Redshift
• How to Use LISTAGG in Redshift
• How to Remove Duplicate Rows in Redshift
• How to Unload Data to S3 in Redshift
• How to Copy Data from S3 in Redshift
• How to Create a Schema in Redshift
• How to Grant SELECT on a Table in Redshift
• How to Kill a Running Query in Redshift
• How to Check Table Sizes in Redshift
• How to Vacuum a Table in Redshift
• How to Analyze a Table in Redshift
• How to Generate a Date Series in Redshift

Running Redshift queries as a team? See the SaturnSQL Redshift editor.