Querying datashares (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).

Querying datashares (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.

Creating databases from datashares

To start querying data in the datashare, create a database from a datashare. You can create only one database from a specified datashare.

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

  2. On the navigation menu, choose Clusters, then choose your cluster. The cluster details page appears.

  3. Choose Datashares. The datashare list appears.

  4. In the Datashares from other clusters section, choose Connect to database. For more information, see Connecting to a database (preview).

  5. Choose a datashare that you want to create databases from, then choose Create database from datashare. The Create database from datashare page appears.

  6. In the Database name, specify a database name. The database name must be 1–64 alphanumeric characters (lowercase only) and it can't be a reserved word.

  7. Choose Create.

After the database is created, you can query data in the database or perform write operations, if they have been granted, authorized, and associated by the consumer administrator.