Download and Install the Plotly Database Connector App
Launch and Connect
Having launched the app, select S3 by clicking on its icon.
Enter your Bucket name, Id and its access Key.
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.
Preview Your Files
Our S3 connector enables you to import csv values into the Plotly Chart Creator. In the preview section, you will see the list of files available to you from the bucket to which you connected.
Import a CSV file from your S3 Bucket
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 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.
A dropdown menu will appear that lets you to select which file you wish to import into the grid and use for your graph."
Once your file is selected, click Import File. 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. Our S3 connector only supports importing CSV files right now, but if you would like to see another file type supported, submit a request to us!
Making a plot!
Let's make a graph. Click on Graph on the left side of the window and choose Chropleth as Chart Type. Select string-1 as the label for location and double for values.
Our graph was updated automatically while we were selecting the columns to use.
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.