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.
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.
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.
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.
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.