All About the Snowflake Identifiers and Variables

If you deal with a lot of coding, how many times did it happen to go from one programming language to another, and mistype the required prefix of a variable name, use a different SQL bind variable rule, or forget for instance that in a Snowflake stored procedure implemented with JavaScript you have to use all declared arguments with upper case?…

Read here the post for free if you do not have a Medium subscription.

I walked through all different use cases I could find — related to identifiers, variables, function arguments, naming conventions — so you don’t have to. They are all related to Snowflake, or to the Snowflake ecosystem (including SnowSQL, environment variables, JSON property names, stored proc implementations in different programming languages etc.).

Identifiers in Snowflake

Identifiers are intended as friendly names to uniquely refer to database objects, such as databases and schemas, tables and columns, sequences and functions etc. In all SQL statements in particular, they may appear hard-coded and totally unquoted. Use max 2565 chars for each and try to avoid special characters (it looks…