From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Schema design for Amazon Redshift

Schema design for Amazon Redshift

From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Start my 1-month free trial Buy for my team

Schema design for Amazon Redshift

“

- [Instructor] As a data warehouse, Redshift is optimized for analytics and not transactions, so we want to use a schema design that reflects this. In this lesson we'll learn about schema designs that work well with Redshift. In Amazon Redshift, a schema is a namespace that groups database objects such as tables, views, storage procedures, and other database objects. So as you create your table definitions, you help to define the schema. Every database will have a default schema called PUBLIC. You'll want to define separate schemas for different applications, because you can have two tables with the same name then in different schemas. For example, a customer's table for different lines of business could be in their own schemas. You could create a new schema using the CREATE SCHEMA SQL command. With Redshift, you can create tables using the common SQL data types such as integers, bar char, timestamps and others. Since a data warehouse is designed for querying, we designed the tables…

Contents