Getting started with multi-warehouse writes using data sharing in Amazon Redshift

You can share database objects for both reads and writes across different Amazon Redshift clusters or Amazon Redshift Serverless workgroups within the same Amazon Web Services account, across accounts, and across regions. The procedures in this topic show how to set up data sharing that includes write permissions. You can grant permissions such as SELECT, INSERT, and UPDATE for different tables and USAGE and CREATE for schemas.

Data is live and available to all warehouses as soon as you commit a write transaction Producer account administrators can determine whether or not specific namespaces or regions get read-only, read-and-write, or any access to the data. The procedures assume you're working in a database in a provisioned cluster or Amazon Redshift Serverless workgroup.

With Amazon Redshift, you can manage data sharing with writes using the console or the SQL interface to control access and govern data across Amazon Redshift clusters and Amazon accounts. The following sections provide step-by-step instructions on configuring and managing data sharing with writes using Amazon Redshift.

For a list of Regions where data sharing is available, see Amazon Web Services Regions where data sharing is available. For considerations and limitations for writes, see Considerations for data sharing in Amazon Redshift.