SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ6

Secure Data Sharing and Consumption

A data share exists between a data provider account and a data consumer account. Five tables from the provider account are shared with the consumer account. The consumer role has been granted the IMPORTED PRIVILEGES privilege.

What occurs in the consumer account when a new table (table_6) is added to the provider schema?

Explanation

A newly created table is not automatically available through an existing Snowflake share. The provider must explicitly grant SELECT on EDW.ACCOUNTING.Table_6 to PSHARE_EDW_4TEST. Because the consumer role already has IMPORTED PRIVILEGES on the imported database, it can access the table as soon as the provider adds it to that share.

Learn more

Community Discussion

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