Get Asynchronous Query Execution Status

Description

Retrieve the execution status of an asynchronous query.

Project compatibility

Windows | Cross-platform

Configuration

• Connection - The connection established in Integration Service. Access the dropdown menu to choose, add, or manage connections.
• Query ID - The query statement's unique execution ID. You can use the output query ID from Execute Any Query Asynchronously. This field supports String type input.

Manage Properties

Use the Manage Properties wizard to configure or use any of the object's standard or custom fields. You can select fields to add them to the activity canvas. The added standard or custom fields are available in the Properties panel (in Studio Desktop) or under Show additional properties (in Studio Web).

Additional properties

Output

• Status - The query execution status. Automatically generated output variable. The status can be one of the following:

  • SUCCESS - The query finished successfully.
  • RUNNING - The query is still running.
  • QUEUED - The query is queued for execution (that is, hasn't yet started running), typically because it is waiting for resources.
  • BLOCKED - The query is waiting on a lock held by another statement.
  • RESUMING_WAREHOUSE - The warehouse is starting up, and the query isn't yet running.
  • FAILED_WITH_ERROR - The query finished unsuccessfully due to an error in the query.
  • FAILED_WITH_INCIDENT - The query finished unsuccessfully due to an incident on the server side.

• Query execution status - Automatically generated output variable.