Show Sidebar Hide Sidebar

Query from Plotly

Query inside the Chart Studio to unlock all Plotly chart types and styling options.

Step 1

Query from Plotly

With Falcon you can query your database from plot.ly (Chart Studio), which will allow you to utilize all chart types and styling options that are avaliable in the Chart Studio and also setup scheduled queries. In order to query from plot.ly, navigate to the PLOT.LY tab in Falcon then click the blue QUERY [DATABASE] FROM PLOT.LY button. This will open plot.ly (Chart Studio) in your default browser.

Query from Plotly

Step 2

Connect to Chart Studio

Once your default browser opens you will be greeted by an import modal, where you ought to see HTTPS radio button selected and your unique URL in option 4 (like below). When ready, you can click Connect.

Connect

Step 3

SQL Editor in Chart Studio

The Chart Studio will load with a slight variation to the interface. As you can see, above the grid is the SQL Editor and to the right are your database conncetions and avaliable tables.

Chart Studio

Step 4

Run Query

To execute a SQL query, simply type your query in the editor and hit Run Query. If succesful, you ought to see the grid populted with data and you can begin creating your chart type. For tutorials on chart types, see our Chart Studio documentation.

Run Query

Step 5

Scheduled Queries

After you have created and saved your chart, you can then schedule queries to take place every x by selecting the Scedule Query checkbox, your selected time and saving the chart again. For more detailed information on scheduled queries see the Schedule a Query tutorial.