Set Up an Amazon Redshift Data Federation Connection

Set up a connection between Amazon Redshift and Data Cloud to access data.

User Permissions Needed 
To create an Amazon Redshift Federation connection in Data Cloud:System Admin

Before you begin:

  • For Private Connect for Data Cloud, you must have a configured Redshift-managed cluster and configure a private network route to create a connection to Redshift.
  • For connections that don’t use Private Connect for Data Cloud:
    • Review Data Cloud IP Allowlist, and update your allowlists.
    • Make sure that the Redshift cluster or server workgroup is publicly accessible. Not applicable to Private Connect for Data Cloud.
    • 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.

  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 authentication details.

    If you choose to use Access Key and Secret, click Access Key/Secret Based.

    Field LabelDescription
    UsernameUsername for access to the Amazon Redshift database.
    PasswordPassword for access to the Amazon Redshift database.

    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 LabelDescription
    IAM Role NameThe Amazon Resource Name (ARN) specifying the role.
    External IDIt’s an auto-generated connection ID. Enter the External ID in the AWS trust policy for the role before testing the connection.

  7. Enter the connection details.

    If you don’t turn on Private Network Route, enter the values.

    Field LabelDescription
    Connection URLJDBC URL of the provisioned Redshift cluster.
    DatabaseThe Redshift database name.

    If you turn on Private Network Route, enter the values.

    Field LabelDescription
    Private Network RouteThe connection name of the private connect route. See Secure Cross-Cloud Integrations with Private Connect and Establish an Inbound Connection with AWS.
    DatabaseThe Redshift database name.

  8. To review your configuration, click Test Connection.

  9. Click Save.