Azure Synapse Dedicated SQL Pool
Published 10 June 2025
SQL Prompt v11.0 required
Azure Synapse Dedicated SQL Pool support is only available in SQL Prompt v11.0 onwards. Download the latest version
This document outlines the support provided in SQL Prompt v11.0 for Azure Synapse Dedicated SQL Pools, including supported functionality, known limitations, and required configuration settings.
Synapse Configuration
- Ensure Dedicated SQL Pool is provisioned and running.
User Permissions
- Assign the connecting user the necessary roles, typically:
db_datareader
What Is Supported
- Autocomplete suggestions for queries specific to Azure Dedicated Pools.
- Formatting rules applied properly for queries specific to Azure Dedicated Pools.
List of the newly supported SQL queries
| # | Keyword | Reference Link |
|---|---|---|
| 1 | CREATE COLUMNSTORE INDEX | Link |
| 2 | CREATE DATABASE | Link |
| 3 | CREATE TABLE | Link |
| 4 | CREATE TABLE | Link |
| 5 | CREATE TABLE AS SELECT | Link |
| 6 | WITH common_table_expression (Transact-SQL) | Link |
| 7 | WITH common_table_expression (Transact-SQL) | Link |
| 8 | OPTION clause (Transact-SQL) | Link |
| 9 | OPTION clause (Transact-SQL) | Link |
| 10 | ALTER MATERIALIZED VIEW | Link |
| 11 | CREATE TABLE AS SELECT | Link |
What Is Not Supported
- Certain SQL Queries related to current limitation in Microsoft SQL parser. (Issue with detailed examples).
- Certain database refactoring features.
