---
title: Amazon RedShift Resources
tags: Resources, Talk
description: Resources to support the Planning and Designing Databases on AWS course
---

# Resources for Amazon RedShift Developers & Admimistrators

Instructor: Scott Jones
Email: [e-mail]
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/
<!-- - A DBA’s Guide to the Amazon Redshift Architecture: -->
- 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

---