Skip to main content

sql_pool_operation_results_location_header_results

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

Overview

Namesql_pool_operation_results_location_header_results
TypeResource
Idazure.synapse.sql_pool_operation_results_location_header_results

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectSQL pool properties (title: SQL pool properties)
skuobjectThe resource model definition representing SKU
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, workspaceName, sqlPoolName, operationIdGet the status of a SQL pool operation

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
operationIdstringOperation ID
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

Get the status of a SQL pool operation

SELECT
location,
properties,
sku,
tags
FROM azure.synapse.sql_pool_operation_results_location_header_results
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND sqlPoolName = '{{ sqlPoolName }}' -- required
AND operationId = '{{ operationId }}' -- required
;