Naming Conventions for Google BigQuery

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

Most SAS names can be up to 32 characters long. The Google BigQuery interface supports table names up to 1024 characters and column names up to 128 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. Google BigQuery is not case sensitive, so all names default to lowercase.

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

• SAS supports table or column names up to 32 characters.
• A name must begin with a letter (A through Z) or an underscore (_).
• To enable case sensitivity, enclose names in quotation marks.
• A name cannot be a reserved word in Google BigQuery such as WHERE or VIEW.
• A name cannot be the same as another Google BigQuery object that has the same type.