Posted On: Mar 10, 2021
Amazon Redshift Data Sharing, a secure and easy way to share live data across Redshift clusters, is now generally available. Data Sharing enables instant, granular, and high-performance data access across Amazon Redshift clusters within an AWS account, without the need to copy or move data. Data Sharing provides live access to the data so that your users always see most up-to-date and consistent information as it is updated in the data warehouse. Data Sharing can be used on your Amazon Redshift RA3 clusters at no additional cost.
With Data Sharing, you can isolate diverse workloads across different Amazon Redshift clusters while still sharing live, transactionally consistent data by leveraging Redshift Managed Storage across these clusters without the complexity and delays associated with data copies and data movement. Queries accessing shared data are run using the compute resources of the consumer cluster and do not impact the performance of the producer cluster.Data sharing allows you to rapidly onboard new analytics workloads and provision them with flexible compute resources to meet individual workload-specific performance SLAs. Data Sharing enables seamless collaboration across business groups for broader analytics and to analyze cross-product impact. You can use SQL or the Redshift console to securely share data at several levels including schemas, tables, views, and user defined functions, providing fine-grained controls that can be tailored for different consumers that all need access to data. Users and groups that have access to shared data on consumer clusters can discover the data and perform cross-database queries to join data in databases on the cluster with shared data from remote clusters using familiar tools. Amazon Redshift offers detailed auditing capabilities to monitor the data sharing permissions and the usage across all the consumers and revoke access instantly when necessary.
Data Sharing is available in all regions where RA3 node types are available, specifically, 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).