vw_query_text

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

Overview

Name	vw_query_text
Type	View
Id	azure.maria_db.vw_query_text

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.queryId') as "query_id",
JSON_EXTRACT(properties, '$.queryText') as "query_text",
subscriptionId,
resourceGroupName,
serverName,
queryId,
queryIds
FROM azure.maria_db.query_text
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND queryIds = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.queryId') as "query_id",
json_extract_path_text(properties, '$.queryText') as "query_text",
subscriptionId,
resourceGroupName,
serverName,
queryId,
queryIds
FROM azure.maria_db.query_text
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND queryIds = 'replace-me';