Omni to DBT Metricflow

Move logic that lives in Omni Analytics views (dimensions, measures, primary keys) and relationships into the dbt Semantic Layer as MetricFlow semantic_models, metrics, and saved_queries YAML, scoped by a field list, a view, or a topic, check it with dbt and mf, then make Omni fall back to the dbt definition by removing the Omni model-layer override once a dbt sync has brought it in. Use this skill whenever someone wants to push Omni measures or metrics down to dbt, hand Omni logic to the dbt Semantic Layer, generate semantic_models or metrics YAML from an Omni view, or make dbt the source of

46 stars 10 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add exploreomni/omni-agent-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add exploreomni/omni-agent-skills --skill omni-to-dbt-metricflow
Manual install
git clone --depth 1 https://github.com/exploreomni/omni-agent-skills.git /tmp/omni-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/omni-agent-skills/skills/omni-integrations/skills/omni-to-dbt-metricflow ~/.claude/skills/omni-to-dbt-metricflow

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Omni → dbt MetricFlow

Export Omni model logic to dbt MetricFlow YAML. The logic lives in views (dimensions, measures, primary keys) and in the relationships file. Each dbt-backed view becomes one semantic model. A topic is optional: it scopes the views and fields, and its `default_filters` and `sample_queries` become saved queries. Once the YAML is merged in dbt, Omni brings it in on the next schema refresh or dbt sync, and the Omni model layer still wins over it. The last part of this skill removes the Omni override so Omni falls back to the dbt definition. Treat exported YAML as a draft until the user approves a write or promotion.

Read [FIELD-MAPPING.md](./references/FIELD-MAPPING.md) for mappings and worked examples. Read [YAML-REFERENCE.md](./references/YAML-REFERENCE.md) for legacy and dbt 1.12 YAML. Read [FALLBACK-TO-DBT.md](./references/FALLBACK-TO-DBT.md) before you remove an Omni override.

---

## Prerequisites

```bash
command -v omni >/dev/null || echo "ERROR: Omni CLI is not installed."
omni config list
omni config use <profile-name>
omni whoami whoami
```

> **Auth**: a profile uses an API key or OAuth. If `whoami` returns `401`, ask the user to run `! omni config login <profile>`. Do not run browser login in a headless session. See [omni-api-conventions](../../../../rules/omni-api-conventions.mdc) for profile setup and `--schema`.

Check the dbt project environment.
Read the full skill on GitHub

Details

Skill name
omni-to-dbt-metricflow
Path
skills/omni-integrations/skills/omni-to-dbt-metricflow/SKILL.md
Repo updated
16 November 2026

FAQ

What does the Omni to DBT Metricflow skill do?

Move logic that lives in Omni Analytics views (dimensions, measures, primary keys) and relationships into the dbt Semantic Layer as MetricFlow semantic_models, metrics, and saved_queries YAML, scoped by a field list, a view, or a topic, check it with dbt and mf, then make Omni fall back to the dbt definition by removing the Omni model-layer override once a dbt sync has brought it in. Use this skill whenever someone wants to push Omni measures or metrics down to dbt, hand Omni logic to the dbt Semantic Layer, generate semantic_models or metrics YAML from an Omni view, or make dbt the source of

How do I install the Omni to DBT Metricflow skill?

Claude Code plugin: /plugin marketplace add exploreomni/omni-agent-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Omni to DBT Metricflow popular?

It lives in exploreomni/omni-agent-skills, which has 46 GitHub stars and 10 forks.

Related skills

Omni Embed

46

exploreomni/omni-agent-skills

Embed Omni Analytics dashboards in external applications — URL signing, custom themes, iframe events, entity workspaces, and permission-aware content — using the @omni-co/embed SDK and Omni CLI. Use this skill whenever someone wants to embed a dashboard, sign an embed URL, customize the embedded theme, handle embed events, listen for clicks or drills in the iframe, send filters to an embedded dashboard, set up entity workspaces, look up embed users, build a permission-aware content list, white-label an embedded dashboard, or any variant of "embed this dashboard", "customize the iframe theme",

Frontend & Design10

Omni Admin

46

exploreomni/omni-agent-skills

Administer an Omni Analytics instance — manage connections, users, groups, user attributes, permissions, schedules, and schema refreshes via the Omni CLI. Use this skill whenever someone wants to manage users or groups, set up permissions on a dashboard or folder, configure user attributes, create or modify schedules, manage database connections, refresh a schema, set up access controls, provision users, or any variant of "add a user", "give access to", "set up permissions", "who has access", "configure connection", "refresh the schema", or "schedule a delivery".

Data & Analytics10

Omni AI Eval

46

exploreomni/omni-agent-skills

Evaluate Omni AI accuracy using Omni's built-in eval system — define a prompt set, run a judged eval against a model (or branch), and read the accuracy-judge verdicts. Use this skill whenever someone wants to evaluate Omni AI, benchmark Blobby, run regression tests, compare AI output across branches or model-context changes, measure AI quality, run A/B tests on model changes, assess the impact of an ai_context or modeling change, or any variant of "run evals", "test Blobby", "benchmark query generation", "compare AI results", "regression test", "how accurate is the AI", or "measure the impact

AI, LLMs & Agents10

Omni to Snowflake Semantic View

46

exploreomni/omni-agent-skills

Convert an Omni Analytics topic into a Snowflake Semantic View YAML definition. Use this skill whenever someone wants to export Omni metrics to Snowflake, create a Semantic View from an Omni topic, harden BI metrics into the warehouse, or bridge Omni's semantic layer with Snowflake Cortex Analyst.

Databases10

Database Query

40

makenotion/cursor-notion-plugin

Query a Notion database by name or ID and return structured, readable results with optional filters and sorting.

DatabasesIn 1 list21

Uw Scriptable Object Arch

47

devdavv/unity-ai-workflow

Generate ScriptableObject-based systems including data containers, event channels, and runtime sets. Use when creating game data (weapons, enemies, items, abilities), cross-system events, or live object tracking. Triggers on requests like "create weapon data", "add an event system", "make a runtime set", "decouple these systems", "create item database", "add a damage event", "track active enemies", "create a config SO", "add game settings data", or any task involving ScriptableObject data containers, event-driven communication, or runtime object tracking. Reads ProjectConfig.yaml -> architectu

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.