Hi, I’m experiencing problem connecting self hosted instance of Dremio to Tableau Online for the past couple of days. My initial version of dremio was 21.1.1, I’ve also tested on the latest 25.2 on an alternative clean installation. When trying to connect to Tableau Cloud I get the following error message:
Can’t connect to Dremio
Detailed Error Message
Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null ↔ null (user client) Unable to connect to the Dremio server “dremio..”. Check that the server is running and that you have access privileges to the requested database.
I’ve checked the dremio console and got this:
2025-01-08 09:02:17,996 [UserServer-1] INFO com.dremio.ConnectionLog - [a49f5b70-c39b-47ef-a2a8-78ed848329fe] Connection opened.
Endpoint: 52.39.159.250:10029
Protocol Version: 5
Record Type: DREMIO
Record Formats: DREMIO_1_4, DREMIO_0_9
Support Complex Types: true
Name: Dremio JDBC Driver
Version: 15.2.0-202104142212170463-ae16cd17 (15.2.0)
Application: 19311@worker-10axpd-az1-1
User Properties:
direct=**.***.***.**:31010
user=****
2025-01-08 09:02:17,996 [UserServer-1] WARN c.dremio.sabot.rpc.user.UserSession - Ignoring unknown property: DIRECT
2025-01-08 09:02:18,175 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /172.17.0.2:31010 <--> /52.39.159.250:10029 (user client)
2025-01-08 09:02:18,175 [UserServer-1] INFO com.dremio.ConnectionLog - [a49f5b70-c39b-47ef-a2a8-78ed848329fe] Connection Closed
Any ideas on what may be the culprit and how to fix this? Thank you
Incidently, I’ve tried to connect Dremio (via metabase dremio driver 1.5.0) to Metabase (0.52.5) and got the same error Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <--> null (user client) which is weird because I’ve unchecked SSL option in all cases.
@Dan888 Let us pull it apart and see where the issue is. Is it possible to connect from DBeaver (on prem) and see if that works? We can then add one variable at a time
@Dan888 Sorry for the dumb question, when you say Tableau online, is it something that you create on your Tableau desktop and then publish to Tableau online? If that is the case, does your Tableau desktop connection work? it seems like there is something ging n with your connection string. Is that something you can send across by masking the sensitive values like passowrds?
@balaji.ramaswamy Yes, so my Tableau Desktop version 2024.3 (Apple silicon) does indeed connect to the Dremio server without a problem, but once I publish the workbook to Tableau online/cloud, published version can’t connect to Dremio. I can send everything you need, just tell me what to do step by step please
@balaji.ramaswamy Yes, I’m I’ve chosen to create extract of the data source and published it to Tableau Cloud with embedded credentials, once I run Refresh extract now, the job fails
