Get startedGet started for free

ACCOUNT_USAGE vs INFORMATION_SCHEMA

Two members of Claro's data team have different monitoring needs this morning. The compliance manager needs a complete report on all queries run against the account over the past month for a regulatory audit. Separately, the on-call engineer is investigating a warehouse that appears to be running slowly right now and wants to see queries currently executing in the active session.

Which schema should each person use?

This exercise is part of the course

Snowflake Management, Governance & Collaboration

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise