Snowflake · Schema

QueryStatus

Status of a query that is in progress or has completed successfully.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
code string Status code for the query execution.
sqlState string SQL state code.
message string Message describing the status of the query.
statementHandle string Handle that uniquely identifies the statement. You can use this handle to check the status of the statement and retrieve the result set.
createdOn integer Timestamp that specifies when the statement execution started. The timestamp is expressed in milliseconds since the epoch.
statementStatusUrl string URL that you can use to check the status of the execution of the statement and retrieve the result set.
View JSON Schema on GitHub

JSON Schema

snowflake-sql-rest-query-status-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "QueryStatus",
  "type": "object",
  "description": "Status of a query that is in progress or has completed successfully.",
  "properties": {
    "code": {
      "type": "string",
      "description": "Status code for the query execution."
    },
    "sqlState": {
      "type": "string",
      "description": "SQL state code."
    },
    "message": {
      "type": "string",
      "description": "Message describing the status of the query."
    },
    "statementHandle": {
      "type": "string",
      "description": "Handle that uniquely identifies the statement. You can use this handle to check the status of the statement and retrieve the result set."
    },
    "createdOn": {
      "type": "integer",
      "description": "Timestamp that specifies when the statement execution started. The timestamp is expressed in milliseconds since the epoch."
    },
    "statementStatusUrl": {
      "type": "string",
      "description": "URL that you can use to check the status of the execution of the statement and retrieve the result set."
    }
  }
}