count.co

Building a catalog

The Count Metric semantic layer is represented as one or more catalogs.

The catalog is the foundation of your semantic layer. It stores all your views and datasets.

This guide walks you through creating and managing a catalog step by step.

Creating a catalog

Click on Create new catalog in the sidebar of the workspace UI

Select the data source(s) you want to be available in your catalog.

Choose specific tables from your source to appear in your catalog as views (optional). These views can be edited or extended later.

Invite your team to the catalog and assign roles.

If you chose to create your catalog from database tables, you can now Validate and commit the new views.

⚠️ At this point, no one can access the catalog unless:

  • You grant them access, or

  • You assign the catalog to a project they are a member of.

Troubleshooting

Creating a catalog is easy, and if you’ve followed along with this guide, you probably already have a catalog ready to connect to a project and start exploring! Sometimes, though, things don’t go exactly as planned, no problem! Here are some handy troubleshooting tips to help you get back on track.

Problem
Solution

I can't see a create new catalog button in my workspace

You may not have the right access to create catalogs in your workspace. You need to be a workspace Admin or Owner to create catalogs.

I can't see the data connection I want to use in my catalog

You may not have the right access to add the data connection to your catalog. You need to be an Admin of the data connection to be able to add it to projects or catalogs. The data connection may not exist, in which case you need to create it.

I can't find the tables I want to add to my catalog in the create from database tables dialog

You may need to refresh the database schema to bring the latest list of tables on your database connection into our UI. The tables might not exist on your database connection, or in some cases the tables exist in a different schema to main schema connected. In this case you can still access those tables, and still create catalog views on them, but not using our create view from table dialog.

I can't find the workspace member that I want to add to my catalog

The user likely doesn't exist on your workspace

I can't update the access role on my catalog member(s)

The roles users can have on the catalog are limited by their workspace role. Workspace owners and admins can take on all catalog roles, analysts and viewers have a limited set of roles.

The data connection I want to use in my catalog is greyed out

You need to upgrade your access on the database connection to Admin.

I can't find the project I want to add my catalog to

You may not have access to the project. Either upgrade your project access to Admin or add an existing project admin to the catalog as an Admin. It could also be that the project doesn't exist.

The project I want to add my catalog to is greyed out

While you have access to view the project, you don't have access to add the catalog to the project. Either upgrade your project access to Admin or add an existing project admin to the catalog as an Admin.

PreviousIntro to Count MetricsNextEditing a catalog

Last updated