10.19 Release Notes: May 22, 2026-May 27, 2026¶

New features¶

Virtual columns (General availability)¶

Virtual columns are now generally available. A virtual column contains values that are computed from an expression at query time rather than stored in the table, which lets you derive values from other columns without using extra storage or maintaining redundant data.

You can define virtual columns when you create or alter a table by including an AS ( <expr> ) clause in the column definition:

CREATE OR REPLACE TABLE t (i INT, j INT AS (i * i));

ALTER TABLE t ADD COLUMN k INT AS (i + 1);

Virtual column expressions support literals, operators, and deterministic system-defined functions, and can reference other columns in the same table (including earlier virtual columns). The declared column type is optional; when omitted, Snowflake infers it from the expression.

For more information, see the following topics:

• Virtual Columns
• CREATE TABLE
• ALTER TABLE

Release notes change log¶