Useful resources

Still looking for more resources, demos, videos and more… the links below should point you to resources that may help you locate what you need.

Name
Link
Description
Redshift Immersion Day Immersion Day Site Amazon Redshift Workshop is a customizable experience delivered by solutions architects and account managers, to either initiate/expedite new Redshift opportunities or help pre-existing customers deploy advance workloads using Redshift.
Redshift Specialist Solutions Architects Amazon Wiki The Redshift Specialist Solutions Architecture (SA) team is a group aligned to Americas. We work with Redshift BD, Specialized SA/Sales, and Account teams and engage on various conversations such as data warehouse migration, new data warehouse use cases, performance tuning Redshift, and other related topics.
Redshift Cluster Review Guide Site This workshop will walk you through the materials and setup to run a Redshift Health Check for your customers.
Redshift Wisdom Resource Hub Wisdom The Wisdom portal consists of contextual landing pages intended to be the entry point for AWS employees to look for accurate, relevant, and trusted information. Wisdom aims to ensure that the field can efficiently find curated, up-to-date announcements, tools, process details, and sales assets they need to effectively do their jobs.
Redshift First Call Deck PowerPoint To support a customer meeting about migrating off an on premises data warehouse to Amazon Redshift. Intended for an audience familiar with data warehousing, but not using Redshift. Audience: IT decision maker (IT leadership, data architect, CIO-1). Level: 100
Redshift Tuning Guide Amazon Wiki This page has been written to assist AWS Data Warehouse users who are experiencing poor performance with their Redshift queries. Whether the SQL is being run through Hammerstone or on an ad-hoc basis via a SQL client, we want you to write the most efficient queries possible, because proper tuning benefits not only you, but other users of your cluster as well. You don’t need to be a DBA (Database Administrator) to put query tuning into practice. If you can write SQL, you can learn a few simple rules and tricks that will make your queries run faster. This guide will step you through common steps that can be used to discover why your query might be running slowly, providing suggestions and examples along the way. You can use it in an interactive form by clicking on links, or simply search through the text for possible solutions.
Workload Management Implementing workload management You can use workload management (WLM) to define multiple query queues and to route queries to the appropriate queues at runtime.

Other Demos

Name
Link
Description
Persona based demo AWS Broadcast Demo for Data Analysts, Data Scientists and BI Professionals. It is meant to complement the first call deck which covers high level messaging, differentiators, pricing, customer use cases, architecture, etc. This demo demonstrates how different personas such as DBAs/Data Engineers, Analysts, Data Scientists and BI Professionals can use Amazon Redshift and AWS Data Lake with different tools available to them.
Persona based demo Script WorkDoc Script for the above demo.
RA3 Migration AWS Broadcast Creating and Migrating to Redshift Data warehouse with RA3 instance type
Data Lake AWS Broadcast AWS DataLake with Amazon Redshift
Schedule Elastic Resize AWS Broadcast Schedule Elastic Resize
SageMaker (Jupyter Notebooks) AWS Broadcast Using SageMaker/Jupyter Notebooks with Redshift
Spatial Processing AWS Broadcast Spatial Processing with Amazon Redshift
DataRow Analyst Workbench AWS Broadcast Using Analyst Workbench with Redshift - Internal Preview features of Analyst Workbench (based on DataRow)

Videos

Name
Link
Description
re:Invent 2019 RA3 and AQUA YouTube Redshift RA3 and AQUA overview and details
re:Invent 2019 Yelp session YouTube What’s new with Amazon Redshift, featuring Yelp
re:Invent 2019 Workday session YouTube What’s new with Amazon Redshift, featuring Workday
re:Invent 2019 Nielsen session YouTube What’s new with Amazon Redshift, featuring Nielsen
re:Invent 2019 Fannie Mae session YouTube What’s new with Amazon Redshift, featuring Fannie Mae
re:Invent 2019 Duolingo session YouTube What’s new with Amazon Redshift, featuring Duolingo
re:Invent 2019 Warner Bros session YouTube What’s new with Amazon Redshift, featuring Warner Bros
re:Invent 2019 Asurion session YouTube What’s new with Amazon Redshift, featuring Asurion
re:Invent 2019 Comcast session YouTube What’s new with Amazon Redshift, featuring Comcast

Blogs

Name
Link
Description
Redshift public blogs AWS Blogs Blogs posted on AWS public site with a Redshift tag
re:Invent 2019 Amazon Redshift AWS Blogs The annual AWS re:Invent learning conference is an exciting time full of new product and program launches. At the first re:Invent conference in 2012, AWS announced Amazon Redshift. Since then, tens of thousands of customers have started using Amazon Redshift as their cloud data warehouse. In 2019, AWS shared several significant launches and dozens of sessions. This post presents highlights of what happened with Amazon Redshift at re:Invent 2019.
Chartio Performance Boost Chartio Website 4x Faster Amazon Redshift Connections. As part of our commitment to continuously improve Chartio’s performance and reliability, we recently made an upgrade that should benefit all of our customers who use Amazon Redshift. In fact, some users have already seen performance improvements of nearly 3,000% thanks to this update. Here’s what’s changing and why—and how it might impact you.