cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
  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 "".
Version history
Last update:
‎02-09-2024 11:31 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: