Snowpipe for continuous loading in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Snowpipe that continuously loads data from a stage.

Snowflake

CREATE PIPE my_pipe AUTO_INGEST = [1] NOTIFICATION_INTEGRATION = my_integration AS COPY INTO my_table FROM @my_stage;

Drag options to blanks, or click blank then click option'

ATRUE

BFALSE

CON

DOFF

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE disables continuous loading.

Using ON or OFF are invalid values for AUTO_INGEST.

Setting AUTO_INGEST = TRUE enables Snowpipe to continuously load data as soon as files arrive in the stage.

2fill in blank

medium

Complete the code to create a notification integration for Snowpipe.

Snowflake

CREATE NOTIFICATION INTEGRATION my_integration TYPE = [1] ENABLED = TRUE;

Drag options to blanks, or click blank then click option'

ASTORAGE

BAWS_SNS

CQUEUE

DAWS_SQS

Attempts:

3 left

💡 Hint

Common Mistakes

Using AWS_SQS or AWS_SNS, which are not valid TYPE values.

Using STORAGE which is not a valid type.

Snowpipe notification integrations use TYPE = QUEUE to receive event messages for continuous loading. Cloud-specific parameters (e.g. AWS_SQS_URL) are specified separately.

3fill in blank

hard

Fix the error in the COPY statement inside the Snowpipe definition.

Snowflake

CREATE PIPE my_pipe AUTO_INGEST = TRUE NOTIFICATION_INTEGRATION = my_integration AS COPY INTO my_table FROM [1];

Drag options to blanks, or click blank then click option'

Amy_stage

B'my_stage'

Cstage

D@my_stage

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting '@' causes Snowflake to look for a table or file path.

Using quotes around the stage name is invalid.

The stage name must be prefixed with '@' to indicate it is a stage reference in the COPY INTO command.

4fill in blank

hard

Fill both blanks to configure the pipe to load from an external stage and specify the file format.

Snowflake

CREATE PIPE my_pipe AUTO_INGEST = TRUE NOTIFICATION_INTEGRATION = my_integration AS COPY INTO my_table FROM [1] FILE_FORMAT = (TYPE = [2]);

Drag options to blanks, or click blank then click option'

A@external_stage

BCSV

CJSON

Dmy_stage

Attempts:

3 left

💡 Hint

Common Mistakes

Using stage names without '@'.

Choosing the wrong file format type.

The pipe loads data from the external stage '@external_stage' and uses the CSV file format for parsing files.

5fill in blank

hard

Fill all three blanks to create a pipe with auto ingest, using a notification integration and a JSON file format.

Snowflake

CREATE PIPE my_pipe AUTO_INGEST = [1] NOTIFICATION_INTEGRATION = [2] AS COPY INTO my_table FROM [3] FILE_FORMAT = (TYPE = 'JSON');

Drag options to blanks, or click blank then click option'

ATRUE

Bmy_integration

C@my_stage

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Setting AUTO_INGEST to FALSE disables continuous loading.

Using stage names without '@'.

Incorrect notification integration name.

This pipe is set to auto ingest (TRUE), uses the notification integration named 'my_integration', and loads data from the stage '@my_stage' with JSON format.