Skip to content

Model Catalog

The Catalog is a centralized view of all models and sources across every deployed project in your organization. It lets you browse, search, and inspect model metadata without leaving the platform.

Accessing the Catalog

Navigate to Get Insights → Catalog from the main navigation.

The Catalog only shows deployed projects. If no projects appear, deploy a project first.

The Catalog provides several ways to narrow down the model list:

Control What it does
Search bar Matches against model name and description
Type chips Filter by model kind (View, Table, Incremental, Source, Seed, etc.)
Sort dropdown Sort by name, type, or favorites-first
Favorites toggle Show only starred models
External/Source toggle Show or hide external models (SQLMesh) and sources (dbt)
Project dropdown Switch between deployed projects

Model types differ by framework. SQLMesh projects have types like VIEW, TABLE, INCREMENTAL_BY_TIME_RANGE, SEED, and EXTERNAL. dbt projects have types like MODEL, SOURCE, SNAPSHOT, and EPHEMERAL.

External models (SQLMesh) and sources (dbt) are hidden by default. Enable the database icon toggle in the filter bar to show them.

Model Detail Panel

Click any row to expand it inline. The detail panel has three tabs:

Details - Model metadata including:

Field Notes
Full name Fully qualified model name in monospace
Type Model kind
Dialect SQL dialect (SQLMesh projects only)
Owner Model owner if defined
Description From model definition
Interval unit How often the model processes data (SQLMesh only)
Cron Cron expression for scheduling (SQLMesh only)
Intervals Number of completed intervals (SQLMesh only)
Start / End date Data range boundaries (SQLMesh only)
Materialization Table, view, incremental, etc. (dbt only)
Schema / Database Target schema and database (dbt only)
Tags Model tags if defined

Columns - Column names and data types for the model. Only populated when column metadata is available from the project.

Recent Executions - The last 10 job runs that touched this model, showing status, data interval processed, execution time, and duration. This is model-scoped, not project-scoped.

Favorites

Star any model to mark it as a favorite. Favorites are stored in browser local storage - they persist across sessions on the same browser but are not shared with other users or devices.

Use the star button in the filter bar to show only favorited models. Use the sort dropdown to sort favorites to the top of the full list.

Cache

Model data is cached. A cache age indicator appears next to the project selector after a project is selected. If the cache is more than 50 minutes old, the Catalog automatically triggers a background refresh. A manual refresh button is also available when a project is selected.

Warning

During a cache refresh, the model list is read-only and filters are temporarily disabled. The UI will indicate this state.

Key Takeaways

  • ✅ The Catalog shows models across all deployed projects - select a project from the dropdown to load its models
  • ✅ External models and dbt sources are hidden by default; use the toggle to show them
  • ✅ Click any model row to see its columns, metadata, and recent execution history
  • ✅ Favorites are browser-local and not synced across devices or users
  • ✅ The Catalog works with both SQLMesh and dbt projects; some fields are framework-specific