{"id":1116,"date":"2022-08-03T10:58:36","date_gmt":"2022-08-03T10:58:36","guid":{"rendered":"https:\/\/www.workfall.com\/learning\/blog\/?p=1116"},"modified":"2025-09-30T05:11:10","modified_gmt":"2025-09-30T05:11:10","slug":"how-to-easily-analyze-data-and-run-different-queries-using-amazon-redshift-serverless-without-having-to-manage-the-infrastructure","status":"publish","type":"post","link":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-easily-analyze-data-and-run-different-queries-using-amazon-redshift-serverless-without-having-to-manage-the-infrastructure\/","title":{"rendered":"How to easily analyze data and run different queries using Amazon Redshift Serverless without having to manage the infrastructure?"},"content":{"rendered":"Reading Time: <\/span> 9<\/span> minutes<\/span><\/span>\n

<\/p>\n\n\n\n

To know about what\u2019s new in Amazon Redshift Serverless, refer to Part 1 of the blog here:<\/p>\n\n\n\n

What\u2019s new in Amazon Redshift \u2013 Serverless?<\/a><\/p>\n\n\n\n

Hands-on<\/h2>\n\n\n\n

In this hands-on, we will see how we can analyze data and run the different queries using Amazon Redshift Serverless without the need of managing the infrastructure using the Serverless capabilities.<\/p>\n\n\n\n

We will first login to the AWS console and navigate to the dashboard.<\/p>\n\n\n\n

Changing the region we will navigate to the Amazon S3 bucket Service and create a new bucket. We will then create a new workgroup traversing to the Amazon Redshift Serverless dashboard.<\/p>\n\n\n\n

While configuring the Redshift serverless, we will create a new IAM role for the newly created bucket to be able to access it. After the successful setup, and opening up the query editor, we will run the different queries to create the tables.<\/p>\n\n\n\n

We will then download the sample data and unzip the files, we will upload the files in the newly created S3 bucket. Once done, we will move the data in the newly created tables via the query editor running the different commands. <\/p>\n\n\n\n

We will then start with executing a basic query to check if the data has been successfully moved in the tables. Post that, we will run a complex query to get the required data.<\/p>\n\n\n\n

Finally, testing out the query editor and the data is retrieved, we will then explore the namespace configuration dashboard to look at how we can enable encryption, create data backups, create datashare objects, etc.<\/p>\n\n\n\n

Exploring the dashboard, we will then create a datashare object selecting the tables whose data can be shareable.<\/p>\n\n\n\n

\"Amazon<\/figure>\n\n\n\n

To implement the same, we will do the following:<\/strong><\/p>\n\n\n\n