Redshift Day at the AWS Loft is an opportunity for you to learn about the most popular & fastest growing cloud-based data warehouse. Amazon Redshift is a fast, fully managed, & cost-effective data warehouse that gives you petabyte scale data warehousing & exabyte scale data lake analytics together in one service. On Redshift Day, we explain the fundamentals, best practices, & take a technical deep dive into Amazon Redshift data warehouse. We cover the integration with Amazon Data Lake through Amazon Redshift Spectrum, & a few other AWS Analytics services including AWS Glue & Amazon Athena.
- A laptop & active AWS account
- Basic knowledge of AWS & its services
Session levels range from 200-300. More information on session levels here.
Who should attend
Developers, engineers, architects, Database Administrators, Data Architects, Data Engineers, & systems administrators who are interested in learning about cloud-based Data Warehouse.
Attend if you're technical & looking to evolve your skills to build a cloud-based Data Warehouse solution based on Amazon Redshift that will enable modern analytics use cases. You'll learn the best practices on how to design tables with the proper distribution style, load data into Redshift, & how to fully integrate with Data Lake using Amazon Redshift Spectrum. With Amazon Redshift Spectrum customers can easily query their data in Amazon S3 & extend Data Warehousing out to exabytes with no loading required.
Welcome & introductory presentations
Sign in, grab a badge, & take your seat.
Introduction to the AWS Loft & Redshift Day
Modernize Your Data Warehouse with Amazon Redshift
Enterprises across the globe are looking to migrate their data warehouse to the cloud. Amazon Redshift is a petabyte scale, highly rated, fully managed cloud data warehouse service. It is used by tens of thousands of customers to get ten times faster performance at one tenth pricing. In this session, you will learn about Amazon Redshift's features & functionalities that will help you build a high-performance data warehouse in cloud.
Workshop: Build a Data Warehouse with Amazon Redshift
Enjoy lunch courtesy of AWS.
Amazon Redshift is a cloud-based modern data warehouse designed to deliver fast query performance at lowest cost possible. In this session, you will deploy a Redshift Cluster from scratch, create the table schemas using the proper distribution style so that queries can take advantage of Massive Parallel processing using multiple nodes & slices. Additionally you will load data stored in the data lake based on Amazon S3.
Redshift Deep Dive & Best Practices
In this session, we will dive deep into Amazon Redshift & walk you through some of the tuning options to get the most of performance for your queries. You will learn how to use the proper distribution style to maximize data distribution, use of sort keys for query predicates & joins, Workload Management for maximum query throughput & concurrency. Additionally, you will learn the newest features available in Amazon Redshift for automatic tuning & increased query throughput during query execution spikes.
Workshop: Analyze Data in Your Amazon Redshift Data Warehouse & Amazon S3 Data Lake Using Amazon Redshift Spectrum
Not all of your data is always loaded into your data warehouse, & yet sometimes analysts need access to it quickly, without waiting on an ETL job to load. Amazon Redshift is a fast, simple, cost-effective data warehouse service that can extend queries to your data lake using your existing business intelligence tools. This session takes a hands-on approach to show you how to mine your Amazon S3 data lake using open data formats with Redshift Spectrum, a feature of Redshift, without the need for unnecessary data movement. This enables you to analyze data across your data warehouse & data lake, together, with a single service.
Redshift Day Closing