Skip to main content

Migration from Goodtables

Goodtables was a data package validation service that has been superseded by Frictionless Repository. To use it, it was necessary to create a goodtables.yml configuration file in your repository, otherwise it would validate all your files with as CSV, ODS, XLS or XLSX extensions. The instructions for doing that configuration are described here.

With Frictionless Repository, instead of the goodtables.yml file, you will need to create a github workflow file named .github/frictionless.yaml as describe here.

Example and howto#

The website has used GoodTables in the past to validate their data files, which contain all the portals listed on it. The migration steps from GoodTables to the current Frictionless workflow on repository were:

1. Delete the GoodTables configuration file goodtables.yml#

The configuration file needs to be removed from the repository:

git rm goodtables.yml

2. Remove the GoodTables WebHook from repository settings#

In the Github repository, go into "Settings", then "WebHooks".

Github Actions

Find the entry there and hit "Delete".

3. Create a file inside the repository at the path .github/frictionless.yaml#

If the .github folder does not yet exist in your repository, you do need to create it first. The contents of the frictionless.yaml file are:

- source: data/datapackage.json
type: package

Note that the source must point to the place in your repository where the data package file that you do want to validate is located.

4. Create the configuration file for the Frictionless validation workflow at .github/workflow/frictionless.yaml#

This file is where you configure how the validation is going to run as described here. The contents of this file for the website are:

name: portals
- master
- master
runs-on: ubuntu-latest
- name: Checkout repository
uses: actions/checkout@v2
- name: Validate data
uses: frictionlessdata/repository@v1

After creating these files in your repository, commit (git commit -a) them and push the changes to Github (git push). You can check the workflow running in your repository clicking the Actions tab:

Github Actions

5. Update the validation badge#

In GoodTables, the badge showing the validation status was located at In's case, the path was

With Frictionless Repository, in order to use a badge for the new workflow you need to create an image referencing a specific URL. In's case this is

You can see how the repository is using the badge at their data README page:

Status Badge

If you look at the file contents you will see how this badge is written in Markdown:


You can get the exact code to create the badge for your frictionless validation workflow, in markdown format, by going to your repository's Github Actions tab:

Github Actions

Click the last workflow run:

Github Workflow Run

And then click the three dots menu at the top right corner:

Github Workflow Run Menu

Select "Create status badge" and this will open a dialog where you can copy the badge markdown code:

Github Workflow Badge Code

Paste this code at the top (or anywhere else) of your file, commit it, and you're done!