sql_pool_operation_results_location_header_results
Creates, updates, deletes, gets or lists a sql_pool_operation_results_location_header_results resource.
Overview
| Name | sql_pool_operation_results_location_header_results |
| Type | Resource |
| Id | azure.synapse.sql_pool_operation_results_location_header_results |
Fields
The following fields are returned by SELECT queries:
- get
| Name | Datatype | Description |
|---|---|---|
location | string | The geo-location where the resource lives |
properties | object | SQL pool properties (title: SQL pool properties) |
sku | object | The resource model definition representing SKU |
tags | object | Resource tags. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | subscriptionId, resourceGroupName, workspaceName, sqlPoolName, operationId | Get 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.
| Name | Datatype | Description |
|---|---|---|
operationId | string | Operation ID |
resourceGroupName | string | The name of the resource group. The name is case insensitive. |
sqlPoolName | string | SQL pool name |
subscriptionId | string | The ID of the target subscription. |
workspaceName | string | The name of the workspace. |
SELECT examples
- get
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
;