Skip to main content

sql_pool_operations

Creates, updates, deletes, gets or lists a sql_pool_operations resource.

Overview

Namesql_pool_operations
TypeResource
Idazure.synapse.sql_pool_operations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectResource properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectsubscriptionId, resourceGroupName, workspaceName, sqlPoolNameGets a list of operations performed on the SQL pool.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
sqlPoolNamestringSQL pool name
subscriptionIdstringThe ID of the target subscription.
workspaceNamestringThe name of the workspace.

SELECT examples

Gets a list of operations performed on the SQL pool.

SELECT
properties
FROM azure.synapse.sql_pool_operations
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND sqlPoolName = '{{ sqlPoolName }}' -- required
;