What's new

Read our What's New posts to learn about recent features and announcements for HAQM Redshift and Redshift Spectrum.

Workshops and Tutorials

Getting started with HAQM Redshift Self Serve Workshop

Learn more » 

HAQM Redshift Deep Dive Self Serve Workshop

Learn more » 

Blogs

No blog posts have been found at this time. Please see the AWS Blog for other resources.

Read more HAQM Redshift articles on the AWS News Blog.

Learn about best practices, feature capabilities, and customer use cases on the AWS Big Data Blog.

Learn how to migrate from an on-premises data warehouse to HAQM Redshift, and more, on the AWS Databases Blog.

Whitepapers and Guides

HAQM Redshift Reference Architectures powering customer success

Modernize your analytics by migrating to HAQM Redshift

Executive Summary: The Business Value of HAQM Redshift

HAQM Redshift: Ten years of continuous reinvention - HAQM Science

Redshift Reinvented

Optimizing your HAQM Redshift and Tableau Software Deployment for Better Performance

Modernizing the HAQM Analytics Infrastructure - Oracle DW to Redshift

Data warehousing on AWS

HTAP for HAQM Redshift

Best Practices for Leveraging Redshift and DBT

Documentation

Getting started with HAQM Redshift Serverless

HAQM Redshift Database Developer Guide 

HAQM Redshift Management Guide 

HAQM Redshift Best Practices 

Tuning and management scripts & tools

HAQM Redshift Admin Scripts »

HAQM Redshift Admin Scripts   

SQL scripts for running diagnostics on your HAQM Redshift cluster using system tables. Download here »

List of Scripts:

  • top_queries.sql - returns top 50 most time-consuming statements in the last 7 days
  • perf_alerts.sql - returns top occurrences of alerts, join with table scans
  • filter_used.sql - returns filter applied to tables on scans to aid in choosing sortkey
  • commit_stats.sql - shows information on consumption of cluster resources through COMMIT statements
  • current_session_info.sql - shows information about sessions with currently running queries
  • missing_table_stats.sql - shows EXPLAIN plans which flagged "missing statistics" on the underlying tables
  • queuing_queries.sql - lists queries which are waiting on a WLM Query Slot
    table_info.sql - Return Table storage information (size, skew, etc) 
Show less
Admin SQL Views »

Admin SQL Views    

SQL Views for managing your HAQM Redshift Cluster and generating Schema DDL. All Views assume you have a schema called Admin. Download here »

List of views:

  • v_check_data_distribution.sql - get data distribution across slices
  • v_constraint_dependency.sql - get the the foreign key constraints between tables
  • v_generate_group_ddl.sql - get the DDL for a group
  • v_generate_schema_ddl.sql - get the DDL for schemas
  • v_generate_tbl_ddl.sql - get the DDL for a table, contains distkey, sortkey, & constraints
  • v_generate_unload_copy_cmd.sql - generate unload and copy commands for an object
  • v_generate_user_object_permissions.sql - get the DDL for a user’s permissions to tables and views
  • v_generate_view_ddl.sql - get the DDL for a view
  • v_get_obj_priv_by_user.sql - get the table/views that a user has access to
  • v_get_schema_priv_by_user.sql - get the schema that a user has access to
  • v_get_tbl_priv_by_user.sql - get the tables that a user has access to
  • v_get_users_in_group.sql - get all users in a group
  • v_get_view_priv_by_user.sql - get the views that a user has access to
  • v_object_dependency.sql - merge the different dependency views together
  • v_space_used_per_tbl.sql - pull space used per table
  • v_view_dependency.sql - get names of views that are dependent on other tables/views
  • v_check_transaction_locks.sql - get info on locks held by open transactions
  • v_check_wlm_query_time.sql - get WLM wait time & execution time for past 7 days
  • v_check_wlm_query_trend_daily.sql - get WLM query Count, wait time, execution time by day
  • v_check_wlm_query_trend_hourly.sql - get WLM query count, wait time, execution time by hour
  • v_generate_cancel_query.sql - get cancel query
  • v_get_cluster_restart_ts.sql - get datetime when cluster was recently restarted
  • v_get_vacuum_details.sql - get vacuum details
Show less
Column Encoding Utility »

Column Encoding Utility

Determine optimal compression for your HAQM Redshift data with this utility. Download here »

Show less
Unload/Copy Utility »

Unload/Copy Utility

Easily migrate data between two HAQM Redshift tables that may be in different databases, clusters, or regions. All exported data is encrypted with AWS Key Management Service (KMS). You can use this utility to supplement AWS Data Pipeline to routinely move data between systems, such as between production and test, or for maintaining read-only copies on other clusters. Download here »

Show less

Community contributed functions & tools

Analytics & Admin Tools »

Analytics & Admin Tools

Easily  

Common User-Defined Functions (UDF). A collection of helpful UDFs for everyone to use. Contributed by Periscope. Learn More » | Download here »

Yelp’s ETL tool for HAQM Redshift. Use Yelp's Mycroft to automatically load data into HAQM Redshift. Read this blog post for more information. Download here »

Framework for developing UDFs. To make development easier, Periscope has built a framework for managing and testing UDFs. Contributed by Periscope Data. Download here »

re:Dash. A free open source data collaboration and visualization platform built to allow fast and easy access to billions of records. Features include a schema browser, improved scheduling, autocomplete, and ability to write Python queries. Contributed by Everthing.me. Download here »

EverythingMe's HAQM Redshift Admin Dashboard. Monitor running queries, WLM queues, and your tables/schemas with this user-friendly tool. Contributed by EverythingMe. Download here »

Spark-Redshift Library. Use this library to load data from HAQM Redshift into an Apache Spark SQL DataFrames, and write data from Apache Spark back into HAQM Redshift. Good example of using AVRO ingestion with HAQM Redshift. Contributed by Swiftkey. Download here »

Show less

Videos

Watch the 2023 AWS Data Insights Day Webinars playlist

Watch the Analytics on AWS Webinars playlist

HAQM Redshift Overview (2:07)
HAQM Redshift Serverless (1:28)