Chapter 2. Getting Started with Amazon Redshift

Amazon Redshift enables you to run analytics for your business without having to provision servers or infrastructure, making it easy to get started. It includes a web-based query editor in the AWS console to start loading and analyzing your data without having to install software. Amazon Redshift is also compatible with your favorite query editors like DBeaver, SQL WorkbenchJ, and Toad using Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC) drivers provided.

In this chapter, we will provide an Amazon Redshift architecture overview, describing the key components of the platform. Next, we’ll provide steps on how you can “Get Started with Amazon Redshift Serverless” and begin querying “Sample Data” with a few button clicks. We’ll also describe “When to Use a Provisioned Cluster?” and how you can “Estimate Your Amazon Redshift Cost” for both serverless and provisioned data warehouses. Then, we’ll talk about “AWS Account Management”, describing how you can create a single account or manage multiple accounts in your organization. Lastly, we’ll cover some options for “Connecting to Your Amazon Redshift Data Warehouse” and how to manage user access.

Amazon Redshift Architecture Overview

What’s in a name? That which we call a rose by any other name would smell just as sweet.

Romeo and Juliet

William Shakespeare uses this line in his play Romeo and Juliet to convey that the naming of things is irrelevant.

There are ...

Get Amazon Redshift: The Definitive Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.