This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
intapiuser
Community Team Member
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on
03-02-2023
08:42 AM
- edited on
02-09-2024
11:31 AM
by
DRay
- In case you don't know already you can download the Dremio ODBC drivers here: https://www.dremio.com/drivers/odbc/
- Information for configuring the driver can be found here: https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-flight-sql-odbc-driver
- 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/
- 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.
- The error was fixed by going into Elasticube/Change Connectivity Settings and selecting 'Manual Query Input' which replaced the square brackets with double quotes "".
Rate this article:
Helpful Links
Recommended Quick Links
- Community FAQs
- Community Welcome & Guidelines
- Discussion Posting Tips
- Partner Guidelines
- Profile Settings
- Ranks & Badges
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
