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

vw_sql_pool_operation_results_location_header_results

Name	Datatype	Description
collation	text	field from the properties object
create_mode	text	field from the properties object
creation_date	text	field from the properties object
location	text	The geo-location where the resource lives
max_size_bytes	text	field from the properties object
operationId	text	field from the properties object
provisioning_state	text	field from the properties object
recoverable_database_id	text	field from the properties object
resourceGroupName	text	field from the properties object
restore_point_in_time	text	field from the properties object
sku	text	The resource model definition representing SKU
source_database_deletion_date	text	field from the properties object
source_database_id	text	field from the properties object
sqlPoolName	text	field from the properties object
status	text	field from the properties object
storage_account_type	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
workspaceName	text	field from the properties object

sql_pool_operation_results_location_header_results

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of a SQL Analytics pool
sku	object	The resource model definition representing SKU
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	operationId, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get the status of a SQL pool operation

SELECT examples

Get the status of a SQL pool operation

vw_sql_pool_operation_results_location_header_results

SELECT
collation,
create_mode,
creation_date,
location,
max_size_bytes,
operationId,
provisioning_state,
recoverable_database_id,
resourceGroupName,
restore_point_in_time,
sku,
source_database_deletion_date,
source_database_id,
sqlPoolName,
status,
storage_account_type,
subscriptionId,
tags,
workspaceName
FROM azure.synapse.vw_sql_pool_operation_results_location_header_results
WHERE operationId = '{{ operationId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_operation_results_location_header_results

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