Configuring Distribution Styles and Table Access in Amazon Redshift

Lab Steps

lock
Logging in to the Amazon Web Services Console
lock
Introduction to Configuring and Securing Amazon Redshift
lock
Connecting to the Amazon Redshift Cluster
lock
Creating Tables and Setting Distribution Styles
lock
Configuring Column Level Access

The hands-on lab is part of this learning path

Ready for the real environment experience?

DifficultyBeginner
Time Limit1h
Students163
Ratings
5/5
starstarstarstarstar

Description

Amazon Redshift is a fully-managed data warehouse service you can use in the public AWS cloud. It's scalable, cost-effective, and stores your data securely.

Amazon Redshift supports configuration of data storage and access control. Anyone aiming to be proficient at working with Databases in AWS will benefit from learning how to use these features.

In this hands-on lab, you will use the PostgreSQL command-line client to connect to an Amazon Redshift cluster and configure table distributions styles and access for subsets of data.

Learning Objectives

Upon completion of this beginner-level lab, you will be able to:

  • Connect to an Amazon Redshift cluster using the PostgreSQL command-line client
  • Create tables and load data into them
  • Set distribution styles on tables
  • Configure column-level and row-level access

Intended Audience

  • Candidates for AWS Certified Data Analytics Specialty certification
  • Cloud Architects
  • Data Engineers
  • DevOps Engineers
  • Software Engineers

Prerequisites

Familiarity with the following will be beneficial but is not required:

  • The Bash command-line
  • PostgresSQL and Amazon Redshift
  • Structured Query Language (SQL)

The following content can be used to fulfill the prerequisites:

Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students55249
Labs140
Courses2
Learning paths3

Andrew is a Labs Developer with previous experience in the Internet Service Provider, Audio Streaming, and CryptoCurrency industries. He has also been a DevOps Engineer and enjoys working with CI/CD and Kubernetes.

He holds multiple AWS certifications including Solutions Architect Associate and Professional.