A Data Engineer creates a pipe called mypipe. What command needs to be run to verify that the pipe is configured correctly and is running?

Question

Options

• Ashow pipes like 'mypipe'
• Bselect system$pipe_status('public.mypipe')
• Cdescribe pipe 'public.mypipe'
• Dselect system$verify_pipe('public.mypipe')

• B
  95% (18)
• D
  5% (1)

Explanation

system$pipe_status('public.mypipe') is a Snowflake system function that returns a JSON object showing the pipe's current operational state - including whether it's running, paused, or has errors - making it the correct tool to verify both configuration and execution status.

Why the distractors are wrong:

• A - SHOW PIPES LIKE 'mypipe' lists pipe metadata (owner, definition, schedule) but does not reveal runtime/execution status.
• C - DESCRIBE PIPE 'public.mypipe' shows the pipe's DDL definition, not whether it's actively running or correctly processing data.
• D - system$verify_pipe() does not exist in Snowflake; it's a plausible-sounding distractor.

Memory tip: Think of system$pipe_status as the pipe's "health check" - the word status directly maps to checking if something is running, which is exactly what the question asks. Anytime an exam asks about runtime state or operational health of a pipe, reach for system$pipe_status.

No community discussion yet for this question.