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…
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.
Sample Data: OpenWeatherMap — Deprecated
DAILY_14_TOTAL 12 days of daily weather forecasts for 20,000+ cities.
Observability Views (Account Usage and Information Schema): New Columns in Views
The number of manual retries for a given graph run. For tasks which have never been restarted a value of 0 is returned.
Using the Query Hash to Identify Patterns and Trends in Queries
Using the Query Hash to Identify Patterns and Trends in Queries To identify, group, and analyze similar queries in the query history, you can use a hash of the query text.
SnowConvert AI - BigQuery Issues
SnowConvert AI for Google BigQuery currently supports assessment and translation for TABLES and VIEWS. Although SnowConvert AI can recognize other types of statements, they are not fully supported.
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…
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.