swagger: '2.0' info: version: 2020-04-01-preview title: Microsoft Azure SynapseSqlV3ManagementClient description: >- The Azure Synapse SQL management API provides a RESTful set of web APIs that interact with Azure Synapse SQL services to manage your resources. The API enables users to create, retrieve, update, and delete SqlPools, SqlDatabases, and other entities. host: management.azure.com schemes: - https consumes: - application/json produces: - application/json paths: ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName} : get: tags: - SqlPoolsV3 description: Gets a SqlPool. operationId: microsoftAzureSqlpoolsv3Get parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '200': description: Successfully retrieved the specified SqlPool. schema: $ref: '#/definitions/SqlPoolV3' default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-examples: Gets a sqlpool.: $ref: ./examples/GetSqlPool.json summary: >- Microsoft Azure Get Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname put: tags: - SqlPoolsV3 description: Creates a new SqlPool or updates an existing SqlPool. operationId: microsoftAzureSqlpoolsv3Createorupdate parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - name: parameters in: body description: The requested SqlPool resource state. required: true schema: $ref: '#/definitions/SqlPoolV3' - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '200': description: Successfully updated the SqlPool. schema: $ref: '#/definitions/SqlPoolV3' '201': description: Successfully created the SqlPool. schema: $ref: '#/definitions/SqlPoolV3' '202': description: Creating or updating the SqlPool is in progress. default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-long-running-operation: true x-ms-examples: Creates a sqlpool.: $ref: ./examples/PutSqlPool.json summary: >- Microsoft Azure Put Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname delete: tags: - SqlPoolsV3 description: Deletes the SqlPool. operationId: microsoftAzureSqlpoolsv3Delete parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '200': description: Successfully deleted the SqlPool. '202': description: Deleting the SqlPool is in progress. '204': description: The specified SqlPool does not exist. default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-long-running-operation: true x-ms-examples: Deletes a sqlpool.: $ref: ./examples/DeleteSqlPool.json summary: >- Microsoft Azure Delete Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname patch: tags: - SqlPoolsV3 description: Updates an existing sqlpool. operationId: microsoftAzureSqlpoolsv3Update parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - name: parameters in: body description: The requested SqlPool resource state. required: true schema: $ref: '#/definitions/SqlPoolUpdate' - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '200': description: Successfully updated the SqlPool. schema: $ref: '#/definitions/SqlPoolV3' '202': description: Updating the SqlPool is in progress. default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-long-running-operation: true x-ms-examples: Updates a sqlpool.: $ref: ./examples/PatchSqlPool.json summary: >- Microsoft Azure Patch Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/pause : post: tags: - SqlPoolsV3 description: Deactivates the SqlPool. operationId: microsoftAzureSqlpoolsv3Deactivate parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '202': description: Pausing the SqlPool is in progress. '204': description: The specified SqlPool does not exist. default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-long-running-operation: true x-ms-examples: Deactivates a sqlpool.: $ref: ./examples/PostSqlPoolDeactivate.json summary: >- Microsoft Azure Post Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname Pause ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/resume : post: tags: - SqlPoolsV3 description: Activates the SqlPool. operationId: microsoftAzureSqlpoolsv3Activate parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: ../../../../common/v1/types.json#/parameters/SqlPoolNameParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '202': description: Resuming the SqlPool is in progress. '204': description: The specified SqlPool does not exist. default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-long-running-operation: true x-ms-examples: Activate a sqlpool.: $ref: ./examples/PostSqlPoolActivate.json summary: >- Microsoft Azure Post Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools Sqlpoolname Resume ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools : get: tags: - SqlPoolsV3 description: Gets a list of sql pools. operationId: microsoftAzureSqlpoolsv3Listbyworkspace parameters: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/SubscriptionIdParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ResourceGroupNameParameter - $ref: ../../../../common/v1/types.json#/parameters/WorkspaceNameParameter - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/parameters/ApiVersionParameter responses: '200': description: Successfully retrieved the list of sql pools. schema: $ref: '#/definitions/SqlPoolListResult' default: schema: $ref: >- ../../../../../common-types/resource-management/v2/types.json#/definitions/ErrorResponse description: '' x-ms-pageable: nextLinkName: nextLink x-ms-examples: Gets a list of sql pools.: $ref: ./examples/ListSqlPoolsByWorkspace.json summary: >- Microsoft Azure Get Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Synapse Workspaces Workspacename Sqlpools definitions: SqlPoolProperties: description: The sql pool's properties. type: object properties: status: description: The status of the sql pool. enum: - Invisible - Online - Offline - Creating - Inaccessible - Pausing - Paused - Resuming - Scaling - Dropping - Error - Unknown type: string readOnly: true x-ms-enum: name: SqlPoolStatus modelAsString: true sqlPoolGuid: format: uuid description: The Guid of the sql pool. type: string readOnly: true currentServiceObjectiveName: description: The current service level objective name of the sql pool. type: string readOnly: true requestedServiceObjectiveName: description: The requested service level objective name of the sql pool. type: string readOnly: true maxServiceObjectiveName: description: The max service level objective name of the sql pool. type: string autoPauseTimer: format: int32 description: >- The period of inactivity in minutes before automatically pausing the sql pool. type: integer autoResume: description: >- Indicates whether the sql pool can automatically resume when connection attempts are made. type: boolean SqlPoolV3: description: A sql pool resource. required: - location type: object allOf: - $ref: >- ../../../../../common-types/resource-management/v1/types.json#/definitions/TrackedResource properties: sku: $ref: '#/definitions/SkuV3' description: >- The sql pool SKU. The list of SKUs may vary by region and support offer. kind: description: Kind of SqlPool. type: string readOnly: true systemData: $ref: ../../../../common/v1/types.json#/definitions/SystemData description: SystemData of SqlPool. readOnly: true properties: $ref: '#/definitions/SqlPoolProperties' description: Resource properties. x-ms-client-flatten: true SkuV3: description: An ARM Resource SKU. required: - name type: object properties: name: description: The name of the SKU, typically, a letter + Number code, e.g. P3. type: string tier: description: The tier or edition of the particular SKU, e.g. Basic, Premium. type: string SqlPoolUpdate: description: A sql pool resource. type: object properties: sku: $ref: '#/definitions/SkuV3' description: The name and tier of the SKU. properties: $ref: '#/definitions/SqlPoolProperties' description: Resource properties. x-ms-client-flatten: true tags: description: Resource tags. type: object additionalProperties: type: string SqlPoolListResult: description: A list of sql pools. type: object properties: value: description: Array of results. type: array items: $ref: '#/definitions/SqlPoolV3' readOnly: true nextLink: description: Link to retrieve next page of results. type: string readOnly: true securityDefinitions: azure_auth: type: oauth2 description: Azure Active Directory OAuth2 Flow flow: implicit authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize scopes: user_impersonation: impersonate your user account tags: - name: SqlPoolsV3