---
schema_version: "1"
id: 4a6dde6c2c2b132c1bbf6723aa68a4be8e9c1e2123ad9aeeb4cd6dc937b817ca
title: Set Up an Amazon Redshift Data Federation Connection
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/redshift/c360-a-set-up-data-federation-redshift-connection.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-set-up-data-federation-redshift-connection.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 2d0fea8f5f28aff1e0ef37770c03e00d5b8f550297ed9321779e75d573aab45e
products:
  - Data 360 Integration Guide
  - Data 360 Developer Documentation
---
# 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](https://help.salesforce.com/s/articleView?id=data.c360_a_private_connect_data_cloud.htm&type=5).

| 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](https://help.salesforce.com/s/articleView?id=data.c360_a_data_cloud_ip_address_allowlist.htm&type=5), 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](https://docs.aws.amazon.com/redshift/latest/dg/cm-c-wlm-query-monitoring-rules.html)

**note:** You can’t use an existing connection and change it to use Private Connect. This isn’t supported.

1.  In Data Cloud, go to Data Cloud Setup.

2.  Under External Integrations, select **Other Connectors**.

3.  Click **New**.

4.  Under Source, select **Amazon Redshift** and click **Next**.

5.  Enter a connection name and connection API name.

6.  Enter the Connection URL and Database details.

7.  If you choose to use IdP, click **Identity Provider Based**. Refer to [Use Identity Provider Authentication for Amazon Redshift Data Federation Connection](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-idp-data-federation-redshift-connection.md) 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. |

8.  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. |

9.  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
- [_Salesforce Help_: Add a Private Network Route for Redshift](https://help.salesforce.com/s/articleView?id=data.c360_a_private_connect_redshift.htm&type=5)




## Next Step

- [Create an Amazon Redshift Data Stream](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-create-redshift-data-fed-data-stream.md)