# How to Setup Redshift Data Warehousing

Redshift data warehousing is a service provided by AWS which allows businesses to store large amounts of data in a scalable and cost-effective way.

# Setup

Click to Cluster on the left side first

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683801607801/ca6a4691-e270-4f9d-ae45-aa5e4418f733.png align="center")

Clicked to help me choose

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683801782246/75885945-2069-46d4-a8bc-65b3bb3a61a9.png align="center")

I less up the storage and months

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683801819012/38bc5d0f-ba45-4fae-8b81-5f2f905d6f7b.png align="center")

Rest default then I setup the password

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683801869507/9d50d50d-1294-449f-9d59-075a6af225d9.png align="center")

Finally clicked to create a cluster

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683801922687/18c961c8-9b73-4b3b-892b-aaa8af79af2a.png align="center")

This process could take a few minutes to get started

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683802643581/7492ae3b-b7f6-4cdc-8e21-d03bfb2895a9.png align="center")

# Creating Table and Loading Data

I selected the database and clicked on Query data and selected Query data V2, because it will default connect to the required database

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804011216/d01aee08-5d0d-41b9-bebd-8f43748c6015.png align="center")

To load some data, I am creating a table

Clicked here and select Table

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804251679/11cf8da4-2e54-400d-8dfa-5e64cbb2cdb4.png align="center")

After selecting your Redshift warehouse and selecting the public schema and giving the name to the table

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804473014/8bc948f1-4f2e-4e34-acb8-c17707d2cde3.png align="center")

We can add columns here by selecting Add column

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804454909/e17c9eb8-f625-497c-9362-0c7d6c21cc29.png align="center")

or Also we do have the option to upload a local CSV file

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804533213/e4419397-ed5b-4a71-a7bf-4812c581e140.png align="center")

Don't forget to add every single detail in the table if you skip blank then the table won't create

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804686779/c7ecdc75-cc24-4c8c-9f6a-dee6819c31d6.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804725994/b79bd75a-3c0e-4f1a-beb4-4e15dd91df71.png align="center")

Now myTable is showing here

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804767014/121923a1-f37b-40ee-93a9-025bfcd0eed8.png align="center")

I ran a command

```plaintext
select * "from"."public"."myTable";
```

After running the command here it is showing No Rows to Show, by using Create Table we are only to create the table we can't load the data.

To load the data click on Load data and select IAM role also select the table file without header directly from S3 uploads.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1683804875014/4f5a988a-b988-4378-927f-affe4913bff9.png align="center")

---