Trying to use DataGrip with Apache Drill; I have no problem registering the JDBC driver and connecting to the database but when using the navigation and selecting a table the sql being generated is for example
select t.* from "database"."tablename" t
for this to work in apache drill it needs to be using the ` and not the " character eg
select t.* from `database`.`tablename`t
I've tried a few different dialects but am not getting any difference. Is there a way around this as it's a similar issue when connecting to SparkSQL via the thriftserver?