Source
Account Usage
In the SNOWFLAKE database, the ACCOUNT_USAGE and READER_ACCOUNT_USAGE schemas enable querying object metadata, as well as historical usage data, for your account and all reader accounts (if any) associated with the account.
LISTING_EVENTS_DAILY: new columns in output
This behavior change is in the 2024_07 bundle. For the current status of the bundle, refer to Bundle History. When this behavior change bundle is enabled, two new columns appear in LISTING_EVENTS_DAILY view in the Data Sharing Usage…
QUERY_HISTORY view (Account Usage): Changes to columns and new columns
The count and number of IDs have a maximum of 50. ROWS_WRITTEN_TO_RESULT NUMBER Number of rows written to a result object. For CREATE TABLE AS SELECT (CTAS) and all DML operations, this result is 1.
How can PARTITIONS_SCANNED be larger than the PARTITIONS_TOTAL for a query
FAQ: The reason for this discrepancy in the ACCOUNT_USAGE.
DATA_CLASSIFICATION_LATEST view
This Account Usage view displays one row for the most recent result of a classified table for each classified table. Each row corresponds to a different table.
Behavior change announcements
Planned to be introduced, Disabled by Default, in the 9.32 release (October 2025), subject to change; once introduced, account admins can enable for testing. Status planned to change in January 2026 to Enabled by Default; however, this…
GET_QUERY_OPERATOR_STATS
Returns statistics about individual query operators within a query that has completed. You can run this function for any completed query that was executed in the past 14 days.
MARKETPLACE_PAID_USAGE_DAILY View
Latency for the view can be up to 48 hours (2 days). The data is retained for 365 days (1 year). You can only see the usage for your account, which must be the consumer account that generated the charges.
<service_name>!SPCS_GET_EVENTS
Returns the events that Snowflake collected for the specified service. For more information, see Accessing platform events. Note The function is supported only for services and jobs created in release 9.20 or later.
MARKETPLACE_PAID_USAGE_DAILY View
You can use the MARKETPLACE_PAID_USAGE_DAILY view in the Organization Usage schema to query the daily history of your usage of paid listings. Retrieve the count of queries executed by users in your account on individual listings, with the…