SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ43

VerifiedDesign and Manage Snowflake Resources and Performance

A Data Engineer used a secondary role to create a dynamic table with a CREATE DYNAMIC TABLE command. The secondary role was granted the USAGE privilege, but the primary role was not.

What effect will this have on the dynamic table?

Explanation

For a dynamic table initialized on schedule, USAGE held only through a secondary role does not satisfy the refresh requirement when the primary owner role lacks that privilege. The dynamic table can initialize, but subsequent refreshes do not succeed.

Learn more

Community Discussion

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