Dremio ODBC Connection

[intapiuser]

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 "".