Data sharing in Amazon Redshift Serverless - 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).

Data sharing in Amazon Redshift Serverless

Use data sharing to share the most up-to-date and consistent information as it's updated in Amazon Redshift Serverless.

Data sharing in Amazon Redshift Serverless

With data sharing, you have live access to data so that your users can see the most up-to-date and consistent information as it's updated in Amazon Redshift Serverless.

Getting started with data sharing in Amazon Redshift Serverless

You can share data for read purposes across different Amazon Redshift Serverless instances within or across Amazon Web Services accounts.

You can get started with data sharing by using either the SQL interface or the Amazon Redshift console. For more information, see either Getting started data sharing using the SQL interface or Getting started data sharing using the console in the Amazon Redshift Database Developer Guide in the Amazon Redshift Database Developer Guide.

With data sharing, Amazon Redshift Serverless namespaces and provisioned clusters can share live data with each other, whether they are within an Amazon Web Services account across Amazon Web Services accounts, or across Amazon Web Services Regions. For more information, see Regions where data sharing is available.

To get started sharing data within an Amazon Web Services account, open the Amazon Web Services Management Console, and then choose the Amazon Redshift console. Choose Namespace configuration and then Datashares. Follow the procedures in Getting started data sharing using the console in the Amazon Redshift Database Developer Guide.

To get started sharing data across Amazon Web Services accounts, open the Amazon Web Services Management Console, and then choose the Amazon Redshift console. Choose Datashares. Follow the procedures in Getting started data sharing using the console in the Amazon Redshift Database Developer Guide.

To start querying data in a datashare, create a database in a namespace that has a workgroup associated with it. From a specified datashare, choose a namespace that has a workgroup associated with it and create a database to query data. Follow the procedures in Creating databases from datashares.

Granting access to view datashares using the console

A superuser can provide access to users who aren't superusers so that they can view the datashares created by all users.

To grant access to a datashare for a user, use the following command to provide datashare access for a user, where datashare_name is the name of the datashare and user-name is the name of the user for whom you want to provide access.

grant share on datashare datashare_name to "IAM:test_user";

To grant access to a datashare for a user group, first create a user group with users. For information on how to create user groups, see CREATE GROUP. Then, grant datashare access to a user using the following command, where datashare_name is the name of the datashare and user-group is the name of the user-group to that you want to grant access.

grant share on datashare datashare_name to group user_group;

For information on how to use the GRANT statement, see GRANT.

Data sharing considerations in Amazon Redshift Serverless

Following are considerations for working with data sharing in Amazon Redshift Serverless:

  • Amazon Redshift only supports provisioned clusters of instance type ra3.16xlarge, ra3.4xlarge, and ra3.xlplus, and serverless endpoint as data sharing producers or consumers.

  • Amazon Redshift Serverless is encrypted by default.

For a list of datasharing limitations, including database objects supported, encryption requirements, and sort-key requirements, see Considerations when using data sharing in Amazon Redshift in the Amazon Redshift Database Developer Guide.