COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ4

Data Loading, Unloading & Connectivity

A user is automating a data pipeline with the Snowflake CLI and must pass variables into SQL scripts.

Which variable-templating syntaxes does Snowflake CLI support?

Choose three
Explanation

Snowflake CLI supports STANDARD syntax (<% variable_name %>), LEGACY SnowSQL syntax (&{ variable_name } or &variable_name), and JINJA syntax ({{ variable_name }}). ALL and NONE configure which supported syntaxes are enabled; they are not variable syntaxes themselves.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!