Which minimum permissions allow a role to view COPY_HISTORY results for Snowpipe loads?

• A. USAGE
• B. USAGE, MONITOR, SELECT
• C. OWNERSHIP, SELECT
• D. USAGE, SELECT

Answer: (B)

Viewing COPY_HISTORY results requires a combination of access to the objects, visibility into monitoring data, and the ability to read the results. USAGE lets you access the database/schema and the history source. MONITOR provides access to monitoring data, which includes load and pipe histories like COPY_HISTORY. SELECT is needed to actually read the rows returned by the COPY_HISTORY query or function. Without MONITOR you can’t see the monitoring history, and without SELECT you can’t retrieve the data. The other options miss one of these essential pieces, so they don’t grant the minimal necessary access.