You don't use an "=" sign to assign a value to a variable in SQL scripting. Try having another look at the documentation: https://docs.snowflake.com/en/developer-guide/snowflake-scripting/variables#assigning-a-value-to-a-declared-variable