The catalog is the foundation of your semantic layer. It stores all your views and datasets.
In this video, we’ll walk through creating your first Count metrics catalog from scratch. You’ll see how to set up a catalog, connect your data, and start building views and datasets that your team can use right away.
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.
Troubleshoot
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.
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.
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.
The user likely doesn't exist on your workspace.
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.
You need to upgrade your access on the database connection to Admin.
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.
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.
