python,go/adbc/driver/snowflake: returning Snowflake query ID

[matquant14]

I'm starting to explore the adbc snowflake driver for python. Is there a way for the adbc cursor to return the Snowflake query id, like the cursor from the snowflake python connector does, after executing a query? Or do I have to run

SELECT LAST_QUERY_ID()
after I execute my SQL query? I'm not seeing anything in the documentation or in the code

[lidavidm]

You will have to do that for now.

gosnowflake does support this so if someone wants to contribute support for exposing this, that would be welcome. I think it would be:

• Add a statement option that when read, gives the last query ID
• In the Python bindings for the Snowflake driver, subclass the Cursor class and add a utility method to fetch that option explicitly (just as a convenience)

[lidavidm]

Ok, it looks like this isn't quite possible in the API we use. If we want to support this, someone will have to make a request upstream to gosnowflake first.

Roughly: we use QueryArrowStream which returns a snowflakeArrowStreamChunkDownloader. Internally QueryArrowStream gets a execResponseData which has the QueryID, however, it does not copy the value to the result snowflakeArrowStreamChunkDownloader and throws it away. So we have no way of getting the query ID.