data_warehouse_user_activities

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

Overview

Name	data_warehouse_user_activities
Type	Resource
Id	azure.sql.data_warehouse_user_activities

Fields

vw_data_warehouse_user_activities

Name	Datatype	Description
active_queries_count	text	field from the properties object
dataWarehouseUserActivityName	text	field from the properties object
databaseName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object

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, databaseName, resourceGroupName, serverName, subscriptionId	Gets the user activities of a data warehouse which includes running and suspended queries
list_by_database	SELECT	databaseName, resourceGroupName, serverName, subscriptionId	List the user activities of a data warehouse which includes running and suspended queries

SELECT examples

List the user activities of a data warehouse which includes running and suspended queries

vw_data_warehouse_user_activities

SELECT
active_queries_count,
dataWarehouseUserActivityName,
databaseName,
resourceGroupName,
serverName,
subscriptionId
FROM azure.sql.vw_data_warehouse_user_activities
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_warehouse_user_activities

SELECT
properties
FROM azure.sql.data_warehouse_user_activities
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';