time required: 2 minutes
Observable notebooks are a great way to make sense of data in general. In this guide, we query a bank account statement and plot the results while keeping both our Splitgraph repository and Observable notebook private.
Open the Observable notebook. The charts display publicly
available sample data. To create your own private copy, click on the
and select Fork as shown in the screen recording.
If you want to analyze your own data, you can Upload an account statement CSV. Most banks have similar CSV formats, though the column names may need to be updated if you are not using Revolut. Be sure to set the repository's visibility to private.
The fully qualified table name of your data will be different than what's in the
original notebook. In your own freshly created copy, set
tableName to the
First, head over to the SQL Credentials page and create a username and password for Observable.
Then, register a new database in Observable as shown in the screen recording:
Any time you need to analyze private data using Splitgraph and Observable, just
db = DatabaseClient("Splitgraph DDN");