Best Practices when Connecting to Dremio

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: Only System and User DSNs are supported. A DSN configured with a default schema does not limit the available schemas to only that schema in Spotfire. Only DSNs configured with the following authentication types are supported: Plain No authentication Username
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.