The multimethod metabase.driver/current-user-table-privileges has been added on v0.48.0

Please see the driver API changes in Metabase v50 and update your driver accordingly.

Hi @Baoqi , I hope you are fine ?
I just upgraded dremio to the last community version : 21.1.1.
Your great driver does not seem to filter datasets anymore based on the 'schema' connection parameter.
All datasets are synchronized, wathever the parameter's value, leading to huge load and performance loss.

I read the driver's code, but did not succeed in guessing where the problem is.

Thank you @Baoqi for your work on this driver !

Hi, I am from Metabase. Please subscribe to the Metabase Community Driver Authors mailing list. We send information about new Metabase releases and the corresponding changes to the Driver API so you can test new releases before they are out.

While testing metabase 0.46.0-RC4, a query with a filter (last 12 months) on a timestamp is not working anymore. Here is the error:

Not supported by Honey SQL 2: ^honeysql.types.SqlCall (honeysql.core/call :timestampadd #sql/raw "month" -12 [:metabase.util.honey-sql-2/typed [:cast [:metabase.util.honey-sql-2/typed :%now {:metabase.util.honeysql-extensions/database-type "timestamptz"}] [:raw "timestamp"]] {:metabase.util.honeysql-extensions/database-type "timestamp"}])
Similar filter on mysql databases are fine, so it could be releated to the driver.

Driver interface has changed with 0.46 https://www.metabase.com/docs/master/developers-guide/driver-changelog

Hi @Baoqi ,

when configuring a new dremio connection with a user home as schema,
catalog is not retreived.
Maybe an issue with the @ ?

Best regards

I'm trying to use this driver to connect to the dremio cloud, but I'm getting the error below.

2022-04-01 02:46:27,328 DEBUG middleware.log :: POST /api/database 400 10.3 s (0 chamadas ao banco de dados) {:valid false, :dbname "Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <--> null (user client)", :message "Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <--> null (user client)"}

Is it possible to use this driver for dremio cloud? I tested the same with dremio software and it worked.

Hello, I am using docker run -d -p 3000:3000 --mount type=bind,source=/usr/local/jt/deploy-datalake/datalake/metabase/plugins,destination=/plugins --name metabase metabase/metabase:v0.39.5
, but I don't find to how to connect dremio

Trouble refers to teaching, My Wechat: wyf19910905

I have upgraded Metabase from version 1.46.4 to the new version 1.48.7 and updated the Dremio driver "dremio.metabase-driver.jar" to its latest version 1.3.0. After the update, database access stopped working across the board, presenting the following errors:

Evd01 (
Aqui está a mensagem de erro completa
PARSE ERROR: Failure parsing the query.

SQL Query SET ROLE NONE;
startLine 1
startColumn 10
endLine 1
endColumn 13
SQL Query SET ROLE NONE;

[Error Id: 06b4f288-cc1e-4958-bdfe-109b56562d95 on 390836d074dc:31010]

(org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10.
Was expecting one of:
"=" ...
"." ...
"[" ...

com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361
com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146
org.apache.calcite.sql.parser.SqlParser.handleException():133
org.apache.calcite.sql.parser.SqlParser.parseStmtList():188
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():199
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269
com.dremio.exec.work.foreman.AttemptManager.plan():516
com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422
com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140
com.dremio.service.commandpool.CommandWrapper.run():70
com.dremio.context.RequestContext.run():96
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192
java.util.concurrent.Executors$RunnableAdapter.call():511
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750

Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10.
Was expecting one of:
"=" ...
"." ...
"[" ...

com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272
com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900
com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197
com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73
org.apache.calcite.sql.parser.SqlParser.parseStmtList():186
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():199
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269
com.dremio.exec.work.foreman.AttemptManager.plan():516
com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422
com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140
com.dremio.service.commandpool.CommandWrapper.run():70
com.dremio.context.RequestContext.run():96
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192
java.util.concurrent.Executors$RunnableAdapter.call():511
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750

)
Evd02 (

{:via
[{:type java.sql.SQLException,
:message
"PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n",
:at [com.dremio.jdbc.impl.DremioCursor nextRowInternally "DremioCursor.java" 543]}
{:type cdjd.com.dremio.common.exceptions.UserRemoteException,
:message
"PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n",
:at [cdjd.com.dremio.common.exceptions.UserRemoteException create "UserRemoteException.java" 94]}],
:trace
[[cdjd.com.dremio.common.exceptions.UserRemoteException create "UserRemoteException.java" 94]
[cdjd.com.dremio.sabot.rpc.user.QueryResultHandler resultArrived "QueryResultHandler.java" 122]
[cdjd.com.dremio.sabot.rpc.user.UserClient handleReponse "UserClient.java" 175]
[cdjd.com.dremio.exec.rpc.BasicClientWithConnection handle "BasicClientWithConnection.java" 56]
[cdjd.com.dremio.exec.rpc.BasicClientWithConnection handle "BasicClientWithConnection.java" 33]
[cdjd.com.dremio.exec.rpc.RpcBus handle "RpcBus.java" 99]
[cdjd.com.dremio.exec.rpc.RpcBus handle "RpcBus.java" 94]
[cdjd.com.dremio.exec.rpc.RpcBus$RequestEvent run "RpcBus.java" 475]
[cdjd.com.dremio.common.SerializedExecutor$RunnableProcessor run "SerializedExecutor.java" 96]
[cdjd.com.dremio.exec.rpc.RpcBus$SameExecutor execute "RpcBus.java" 341]
[cdjd.com.dremio.common.SerializedExecutor execute "SerializedExecutor.java" 129]
[cdjd.com.dremio.exec.rpc.RpcBus$InboundHandler decode "RpcBus.java" 375]
[cdjd.com.dremio.exec.rpc.RpcBus$InboundHandler decode "RpcBus.java" 346]
[cdjd.io.netty.handler.codec.MessageToMessageDecoder channelRead "MessageToMessageDecoder.java" 88]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365]
[cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357]
[cdjd.io.netty.handler.timeout.IdleStateHandler channelRead "IdleStateHandler.java" 286]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365]
[cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357]
[cdjd.io.netty.handler.codec.ByteToMessageDecoder fireChannelRead "ByteToMessageDecoder.java" 324]
[cdjd.io.netty.handler.codec.ByteToMessageDecoder channelRead "ByteToMessageDecoder.java" 296]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365]
[cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357]
[cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext channelRead "DefaultChannelPipeline.java" 1410]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379]
[cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365]
[cdjd.io.netty.channel.DefaultChannelPipeline fireChannelRead "DefaultChannelPipeline.java" 919]
[cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe read "AbstractNioByteChannel.java" 166]
[cdjd.io.netty.channel.nio.NioEventLoop processSelectedKey "NioEventLoop.java" 719]
[cdjd.io.netty.channel.nio.NioEventLoop processSelectedKeysOptimized "NioEventLoop.java" 655]
[cdjd.io.netty.channel.nio.NioEventLoop processSelectedKeys "NioEventLoop.java" 581]
[cdjd.io.netty.channel.nio.NioEventLoop run "NioEventLoop.java" 493]
[cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4 run "SingleThreadEventExecutor.java" 986]
[cdjd.io.netty.util.internal.ThreadExecutorMap$2 run "ThreadExecutorMap.java" 74]
[java.lang.Thread run nil -1]],
:cause
"PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n",
:message
"PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10.\nWas expecting one of:\n "=" ...\n "." ...\n "[" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n",
:sql-exception-chain
["SQLException:"
"Message: PARSE ERROR: Failure parsing the query."
"SQL Query SET ROLE NONE;"
"startLine 1"
"startColumn 10"
"endLine 1"
"endColumn 13"
"SQL Query SET ROLE NONE;"
"[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]"
"(org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10."
"Was expecting one of:"
""=" ..."
""." ..."
""[" ..."
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146"
"org.apache.calcite.sql.parser.SqlParser.handleException():133"
"org.apache.calcite.sql.parser.SqlParser.parseStmtList():188"
"com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172"
"com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187"
"com.dremio.exec.planner.sql.SqlConverter.parse():199"
"com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317"
"com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269"
"com.dremio.exec.work.foreman.AttemptManager.plan():516"
"com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422"
"com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140"
"com.dremio.service.commandpool.CommandWrapper.run():70"
"com.dremio.context.RequestContext.run():96"
"com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212"
"com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192"
"java.util.concurrent.Executors$RunnableAdapter.call():511"
"java.util.concurrent.FutureTask.run():266"
"java.util.concurrent.ThreadPoolExecutor.runWorker():1149"
"java.util.concurrent.ThreadPoolExecutor$Worker.run():624"
"java.lang.Thread.run():750"
"Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10."
"Was expecting one of:"
""=" ..."
""." ..."
""[" ..."
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900"
"com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197"
"com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73"
"org.apache.calcite.sql.parser.SqlParser.parseStmtList():186"
"com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172"
"com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187"
"com.dremio.exec.planner.sql.SqlConverter.parse():199"
"com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317"
"com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269"
"com.dremio.exec.work.foreman.AttemptManager.plan():516"
"com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422"
"com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140"
"com.dremio.service.commandpool.CommandWrapper.run():70"
"com.dremio.context.RequestContext.run():96"
"com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212"
"com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192"
"java.util.concurrent.Executors$RunnableAdapter.call():511"
"java.util.concurrent.FutureTask.run():266"
"java.util.concurrent.ThreadPoolExecutor.runWorker():1149"
"java.util.concurrent.ThreadPoolExecutor$Worker.run():624"
"java.lang.Thread.run():750"
"SQLState: null"
"Error Code: 0"]}

)

Could you help me?

Do you plan to update the driver to support latest version of dremio and metabase ?

Hello @Baoqi , thank you for providing us with a new dremio driver !
Please, could you tell me what to put in the "database" required connection field ?
I tried with several space names, with no luck.

Looking forward,
Fabrice

I tried to install the driver but I've got the following error:

:cause
 "Could not locate metabase/mbql/util__init.class, metabase/mbql/util.clj or metabase/mbql/util.cljc on classpath.",
 :phase :execution}
    Step "Compile clojure source files" failed with error "Syntax error macroexpanding at (metabase/driver/dremio.clj:1:1)."

The metabase/mbql does not exist.
I followed the install guide

• Install on WSL 2.0
• Metabase v0.50.10

After syncing dremio schema to metabase, sync says complete but the schemas page in metabase is empty. Metabase logs dont seem to show anything but dremio logs have the following -

dremio_1 | 2022-08-12 02:22:24,459 [UserServer-1] WARN c.dremio.sabot.rpc.user.UserSession - Ignoring unknown property: APPLICATIONNAME
dremio_1 | 2022-08-12 02:22:24,460 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /172.21.0.2:31010 <–> /172.21.0.1:65186 (user client)
dremio_1 | 2022-08-12 02:22:24,461 [UserServer-1] INFO com.dremio.ConnectionLog - [121ffbb1-210e-4959-a6f3-293681bedb9f] Connection Closed

Any idea why?