Set Up an Amazon Redshift Data Federation Connection
Set up a connection between Amazon Redshift and Data 360 to access data. To set up an Amazon Redshift data federation connection for Data 360, see Private Connect for Data 360.
| User Permissions Needed | |
|---|---|
| To create an Amazon Redshift Federation connection in Data Cloud: | System Admin profile or Data Cloud Architect permission set |
Before you begin:
- Review Data 360 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. Redshift AWS Region AWS Region of the Redshift cluster. This field is mandatory if you set up the Identity Provider Based authentication and the Redshift cluster and Data360 clusters are in different regions. -
Click Save.
Keep these behaviors in mind when you edit an existing Redshift query federation connection.
- You can edit the existing Redshift connection and update the Connection Name. Note that the Connection API Name can't be changed.
- You can change the authentication options from Username and Password based to Identity Provider based and back again.
- You can update the Username and Password, the connection URL, and the database name.
- You need to update the Redshift AWS Region if you change the connection to use Identity Provider based authentication and the Redshift and Data360 clusters are in different regions.
See Also