Simplifying Data Sharing Setup with the Amazon Redshift Console

Overview

In the modern landscape of data-driven decision-making, efficient and secure data sharing is essential for organizations looking to collaborate across departments or even with external partners. Amazon Redshift Data Sharing offers an innovative solution that allows users to share live data between Amazon Redshift clusters seamlessly. This feature ensures instant access to real-time data by eliminating data redundancy, making it a powerful tool for cross-cluster analytics and collaboration.

This guide walks you through setting up data sharing in Amazon Redshift using the Amazon Redshift Console and answers frequently asked questions for an easier start.

Prerequisites

To get started with Amazon Redshift Data Sharing, ensure the following:

1. Your Amazon Redshift account has at least one cluster for data sharing.
2. You have the necessary AWS IAM permissions to create and manage data shares.
3. Your Amazon Redshift cluster is compatible with data sharing (generally supported by RA3 node types).

Step-by-Step Process for Configuring Data Sharing in Amazon Redshift

Step 1: Access the Amazon Redshift Console

1. Open the Amazon Redshift Console
2. In the left navigation pane, click on Clusters to view your available clusters.

Step 2: Choose the Producer Cluster

1. Select the cluster that will be the Producer Cluster containing the shared data. Choose redshift-cluster.

2. Tap on redshift-cluster and Choose Datashares.

Step 3: Create a Data Share

1. In the Data Shares section, click Create data share.

2. Provide a name for your data share.

3. Add Datashare Objects like Tables, views, and User Defined Functions.

4. Specify the AWS Account you want the data share to be accessible within and the namespace of the consumer cluster from the dropdown.

Step 4: Review and Confirm the Data Share

1. Carefully review the configuration details, including the selected objects and permissions.
2. Click Create to finalize and create the data share.

Step 5: Configure Data Sharing on the Consumer Cluster

1. Go back to the Clusters section of the Amazon Redshift Console and select the Consumer Cluster that will access the shared data. Choose redshift-cluster-2.
2. Tap on redshift-cluster-2 and choose Datshares. Go to Datashares from other namespaces and AWS accounts.

3. Select the data share you created earlier and click on Create database from Datashare for your shared views, tables, or functions to reside in.

5. Confirm the configurations and click on Create.

Managing Data Shares

Modifying a Data Share
To change objects in an existing data share, return to the Manage data sharing section of the producer cluster. Add or remove objects and update permissions as needed.

Deleting a Data Share
To remove a data share, navigate to the Data Shares section in the producer cluster and select the data share you wish to delete. Confirm the deletion to revoke access.

Best Practices for Data Sharing

1. Granular Access Control: Share only specific schemas, tables, or views to minimize exposure of sensitive data.
2. Monitor Usage: Use system views such as svv_datashares to track data access and usage patterns.
3. Optimize Performance: Apply appropriate filters and permissions to ensure efficient data queries.
4. Security and Compliance: Regularly review data-sharing configurations to ensure compliance with organizational policies and regulations.

Conclusion

By leveraging access controls and high-performance querying, Amazon Redshift Data Sharing provides a secure and scalable approach to data collaboration. Setting it up via the Amazon Redshift Console is straightforward and brings significant value to data-driven decision-making.

Drop a query if you have any questions regarding Amazon Redshift Data Sharing and we will get back to you quickly.

About CloudThat

CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.

CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 650k+ professionals in 500+ cloud certifications and completed 300+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner,  AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner, Amazon CloudFront and many more.

To get started, go through our Consultancy page and Managed Services Package, CloudThat’s offerings.