Accessing data from Apache Drill

You can connect to and access data from Apache Drill in Spotfire.

About this task

Before you begin

Read the System requirements for Spotfire Connectors. Make sure your version of Spotfire supports connecting to Apache Drill. The system requirements page also specifies which ODBC driver, and versions of the driver, that you can use with the connector.
Install the required ODBC driver on your computer. See Drivers and data sources in Spotfire.

Accessing data with an existing connection to Apache Drill

About this task

You can access data from Apache Drill by opening an existing connection or connection data source that is shared in your library. This is a convenient way to access a predefined selection of data from Apache Drill, that you or someone else in your organization has set up.

Procedure

On the Authoring bar, click Files and data .
In the Files and data flyout, browse the folders in the library, or start typing in the search field to find for your content.

Tip: You can search for 'connector:drill' to find all shared connections and connection data sources that were created with the Apache Drill connector.
Click to open the connection or connection data source that you want to add data from. If necessary, sign in with your Apache Drill credentials.
1. If you opened a connection data source, use the controls in the Views in Selection dialog to select the data you want to analyze from the data source.
  
  Note: To open an Apache Drill connection data source, you must use an installed client.
The final step is a summary view of the data that you are about to add to your analysis. Here you can view and change how the data should be added. Make any changes that you want, and then click OK to confirm and add the data to the analysis.

Creating a new connection to access data from Apache Drill

Before you begin

To create a new Spotfire connection to Apache Drill, the following is required:

You must use a Spotfire installed client.
You must have a DSN for your data on your computer. See Setting up a DSN for your Apache Drill data below.

About this task

To create a new connection to Apache Drill, you use a DSN on your computer. Once you have connected to Apache Drill in Spotfire, you can share the connection or the analysis in the library, so that other users on your team can easily access the selected Apache Drill data.

Note: Once you have created the connection in Spotfire, the DSN is no longer required for using the connection. All the required connection information, except for username and password, is stored in the Spotfire connection.

Procedure

On the Authoring bar, click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, select Apache Drill, and then click New connection.
In the list in the Apache Drill Connection dialog, select the DSN that you want to create a Spotfire connection from. Enter your Apache Drill credentials, and then click Connect.
In the Views in Connection dialog, select the data that you want to include in the connection, then click OK.
The final step is a summary view of the data that you are about to add to your analysis. Here you can view and change how the data will be added. Make any changes that you want, and then click OK to confirm and add the data to the analysis.

Setting up a DSN for your Apache Drill data

About this task

To manage and create new connections to Apache Drill, you must have a DSN for your Apache Drill data on your computer.

For information and help, see Using DSNs to create data connections to Apache Drill and Dremio.

For best practices, requirements, and limitations, see Best practices for connections to Apache Drill.

Tip: For more information about authentication and DSNs for Apache Drill, see the official documentation from Apache Drill.