Naming Conventions for Snowflake

For general information, see SAS Names and Support for DBMS Names.

Most SAS names can be up to 32 characters long. The Snowflake interface supports table names and column names that contain up to 32 characters. If column names are longer than 32 characters, they are truncated to 32 characters. If truncating a column name would result in identical column names, SAS generates a unique name by replacing the last character with a number. DBMS table names must be 32 characters or fewer. SAS does not truncate a name longer than 32 characters. If you have a table name that is longer than 32 characters, it is recommended that you create a table view.

The PRESERVE_TAB_NAMES= and PRESERVE_COL_NAMES= options determine how this interface handles case sensitivity, spaces, and special characters. (For information about these options, see LIBNAME Statement for Relational Databases.) Snowflake is not case sensitive, so all names default to lowercase.

Snowflake objects include tables, views, and columns. They follow these conventions.

• A name can contain up to 128 characters.
• The first character in a name can be a letter, @, _, or #.
• A name must begin with a letter (A through Z), diacritic marks, non-Latin characters (200–377 octal) or an underscore (_).
• To enable case sensitivity, enclose names in quotation marks. All references to quoted names must always be enclosed in quotation marks.
• A name cannot be a reserved word in Snowflake such as WHERE or VIEW.
• A name cannot be the same as another Snowflake object that has the same type.