sigma-migration-skills

Convert a Domo dashboard (pages + cards + DataSets + Beast Modes) into a Sigma data model and matching workbook. Use when the user has a Domo instance and wants to recreate a dashboard in Sigma. Discovery via Domo's public + private APIs, Beast Mode (MySQL-dialect SQL) → Sigma formula translation, a reuse check before building a new data model, data model + workbook creation via the Sigma REST API, layout generation, Domo PDP → Sigma row-level-security detection, and parity verification against the same warehouse — driven by `scripts/*.rb`.

Convert a Hex project (SQL cells, single-value/METRIC cells, EXPLORE charts, app layout) into a Sigma data model and matching workbook. Discovery via a Hex project export file (Hex's REST API does not expose cell content), calc translation, DM + workbook creation via REST, layout, and warehouse parity verification.

Convert a Looker instance (LookML semantic model + dashboards) into a Sigma data model and matching workbook(s). Use when the user has Looker content — LookML projects, explores, or dashboards (user-defined OR LookML-defined) — and wants to recreate it in Sigma. Discovery via the Looker REST API 4.0 / Looker MCP server (or LookML files offline), model conversion via the local vendored LookML converter (convert_lookml_to_sigma MCP tool as a manual fallback), dashboard → workbook conversion from the Looker Dashboard API JSON, build via the Sigma REST API, and 3-way parity verification against the source warehouse — driven by `scripts/*`.

Convert a Power BI report + semantic model into a Sigma data model and matching dashboard. Use when the user has a Power BI report (in Power BI Service / Fabric, or a .pbix/.pbit file) and wants to recreate it in Sigma. Covers connecting to Power BI with no Entra app, extracting the model (TMSL) + report layout (PBIR/Report-Layout), converting via the sigma-data-model MCP, posting the data model + workbook via REST, and parity verification. Can also author dashboards back INTO Power BI via the Fabric write API.

Convert a Qlik Sense / Qlik Cloud app into a Sigma data model and matching workbook. Use when the user has a Qlik Cloud tenant/app and wants to recreate it in Sigma. Discovery via qlik-cli (Engine + REST), Qlik-expression → Sigma-formula translation via the local vendored convert_qlik_to_sigma converter (MCP tool only as a manual fallback), data model + workbook creation via the Sigma REST API, and parity verification against the source warehouse. Requires qlik-cli + a Sigma SIGMA_API_TOKEN.

Convert an Amazon QuickSight analysis or dashboard into a Sigma data model and matching dashboard. Use when the user has a QuickSight analysis/dashboard and wants to recreate it in Sigma. Covers AWS-CLI extraction of the analysis definition + datasets + data sources, calc-field / data-prep translation via the local vendored converter (the convert_quicksight_to_sigma MCP tool is a manual fallback only), posting the data model + workbook via the Sigma REST API, layout, and parity verification against the same warehouse.

Convert a ThoughtSpot model/worksheet and its Liveboards into a Sigma data model and matching dashboards. Use when the user has a ThoughtSpot instance (or exported TML) and wants to recreate it in Sigma. Covers discovery (TML export), data-model conversion, workbook build, layout, and parity verification driven by scripts/.

Inventory a Hex instance and produce a migration-readiness readout — environment counts, content mix, complexity, and a value/cost-ranked shortlist. Read-only.

Convert a Tableau datasource or workbook into a Sigma data model and matching dashboard. Use when the user has a Tableau datasource, TDS file, or Tableau workbook and wants to recreate it in Sigma. Discovery, calc-field translation, data model + workbook creation via REST API, layout generation, and parity verification — driven by `scripts/*.rb`.

Migrate IBM Cognos Analytics content to Sigma. Use when the user has a Cognos Data Module, Framework Manager package, report (Report Studio / CA Reporting), or dashboard (exploration) and wants to recreate it in Sigma. Converts Data Module JSON → Sigma data model and report-spec XML → Sigma workbook, translating the Cognos expression DSL and flagging constructs with no clean Sigma analog. Dashboards (exploration JSON) are hand-authored per refs/dashboard-migration.md (tabs → separate Sigma pages). Discovery via the CA REST API.

Migrate GoodData Cloud / GoodData.CN workspaces to Sigma. Use when the user has a GoodData workspace — datasets, MAQL metrics, insights, and analytical dashboards — and wants to recreate it in Sigma. Exports the workspace via the declarative layout API (logicalModel + analyticsModel), maps the LDM (datasets / attributes / facts / references) to a Sigma data model, translates MAQL metrics to Sigma formulas, maps insights to workbook charts/KPIs/pivots and dashboards to pages + layout, ports user data filters (RLS) to Sigma user attributes, and verifies parity against the same warehouse. Translates what maps cleanly and flags what doesn't (compute-engine-only metrics, exotic MAQL context, unsupported widgets) instead of emitting wrong logic. Also handles the legacy GoodData Platform (classic "bear", /gdc metadata API, SST/TT auth) for discovery + assessment — one identity sweeps every project under a domain — with DM/workbook conversion still Cloud-only (refs/gooddata-platform-api.md).

Migrate MicroStrategy (Strategy One) content to Sigma. Use when the user has MicroStrategy dossiers, reports, or a classic schema (attributes / facts / metrics) and wants to recreate them in Sigma. Extracts the dossier + full semantic model over the MSTR REST API into a bundle, converts it to a Sigma data model + workbook, reproduces Analytical-Engine row-collapse quirks deterministically, and verifies row-level parity. Live-validated with exact parity on the classic-schema grid path.

Migrate Sisense to Sigma. Use when the user has a Sisense instance — ElastiCube or Live data models and dashboards — and wants to recreate them in Sigma. Pulls the source live over the Sisense REST API (data model schema export + dashboards/widgets), converts the model to a Sigma data model and the dashboards to a Sigma workbook (pivot2→pivot-table, indicator→KPI, chart/*→chart, filters→controls), translates JAQL formulas to Sigma formulas, and verifies data parity by running JAQL against Sisense and comparing to the Sigma query. For a full migration it lands the source data in Snowflake so both tools read the same warehouse. Translates what maps cleanly and flags what doesn't (custom JAQL, BloX/plugin widgets, scripted dashboards) instead of emitting wrong logic.

Build, edit, and iterate on Sigma workbook specs — the JSON definition you POST to /v2/workbooks/spec, covering pages, layout, controls, charts, KPIs, tables, formulas, and sources. The Sigma OpenAPI is the source of truth for every shape and field; this skill adds navigation, style guidance, and proven recipes for effective dashboards. Use when the user wants to construct a dashboard from a spec, add or modify pages / elements / controls / formulas, validate a spec before submission, or work through the workbook spec lifecycle programmatically. Requires an SIGMA_API_TOKEN — obtain via the sigma-api skill first.

Inventory a Domo instance via its public Governance/DomoStats system datasets (and, when reachable, the private card-definition API) to produce a value/cost-ranked migration-readiness readout — environment counts, Beast Mode complexity, PDP/DataFlow structural flags, usage-driven value, and a migration shortlist + plan. Use to scope a Domo→Sigma migration or audit BI sprawl. Read-only; never posts to Sigma; hands off to `domo-to-sigma`.

Build, register, host, embed, and data-bind a bespoke Sigma custom plugin (@sigmacomputing/plugin) to recreate a source visualization for which Sigma has no native chart/KPI/table equivalent — a radial gauge, a custom heatmap, a sankey, or any bespoke viz kind outside Sigma's native element set. **Use when a source viz has no native Sigma equivalent and should be recreated as a bespoke plugin** — not when a native Sigma chart, KPI, or table kind already covers it (that's the `sigma-workbooks` skill). Covers the full lifecycle: writing the single-file plugin, registering it via `POST /v2/plugins`, hosting it, embedding it in a workbook spec bound to real data, and verifying value parity. Ships a worked example (a radial gauge / "value vs. target" plugin) and the `plugin_embed` emitter. Requires an SIGMA_API_TOKEN — obtain via the sigma-api skill first.

Take inventory of an IBM Cognos Analytics estate and produce a migration-readiness readout — content-tree counts, per-artifact conversion complexity (scored against the Cognos→Sigma converter's exact coverage), an estate-wide auto-migration percentage, a named gap analysis, and an effort/wave plan. Use when a user wants to scope a Cognos→Sigma migration, audit Cognos sprawl, or pick which modules / reports to convert first. Read-only, all-free, ~Tableau-assessment-style pre-scoping that complements (does not replace) a deeper paid engagement.

Take inventory of a GoodData Cloud / GoodData.CN estate and produce a migration-readiness readout — workspace, dataset, metric, insight, and dashboard counts; a MAQL-complexity histogram (which metrics use BY / WITHIN / BY ALL / FOR time transforms); an insight visualization-type mix; and per- dashboard AUTO / HINT / MANUAL / UNHANDLED tags scored against the gooddata-to-sigma converter's actual coverage. Use when a user wants to scope a GoodData→Sigma migration, audit estate sprawl, or pick which dashboards to convert first. Read-only, all-free pre-scoping over the declarative workspace export. Also assesses the legacy GoodData Platform (classic /gdc, SST/TT auth) and sweeps EVERY project a user can access under one domain in a single run.

Take inventory of a Looker instance and produce a migration-readiness readout — model / explore / project / connection (dialect) / Look / dashboard (UDD vs LookML) / user / group / folder counts, per-dashboard complexity (vis-type mix, pivots, table calcs, merged results, custom viz, Liquid, filters), usage from Looker's System Activity model, and a value/cost-ranked migration shortlist. Use to scope a Looker→Sigma migration or audit BI sprawl. Looker REST API 4.0 driven (read-only); hands off to looker-to-sigma.

Take inventory of a MicroStrategy (Strategy One) environment and produce a migration-readiness readout — project/report/dossier counts, a visualization-type histogram (walking panel stacks recursively), datasource types, per-dossier complexity flags, and migrate-first / moderate / needs-review tags scored against the microstrategy-to-sigma converter's actual coverage. Use when a user wants to scope a MicroStrategy→Sigma migration, audit dossier sprawl, or pick which dossiers to convert first. Read-only, all-free pre-scoping.

Take inventory of a Power BI / Fabric tenant and produce a migration-readiness readout — environment counts, per-semantic-model DAX complexity (measures / calc columns / calc tables / RLS / DirectQuery / warehouse sources from M), per-report visual complexity, refresh history, a DAX-convertibility score against the Sigma coverage buckets, and a value/cost-ranked migration shortlist. Use when a user wants to scope a Power BI→Sigma migration, audit BI sprawl, or pick which reports to convert first. READ-ONLY — never writes to Power BI or posts to Sigma. Lightweight, device-code auth (no Entra app). Feeds the powerbi-to-sigma conversion skill.

Take inventory of a Qlik Cloud tenant and produce a migration-readiness readout — app/space/user counts, per-app complexity (master-measure expression convertibility, chart-type coverage, Set Analysis / Section Access flags, data model size), reload health, and a value/cost-ranked migration shortlist. Use to scope a Qlik→Sigma migration or audit BI sprawl. qlik-cli driven; hands off to qlik-to-sigma.

Take inventory of an Amazon QuickSight account and produce a migration-readiness readout — environment counts, per-analysis visual-type mix, calc-field complexity (mechanical / restructuring / window-table-calc buckets), parameter + FilterGroup + layout-shape signals, per-dataset source types / custom-sql / joins / RLS, and a value/cost-ranked migration shortlist. Use when a user wants to scope a QuickSight→Sigma migration, audit BI sprawl, or pick which analyses to convert first. READ-ONLY — never writes to QuickSight or posts to Sigma. AWS-CLI auth (no boto3). Enterprise edition required for full complexity. Feeds the quicksight-to-sigma conversion skill.

Scan Sigma workbooks for custom SQL elements, dedupe across workbooks, build or reuse Sigma data models, then repoint the workbooks via the v3alpha `:swapSources` endpoint. Use when you want to find ad-hoc SQL in workbooks and promote it to one reusable data model per unique query.

Take inventory of a Sisense estate and produce a migration-readiness readout — ElastiCube/Live model counts, dashboard counts, a widget-type histogram, JAQL complexity, dataset/connection mix, and per-dashboard AUTO / HINT / MANUAL / UNHANDLED tags scored against the sisense-to-sigma converter's actual coverage. Use when a user wants to scope a Sisense→Sigma migration, audit BI sprawl, or pick which dashboards to convert first. Read-only, all-free pre-scoping over the Sisense REST API.

Take inventory of a Tableau Cloud site and produce a migration-readiness readout — environment counts, licenses, datasource mix, refresh history, per-workbook usage, per-workbook complexity (via .twb gap-scan), and a value/cost-ranked migration shortlist. Use when a user wants to scope a Tableau→Sigma migration, audit BI sprawl, or pick which workbooks to convert first. Lightweight (~90s) MCP-driven pre-scoping; complements Hakkoda's deeper Assessment App rather than replacing it.

Take inventory of a ThoughtSpot instance and produce a migration-readiness readout — models/worksheets, Liveboards, Answers, tables, connections, per-object usage (views + distinct users from TS: BI Server), per-Liveboard chart-type mix and complexity, ownership concentration, Embrace-vs-Falcon data-source patterns, and a value/cost-ranked migration shortlist. Use to scope a ThoughtSpot→Sigma migration or audit BI sprawl. Read-only.

Author, retrieve, or modify a Sigma data model spec (the JSON/YAML semantic-layer definition with sources, columns, metrics, relationships, filters, controls, folder groupings, and column-level security) by calling the Sigma REST API directly. Use when the user wants to build a new data model from existing warehouse tables, add metrics or relationships to an existing model, change a model's source, edit columns, or round-trip a data model spec through code. **Out of scope: converting from another BI tool's format (dbt, LookML, Tableau, Power BI, Alteryx, etc.).** Those conversions are handled by the Sigma data-model converter (browser tool + MCP) — point users there when they paste source-format input. Requires an SIGMA_API_TOKEN — obtain via the sigma-api skill first.

Extract data from a published Tableau datasource via the VizQL Data Service (VDS) API and land it in a cloud data warehouse — Snowflake or Databricks — so Sigma can read it. Use when a user wants to pull a Tableau-managed dataset into the warehouse (one-shot or scheduled refresh) without exporting CSV by hand. Optionally schedule ongoing refresh (Snowflake Task / Databricks Workflow).

Land an Import-mode Power BI model's source data into Snowflake so a warehouse-native tool (Sigma) can query it. Use when a .pbix / semantic model is Import mode over Excel / Power Query / flat files (no live warehouse behind it) and a migration needs the data physically in a warehouse first. This is the DATA track that runs BEFORE powerbi-to-sigma converts the model logic. Not for DirectQuery models (those already point at a warehouse) and not a logic/DAX converter.