query_tags

Description

Exposes key/value tags attached to queries. Tags can be used to annotate and categorize queries for filtering and reporting. Only tags for queries on which the current role has USAGE privileges are returned.

Syntax

SELECT * FROM deltastream.sys."query_tags";

Columns

Column	Type	Nullable	Description
key	VARCHAR	No	Tag key.
value	VARCHAR	No	Tag value.
query_id	VARCHAR	No	Unique identifier of the query this tag is attached to.
organization_id	VARCHAR	No	The unique identifier of the organization this resource belongs to.
created_at	TIMESTAMP_LTZ	No	Timestamp when the tag was created.
updated_at	TIMESTAMP_LTZ	No	Timestamp when the tag was last updated.

Examples

$ dsql -e 'SELECT * FROM deltastream.sys."query_tags";'
[{"key":"a","value":"b","query_id":"0196fef1-7f99-785b-b80d-4d1813384080","organization_id":"00000000-0000-0000-0000-000000000001","created_at":"2025-08-11T22:00:39.652Z","updated_at":"2025-08-11T22:00:39.652Z"},{"key":"a","value":"b1","query_id":"0196fef1-7f99-785b-b80d-4d1813384080","organization_id":"00000000-0000-0000-0000-000000000001","created_at":"2025-08-11T22:01:08.189Z","updated_at":"2025-08-11T22:01:08.189Z"}]

Find all tags for a specific query:

SELECT key, value FROM deltastream.sys."query_tags" WHERE query_id = '0196fef1-7f99-785b-b80d-4d1813384080';

See Also

• System Tables Overview

• queries