Querying datashares
With Amazon Redshift, you can query data across datashares from producer clusters to securely access live data without copying or transferring it. The following sections cover the details of setting up and querying datashares in your Amazon Redshift environment.
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.
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/
. -
On the navigation menu, choose Clusters, then choose your cluster. The cluster details page appears.
-
Choose Datashares. The datashare list appears.
-
In the Datashares from other clusters section, choose Connect to database. For more information, see Connecting to a database.
-
Choose a datashare that you want to create databases from, then choose Create database from datashare. The Create database from datashare page appears.
-
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.
-
Choose Create.
After the database is created, you can query data in the database.