managed_database_queries

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

Overview

Name	managed_database_queries
Type	Resource
Id	azure.sql.managed_database_queries

Fields

vw_managed_database_queries

Name	Datatype	Description
databaseName	text	field from the properties object
managedInstanceName	text	field from the properties object
queryId	text	field from the properties object
query_text	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

managed_database_queries

Name	Datatype	Description
properties	object	Properties of a database query.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, managedInstanceName, queryId, resourceGroupName, subscriptionId	Get query by query id.
list_by_query	SELECT	databaseName, managedInstanceName, queryId, resourceGroupName, subscriptionId	Get query execution statistics by query id.

SELECT examples

Get query by query id.

vw_managed_database_queries

SELECT
databaseName,
managedInstanceName,
queryId,
query_text,
resourceGroupName,
subscriptionId
FROM azure.sql.vw_managed_database_queries
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND queryId = '{{ queryId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_database_queries

SELECT
properties
FROM azure.sql.managed_database_queries
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND queryId = '{{ queryId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';