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.
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.
Considerations
Consider the following when 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.