Azure Synapse Analytics

Azure Synapse Analytics SqlPools API

The SqlPools API from Azure Synapse Analytics — 4 operation(s) for sqlpools.

Documentation GitHub OpenAPI

Operations 7

GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools Azure Synapse Analytics List SQL pools by workspace #

GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName} Azure Synapse Analytics Get a SQL pool #

PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName} Azure Synapse Analytics Create a SQL pool #

PATCH /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName} Azure Synapse Analytics Update a SQL pool #

DELETE /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName} Azure Synapse Analytics Delete a SQL pool #

POST /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/pause Azure Synapse Analytics Pause a SQL pool #

POST /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/resume Azure Synapse Analytics Resume a SQL pool #

Documentation

https://learn.microsoft.com/en-us/rest/api/synapse/workspace

https://learn.microsoft.com/en-us/rest/api/synapse/sqlpools

https://learn.microsoft.com/en-us/rest/api/synapse/bigdatapool

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/spark

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/monitoring

https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/role-assignments

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/notebook

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/dataset

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/linked-service

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/data-flow

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/sql-script

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/trigger

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/spark-job-definition

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/managed-private-endpoints

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/integration-runtimes

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/library

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/git-integration

https://learn.microsoft.com/en-us/rest/api/synapse/ip-firewall-rules

https://learn.microsoft.com/en-us/rest/api/synapse/keys

https://learn.microsoft.com/en-us/rest/api/synapse/private-endpoint-connections

https://learn.microsoft.com/en-us/rest/api/synapse/private-link-hubs

https://learn.microsoft.com/en-us/rest/api/synapse/kusto-pools

https://learn.microsoft.com/en-us/rest/api/synapse/azure-ad-only-authentications

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/spark-configuration

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/data-flow-debug-session

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/credential

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/kql-script

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/link-connection

Specifications

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/openapi/microsoft-azure-synapse-analytics-sqlpools-api-openapi.yml

Schemas & Data

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-workspace-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-sql-pool-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-spark-pool-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-pipeline-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-spark-batch-job-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-role-assignment-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-notebook-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-dataset-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-linked-service-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-trigger-schema.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-schema/azure-synapse-analytics-firewall-rule-schema.json

Other Resources

https://raw.githubusercontent.com/Azure/azure-rest-api-specs/main/specification/synapse/resource-manager/Microsoft.Synapse/stable/2021-06-01/workspace.json

https://raw.githubusercontent.com/api-evangelist/microsoft-azure-synapse-analytics/refs/heads/main/json-ld/azure-synapse-analytics-context.jsonld

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/microsoft-azure-synapse-analytics-sqlpools-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Azure Synapse Analytics Sql Pools API
  description: Manage dedicated SQL pools for enterprise data warehousing workloads including provisioning, scaling, pausing, and resuming compute resources.
  version: '2021-06-01'
  contact:
    name: Microsoft Azure Support
    url: https://azure.microsoft.com/en-us/support/
  license:
    name: Microsoft
    url: https://azure.microsoft.com/en-us/support/legal/
servers:
- url: https://management.azure.com
  description: Azure Resource Manager
security:
- azure_auth:
  - user_impersonation
tags:
- name: SqlPools
paths:
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools
  : get:
      operationId: SqlPools_ListByWorkspace
      summary: Azure Synapse Analytics List SQL pools by workspace
      description: List all SQL pools within a workspace.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      responses:
        '200':
          description: Successfully retrieved the list of SQL pools.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlPoolInfoListResult'
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}
  : get:
      operationId: SqlPools_Get
      summary: Azure Synapse Analytics Get a SQL pool
      description: Get SQL pool properties.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      responses:
        '200':
          description: Successfully retrieved the SQL pool.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlPool'
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
    put:
      operationId: SqlPools_Create
      summary: Azure Synapse Analytics Create a SQL pool
      description: Create a SQL pool.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SqlPool'
      responses:
        '200':
          description: Successfully updated the SQL pool.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlPool'
        '202':
          description: SQL pool creation accepted.
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
    patch:
      operationId: SqlPools_Update
      summary: Azure Synapse Analytics Update a SQL pool
      description: Apply partial modifications to a SQL pool.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SqlPoolPatchInfo'
      responses:
        '200':
          description: Successfully updated the SQL pool.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlPool'
        '202':
          description: SQL pool update accepted.
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
    delete:
      operationId: SqlPools_Delete
      summary: Azure Synapse Analytics Delete a SQL pool
      description: Delete a SQL pool.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      responses:
        '200':
          description: Successfully deleted the SQL pool.
        '202':
          description: SQL pool deletion accepted.
        '204':
          description: SQL pool not found.
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/pause
  : post:
      operationId: SqlPools_Pause
      summary: Azure Synapse Analytics Pause a SQL pool
      description: Pause a SQL pool to suspend compute operations.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      responses:
        '200':
          description: Successfully paused the SQL pool.
        '202':
          description: SQL pool pause accepted.
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/resume
  : post:
      operationId: SqlPools_Resume
      summary: Azure Synapse Analytics Resume a SQL pool
      description: Resume a SQL pool to reactivate compute operations.
      tags:
      - SqlPools
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - $ref: '#/components/parameters/WorkspaceNameParameter'
      - $ref: '#/components/parameters/SqlPoolNameParameter'
      responses:
        '200':
          description: Successfully resumed the SQL pool.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SqlPool'
        '202':
          description: SQL pool resume accepted.
        default:
          description: Error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
components:
  schemas:
    ErrorResponse:
      type: object
      description: Error response.
      properties:
        error:
          type: object
          properties:
            code:
              type: string
            message:
              type: string
    SqlPoolProperties:
      type: object
      description: SQL pool properties.
      properties:
        maxSizeBytes:
          type: integer
          format: int64
          description: Maximum size in bytes.
        collation:
          type: string
          description: Collation mode.
        sourceDatabaseId:
          type: string
          description: Source database ID for restore.
        recoverableDatabaseId:
          type: string
          description: Recoverable database ID for geo-restore.
        provisioningState:
          type: string
          description: Resource provisioning state.
          readOnly: true
        status:
          type: string
          description: Resource status.
          readOnly: true
        restorePointInTime:
          type: string
          format: date-time
          description: Snapshot time to restore.
        createMode:
          type: string
          description: The create mode.
          enum:
          - Default
          - PointInTimeRestore
          - Recovery
          - Restore
        creationDate:
          type: string
          format: date-time
          readOnly: true
        storageAccountType:
          type: string
          description: The storage account type.
          enum:
          - GRS
          - LRS
    SqlPoolInfoListResult:
      type: object
      description: List of SQL pools.
      properties:
        value:
          type: array
          items:
            $ref: '#/components/schemas/SqlPool'
        nextLink:
          type: string
    SqlPoolPatchInfo:
      type: object
      description: SQL pool patch info.
      properties:
        tags:
          type: object
          additionalProperties:
            type: string
        location:
          type: string
        sku:
          $ref: '#/components/schemas/Sku'
        properties:
          type: object
          properties:
            maxSizeBytes:
              type: integer
              format: int64
            collation:
              type: string
            createMode:
              type: string
    SqlPool:
      type: object
      description: A SQL pool resource.
      properties:
        id:
          type: string
          readOnly: true
        name:
          type: string
          readOnly: true
        type:
          type: string
          readOnly: true
        location:
          type: string
          description: The geo-location where the resource lives.
        tags:
          type: object
          additionalProperties:
            type: string
        sku:
          $ref: '#/components/schemas/Sku'
        properties:
          $ref: '#/components/schemas/SqlPoolProperties'
    Sku:
      type: object
      description: SQL pool SKU.
      properties:
        tier:
          type: string
        name:
          type: string
        capacity:
          type: integer
  parameters:
    SubscriptionIdParameter:
      name: subscriptionId
      in: path
      required: true
      schema:
        type: string
    ApiVersionParameter:
      name: api-version
      in: query
      required: true
      schema:
        type: string
        default: '2021-06-01'
    SqlPoolNameParameter:
      name: sqlPoolName
      in: path
      required: true
      description: SQL pool name.
      schema:
        type: string
    WorkspaceNameParameter:
      name: workspaceName
      in: path
      required: true
      schema:
        type: string
    ResourceGroupNameParameter:
      name: resourceGroupName
      in: path
      required: true
      schema:
        type: string
  securitySchemes:
    azure_auth:
      type: oauth2
      flows:
        implicit:
          authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize
          scopes:
            user_impersonation: impersonate your user account