Source
All functions (alphabetical)
This topic provides a list of all Snowflake system - defined (i.e. built - in) functions, scalar or table, in alphabetical order.
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.
<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.
DATA_METRIC_SCHEDULED_TIME (system data metric function)
Returns the timestamp for when a DMF is scheduled to run or the current timestamp if the function is called manually. You can use this DMF to define custom metrics to measure the freshness of your data or to define incremental metrics…
How to Search, Create, Vote & Follow Ideas
Snowflake Ideas is a great place for our customers to share feature requests, enhancements, and general ideas while allowing us to share where they are on our roadmap.
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…
How to check general availability for new features
FAQ: Snowflake's What’s New page is periodically updated with information on the latest releases, including when a feature becomes generally available.Snowflake encourages customers to check to visit the page to keep informed when the…