Connecting to a database (preview) - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Connecting to a database (preview)

This is prerelease documentation for the multi-data warehouse writes through data sharing feature for Amazon Redshift, which is available in public preview in the PREVIEW_2023 track. The documentation and the feature are both subject to change. We recommend that you use this feature only with test clusters, and not in production environments. For preview terms and conditions, see Beta Service Participation in Amazon Service Terms.

For more information about getting started with data sharing, go to Sharing both read and write data within an Amazon account or across accounts.

Connect to a database to view databases and objects within databases in this cluster or to view datashares.

The user credentials used to connect to a specified database must have the necessary permissions to view all datashares.

If there is no local connection, do one of the following:

  • In the cluster details page, from the Databases tab, in the Databases or Datashare objects section, choose Connect to database to view database objects in the cluster.

  • In the cluster details page, from the Datashares tab, do one of the following:

    • In the Datashares from other clusters section, choose Connect to database to view datashares from other clusters.

    • In the Datashares created in my cluster section, choose Connect to database to view datashares in your cluster.

  • On the Connect to database window, do one of the following:

    • If you choose Create a new connection, choose Amazon Secrets Manager to use a stored secret to authenticate access for the connection.

      Or, choose Temporary credentials to use database credentials to authenticate access for the connection. Specify values for Database name and Database user.

      Choose Connect.

    • Choose Use a recent connection to connect to another database that you have the necessary permissions.

      Amazon Redshift automatically makes the connection.

After database connection is established, you can start creating datashares, querying datashares, or creating databases from datashares.