QuestionQ292

Data Store Management

Two data engineering teams use different AWS accounts. Both teams request access to the same datashare, named salesshare, in an Amazon Redshift cluster located in a third AWS account.

A data engineer must use the Amazon Redshift SQL interface to grant both data engineering teams access to the datashare.

Which command or commands satisfy this requirement?

  • A GRANT USAGE ON DATASHARE salesshare TO ACCOUNTS ‘’ AND ‘’;
  • B GRANT USAGE ON DATASHARE salesshare TO NAMESPACES ‘’ AND ‘’;
  • C GRANT USAGE ON DATASHARE salesshare TO ACCOUNT ‘’;GRANT USAGE ON DATASHARE salesshare TO ACCOUNT ‘’;
  • D GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ‘’;GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ‘’;
Explanation

Amazon Redshift grants cross-account datashare usage to an AWS account with GRANT USAGE ON DATASHARE ... TO ACCOUNT 'accountnumber'. A GRANT statement can grant access to only one datashare consumer, so each of the two consumer accounts requires its own TO ACCOUNT statement. Amazon Redshift GRANT documentation

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!