Synapse URI Format

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

Identifier Fragments

• Namespace: sqlserver://{host}:{port};database={database}
  • Scheme = sqlserver
  • Authority = {host}:{port};database={database}
• Unique name: {schema}.{table}

Asset URI Format

• sqlserver://{host}:{port};database={database}/{schema}.{table}

Schema URI Format

• sqlserver://{host}:{port};database={database}/{schema}

Parameter Limitations

• host identifier must start with a lowercase letter and include only lowercase letters, numbers, dash and dot (regex: [a-z][a-z0-9-.]+)
• port identifier must include only numbers
• database, schema and table can have two formats, following Azure Synapse naming standards: quoted and unquoted
  • unquoted identifier must start with a character belonging to the Unicode category L (letter), _, @ or #. The other characters must belong to the Unicode category L (letter), Unicode category N (number), or be _, @, # or $.
  • quoted identifier needs to be wrapped using brackets [ and ] and must include only characters included in the Unicode range U+0001 to U+FFFF. If a right bracket character ] is included inside the name it needs to be doubled. (Ex: my]]name is a valid name if put inside brackets and my]name is not valid)

Asset Examples

• sqlserver://sifflet-dev-synapse.cfbuquha2ngc.eu-west-1.rds.amazonaws.com:1433;database=test_database/test_schema.test_table
• sqlserver://testing-mssql.cfbu.us-west-1.rds:8080;database=prod_database/[MY-SCHEMA].테스트_데이터1

Schema Examples

• sqlserver://sifflet-dev-synapse.cfbuquha2ngc.eu-west-1.rds.amazonaws.com:1433;database=test_database/test_schema
• sqlserver://testing-mssql.cfbu.us-west-1.rds:8080;database=prod_database/[MY-SCHEMA]