Multi-cluster warehouses
Maximized: This mode is enabled by specifying the same value for both maximum and minimum number of clusters (note that the specified value must be larger than 1). In this mode, when the warehouse is started, Snowflake starts all the…
Common considerations related to Virtual Warehouse credit consumption
These features are useful for managing credit usage when a virtual warehouse has stopped executing queries(and to automatically resume the warehouse when queries begin executing again).
Warehouse considerations
Snowflake utilizes per - second billing, so you can run larger warehouses (Large, X - Large, 2X - Large, etc.) and simply suspend them when not in use.
Automatic Clustering, Materialized Views, & Automatic Maintenance In Snowflake
This means Snowflake efficiently and automatically executes the re - clustering or MV refresh statements in the background. No need to create, size or resize a virtual warehouse.
Overview of warehouses
Warehouses are required for queries, as well as all DML operations, including loading data into tables. In addition to being defined by its type as either Standard or Snowpark - optimized, a warehouse is defined by its size, as well as the…
Snowflake Editions
It includes all the features and services of Enterprise Edition, with the addition of enhanced security and data protection. In addition, account failover/failback adds support for business continuity and disaster recovery.
How refresh mode affects dynamic table performance
A dynamic table’s actual refresh mode is determined at creation time and is immutable afterward. If not specified explicitly, the refresh mode defaults to AUTO, which selects a refresh mode based on various factors such as query…
Optimizing storage for performance
Snowflake enables Automatic Clustering to maintain the clustering of the table as soon as you define a cluster key. Once enabled, Automatic Clustering updates micro - partitions as new data is added to the table.
Introduction to tasks
With this model, tasks run on Snowflake - managed compute. Snowflake automatically resizes the resources as required for each workload. Snowflake determines the ideal size of compute resources for a given run based on a dynamic analysis of…
Snowflake Cortex AISQL (including LLM functions)
All models are fully hosted in Snowflake, ensuring performance, scalability, and governance while keeping your data secure and in place. Available functions Snowflake Cortex features are provided as SQL functions and are also available in…
Source