Snowflake EXPLAIN query support with Snowflake JDBC Driver

ursyathi

Is there a way to run an EXPLAIN snowflake query through the JDBC driver with the Snowflake extension? I am running net.snowflake snowflake-jdbc 3.12.8 and it throws an error saying net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position 15 unexpected 'EXPLAIN'.. I see there are more up to date versions to 3.12.16 but nothing in the release notes mentions this added capability. The same exact query I am running works successfully in the snowflake UI.

Genevieve P.

Hi @ursyathi

I see you posted the same question in Stack Overflow:

https://stackoverflow.com/questions/65799176/snowflake-explain-query-support-with-snowflake-jdbc-driver

This is a better Community for your question; I would recommend following up on that thread.

Cheers,

Genevieve