skills.rest
sigmacomputing
sigmacomputingOFFICIAL
Explore all skills by this author →
WebsiteGitHub

hex-to-sigma

Convert Hex .hex.yaml exports into Sigma data models and workbooks.

6|7|Updated Dec 14, 2023
Search Tags:#migration#dashboard#sql#hex#data-modeling#sigma
One-click install
npx skills add https://github.com/sigmacomputing/quickstarts-public --skill hex-to-sigma
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hex-to-sigma
Source: https://github.com/sigmacomputing/quickstarts-public/tree/main/hex-migration-skills/hex-to-sigma
Command: npx skills add https://github.com/sigmacomputing/quickstarts-public --skill hex-to-sigma

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyyaml, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill automates the complex migration of Hex projects, including SQL cells, metrics, and charts, into Sigma data models and workbooks, eliminating manual reconstruction.

Core Features & Use Cases

  • Automated Conversion: Translates Hex SQL cells, KPI metrics, and EXPLORE charts into native Sigma elements.
  • Layout Preservation: Maps Hex app layouts to Sigma grid-based dashboard structures.
  • Parity Verification: Includes hard gates for numeric parity and compiled-SQL checks to ensure the migrated workbook matches the original logic.

Quick Start

Run the hex-to-sigma skill by providing the path to your exported .hex.yaml file and your Sigma connection ID to generate the data model and workbook.

Frequently Asked Questions about hex-to-sigma

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate Hex projects to Sigma workbooks?▼

You migrate Hex projects to Sigma workbooks by parsing exported .hex.yaml files to automatically convert SQL cells, KPI metrics, and EXPLORE charts into native Sigma data models and interactive grid-based dashboard layouts.

What do I need to convert a Hex project to a Sigma data model?▼

Converting a Hex project to a Sigma data model requires Python 3.10+ with PyYAML installed, Ruby for post-migration layout linting, your exported .hex.yaml file, and a valid Sigma connection ID.

How does the Hex to Sigma migration handle SQL and visualization layouts?▼

The migration handles SQL and visualization layouts by translating Hex SQL cells and EXPLORE charts into native Sigma elements while mapping Hex app layouts to Sigma grid-based dashboard structures to preserve visual parity.

Can I verify data parity after converting Hex SQL cells to Sigma?▼

You can verify data parity after converting Hex SQL cells to Sigma using built-in hard gates that perform numeric parity checks and compiled-SQL validation to ensure the migrated workbook matches the original Hex logic.

Does the Hex to Sigma migration require manual dashboard reconstruction?▼

The Hex to Sigma migration eliminates manual dashboard reconstruction by automating the conversion of Hex app layouts into Sigma grid-based dashboard structures and automatically translating KPI metrics and charts.

Related Skills

Explore More Data & Analytics Skills→
swaruplabswaruplab
94

pymatgen

Analyze materials structures and data using pymatgen APIs.

Community
Advanced
sigmacomputingsigmacomputing
6

thoughtspot-to-sigma

Migrate ThoughtSpot models and Liveboards into Sigma data models and workbooks.

Official
Advanced
sigmacomputingsigmacomputing
6

cognos-to-sigma

Migrate IBM Cognos Analytics content into Sigma Computing data models and workbooks.

Official
Advanced
sigmacomputingsigmacomputing
6

qlik-to-sigma

Convert Qlik Sense and Qlik Cloud applications into Sigma data models and workbooks.

Official
Advanced