A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a database named test and a schema named Extract (case-sensitive). Which query will provide the status of the pipe?
A.
SELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
B.
SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
C.
SELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
D.
SELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
The correct query to check the status of a pipe named my_pipe inside a database named test and a case-sensitive schema named Extract is:
B. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
This query uses double quotes around the schema name "Extract" to ensure that the case sensitivity is preserved. Additionally, the single quotes around the pipe name my_pipe and the dot notation for specifying the database and schema are correct in Snowflake SQL syntax.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
prshntdxt7
10 months, 2 weeks agostopthisnow
1 year agoSV1122
11 months, 2 weeks ago