SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ40

Ingest and Process Data

Which of the following grants are needed for the kafka_load_role_1 role when it runs the Snowflake Connector for Kafka to load data into Snowflake?

Assume that this role already exists and has USAGE access to the kafka_schema schema in the kafka_db database, which is the data-loading target.

Choose three
Explanation

The classic Snowflake Connector for Kafka requires schema-level privileges to create the target table, a temporary internal stage, and Snowpipe pipes used to load Kafka data. Therefore, the role needs CREATE TABLE, CREATE STAGE, and CREATE PIPE on the target schema; CREATE STREAM, CREATE TASK, and CREATE EXTERNAL TABLE are not part of the connector’s required schema privileges.

Learn more

Community Discussion

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