Snowpro Core · Free Practice Question Easy
Question 20
What value does the CURRENT_CLIENT function return when called from an application using a JDBC driver to connect?
- A The name of the application
- B The string ‘JDBC.’
- C The string ‘External Application.’
- D The version of the JDBC driver
Reveal correct answer
Correct answer: D
Explanation
The CURRENT_CLIENT function returns the client’s version from where the query was executed. When called from a query executed by an application using JDBC or ODBC driver, the version of the driver is returned. For example, Calling CURRENT_CLIENT in Snowsight returns ‘Go 1.1.5’ since it uses the Go Driver. CURRENT_CLIENT in Classic Web UI returns ‘Snowflake UI 20230324175929’ since the Classic Web UI connects directly without a driver. Calling CURRENT C_CLIENT in SnowSQL returns ‘SnowSQL 1.2.24’. https://docs.snowflake.com/en/sql-reference/functions/current_clientDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
