What is Amazon Redshift?
Welcome to the Amazon Redshift Management Guide. Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. This allows you to use your data to gain new insights for your business and customers.
The first step to create a data warehouse is to launch a set of nodes, called an Amazon Redshift cluster. After you provision your cluster, you can upload your data set and then perform data analysis queries. Regardless of the size of the data set, Amazon Redshift offers fast query performance using the same SQL-based tools and business intelligence applications that you use today.
Amazon Redshift Serverless
Amazon Redshift Serverless provides data warehouse capacity and intelligent scaling with simple configuration and management. You can access and analyze data without setting up a provisioned data warehouse.
Create Amazon Redshift
Prerequisite: REDSHIFT JDBC URL
Enable Inboud for Type Redshift in security group of Redshift Cluster
First open security group of Redshift cluster
Configure inbound rule for redshift
Enable publicly accessible
Click on edit as per attached screenshot
Enable checkbox as done in screenshot