Skip to content
hands-on lab

Configuring Distribution Styles and Table Access in Amazon Redshift

Difficulty: Beginner
Duration: Up to 1 hour
Students: 1,022
Rating: 3.8/5
Start lab
On average, students complete this lab in35m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
About
Author

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 data storage and access control configuration. 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, configure table distribution styles, and grant access to 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:

Updates

June 9th, 2025 - Updated lab environment and Redshift cluster

October 15th, 2024 - Updated instructions and screenshots to reflect the latest UI

Environment before

Environment after

Covered topics

Amazon Web Services
Analytics for AWS
Storage for AWS
Databases for AWS
Amazon Redshift
SQL for AWS
Big Data for AWS
CLI
Big Data
SQL
Analytics
Storage
Management
Databases
Hands-on Lab UUID

Lab steps

0 of 5 steps completed.Use arrow keys to navigate between steps. Press Enter to go to a step if available.
  1. Logging In to the Amazon Web Services Console
  2. Introduction to Configuring and Securing Amazon Redshift
  3. Connecting to the Amazon Redshift Cluster
  4. Creating Tables and Setting Distribution Styles
  5. Configuring Column Level Access

Lab Rules