Using variables in Snowflake is denoted by using which SQL character?

The correct answer is C. $. In Snowflake, session variables are defined with SET and referenced using the dollar sign ($) prefix-for example, SET myvar = 10; followed by SELECT $myvar. This applies both in SnowSQL scripting and within Snowflake's SQL worksheets. The @ symbol (A) is used in Snowflake to…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

How the community answered

(54 responses)

A
4% (2)
B
6% (3)
C
89% (48)
D
2% (1)

Explanation

In Snowflake, session variables are defined with SET and referenced using the dollar sign ($) prefix-for example, SET myvar = 10; followed by SELECT $myvar. This applies both in SnowSQL scripting and within Snowflake's SQL worksheets. The @ symbol (A) is used in Snowflake to reference stages (e.g., @my_stage). The & symbol (B) is not used as a variable prefix in Snowflake SQL. The # symbol (D) has no special variable-referencing role in Snowflake SQL.

Topics

#Variables#SQL Syntax#Session Variables

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice