The following information lists miscellaneous requirements, tips and suggestions for working with the Dremio connector. The purpose is to help you achieve stable performance and avoid issues when you access your data from Dremio in Spotfire.
Tip |
Description |
DSN information |
When you create or select a DSN to use for creating a connection to Dremio in Spotfire, consider the following:
|
Use well-defined views |
For stable performance, it is recommended that the Dremio data that you want to analyze in Spotfire is properly configured and has a well-defined schema. Data with dynamic schemas and that has not been properly configured can cause unpredictable issues and exceptions, where Dremio fails to execute queries. |
Some Drill plugins might affect performance |
Apache Drill systems can connect to data in a range of different types of data sources. To achieve this, various plugins are used. Different plugins might cause varying performance in Spotfire. |