Best Practices when Connecting to Apache Drill

The following information lists miscellaneous requirements, tips and suggestions for working with the Apache Drill connector. The purpose is to help you achieve stable performance and avoid issues when you access your data from Apache Drill Spotfire.

Tip	Description
DSN information	When you create or select a DSN to use for creating a connection to Apache Drill 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 Kerberos
Use well-defined views	For stable performance, it is recommended that the Apache Drill 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 Apache Drill fails to execute queries.
Apache Drill data must be available as views	The data that you want to access in Spotfire must be available as views in Apache Drill. Data that is not available as a view in Apache Drill is not displayed when you select data in the Views in Connection dialog. However, you can access data that is not available in a view by using custom 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.