Categories:

Context Functions (General)

CURRENT_CLIENT¶

Returns the version of the client from which the function was called. If called from an application using the JDBC or ODBC driver to connect to Snowflake, returns the version of the driver.

Syntax¶

CURRENT_CLIENT()
Copy

Usage Notes¶

  • The Worksheet in the Snowflake web interface connects to Snowflake directly through the interface; it doesn’t use the JDBC or ODBC driver. As such, calling CURRENT_CLIENT in the Worksheet returns a different value than calling the function from a client application.

Examples¶

Call CURRENT_CLIENT from within SnowSQL:

SELECT CURRENT_CLIENT();

+------------------+
| CURRENT_CLIENT() |
|------------------|
| SnowSQL 1.1.18   |
+------------------+
Copy

Call CURRENT_CLIENT from within the Worksheet in the Classic Console:

SELECT CURRENT_CLIENT();
Copy

Results

row#

CURRENT_CLIENT()

1

Snowflake UI 1434236365