thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

ACCOUNT_USAGE Schema

A schema in the shared SNOWFLAKE database with account-wide metadata and usage views such as QUERY_HISTORY, WAREHOUSE_METERING_HISTORY and ACCESS_HISTORY.

Definition

ACCOUNT_USAGE retains data for 365 days, includes dropped objects, and has latency of roughly 45 minutes to 3 hours. INFORMATION_SCHEMA is real-time but database-scoped, has shorter retention (7-14 days for history functions) and excludes dropped objects.

Exam tip

Long-term usage analysis = ACCOUNT_USAGE; real-time per-database metadata = INFORMATION_SCHEMA.

Related terms