Schedule Persistent Queries
Set your data to be updated using peristent queries with Chart Studio and the Plotly Database Connector.
Save your query
You have successfully ran a query and your Chart Studio grid now has data from your database. The first step to have your data automatically updated in Chart Studio is to save your grid along with the query. Click on Save on the left of the Chart Studio user interface.
You can set privacy settings for both your grid and plot upon saving. Once that is done, click save on the bottom right.
Set your refresh rate
Your connector will update your data periodically and you have several choices when it comes to the refresh rate of your data. Click on the dropdown above the grid as shown below and choose a refresh rate that will be suitable for you and your colleagues.
Click on the check box next to the refresh rate dropdown to schedule your query. If this is your first time scheduling a query, you will be asked to authorize your connector to run queries on your behalf - this is described for you in the next step.
Authorize your connector
If this is your first time scheduling a query, you were prompted in Chart Studio to login and authorize your connector to run queries on your behalf. Let's give the authorization to the Database Connector by clicking login as shown to authorize.
Click authorize to allow Plotly Database Connector to run in the background and update your data within Chart Studio grids.
A message confirming your authorization will appear. You may close this Web Browser tab and return to Chart Studio
Back in Chart Studio, click on the check box to schedule the query now that the connector has your authorization.
Scheduled queries
Once the query is scheduled, the connector will post queries to your database and update your grid with data received from the query. You can observe the grid's last update time from your Plotly organizer. In case you want to change the refresh rate, simply interact with the dropdown menu while your Database Connector is running. If the query is saved, the checkbox in Chart Studio will be checked.
