Show Sidebar Hide Sidebar

Connect Your Charts and Dashboards to Parquet files with Apache Drill

Graph data from your Parquet files using Apache Drill database with Plotly 2.0 and the Plotly Database Connector.

Step 1

Download and Install the Plotly Database Connector App

If you haven't downloaded and installed the application yet, please follow the instructins for either personal setup or company on-premise.

Step 2

Launch and Connect

Having launched the app, select Postgres by clicking on its icon.

Enter your username, password, database server name (host) and its port number.

Finally, click on the connect button!

Once connection is established, your connection credentials will be saved and greyed out to avoid unintentional changes. If you wish to modify your connection, click on edit credentials.

Step 3

Preview Your Files

Two lists will appear. The values are the Plugins and Files available for querying.

Step 4

Send a Query to Your Database

Having connected your app, visit Plotly Chart Creator and click on import data in the top right corner.

Choose SQL from the options on the top.

Click Next.

If you have not setup your connector to use HTTPS protocol, you do not need to modify any of the options. See HTTPS tutorial to setup your connector to use the HTTPS protocol. Once done, come back to this point and select the HTTPS option.

Click on Connect

The modal will close and a new panel will be added to your Plotly Chart Creator.

On the right, your available connections from the Plotly Database Connector will be displayed. If you have more than one, make sure you select the database connection that you want to use when writing the query.

In this use case, we want to query parquet files, we wrote a SQL-like query as supported by Apache Drill to obtain data from our sample-data file as shown. Visit Apache Drill documentation for SQL-like queries to have a better understanding of its functionality.

Once your query is finalized, click Run Query. If you wish to set your query on a schedule to keep your grid's data updated to the latest entries of your database, visit our schedule a query tutorial.

Step 5

Making a plot!

Let's visualize the complaints types from our dataset. Click on Graph on the left side of the window and choose Histogram as Chart Type. Select Complaint Type as the labels for the chart.

The graph will have been updated as per our data selection and we can notice that Heating was by far the highest complaint.

Finally let's not forget to save and share our graph. You can press Control + S to save or click on the Save button on the left of the window.

You will be prompted to choose your privacy settings for this graph and data. There is nothing here to classify, let's simply set both plot and data to public. Click SAVE.

Let's share this interactive plot with a friend or a coworker (or both)! Click on the SHARE tab on the left.

The fastest way is to send the Shareable Link, copy and paste it into your favorite e-mail or other communication service. Try out our Twitter, Facebook and Google+ links as well or embed it into your website by obtaining the iframe link in the Embed tab. If you set the settings to public previously, your friend or coworker will be able to view it even without an account and give you feedback.

Still need help?
Contact Us

For guaranteed 24 hour response turnarounds, upgrade to our Premium or Enterprise plans.