Amazon Redshift
Amazon Redshift is a cloud data-warehouse service.
There are two different types of connection that you can make to a Redshift cluster that you add as a source:
- A secure connection to a publicly accessible Redshift cluster
- A secure connection to a private Redshift cluster
Creating a Secure Connection to a Publicly Accessible Redshift Cluster
When Dremio Cloud runs queries against the Redshift cluster, the compute engines in your VPC and the cluster communicate through a connection that consists of a NAT gateway and internet gateway in the VPC used with Dremio Cloud, the internet, and the internet gateway in the VPC used for Redshift.
Prerequisites for the VPC that you are using for your Dremio Cloud project
- Ensure that the compute engines are deployed in a private subnet.
- Ensure that a NAT gateway configured in a public subnet.
- Ensure that an internet gateway is attached to the VPC.
Prerequisites for the VPC that you are using for Amazon Redshift
- Ensure that the Redshift cluster is in a public subnet.
- Ensure that you know the IP address of the NAT gateway that is in the VPC that you are using for Dremio Cloud.
Steps to follow in Amazon Redshift
- In the Clusters table, click the name of the Redshift cluster that you plan to use. The UI console for the cluster opens.
- Make the cluster publicly accessible:
- Click Actions in the upper-right corner of the console.
- Select Modify publicly accessible setting.
- In the Edit publicly accessible dialog, select the check box Turn on Publicly accessible, and select the Elastic IP address to use for connections to the cluster.
- Create an inbound rule for the IP address of the NAT gateway that is in the VPC being used with Dremio Cloud:
- In the UI console for the cluster, scroll down to the Network and security settings section.
- Click the name of the VPC security group. The UI console for the security group opens.
- In the Inbound rules section, click Edit Inbound Rules.
- On the Edit inbound rules page, click Add rule.
- In the Type field, select Redshift.
- Specify the IP address for the NAT gateway in the field to the right of the Source field.
- Click Save rules.
What to do next
Add the Redshift cluster as a data source in Dremio Cloud.
Creating a Secure Connection to a Private Redshift Cluster
When Dremio Cloud runs queries against the Redshift cluster, the compute engines in your VPC and the cluster communicate through a VPC peering connection.