Which view in Account Usage schema is used to get details of Pipes objects?

• A. PIPE_DETAILS
• B. PIPES
• C. PIPE_OBJECTS
• D. PIPES_INFO

Answer: (B)

In Account Usage, the PIPES view is the go-to source for metadata about Snowpipe pipelines. It provides details for each pipe object, such as database_name, schema_name, pipe_name, the owner, creation time, and current status. This makes PIPES the best choice when you need to obtain details about Pipes objects. The other names aren’t the standard source for pipe-level metadata in Account Usage, so they don’t align with retrieving those details.