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.
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.
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.
All functions (alphabetical)
This topic provides a list of all Snowflake system - defined (i.e. built - in) functions, scalar or table, in alphabetical order.
QUERY_INSIGHTS view
This Account Usage view displays a row for each insight produced for a query.
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…
<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.
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.
Deprecated functionality
You can use the numPages field in the ResultSet_resultSetMetaData object in the ResultSet object to determine the total number of pages of results. To get the next page of results or other pages of results, use the URLs provided in the…
WAREHOUSE_EVENTS_HISTORY view
This Account Usage view can be used to return the events that have been triggered for the single - cluster and multi - cluster warehouses in your account in the last 365 days (1 year). Supported events include: Creating, dropping, or altering…