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.
All functions (alphabetical)
This topic provides a list of all Snowflake system - defined (i.e. built - in) functions, scalar or table, in alphabetical order.
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…
Parquet Files: Statistics Included for Decimal Columns Unloaded as FixedLengthByteArrays
Attention This behavior change is in the 2023_03 bundle. For the current status of the bundle, refer to Bundle History.
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.
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.
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.
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…
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.
Dealing with real-world data in Time-Series Forecasting
This parameter specifies a time period in a form similar to '1 day' or '2 weeks'. The interval specification is a string and therefore must be surrounded with single quotes. Supported intervals are seconds, minutes, hours, days, weeks,…