A user is automating a data pipeline using Snowflake CLI and needs to pass variables into SQL scripts.
Which variable-templating syntaxes are supported? (Choose three.)
Correct Answer: A,B,C
Snowflake CLI supports three actual variable-templating syntaxes for SQL execution: STANDARD, LEGACY, and JINJA. STANDARD uses the native Snowflake CLI form, such as < % variable_name
% > . LEGACY supports SnowSQL-style variables, such as & variable_name or & {variable_name}.
JINJA uses double-brace expressions, such as {{ variable_name }}. ALL and NONE are not separate templating syntaxes. They are control values: ALL enables every supported syntax, while NONE disables template resolution. Snowflake currently enables STANDARD and LEGACY by default, whereas JINJA must normally be enabled explicitly. Therefore, the original "Choose two" instruction and the supplied B, C answer are inconsistent with the official documentation. The corrected question must say "Choose three," and the verified answer is A, B, C.