Amazon Redshift Cluster Management

Introduction

Let’s start off with the basics. Our first step is to have an Amazon Redshift cluster set up. This chapter will show you exactly how to do that.

How to setup the most important parts of your cluster, permissions and how to work with system tables and schemas.

Though, you need first to start with a decision. There are two types of Redshift instances you can set up in AWS, Dense Compute (DC) and Dense Storage (DS).

Node Types in Amazon Redshift

When you launch a cluster, you need to specify the node type, that determines CPU, RAM, and storage for each node. A high-level difference is that:

The Dense Compute cluster has less storage, but better performance and speed. The more data you are querying, the more compute you need to keep queries fast. The Dense Compute type of instances is good to use if you need a high-performance data warehouse.

The Dense Storage cluster is designed for big data warehouses. So, if you have too much data to fit.

There is also a difference in the pricing, so go here to check some more information from AWS and its pricing.

Having said that let’s see with more details how to create an Amazon Redshift cluster in the next section.

load data into any data warehouse - Blendo