SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ12

Implement Data Pipelines

A Data Engineer needs to check the status of a pipe named my_pipe. The pipe is located in a database named test and a schema named Extract (case-sensitive).

Which query returns the pipe's status?

Explanation

SYSTEM$PIPE_STATUS takes the fully qualified pipe name as one single-quoted string. A case-sensitive identifier within that name must retain double quotes, so the schema is written as "Extract" inside 'test."Extract".my_pipe'. The function returns a JSON value rather than a table result. Snowflake SYSTEM$PIPE_STATUS documentation

Learn more

Community Discussion

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