sql_pool_data_warehouse_user_activities

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

Overview

Name	sql_pool_data_warehouse_user_activities
Type	Resource
Id	azure.synapse.sql_pool_data_warehouse_user_activities

Fields

vw_sql_pool_data_warehouse_user_activities

Name	Datatype	Description
active_queries_count	text	field from the properties object
dataWarehouseUserActivityName	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_data_warehouse_user_activities

Name	Datatype	Description
properties	object	User activities of a data warehouse. This currently includes the count of running or suspended queries. For more information, please view the sys.dm_pdw_exec_requests dynamic management view (DMV).

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataWarehouseUserActivityName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Gets the user activities of a SQL pool which includes running and suspended queries

SELECT examples

Gets the user activities of a SQL pool which includes running and suspended queries

vw_sql_pool_data_warehouse_user_activities

SELECT
active_queries_count,
dataWarehouseUserActivityName,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName
FROM azure.synapse.vw_sql_pool_data_warehouse_user_activities
WHERE dataWarehouseUserActivityName = '{{ dataWarehouseUserActivityName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_data_warehouse_user_activities

SELECT
properties
FROM azure.synapse.sql_pool_data_warehouse_user_activities
WHERE dataWarehouseUserActivityName = '{{ dataWarehouseUserActivityName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';