Managing Data Sources

Data Sources in Akuko

Data sources define which data is available to visualize in Akuko. These are used to power the map layers, table, charts and other data components used in Akuko posts. It is easy to combine different data sources in a post to build an engaging data story.

Data Source Types

Akuko currently supports three primary types of data sources

  • Static Files - CSV and Geojson

  • Online Apps - Google Sheets

  • Database Connections - PostgreSQL

In the near future, we have plans to support the additional data sources:

Database

Online Apps

MySQL

Office 365 / Sharepoint

AWS Redshift

Airtable

AWS Athena

MongoDB

Google BigQuery

MS SQL

Snowflake

Apache Druid

SQL Lite

Oracle

If there is a data base or online app you would like us to support please contact us.

Creating a Data Source

Go to the Sources page and click Add Source in the top right corner.

Give your source a name and then in the pull down select the source type.

Static Data Source Types

To upload a static file, select a valid CSV and GeoJSON file and it will automatically upload.

Note: Akuko currently expects that any column with numeric data to only be numbers including blank spaces which should be replaced with a zero.

Akuko will throw an error if the column name in a dataset starts with a number. eg. 2019-cases This should soon be fixed. For now, please rename columns in your data sources to something like thiscases-2019.

You currently can not update a data source created from a static file yet.

Connecting to a Database Source

If you wish to create a source from a database table, select the database you want to connect too. Akuko currently only supports PostgreSQL. Enter in the database connection properties requested and hit connect. Once connected, Akuko will automatically determine the schema of your DB table and generate a corresponding source. Once your DB source is setup, you can create components that will automatically reflect the contents of your database in real time.

Deleting a Data Source

Click on the data source you want to delete. Click on the menu in the top right and then select Delete Source. You will then be prompted to confirm you want to delete the data source.

Once deleted the data source cannot be retrieved. When deleting data sources please be aware that there may be numerous posts and components tied to that data source that may break. You may wish to rename the data source to something like My Data Source - Old if you need to repoint existing components in posts to an updated source.

If you are connected to an external data source like a database or Google Sheet it is important to know that deleting a source will not result in deleting your underlying data. Unless you have uploaded a static file, data sources in Akuko just represent a mapping to an external data source.