Cancelling Queries

While most queries on Transpose run in just a few milliseconds, given the powerful combination of SQL and our massive quantity of data, it is possible to create queries that take longer to complete. In these situations, it may be useful for you to cancel queries that are already running.

To create a cancellable query, you'll first need to create a query using the cancel_id option. This cancel_id is namespaced to your API key - so you can't cacancel someone else's query, or vice-versa!

SQL Query

SELECT COUNT(*) from ethereum.nfts LIMIT 100000;

PythonNodecURL

import requests url = "https://api.transpose.io/sql" sql_query = """SELECT COUNT(*) from ethereum.nfts LIMIT 100000;""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } response = requests.post(url, headers=headers, json={ 'sql': sql_query, 'options': { 'cancel_id': '<my_special_query_cancel_id>' } }, ) print(response.text) print('Credits charged:', response.headers.get('X-Credits-Charged', None))

const https = require('https'); var postData = JSON.stringify({ sql: "SELECT COUNT(*) from ethereum.nfts LIMIT 100000;", options: { cancel_id: '<my_special_query_cancel_id>' } }); var options = { hostname: 'api.transpose.io', path: '/sql', method: 'POST', headers: { 'Content-Type': 'application/json', 'Content-Length': postData.length, 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' } }; var req = https.request(options, (res) => { console.log('Credits charged:', res.headers['x-credits-charged']); res.on('data', (d) => { process.stdout.write(d); }); }); req.on('error', (e) => { console.error(e); }); req.write(postData); req.end();

curl --request POST \
     --data '{"sql": "SELECT COUNT(*) from ethereum.nfts LIMIT 100000;", "options": {"cancel_id": '<my_special_query_cancel_id>'}}' \
     --url 'https://api.transpose.io/sql' \
     --header 'Content-Type: application/json' \
     --header 'x-api-key: BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' \

You can then pass this cancel_id to our cancellation endpoint, as demonstrated below. Give this a go! Run the request above, and while it's running, try cancelling it with the request below!

PythonNodecURL

import requests url = "https://api.transpose.io/sql/cancel/<my_special_query_cancel_id>" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } params = { } response = requests.get(url, headers=headers, params=params) print(response.text) print('Credits charged:', response.headers.get('X-Credits-Charged', None))

const https = require('https'); const querystring = require('querystring'); const params = { } var options = { hostname: 'api.transpose.io', path: '/sql/cancel/<my_special_query_cancel_id>?' + querystring.stringify(params), method: 'GET', headers: { 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' } }; var req = https.request(options, (res) => { console.log('Credits charged:', res.headers['x-credits-charged']); res.on('data', (d) => { process.stdout.write(d); }); }); req.on('error', (e) => { console.error(e); }); req.end();

curl -X GET \
    'https://api.transpose.io/sql/cancel/<my_special_query_cancel_id>?' \
    -H 'X-API-KEY: BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' \

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.