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