Querying datashares - Amazon Redshift

Querying datashares

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 AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

  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.

  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.