Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Creating the consumer database - Amazon Redshift

Creating the consumer database

On the consumer cluster, you create a database from the datashare. These steps describe how to share data between two clusters in the same account. For information on sharing data across AWS accounts, see Sharing data across AWS accounts in the Amazon Redshift Database Developer Guide.

You can use SQL commands or the query editor v2 tree-view panel to create the database.

To use SQL
  1. Create a database from the datashare for your account and the namespace of the producer cluster. For example:

    create database share_db from datashare mysource of account '123456789012' namespace 'p1234567-8765-4321-p10987654321';
  2. Set permissions so that users can access the database and the schema. For example:

    grant usage on database share_db to usernames;
    grant usage on schema public to usernames;
To use the query editor v2 tree-view panel
  1. Choose Plus sign icon inside a circle, indicating an add or create action. Create, and then choose Database.

  2. Enter a Database name.

  3. (Optional) Select Users and groups, and choose a Database user.

  4. Choose Create using a datashare.

  5. Choose the datashare.

  6. Choose Create database.

    The new datashare datashare database displays in the query editor v2 tree-view panel.

  7. Set permissions so that users can access the database and the schema. For example:

    grant usage on database share_db to usernames;
    grant usage on schema public to usernames;
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.