Redshift offers Cross-account data sharing which is a two-step process:
- You need to create a Redshift datashare.
- Then your authorize sharing data with the Kubit account. You can do this from the Amazon Redshift console.
You might choose one or more tables, views, or user-defined functions - whatever is relevant for your analytics use cases.
It’s important to note that the secondary account needs to be in the same Region, as cross-account data sharing does not work across Regions.
For more details on this setup check out the Cross-Account Data Sharing for Amazon Redshift blog post by AWS.
Updated 5 months ago