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