Upserting Data

Intermediate
5m 41s
2,497
4.8/5

This lesson covers how to load your data efficiently using the COPY command in Amazon Redshift. You'll learn how it can be used to load multiple or a single large file into Amazon Redshift, as well as the different features that the COPY command has to offer and what data upserting is.

Learning Objectives

  • Understand the essentials of the COPY command in Redshift and its features
  • Learn how to load single or multiple large files into Redshift
  • Learn what upserting is and why it's important

Intended Audience

This lesson is intended for people that want to learn more about how to load their data efficiently using the COPY command.

Prerequisites

To get the most from this lesson, you should have a basic understanding of Amazon Redshift and Data Analytics concepts.

About the Author
Avatar
Stephen Cole, opens in a new tab
AWS Certification Specialist
Students
34,170
Courses
20
Learning paths
12

Stephen is the AWS Certification Specialist at Cloud Academy. His content focuses heavily on topics related to certification on Amazon Web Services technologies. He loves teaching and believes that there are no shortcuts to certification but it is possible to find the right path and course of study.

Stephen has worked in IT for over 25 years in roles ranging from tech support to systems engineering. At one point, he taught computer network technology at a community college in Washington state.

Before coming to Cloud Academy, Stephen worked as a trainer and curriculum developer at AWS and brings a wealth of knowledge and experience in cloud technologies.

In his spare time, Stephen enjoys reading, sudoku, gaming, and modern square dancing.

Covered Topics