Set Up an Amazon Redshift Data Federation Connection
Set up a connection between Amazon Redshift and Data Cloud to access data. To set up an Amazon Redshift data federation connection for Data Cloud, see Private Connect for Data Cloud.
| User Permissions Needed | |
|---|---|
| To create an Amazon Redshift Federation connection in Data Cloud: | System Admin |
Before you begin:
- Review Data Cloud IP Allowlist, and update your allowlists.
- Make sure that the Redshift cluster or server workgroup is publicly accessible.
- To support large data sizes, set
Maximum query execution timeto the maximum, which is 86,399 seconds. For more information, see Query monitoring metrics for Amazon Redshift
You can’t use an existing connection and change it to use Private Connect. This isn’t supported.
-
In Data Cloud, go to Data Cloud Setup.
-
Under External Integrations, select Other Connectors.
-
Click New.
-
Under Source, select Amazon Redshift and click Next.
-
Enter a connection name and connection API name.
-
Enter the Connection URL and Database details.
-
If you choose to use IdP, click Identity Provider Based. Refer to Use Identity Provider Authentication for Amazon Redshift Data Federation Connection for more details and enter the values.
Field Label Description IAM Role Name The Amazon Resource Name (ARN) specifying the role. External ID It’s an auto-generated connection ID. Enter the External ID in the AWS trust policy for the role before testing the connection. -
Enter the connection details.
If you don’t turn on Private Network Route, enter the values.
Field Label Description Connection URL JDBC URL of the provisioned Redshift cluster. Database The Redshift database name. -
Click Save.
See Also