Creating a database from a datashare in
Amazon Redshift
With Amazon Redshift, you can use a datashare to create a database, and then query data across datashares from producer clusters to securely access live data without copying or transferring it. The following steps cover the details of setting up a database in your Amazon Redshift environment.
Before you can query data in the datashare, you must 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 or perform write operations, if they have been granted, authorized, and associated by the consumer administrator.