From sigma-dashboard
Use this skill when the user asks about Sigma Computing dashboards, wants to extract SQL from Sigma workbooks, list Sigma dashboards, or inspect what tables/columns a Sigma dashboard uses. Also triggers on /sigma.
How this skill is triggered — by the user, by Claude, or both
Slash command
/sigma-dashboard:sigma-dashboardThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Interact with Sigma Computing dashboards via the Sigma REST API v2. Extracts compiled SQL from
Interact with Sigma Computing dashboards via the Sigma REST API v2. Extracts compiled SQL from workbook elements and lists workbooks.
The Sigma integration code is bundled with this skill at {SKILL_DIR}/sigma-integration/.
Set SIGMA_DIR to that path and verify the environment:
.env exists in SIGMA_DIR (contains API credentials).httpx and python-dotenv are importable.If .env is missing:
.env.example template from SIGMA_DIR/.env.examplehttps://aws-api.sigmacomputing.com (AWS US region)If dependencies are missing, run:
cd SIGMA_DIR && python3 -m pip install httpx python-dotenv sqlglot
cd SIGMA_DIR && python3 extract_queries.py --list-only
Shows all workbooks the API client can access, with tags.
To list only Production-tagged workbooks:
cd SIGMA_DIR && python3 extract_queries.py --list-only --production-only
Extract all workbooks:
cd SIGMA_DIR && python3 extract_queries.py
Extract a specific workbook by name (case-insensitive substring match):
cd SIGMA_DIR && python3 extract_queries.py --workbook-name "State of the Business"
Extract by workbook ID:
cd SIGMA_DIR && python3 extract_queries.py --workbook-id <id>
Extract only Production-tagged workbooks:
cd SIGMA_DIR && python3 extract_queries.py --production-only
Output goes to SIGMA_DIR/output/<workbook-name>/ with:
.sql file per element (organized by page)manifest.json with element metadataAfter extraction, read the SQL files directly:
ls SIGMA_DIR/output/<workbook-name>/
Then read individual .sql files to see the compiled Snowflake SQL for each element.
For custom queries not covered by the CLI scripts, use sigma_client.py in a Python session:
import sys
sys.path.insert(0, "SIGMA_DIR")
from sigma_client import SigmaClient
with SigmaClient() as client:
# List all workbooks
workbooks = client.list_workbooks()
# Get a specific workbook
wb = client.get_workbook("workbook-id")
# List pages in a workbook
pages = client.list_pages("workbook-id")
# List elements on a page
elements = client.list_elements("workbook-id", "page-id")
# Get compiled SQL for an element
query = client.get_element_query("workbook-id", "element-id")
print(query["sql"])
# Get column metadata for an element
columns = client.get_element_columns("workbook-id", "element-id")
# List all members
members = client.list_members()
# List all tags
tags = client.list_tags()
https://aws-api.sigmacomputing.com)SIGMA_DIR/output/ — gitignored, safe to delete and re-extract.| Error | Fix |
|---|---|
SIGMA_CLIENT_ID not set | Create .env from .env.example with valid credentials |
| 401 Unauthorized | Credentials may be revoked — get new ones from Sigma admin |
| 403 Forbidden | API client may lack permissions — ask admin to check scope |
| Workbook not found | Use --list-only to verify the workbook name/ID |
| Empty SQL for elements | Text, image, and container elements have no SQL — this is expected |
npx claudepluginhub winsthuang/hazel-skills --plugin sigma-dashboardAutomates Looker dashboard creation: add elements, filters, and configure queries. Useful for data discovery and BI workflows.
Creates, updates, deploys Databricks AI/BI (Lakeview) dashboards with mandatory SQL query testing via execute_sql before deployment.
Create, update, and manage Omni Analytics documents and dashboards programmatically via the Omni CLI — drafts, tiles, visualizations, filters, controls, and layouts.