QuestionQ31

Set up and navigate the Snowflake user interface and Snowflake Notebooks

Which syntax enables the use of a Python string variable named myvar in a SQL cell within a Snowflake Notebook?

Explanation

Snowflake Notebooks use double curly braces to substitute a Python variable in SQL: {{myvar}}. Python variables referenced from SQL must be strings; when the variable is used as a SQL value, the surrounding SQL expression may also need single quotes.

Learn more

Community Discussion

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