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
Install
/plugin marketplace add exploreomni/omni-agent-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add exploreomni/omni-agent-skills --skill omni-to-dbt-metricflowgit 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-metricflowPersonal 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.
Details
- Skill name
omni-to-dbt-metricflow- Repository
- exploreomni/omni-agent-skills
- 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
46exploreomni/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",
Omni Admin
46exploreomni/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".
Omni AI Eval
46exploreomni/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
Omni to Snowflake Semantic View
46exploreomni/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.
Database Query
40makenotion/cursor-notion-plugin
Query a Notion database by name or ID and return structured, readable results with optional filters and sorting.
Uw Scriptable Object Arch
47devdavv/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
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.