Learn by building
Sigma QuickStarts
Maximize your investment in Sigma with easy-to-follow, step-by-step guides.
- 150
- 14
- 0
Just published
Recently added
The latest guides from the QuickStarts team.
Create a Sigma Assistant Usage Dashboard
Configure Sigma Assistant history logging into an isolated Snowflake schema, then use Sigma’s built-in admin dashboard to analyze user questions and usage patterns.
Audit Logging
Access Sigma’s audit log connection to explore user activity and build a chart tracking daily login successes and failures for troubleshooting and compliance.
Export Bursting
Configure Sigma’s export bursting to automatically split a scheduled report into personalized segments and deliver each one to the right recipient by email.
How to Get Started - A Guide for Sigma Administrators
Walks new Sigma administrators through a checklist of setup decisions: authentication, warehouse connections, AI configuration, branding, versioning, and training.
Materialization with Sigma
Configure materialization of a Sigma dataset into a Snowflake table to cut query times and reduce warehouse compute costs, then verify results after the first refresh.
Working with Metrics in Datasets
Create and apply Sigma Metrics in a dataset to define reusable, governed calculations like revenue and conversion rate that stay consistent across tables, charts, and pivot tables.
Sigma Tenants: Managing Isolated Organizations
Configure Sigma Tenants to create isolated child organizations under a parent org, using deployments and connection swap policies to isolate business units and their data sources.
Version Tagging with Sigma
Configure version tagging in Sigma to freeze workbook versions and control which versions are available to users, without external CI/CD tools.
Snowflake Object Usage Template Setup
Set up Sigma’s Snowflake Object Usage template to surface object- and column-level query activity across your Snowflake account.
Agents 01: Building Your First Sigma Agent
Agents 02: Agent-Driven Actions & Writeback
Agents 03: Giving Agents Memory
Agents 04: Scheduling Unattended Agent Runs
Agents 05: Build Web Search for a Sigma Agent
Connect a Sigma agent to Tavily’s web search API as a custom API connector, then attach it as a callable action so the agent can pull in live results and cite sources alongside governed data.
Agents 06: Connect a Sigma Agent to GitHub with MCP Tools
Connect a Sigma agent to GitHub’s hosted MCP server and use a chat element to ask natural-language questions about a live GitHub repository’s issues, pull requests, and files.
Agents 07: Running Python from an Agent
Agents 08: Give Your Sigma Agent a Snowflake Cortex Specialist
Build an AI app with Claude and the Sigma MCP server
Build a four-page store performance app on live warehouse data by describing it to Claude through the Sigma MCP server, from dashboards to a review queue with writeback and a Sigma agent.
Build Dashboards and Apps with Sigma Assistant
Use Sigma Assistant’s Plan and Build modes to build a revenue forecast workbook from a data model and a design image, then refine it through conversation.
Build Conversational AI Apps with Chat Elements and Snowflake Cortex
Build a conversational AI app in Sigma using a chat element, a Sigma agent, and a Snowflake Cortex Agent — with optional write-back actions to an input table.
Multi-Modal File Analysis with AI
Build an AI app that analyzes uploaded images, audio, video, and documents by pairing Sigma file uploads with Snowflake Cortex AI functions for vision, transcription, and document extraction.
Find and Interact with Sigma Workbooks in Claude Desktop
Run a small local MCP server so Claude Desktop can find a Sigma workbook by name and open it live and interactive in Claude’s browser pane.
Building Forms for Data Capture and Analysis
Build a customer return request form bound to an input table, with column-level validation and a live analysis view that updates as submissions arrive.
Unlocking Insights from Unstructured Text with a Sigma Agent
Learn how to use a Sigma agent to extract actionable insights from unstructured Gong call transcript data stored in Snowflake.
Natural Language Analytics with Claude and Sigma
Connect Claude to a Sigma organization through the Sigma MCP server to search workbooks, explore data model structure, and query live data using natural language.
Automate Inventory Alerts with Scheduled Actions
Learn how to automate a nightly inventory monitoring workflow using Sigma’s Scheduled Actions feature, including formula-based conditions, input table writes, and email notifications.
Scheduling Sigma Insights to Slack
Connect Claude to Sigma via the Sigma MCP server and to Slack via the claude.ai Slack connector, then use Claude Code to schedule a recurring daily Sigma data digest to Slack.
Build an Interactive Storefront with Repeaters and Actions
Build a retail storefront app using a Repeated container for product cards, popover and date range controls, a boolean-filtered notification center, and role-based storefront/manager views.
Cross Chart Actions
Build a Sigma workbook with linked charts where clicking a data point in one chart filters other elements on the page using cross-chart actions.
Adjustments - Change Log
Build an app with a Sigma input table that lets users edit values in place while automatically logging every adjustment with user, timestamp, and original value.
Approvals
Build an approvals workflow app where Adjusters propose retail revenue adjustments in a modal and Approvers review, reject, or approve them via an input table with persona switching.
Integrate 3rd Party REST API via Stored Procedure
Cleans a single business address row using a Snowflake stored procedure that calls the Geocodio API, triggered by a Sigma action, and writes the corrected result back to a table.
Crowdsource Ideas with a Sigma AI App
Build a crowdsourcing app in Sigma using input tables, user-aware controls, and modals so users can submit, view, and upvote ideas without writing code.
Discounted Cash Flow
Build a discounted cash flow financial model in Sigma using spreadsheet-style formulas and sample data, replacing a manual Excel-based DCF workflow with a live, warehouse-scale version.
Pivot Spreading
Use pivot table spreading to edit an aggregate value in a pivot table and automatically redistribute the change across underlying rows, such as budget or forecast line items.
Reconciliation
Trigger a Snowflake stored procedure from a Sigma app to snapshot live data and compare it against historical snapshots for reconciliation and audit tracking.
Snapshotting with Stored Procedures
Builds an inventory app where users edit stock quantities and snapshot changes via a Snowflake stored procedure to preserve original and revised values for historical comparison.
Build an AI prompt box with Cortex in Sigma
Build a natural language prompt box in Sigma that sends questions to Snowflake Cortex’s COMPLETE function with Claude to return narrative answers over workbook data.
AI Apps Fundamentals
Learn how to build a fully functional project tracking AI app in Sigma using input tables, modals, controls, actions, and approval workflows — without writing code.
Snowflake Cost per Query Template Setup
Deploy Sigma’s Snowflake Cost per Query template, creating a query_history_enriched table and swapping it in to break down query cost by workbook, user, role, and warehouse.
Budget Variance Analysis App Template
Explore Sigma’s Budget Variance Analysis App Template — a ready-to-use finance app for tracking actuals against budget, documenting variance commentary, building AI-assisted reforecast scenarios, and routing them through executive approval.
Demand Planning App Template
Explore Sigma’s Demand Planning App Template — a ready-to-use operations app for building demand forecasts by product and time period, resolving outliers, and publishing approved plans to downstream stakeholders.
Headcount Planning App Template
Explore Sigma’s Headcount Planning app template to model headcount scenarios against revenue targets, stage hires and backfills, and submit a plan with input tables and an AI advisor.
Marketing Analytics App Template
Explore the Marketing Analytics app template, covering campaign budget pacing, an AI-generated morning brief, customer segmentation, and AI-assisted A/B test analysis.
Pipeline Forecasting App Template
Explore and configure the Pipeline Forecasting app template, which uses input tables and an AI-generated summary to track Gut, Commit, and Best Case forecast calls against CRM data.
Project Management App Template
Explore Sigma’s Project Management App Template — a ready-to-use ops app for planning milestones, tracking execution, resolving blockers, and communicating project health across your portfolio.
Revenue Forecasting App Template
Explore Sigma’s Revenue Forecasting App Template — a ready-to-use finance app for building, managing, and comparing AI-assisted revenue forecast scenarios against live data.
Shift Management App Template
Explores Sigma’s Shift Management starter app (Clockwork), covering weekly schedule building, attendance tracking, clock in/out, and an AI-generated labor performance briefing.
Territory Management App Template
Explore and customize Sigma’s Territory Management app template, using AI-generated diagnostics and an editable input table to reassign sales accounts and rebalance regional workload.
Ticket Management App Template
Explore and adapt the Nexus ticket management App Template, covering requester, triage, and assignee views, AI-driven urgency scoring and resolution summaries, and the input-table data model.
API Actions - Getting Started
Build a Sigma workbook from scratch that uses API Actions to call the Open-Meteo Weather API, binding a city list control to fetch and parse real-time weather data as JSON.
Integrate JIRA using API Actions
Connect Sigma to JIRA Cloud using Basic Authentication and API Actions, query issues with JQL, parse JSON via a Python element, and update issue status from a workbook.
Integrate Salesforce using API Actions
Build a Sigma workbook that uses API actions with OAuth authentication and dynamic controls to query the Salesforce REST API and display live SOQL query results.
Integrate ServiceNow using API Actions
Build a bidirectional Sigma workbook that queries ServiceNow incidents via the Table API, filters them by state, and writes status updates back to ServiceNow using Basic Auth API actions.
Sigma REST API Recipes
Run JavaScript code samples covering Sigma’s most-used REST API operations, including member management, workspace permissions, workbook copying, and CSV export.
Data Models as Code
Use Sigma’s REST API to create and update data models from JSON specifications, enabling version control, code review, and CI/CD for data model deployments.
Layout Composer: Governed Self-Service Layouts with Workbook as Code
Extend Sigma with Plugins
Build and deploy a custom Sigma plugin using an open-source charting library to add a visualization type not natively available in Sigma.
QuickStarts API Toolkit
Sets up a local web portal that authenticates to the Sigma REST API, runs prebuilt request recipes, and displays responses to help learn common Sigma API workflows.
Sigma's Query Engine
Explains Sigma’s multi-tier caching and query evaluation architecture, which reduces Snowflake compute load while keeping the interface responsive as user count grows.
Automate Sigma from the Command Line with the Sigma CLI
Install and authenticate the Sigma CLI, then build a governance inventory script that exports members, connections, and workbooks to CSV and runs on a schedule via the REST API.
Sigma Skills for AI Assistants
Install Sigma’s open-source agent skills in Claude Code to authenticate against the Sigma REST API and create or update data models through natural-language prompts.
Manage Sigma Workbooks as Code with Git and CI/CD
Define a Sigma workbook as a single YAML file and manage it through Sigma’s REST API, enabling version control, code review, and CI/CD deployment alongside the rest of your application code.
Sigma API with Postman
How to use the Sigma API with Postman
Embedding 01: Getting Started
Build a local Node.js host application used to test Sigma embed URLs, establishing the environment used throughout the embedding QuickStart series.
Embedding 02: Federated Access
Configure federated user access for an embedded Sigma workbook using single sign-on and role assignment so host application users authenticate into Sigma with the correct permissions.
Embedding 03: Using JWT Claims and Embed Parameters
Configure signed JWT claims and embed URL parameters to authenticate embedded Sigma content, enforce row-level security, and pass custom user attributes.
Embedding 04: Isolation Solutions
Explore Sigma’s embedding isolation strategies, including workspace and team permissions, row-level and column-level security, and role-based feature controls.
Embedding 05: Under Construction
Placeholder page reserving the Embedding 05 slot in the series; no content yet, to be published in a future update.
Embedding 06: Creating a Premium Service
Explains how to design a tiered premium embedded-analytics offering in Sigma using account types like View, Analyze, and Build to gate features by license level.
Embedding 07: Dynamic Role Switching with Snowflake
Configure dynamic connection and role switching in a JWT-embedded Sigma workbook so the Snowflake warehouse and role swap at runtime based on user attributes, restricting data access.
Embedding 08: Embedding Sigma Assistant
Embed Sigma Assistant’s natural language query interface into an external application so users can ask questions about data and see the underlying analysis steps and sources.
Embedding 09: Events
Pass inbound and outbound events between a host application and an embedded Sigma iframe, using JavaScript or URL parameters and a listener for Sigma’s outbound messages.
Embedding 10: Version Tagging
Use Postman to simulate a CI/CD pipeline that promotes tagged Sigma workbook versions between development, staging, and production in an embedded environment.
Embedding 11: Responsive Embeds
Configure a Sigma embed and its host page so the iframe resizes responsively with page content, eliminating nested scroll bars across desktop and mobile screens.
Embedding 12: Parameterized Queries
Use parameterized queries with custom user attributes in an embedded Sigma workbook to route each customer’s SQL to their own database and schema.
Embedding 13: Link Sharing
Generate shareable URLs from an embedded Sigma workbook for a full workbook, an exploration, or a bookmark, including links delivered through scheduled exports.
Embedding 14: Connection Swapping
Implement Dynamic Connection Swapping in a Sigma embed using the eval_connection_id JWT claim to switch the underlying data connection at runtime without changing the workbook.
Embedding 15: Embed-SDK for React
Sets up a local React development environment, runs a sample application built with Sigma’s Embed SDK for React, and customizes the embedded workbook’s appearance and behavior.
Embedding 16: Public Access
Embed a Sigma workbook publicly without JWT authentication, using the base embed URL directly in an iframe for non-sensitive, no-login public-facing content.
Plugin Use Case 01: Dashboard Builder
Build a configurable embedded dashboard using Sigma’s plugin framework with a hosted Angular plugin and a JavaScript host app that saves KPI and layout selections via Sigma bookmarks.
REST API Usage 01: Getting Started
REST API Usage 02: Bookmarks
Extend an embedded Sigma workbook with bookmark functionality via the Sigma REST API, letting Build users save exploration states and View users reapply them from a host-app dropdown.
REST API Usage 03: Bookmark Sharing with a Local DB
Extend an embedded Sigma workbook with bookmark save, delete, and sharing controls backed by a local database and the Sigma REST API.
REST API Usage 04: Scheduling Exports
Extend an embedded Sigma workbook with a REST API-driven modal for scheduling, editing, deleting, and immediately triggering emailed workbook exports.
REST API Usage 05: Workbook Descriptions
Add custom, editable descriptions to embedded Sigma workbooks using a local lowdb database, since the Sigma REST API doesn’t natively store workbook description metadata.
REST API Usage 06: Copy or Create a New Workbook
Use Sigma’s REST API to create a new workbook or copy an existing one programmatically, handling naming conflicts, team workspace sharing, and UI feedback.
REST API Usage 07: Custom Loading Indicators
Implement a custom loading indicator for a Sigma embed that listens for the workbook:dataLoaded postMessage event to hide the indicator once data finishes loading.
REST API Usage 08: Filters
Uses the Sigma REST API to synchronize Store Region and Date Range filters between a host application and an embedded Sigma workbook in real time.
REST API Usage 09: Hide Menus & Page Nav
Use the Sigma Embedding API to hide a workbook’s built-in menus and programmatically navigate between pages from the host application.
REST API Usage 10: Set Default Workbook
Implement a per-user default workbook selector for embedded Sigma content using the Sigma REST API and browser local storage.
REST API Usage 11: Custom Workbook List
Build a thumbnail carousel for selecting embedded workbooks, using the List member files REST API endpoint to return only the workbooks a given user is permissioned to access.
REST API Usage 12: Call Sigma Agents from Your Application
Call a Sigma agent directly over the REST API — from a custom chat interface, a scheduled job, or another application — while inheriting the same governance and permissions configured in the workbook.
Use Case: Embed into Salesforce
Embed a static Sigma table and a dynamically filtered view into Salesforce using Lightning Web Components.
Use Case: Secure Embedding into Streamlit
Embed a Sigma workbook inside a Python Streamlit application, combining Streamlit’s app framework with Sigma’s live, warehouse-connected analytics interface.
Use Case: Embed into ServiceNow
Embed a Sigma workbook into a ServiceNow page using an iframe secured by a signed JWT that supplies the required authentication claims.
Use Case: Embed into Microsoft Sharepoint
Embed a Sigma workbook into Microsoft SharePoint Online using an Azure Function that mints JWTs and an SPFx web part that passes through the current user’s identity.
Use Case: Sigma with Databricks OAuth
Build a Node.js app that implements OAuth 2.0 with PKCE for Sigma embedding with Databricks, encrypting tokens and signing JWTs so each embedded user queries with their own permissions.
Common Date Functions
Builds date-handling formulas in Sigma, including weekday calculations, business-day counts, week-over-week and year-over-year comparisons, date-range filters, and a retail 4-5-4 calendar.
Getting Started with Period Over Period Analysis in Sigma
Build period-over-period comparison formulas in Sigma, such as year-over-year and month-to-date, to compare a key metric between two selected time periods.
Popular Functions
Apply commonly used Sigma functions, including categorization, null handling, text search, lookups, percentages, pattern parsing, hierarchy analysis, and conditional logic, to sample retail data.
Fundamentals 01: Overview
Navigate Sigma’s interface using sample retail data, learning core terminology, workbook structure, and how to create, save, and share a workbook, plus which QuickStart path fits your role.
Fundamentals 10: Data Modeling
Build a Sigma data model with table relationships, custom columns, metrics, column-level security, and materialization for reusable governed analytics.
Fundamentals 11: Pixel Perfect Reporting
Fundamentals 12: Build App-Style Layouts in Sigma
Build a card-based product catalog using a Repeater container for the gallery and a Single Row container in a modal for product detail.
Fundamentals 02: Data
Sort, filter, group, and build formula-based calculations, including cross-table lookups, on live warehouse data in a Sigma workbook without writing SQL.
Fundamentals 03: Pivot Tables
Build a pivot table on sample sales data, apply conditional formatting, and drill down into the underlying rows to explore results in more detail.
Fundamentals 04: Input
Get introduced to Sigma input tables and their key features to build a foundation for using write-back workflows in your own business data.
Fundamentals 05: Charts
Build and configure Sigma chart types, including bar, line, KPI, pie, and map charts, using sample sales data to visualize and analyze business metrics.
Fundamentals 06: Controls
Adds and configures Sigma control elements, including sliders, range sliders, date range, Top N, and switch controls, plus synced copies and referencing controls directly in formulas.
Fundamentals 07: Design Elements (UI & Layout)
Arrange elements built in earlier Fundamentals lessons onto a dashboard page and apply Sigma’s layout and design tools to produce a polished, visually organized dashboard.
Fundamentals 08: Administration
Tour Sigma’s administration area, covering instance management, connection setup, data governance rules, and user interaction configuration for admin-level accounts.
Fundamentals 09: Beyond the Basics
Address common post-fundamentals questions in Sigma, including joining multiple tables into one data model and identifying and resolving duplicate rows caused by messy join data.
Migrating From Cognos Made Easy
Use the cognos-to-sigma Claude Code skill to convert a Cognos Analytics report into a Sigma data model and workbook, then verify results with a parity check against the warehouse.
Migrating From Domo Made Easy
Use the domo-to-sigma Claude Code skill to rebuild a Domo dashboard as a Sigma data model and workbook from a screenshot and its warehouse table, then verify results with a parity check against the warehouse.
Migrating From Excel Made Easy
Use the excel-to-sigma Claude Code skill to migrate an Excel rolling forecast to a Sigma data model and workbook, keep the forecast inputs editable with input tables, and verify that Sigma’s totals tie to Excel’s.
Migrating From Hex Made Easy
Uses the hex-to-sigma Claude Code skill to convert an exported Hex project’s SQL cells and charts into a Sigma data model and workbook, then verifies numeric parity against the warehouse.
Migrating From Metabase Made Easy
Use the metabase-to-sigma Claude Code skill to convert a Metabase dashboard into a Sigma data model and workbook, then verify results with a parity check against the warehouse.
Migrating From MicroStrategy Made Easy
Use a Claude Code skill to convert a MicroStrategy dossier’s semantic model and dashboard layout into a Sigma data model and workbook, verified with a row-level parity check against the source.
Migrating From AWS QuickSight Made Easy
Use the quicksight-to-sigma Claude Code skill to convert an AWS QuickSight analysis into a Sigma data model and workbook, then verify results with a row-level parity check.
Migrating From Sisense Made Easy
Use the sisense-to-sigma Claude Code skill to convert a Sisense dashboard into a Sigma data model and workbook, then verify results with a parity check against the warehouse.
Migrating From Tableau Made Easy
Use the tableau-to-sigma Claude Code skill to convert a live Tableau dashboard into a Sigma workbook on the warehouse and verify the numbers match the Tableau source.
Migrating From ThoughtSpot Made Easy
Run the thoughtspot-to-sigma Claude Code skill to convert a ThoughtSpot worksheet and Liveboard into a Sigma data model and workbook, verified against the warehouse.
Migrating From Looker Made Easy
Use the Claude Code looker-to-sigma skill to convert a Looker dashboard and its LookML model into a Sigma data model and workbook, then verify parity against the live warehouse.
Migrating From Power BI Made Easy
Run the powerbi-to-sigma Claude Code skill to convert a Power BI report’s semantic model and layout into a Sigma data model and workbook, verifying data parity against the source warehouse.
Migrating From Qlik Made Easy
Use the Claude Code qlik-to-sigma skill to convert a Qlik Cloud app’s data model, measures, and Set Analysis expressions into a Sigma workbook with a warehouse parity check.
Getting Started with Sigma and MotherDuck
Getting Started with Sigma and Snowflake
Launch a Snowflake trial and a Sigma trial through Snowflake Partner Connect, then model, explore, and visualize sample data, building a Sigma workbook from a data model.
Google Analytics 4 Template Setup
Sets up Sigma’s Google Analytics 4 template on Snowflake, using the Google Analytics Raw Data connector and a provided SQL script to build a page- and event-level analytics workbook.
Sync Leads to Hubspot with Hightouch's Sigma Integration
Use a Sigma workbook and Hightouch’s reverse ETL integration to sync a defined list of loyal US customers from Snowflake into HubSpot as marketing contacts.
Unlock the Power of Your Data: Seamlessly Connect Sigma to Databricks via Partner Connect
Create a Sigma trial account through Databricks Partner Connect and connect it to an existing Databricks workspace to visualize its data.
Google BigQuery with Sigma
Connect Sigma to Google BigQuery with a service account, validate the connection, and build a workbook querying live BigQuery data for tables, pivots, and visualizations.
Getting Started with the Sigma Health Check Native App for Snowflake
Install and connect the Sigma Health Check Native App for Snowflake to review account architecture, user and role grants, and warehouse performance and sizing recommendations.
Snowpark UDF's with Python and Sigma
Create a Python user-defined function with Snowflake Snowpark and call it directly from a Sigma workbook, covering the basic developer workflow for building Snowpark UDFs.
Azure Private Link
Configure Azure Private Link to connect Sigma to a Snowflake, Databricks, or PostgreSQL warehouse over Azure’s internal network without traversing the public internet.
Single Sign-On with Sigma and Okta
Configure SAML single sign-on between Sigma and Okta, covering user provisioning, deprovisioning, group management, and access policies.
Implementing Column Level Security (CLS)
Use a Sigma data model’s Column Security setting to restrict specific columns, such as customer name, to selected users or teams.
Managing Secrets in Sigma with AWS
Connect Sigma to AWS Secrets Manager via a cross-account trust handshake, then add a secret and attach it to a Snowflake key pair connection instead of typing credentials directly.
Managing Secrets in Sigma with HashiCorp
Connect Sigma to a self-hosted HashiCorp Vault instance using the Self-Signed JWT trust handshake, then add secrets and attach them to a Snowflake key pair connection.
OAuth 2.0 & PKCE for Secure Data Integration
Explains OAuth 2.0 with PKCE as a secure authentication pattern for embedding Sigma and connecting to data warehouses, covering the authorization flow at a conceptual level.
Open Authorization (OAuth)
Configure OAuth between Sigma, Snowflake, and Okta across four scenarios - basic setup, Snowflake integration, Okta auto-provisioning, and writeback - eliminating shared credentials.
Implementing Row-Level Security (RLS)
Implement row-level security in a Sigma data model using CurrentUserEmail, CurrentUserTeam, user attributes, or a custom SQL WHERE clause to restrict which rows each user can see.
Snowflake Key-pair Authorization
Configure a Snowflake connection in Sigma to use RSA key pair authentication instead of a password, then rotate the key pair periodically to maintain security.
Sigma Input Tables: Use Cases
Examples of using Sigma Use Cases
Resolving The Fan Trap with Sigma and Snowflake UDF
Diagnose a fan trap caused by chained one-to-many table relationships and resolve the resulting overcounted values using a Sigma data model paired with a Snowflake user-defined function.
Getting Started with Sigma Tables
Parsing JSON Data in Seconds
Parse JSON-formatted columns directly inside Sigma tables to extract values, iterate arrays, and read key-value pairs without ETL tooling.
Reshaping Data with Transpose Tables
Learn how to use Sigma’s Transpose table to reshape data in two directions — converting rows into columns for side-by-side category comparisons, and converting wide columns into rows for long-format analysis.
Retail & CPG 1: Retention Analysis
Retail & CPG 1: Retention Analysis
Retail & CPG 2: Cohort Analysis
Retail & CPG 2: Cohort Analysis