Skip to main content

How can I cancel a query?

Comments

1 comment

  • Sam

    To cancel a query, you’ll have to run some SQL. The process involves two steps: (1) find the query of interest (2) cancel it.

    1. Look at the special STV_INFLIGHT Redshift table and grab the Process ID (in the pid column) associated with the query you’re interested in.

    2. Cancel the query using this pid by running CANCEL <your pid here>. For more detail, see the Redshift documentation on canceling a query.

    0

Please sign in to leave a comment.

Powered by Zendesk