Cancel SQL statement using ODBC driver

Datbth — Wed, 08 Nov 2023 12:40:54 GMT

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.

topic Cancel SQL statement using ODBC driver in Warehousing & Analytics

Cancel SQL statement using ODBC driver