Snowflake · Schema

Identifier

A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Data LakesData SharingData WarehousingDatabaseSQL
View JSON Schema on GitHub

JSON Schema

snowflake-identifier-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/Identifier",
  "title": "Identifier",
  "type": "string",
  "description": "A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.",
  "pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
  "example": "TEST_NAME"
}