Redshift – The basics of granting a shared database or subset of a database

By /

Basically it comes down to this syntactical example:

GRANT USAGE ON DATASHARE salesshare TO NAMESPACE '13b8833d-17c6-4f16-8fe4-1a018f5ed00d';

To determine the namespace of the cluster you want to grant the share to you or someone with access to the cluster should issue this command to identify the namespace that should be grant access to the share:

SELECT CURRENT_NAMESPACE;

For more information on creating and granting Redshift database shares see:

https://docs.aws.amazon.com/redshift/latest/dg/datashare-overview.html

Post Views: 9

Leave a Comment

Scroll to Top