Posted On: Apr 20, 2023
HAQM Redshift data sharing enables you to share live data across HAQM Redshift data warehouses. HAQM Redshift now supports simplified governance of HAQM Redshift data sharing by using AWS Lake Formation to centrally manage permissions on data being shared across your organization. With the new HAQM Redshift data sharing managed by AWS Lake Formation, you can manage permission grants, view access controls, and audit permissions on the tables and views in the Redshift datashares using Lake Formation APIs and the AWS Console.
Lake Formation managed data sharing improves the security of your data by enabling security administrators to use Lake Formation to manage granular entitlements such as table-level, column-level, or row-level access to tables and views being shared in Redshift data sharing. Data is shared live from Redshift Managed Storage (RMS) and not copied or moved to HAQM S3, data consumers can detect the data directly in AWS Lake formation and start querying within a minutes. You now have better visibility and control of data shared within and across accounts in your organization. AWS Lake Formation managed data sharing also enables you to define policies once and enforce those consistently for multiple data consumers.
Centralized access control for data sharing with AWS Lake formation is available in the following AWS Regions: US East (N. Virginia), US East (Ohio), US West (Oregon), Asia Pacific (Tokyo), Europe (Ireland), Europe (Stockholm), Europe (London), Europe (Paris), Europe (Frankfurt), South America (São Paulo), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Seoul), Asia Pacific (Mumbai), Canada (Central), US West (N. California). To learn more, visit the HAQM Redshift database developer guide.