I’m trying to open up Tableau to view the data in Dremio but when Tableau opens, it asks me to connect using the Dremio ODBC connection, and when I try to configure this, I get a message that says:
An error occurred while communicating with Other Databases (ODBC).
The connection to the data source might have been lost.
[Dremio][Connector] (20) Failure occurred while trying to connect to local=localhost:3306. (Details: [30004]Connection failed with error: Cannot decode handshake.)
Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection.
Unable to connect using the DSN named “Dremio Connector”. Check that the DSN exists and is a valid connection.
What should I use for the connection attributes? I’m running Dremio locally on my laptop.
thanks,
Nate