Posted On: Aug 13, 2021
Amazon Redshift data sharing allows you to share live, transactionally consistent data across different Redshift clusters without the complexity and delays associated with data copies and data movement. Ability to share data across clusters that are in the same AWS account is already available. Now sharing data across Redshift clusters in different AWS accounts is also generally available. Cross-account data sharing is supported on all Redshift RA3 node types. There is no additional cost to use cross-account sharing on your Amazon Redshift clusters.
With data sharing, you can securely share data at many levels including schemas, tables, views, and user defined functions, and use fine-grained controls to specify access for each data consumer. With cross-account data sharing, you can provide data access to other business groups within your organization, partners, and customers, enabling you to securely offer data and analytics as a service. Users with access to shared data can discover and query the data with high performance using standard SQL and analytics tools. Queries accessing shared data use the compute resources of the consumer Redshift cluster and do not impact the performance of the producer cluster. In addition to the database level privileges available to control sharing within the same account, Amazon Redshift integrates with AWS Identity Access Management (IAM) and offers additional granular security controls with a new authorization and acceptance workflow in cross-account sharing. With this, you can ensure that only authorized users are able to share data to other AWS accounts including outside organizations and consume data coming from other AWS accounts. Redshift also provides ability to monitor the data sharing permissions and the usage across all the consumer clusters and accounts and revoke access when needed.
Cross-account data sharing is available for all Amazon Redshift RA3 node types in US East (N. Virginia), US East (Ohio), US West (N. California), US West (Oregon), Asia Pacific (Mumbai), Asia Pacific (Seoul), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Canada (Central), Europe (Frankfurt), Europe (Ireland), Europe (London), Europe (Paris), Europe (Stockholm), and South America (São Paulo). Learn more about data sharing capability in feature page and refer to the blog and documentation on how to get started with cross-account data sharing.