Source
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…
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.
AI_COMPLETE (Single string)
Preview Feature — Open Available to all accounts. Note AI_COMPLETE is the updated version of COMPLETE (SNOWFLAKE.CORTEX). For the latest functionality, use AI_COMPLETE. Generates a response (completion) for a text prompt using a…
All functions (alphabetical)
This topic provides a list of all Snowflake system - defined (i.e. built - in) functions, scalar or table, in alphabetical order.
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.
LISTING_AUTO_FULFILLMENT_DATABASE_STORAGE_DAILY view
The data is retained for 365 days (1 year). Stage storage is not included in this view. The view only contains data from 2023 - 04 - 16 onward. In cases where auto - fulfillment is incomplete, the array returned for the LISTINGS column might be…
<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.
DESCRIBE LISTING
To post - process the output of this command, you can use the pipe operator ( - >>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query. The output column names for this command are generated in…