DESCRIBE QUERY EVENTS
Syntax
DESCRIBE QUERY EVENTS [query_id | query_name[:query_version]];Description
This command provides a list of events for a Streaming or Continuous Query created in the current Organization.
See Query on how streaming queries operate in DeltaStream.
The Query is visible only if the current role has USAGE privileges.
Arguments
query_id
This is the unique identifier of the query to describe. See LIST QUERIES to find out how to list all queries to which the user has access. The first column (ID) in the response corresponds with the query_id.
query_name
This is the name of the Query to describe. See LIST QUERIES to find out how to list all queries to which the user has access. The column (Name) in the response corresponds with the query_name. The query_version property disambiguates between multiple queries with the same name.
query_version
This is the version of the query to describe. See LIST QUERIES to find out how to list all queries to which the user has access. The column (Version) in the response corresponds with the query_version. If query_name is provided without a query_version, the system uses query_version.
Examples
Show query events when running and stopped
Show events for a query that has been rescheduled
You can reschedule queries for any number of reasons. Typically you reschedule a query if a you must move it to another node.
The following example shows an errored query:
Last updated