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 time to 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.

Note

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.

Next Step

Create an Amazon Redshift Data Stream

Set Up an Amazon Redshift Data Federation Connection

See Also

Next Step