Resources for Amazon RedShift Developers & Admimistrators

Image Not Showing Possible Reasons

The image file may be corrupted
The server hosting the image is unavailable
The image path is incorrect
The image format is not supported

Instructor: Scott Jones
Email: scojoe@amazon.com
Path to this page: https://bit.ly/scojoe-on-redshift

Have a look at these resources related to our course.

Welcome to Amazon Redshift

Amazon Redshift System Overview https://docs.aws.amazon.com/redshift/latest/dg/welcome.html

General Topics

Amazon Redshift | AWS Big Data Blog: https://aws.amazon.com/blogs/big-data/category/analytics/amazon-redshift-analytics/?sc_ichannel=ha&sc_icampaign=acq_awsblogsb&sc_icontent=bigdata-resources
Amazon Redshift Best Practices: https://docs.aws.amazon.com/redshift/latest/dg/best-practices.html
New – Concurrency Scaling for Amazon Redshift – Peak Performance at All Times: https://aws.amazon.com/blogs/aws/new-concurrency-scaling-for-amazon-redshift-peak-performance-at-all-times/

Whitepaper: Data Warehousing on AWS Whitepaper: https://d0.awsstatic.com/whitepapers/enterprise-data-warehousing-on-aws.pdf
Whitepaper: Big Data Analytics Options on AWS: https://d0.awsstatic.com/whitepapers/Big_Data_Analytics_Options_on_AWS.pdf
Redshift Performance & Cost - Airbnb Engineering: https://medium.com/airbnb-engineering/redshift-performance-cost-b4aa8dc25d75#.gm7gbuul5
Tutorial: Getting Started with Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_intro_to_admin.html

Schema and Database Design

Optimizing for Star Schemas and Interleaved Sorting on Amazon Redshift - AWS Big Data Blog: https://aws.amazon.com/blogs/big-data/optimizing-for-star-schemas-and-interleaved-sorting-on-amazon-redshift/
Data Types - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html
Distribution Styles - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
Third Normal Form (3NF) - Database Normalization: https://www.1keydata.com/database-normalization/third-normal-form-3nf.php
Quickly Filter Data in Amazon Redshift Using Interleaved Sorting | AWS Blog: https://aws.amazon.com/blogs/aws/quickly-filter-data-in-amazon-redshift-using-interleaved-sorting/
Tutorial: Tuning Table Design - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/tutorials-redshift.html

Data Load

Preparing Your Input Data: https://docs.aws.amazon.com/redshift/latest/dg/t_preparing-input-data.html
Loading Tables with Automatic Compression in the Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_Loading_tables_auto_compress.html
Redshift Compression Encodings: https://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html
A Zero-Administration Amazon Redshift Database Loader | AWS Big Data Blog: https://aws.amazon.com/blogs/big-data/a-zero-administration-amazon-redshift-database-loader/
Using a COPY Command to Load Data - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/t_Loading_tables_with_the_COPY_command.html
COPY Examples - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/r_COPY_command_examples.html
JSONPath Expressions: https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-format.html#copy-json-jsonpath-expressions
Redshift SQL Utility to Evaluate Data Skew: https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminScripts/table_inspector.sql
Tutorial: Loading Data from Amazon S3: https://docs.aws.amazon.com/redshift/latest/dg/tutorial-loading-data.html

Tuning

Amazon Redshift Best Practices for Designing Queries: https://docs.aws.amazon.com/redshift/latest/dg/c_designing-queries-best-practices.html
Amazon Redshift Best Practices for Designing Queries: https://www.intermix.io/blog/amazon-redshift-best-practices-for-designing-queries/
Top 10 Performance Tuning Techniques for Amazon Redshift | AWS Big Data Blog: https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/
EXPLAIN Command Usage Notes: https://docs.aws.amazon.com/redshift/latest/dg/r_EXPLAIN.html
Diagnostic Queries for Query Tuning - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/diagnostic-queries-for-query-tuning.html
Differences, PostgreSQL and Redshift SQL: https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
CREATE FUNCTION - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_FUNCTION.html
Troubleshooting Queries: https://docs.aws.amazon.com/redshift/latest/dg/queries-troubleshooting.html
Reviewing Query Alerts - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c-reviewing-query-alerts.html
Working with Parameter Groups: https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-parameter-groups.html
Tutorial: Configuring WLM Queues to Improve Query Processing: https://docs.aws.amazon.com/redshift/latest/dg/tutorial-configuring-workload-management.html
Tutorial: Tuning Table Design: https://docs.aws.amazon.com/redshift/latest/dg/tutorials-redshift.html

Cluster Admin

Amazon RedShift Admin Utilities: https://github.com/awslabs/amazon-redshift-utils
SQL commands Best Practices – Amazon Redshift: https://www.intermix.io/blog/sql-commands-best-practices-redshift/
5 Essential Tools for RedShift DBAs: https://www.iheavy.com/2016/09/18/5-essential-tools-for-redshift-dbas/
Redshift Security Overview: https://docs.aws.amazon.com/redshift/latest/dg/c_security-overview.html
Using IAM Authentication to Generate Database User Credentials: https://docs.aws.amazon.com/redshift/latest/mgmt/generating-user-credentials.html
System Tables Reference - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html
STL Tables for Logging - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STL_tables.html
STV Tables for Snapshot Data - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_intro_STV_tables.html
System Views - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_intro_system_views.html
System Catalog Tables - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/dg/c_intro_catalog_views.html
AWS Service Limits - Amazon Web Services: https://docs.aws.amazon.com/general/latest/gr/aws_service_limits.html#limits_redshift
Limits in Amazon Redshift - Amazon Redshift: https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html
Tutorial: Resizing Redshift Clusters: https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-operations.html