Knowledge Base Article

Dremio ODBC Connection

  1. In case you don't know already you can download the Dremio ODBC drivers here:  https://www.dremio.com/drivers/odbc/
  2. Information for configuring the driver can be found here:  https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-flight-sql-odbc-driver
  3. When connecting in Sisense I got an error when trying to use the DSN option.  I was only able to connect by 'Connection String' based on the format found here:  https://www.connectionstrings.com/dsn/
  4. I was now able to add the tables but running the query returned an error " ERROR [HY000] [Dremio][Connector] (1040) Dremio failed to execute the query".  This error was due to Sisense putting [] around the table names in the query. 
  5. The error was fixed by going into Elasticube/Change Connectivity Settings and selecting 'Manual Query Input' which replaced the square brackets with double quotes "".
Updated 02-09-2024
Data Connectors
No CommentsBe the first to comment

About Data Sources

Node avatar for Data Sources
Guides for how to connect to and manage Data Sources
34 ArticlesCreated: 4 months agoLatest Activity: 06-04-2025