Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage
  1. Docs
  2. /
  3. Reference
  4. /
  5. Hook Conditions
  6. /
  7. execution_status

execution_status

The execution status of a query as reported by Snowflake.

Syntax 

  EXECUTION_STATUS

Returns

The status of a snowflake query after it has completed execution. The valid values are:

  • SUCCESS
  • FAILED_WITH_ERROR
  • FAILED_WITH_INCIDENT
  • ABORTED
  • DISCONNECTED

Usage Notes

  • This condition can be used only with POST hooks.
  • Other values of EXECUTION_STATUS eg. RUNNING cannot be used in conditions since they represent an intermediate state of the query execution.

Examples 

EXECUTION_STATUS = 'SUCCESS'

EXECUTION_STATUS = 'FAILED_WITH_ERROR' OR EXECUTION_STATUS = 'FAILED_WITH_INCIDENT'