Amazon Redshift Serverless

Prerequisites

• The Amazon Redshift instance is running.

• An Amazon Redshift workgroup is created.

• The connection string or cluster identifier and port number of the Amazon Redshift Serverless instance are available.

• You are assigned the Team Collaborator or any administrator role except the Billing Administrator role in Hevo to create the Destination.

---

Set up an Amazon Redshift Instance (Optional)

---

Create a Workgroup and Namespace

You can create and associate a workgroup with a namespace to effectively manage resources and isolate workloads in Amazon Redshift Serverless. A workgroup is a collection of compute resources such as Redshift Processing Units (RPUs) and VPC subnet groups, whereas a namespace comprises database objects and users.

Perform the following steps to create a workgroup and a namespace:

1. On the Serverless dashboard, in the top right corner, click Create workgroup.

   

2. On the Create workgroup page, specify the following:

   

   • Workgroup name: A unique name for your workgroup.

   • Base capacity: The capacity, measured in Redshift Processing Units (RPUs), based on the amount of data or computational processing you require. Default value: 128.

   • Virtual private cloud (VPC): The virtual networking environment for the Serverless database.

   • VPC security groups: The security group(s) that define the subnets, IP ranges, and rules that control inbound traffic for your VPC endpoint. The security group allows access to the selected port.

     Note: Ensure that the security group you select has the protocol Type set to All TCP in its inbound rule configuration. Read Configuring security group communication settings for the steps to edit inbound rules.

     

   • Subnet: The IP address segments associated with the selected VPC.

3. Click Next.

4. On the Choose namespace page, specify the following:

   

   • Namespace: A unique name for your namespace.

   • Admin user credentials: The credentials to authorize the admin user on the Serverless database.

     • Customize admin user credentials (recommended): If selected, it allows you to add a new admin username and password. Otherwise, your IAM credentials are used as the default admin credentials.

     • Admin user name: The username of your admin user. Default value: admin.

     • Admin password: Select the following option to generate your admin password:

       • Manually add the admin password: If selected, you can provide the admin password manually.

         • Admin user password: The password of your admin user.

5. Copy the Database name, Admin user name, and Admin user password credentials and save them securely. Use these credentials while configuring your Amazon Redshift Serverless Destination.

6. Click Next.

7. In the Review and create page, review the workgroup and namespace settings and click Edit next to each section to change its details.

   

8. Click Create.

Once the workgroup and namespace are created, you can view them in the Serverless dashboard, under the Namespaces/Workgroups section.

---

Obtain the Redshift Serverless Connection Settings

Hevo connects to your Amazon Redshift Serverless data warehouse in one of the following ways:

• Using a connection string.

• Using the individual connection fields.

To connect using the connection string, you only need the string. If you opt for individual fields, you need the database cluster identifier and the port number. To retrieve these:

1. In the Namespaces/workgroups section, select the Workgroup that you created in the section above.

   

2. On the <your workgroup> page, under the Network and security section, click Edit.

   

3. In the Edit network and security page, select the Turn on Publicly accessible check box to allow outside sources to connect to your Serverless database.

   

4. Click Save changes.

5. In the <your workgroup> page, do one of the following:

   • To retrieve the publicly accessible endpoint:

     1. Click the copy ( ) icon corresponding to the JDBC URL to copy it. The connection string or database cluster identifier and the port number can be obtained from this URL.

        • Connection string: Use the entire JDBC URL as the connection string while configuring your Destination in Hevo.

          For example, jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/dev.

        • Database cluster identifier: Remove the jdbc:redshift:// and :<portnumber>/<databasename> parts from the JDBC URL to obtain the database cluster identifier, and use it while configuring your Destination in Hevo.

          For example, if jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/dev is the URL, use examplecluster.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com as the identifier.

        • Port number: The number string in the JDBC URL before the database name.

          For example, in the JDBC URL jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/dev, 5439 is the port number.

        

     2. Proceed to configure Amazon Redshift Serverless as a Destination in Hevo.

   • To retrieve the VPC endpoint:

     1. In the Data access tab, under the Redshift-managed VPC endpoint, click Create endpoint.

        

     2. In the Create Redshift-managed VPC endpoint page, specify the following:

        

        • Endpoint name: A unique name for the VPC endpoint.

        • Virtual private cloud (VPC): The virtual networking environment where the endpoint is created. The selected VPC must have subnets associated with it.

        • Subnet: The IP address segments associated with the selected VPC.

     3. Click Create endpoint.

     4. In the <your workgroup> page, Data access tab, under the Redshift-managed VPC endpoint, select the VPC endpoint that you created above.

        

     5. In the Settings for Redshift-managed VPC endpoint page, click the copy ( ) icon corresponding to the JDBC URL to copy it. The connection string or database cluster identifier and the port number can be obtained from this URL.

        • Connection string: Add the database name as a suffix to the JDBC URL to obtain the connection string while configuring your Destination in Hevo.

          For example, if jdbc:redshift://exampleendpoint.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/ is the URL, use jdbc:redshift://exampleendpoint.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/<database name> as the string.

        • Database cluster identifier: Remove the jdbc:redshift:// and :<portnumber>/ parts from the JDBC URL to obtain the database cluster identifier, and use it while configuring your Destination in Hevo.

          For example, if jdbc:redshift://exampleendpoint.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/ is the URL, use exampleendpoint.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com as the identifier.

        • Port number: The number string at the end of the JDBC URL.

          For example, in the JDBC URL jdbc:redshift://exampleendpoint.abc123xyz789.us-west-2.redshift-serverless.amazonaws.com:5439/, 5439 is the port number.

        

     6. Proceed to configure Amazon Redshift Serverless as a Destination in Hevo.

---