Broadcast Date: June 20, 2019

Level: 300

As the amount of data accumulates, customers have stored it in different silos, making it difficult to do analytics. To make it easier, customers want all of their data in a single repository, i.e., a data lake. However, even well implemented data lakes do not replace the need for a data warehouse for well-defined, high-concurrency, high-speed, responsive analytics and reporting, using their existing SQL skills and applications. Most data warehouses impose the limitation of loading data into a proprietary format inside the data warehouse before it can be analyzed, perpetuating the silos that customers wanted to break by implementing the data lake in the first place. This tech talks demonstrates a new paradigm for data warehousing that enables customers to answer the most complex analytical questions by querying exabytes of data in their Amazon S3 data lakes and Amazon Redshift data warehouse with familiar SQL and no data movement or transformation required. It also demonstrates how you can break data silos among various analytical engines as well as among various lines of business in your organization.

Learning Objectives

  • Learn how to break data silos by quickly making all of your data in Amazon S3 available for analysis with Amazon Redshift for data warehousing workloads, while also being able to flexibly use other analytical engines such as Amazon Athena for ad-hoc queries and EMR for big data processing
  • Learn how to analyze data between the data warehouse and your data lake together in the same SQL query using Amazon Redshift spectrum, and learn about some recent updates to the feature
  • Learn how to break information silos among lines of business in your organization by sharing data in your data lake and data warehouse without needing to duplicate it

Who Should Attend?

DBAs, Data Warehouse Admins, Data Architects, Data Engineers, Security Teams


  • Raghu Prabhu, Sr. Business Development Manager, AWS

Learn More

To learn more about the services featured in this talk, please visit:

Intro body copy here about 2018 re:Invent launches.

Download the Slide Deck


Service How To

December 19th, 2018 | 1:00 PM PT

Developing Deep Learning Models for Computer Vision with
Amazon EC2 P3 Instances.

Register Now>


What's New / Cloud Innovation

December 11th, 2018 | 1:00 PM PT


Register Now>

Data Lakes & Analytics

Webinar 1:

What's New / Cloud Innovation

December 10th, 2018 | 11:00 AM PT


Register Now>

Webinar 2:

What's New / Cloud Innovation

December 12th, 2018 | 11:00 AM PT


Register Now>