Cannot connect to Tableau Online

1

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

2

@Dan888 Are you using the taco file and legacy JDBC driver? What is the Java version running on the Dremio server?

When you say Tableau online, do you mean Tableau Cloud?

3

@balaji.ramaswamy Yes indeed, I meant Tableau Cloud, the instance in 10ax location (US West - Oregon).
I’m running Dremio in Docker, Java version is:

openjdk version “1.8.0_332”
OpenJDK Runtime Environment (build 1.8.0_332-b09)
OpenJDK 64-Bit Server VM (build 25.332-b09, mixed mode)

EDIT:

I’ve setup a separate test server with a more recent image of Dremio that produces the same error, Java version there is

openjdk version “11.0.25” 2024-10-15
OpenJDK Runtime Environment Temurin-11.0.25+9 (build 11.0.25+9)
OpenJDK 64-Bit Server VM Temurin-11.0.25+9 (build 11.0.25+9, mixed mode, sharing)

4

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.

Metabase logs are as follows are at https://sharepad.io/p/kR7c4mV since it’s more than 30k symbols

5

@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

6

Yes, I’ve tried DBeaver on my Mac with Dremio JDBC driver 24.0.0-202302100528110223 and it works just fine