Categories:: Context Functions (General)

CURRENT_VERSION¶

Returns the current Snowflake version.

See also:: CURRENT_CLIENT

Syntax¶

CURRENT_VERSION()

Copy

Arguments¶

None.

Returns¶

The data type of the returned value is VARCHAR.

The returned value contains four fields:

<major_version>.<minor_version>.<patch_version>  <internal_identifier>
Copy
major_version
Major version numbers typically change only when major new functionality is introduced.

minor_version
Minor version numbers change for each weekly release.

patch_version
Patch version numbers represent minor changes within a weekly release.

internal_identifier
This field is for internal use only.

For example, for version 1.2.3, the major version is 1, the minor version is 2, and the patch version is 3.

Usage Notes¶

This function returns version number information for Snowflake. To retrieve information about client versions, see CURRENT_CLIENT.

Examples¶

This shows the version of Snowflake on which the query is run:

SELECT CURRENT_VERSION();

Copy

Output:

+-------------------+
| CURRENT_VERSION() |
|-------------------|
| 4.32.0 b134968    |
+-------------------+

Copy