Introduction

Count views are data tables that have come from a cell in a notebook, and will refresh whenever the notebook and its dependent data refreshes. They are analogous to views in SQL that run bespoke queries to create an updating table of data.

As in the example above, you can use notebooks to create views that are simplified and clean versions of your source data. You can optionally connect this view with any other data in any other notebook.

Create a View

When you publish a notebook, you'll be asked whether you want to create any views.

Select the cell names you want to save, and chose what you want the new table to be named in Count.

Now whenever the dependent data is refreshed, so will the new view (Clean_Movies) in this case.

Managing a View

A view is now treated like any other data table in Count.

This means you can:

  • query it
  • delete it
  • import it to another project
  • add it to the schema for automatic joining
  • create another view with it

Editing a View

If you ever need to change a view (e.g. to update column names or to completely change the logic), all you need to do is:

  1. Fork the notebook where the view is housed
  2. Make your edits
  3. Re-merge the new notebook

And this will update your view.

Un-doing Edits of a View

If you've made edits to a view and want to un-do them, simply revert the old version of the notebook that has the logic you want to keep, and the view will be updated accordingly.

Did this answer your question?