Q: How do I turn on the Publicly accessible feature on my Amazon Redshift Serverless workgroup?

To turn on the Publicly accessible feature on your Amazon Redshift Serverless, follow the steps mentioned below-

• As a first and foremost step using the AWS Management Console, navigate your way to the Amazon Redshift console.
• On the navigation tab, select the option CLUSTERS.
• Once the CLUSTERS are selected, choose the group of CLUSTERS that you are planning to modify.
• Select Actions.
• Post the selection of Actions, click on the modify publicly accessible setting.
• Select Enable.
• Once all the steps are properly followed, choose save changes.

Through Redshift console, you will go to the main menu. select Create a workgroup and then do the steps to give it a name. choose the related VPC and subnet. Select Next.

Complete all the steps to make a namespace. This process will tell you to specify a database and assign an IAM role with permissions to do databased tasks.

If you have already made a namespace, that will also work.

With the Amazon VPC service console, you will verify that your VPC has an internet gateway included, with custom route table.

After completing the previous steps, select the workgroup from the given list. Then go to the Network and security panel, click on edit.

Choose Turn on Public Accessible. After doing this, the Amazon Redshift Serverless instance will be made public by means of allocating it to a static IPv4 Elastic IP address. This IP address will be assigned to your AWS account.