SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ78

Secure Data Sharing and Consumption

A Data Engineer is designing a near-real-time ingestion pipeline for a retail company to ingest event logs into Snowflake and derive insights. A Snowflake Architect is asked to define security best practices for configuring access-control privileges for the data load through auto-ingest to Snowpipe.

What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

Explanation

A Snowpipe auto-ingest role must own the named pipe and have the stage permissions needed to read staged files, along with USAGE on the target database and schema and INSERT and SELECT on the target table. Snowflake documents these required privileges for users executing continuous Snowpipe loads.

Learn more

Community Discussion

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