Snowflake URI Format

The Uniform Resource Identifier (URI) definition for Snowflake follows this standard:

Identifier Fragments

Namespace: snowflake://{organization name}-{account name}
- Scheme = snowflake
- Authority = {organization name}-{account name}
Unique name: {database}.{schema}.{table}

Snowflake originally identified accounts with an account locator such as xyz12345.eu-west-3.aws. Sifflet also accepts this account locator as the Snowflake authority.
The URI then has this format: snowflake://{account locator}/{database}.{schema}.{table}

organization name must start with a lowercase or uppercase letter and include only lowercase and uppercase letters and numbers (regex: [a-zA-Z][a-zA-Z0-9]+)
account name must start with a lowercase or uppercase letter and include only lowercase and uppercase letters, numbers, underscores and dashes (regex: [a-zA-Z][a-zA-Z0-9_-]+)
account locator must start with a lowercase or uppercase letter and include only lowercase and uppercase letters, numbers, dots and dashes (regex: [a-zA-Z][a-zA-Z0-9.-]+)
database, schema and table can have two formats, following Snowflake naming standards: quoted format and unquoted format
- unquoted identifier must include only lowercase and uppercase letters, numbers, underscores and dollars
- quoted identifier must be enclosed in double quotes (") and must include only characters included in the Unicode range U+0001 to U+FFFF. If a double quote character is present in the name, it needs to be escaped with another double quote character in front of it.