query_text

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

Overview

Name	query_text
Type	Resource
Id	azure.maria_db.query_text

Fields

vw_query_text

Name	Datatype	Description
queryId	text	field from the properties object
queryIds	text	field from the properties object
query_id	text	field from the properties object
query_text	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

query_text

Name	Datatype	Description
properties	object	The properties of a query text.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	queryId, resourceGroupName, serverName, subscriptionId	Retrieve the Query-Store query texts for the queryId.
list_by_server	SELECT	queryIds, resourceGroupName, serverName, subscriptionId	Retrieve the Query-Store query texts for specified queryIds.

SELECT examples

Retrieve the Query-Store query texts for the queryId.

vw_query_text

SELECT
queryId,
queryIds,
query_id,
query_text,
resourceGroupName,
serverName,
subscriptionId
FROM azure.maria_db.vw_query_text
WHERE queryId = '{{ queryId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

query_text

SELECT
properties
FROM azure.maria_db.query_text
WHERE queryId = '{{ queryId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';