Connecting from within DataGrip using the JDBC driver

I succeeded to connect DataGrip to Dremio.

All my queries seem to work, e.g. give the expected results but throw also an error.
FROM “Test”.energiebronnen
[2017-09-22 16:33:54] java.sql.SQLException
[2017-09-22 16:33:54] 9 rows retrieved starting from 1 in 139ms (execution: 79ms, fetching: 60ms)

DataGrip asks to indicate the optimal SQL dialect to use by the driver; I tried several but that doesn’t seem to make a difference.

@PaulZH this is a known issue – we’ll reach out when this is addressed. As you mentioned this should not affect normal operations. Please let us know if you are observing any other issues that prevent queries from running or return unexpected results. Also, none of the dialects is a 1-1 match with Dremio’s but I’ve been using the SQL92 dialect for my own use.