Cancel SQL statement using ODBC driver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2023 04:38 AM - edited 11-08-2023 04:40 AM
Hi,
I'm implementing a Databricks connector using the ODBC driver and currently working on the functionality to Cancel an ongoing SQL statement.
However, I can't seem to find any ODBC function or SQL function to do so.
The only other alternative I see is to use this API, but then I could not find any easy/efficient way to get the Statement ID from the ODBC execution. It is technically possible to use the Query History API and browse for the target statement, but I cannot filter by SQL, making it quite inefficient.
Am I missing something?
Is there a plan to support any of these features?
- ODBC/SQL function to cancel a SQL statement
- Ability to filter Query History API by SQL text (so that I can inject an ID into the SQL statements and efficiently query them)
Thank you for looking into this.

