Why teams choose Sigma vs Pigment
Plan where your data lives
Budgets, forecasts, and assumptions write to your warehouse, next to the actuals they depend on.
Live actuals, no imports
Plans read live from Snowflake, Databricks, BigQuery, and Redshift, so there is no import to schedule.
Down to the transaction
Drill from a plan line to the rows behind it, on billions of rows of warehouse data.
The spreadsheet finance knows
More than 200 functions and Excel-style pivots, with SQL and Python when a model needs them.
Workflows and agents built in
Actions route inputs, update rows, and call APIs. Sigma Agents can ask for approval before they write.
One platform beyond planning
The same governed data powers reporting, data apps, and embedded analytics across the company.
Planning, analytics, and AI apps on one governed platform
Plans that write to your warehouse
Enter budgets, forecasts, and assumptions in Input Tables. Each change lands in a governed schema in your warehouse, with an audit history of who changed what and when.
Actuals and plan on the same live data
Sigma queries your warehouse directly, so budget versus actual always uses current numbers. Drill from a variance to the transactions behind it without exporting a file.
What-ifs with the controls you choose
Feed drivers into formulas with controls, keep scenario assumptions in Input Tables, and save a version tag when a plan is final. Start from App Library templates for budget variance, headcount, and expense forecasting.
Route, approve, and automate on live data
Actions insert and update rows, call stored procedures and APIs, and hand work to Sigma Agents. Set an agent to require approval before it writes, so sign-off stays with the plan owner.
Plan in your warehouse with the spreadsheet finance knows
FEATURE COMPARISON
As of November 9, 2026
Sigma
Pigment
Where plan data lives
In your warehouse. Input Tables write to a governed schema next to your actuals.
In Pigment's own storage on Google Cloud, in a Frankfurt or Oregon region.
Warehouse connection
Live queries on Snowflake, Databricks, BigQuery, Redshift, and more. No extracts.
Connectors run a query and import the result into Pigment, with up to four schedules per import.
Plans back to the warehouse
Already there. Every input is a warehouse table your team can query through a view.
Exported through the API to S3, Google Cloud Storage, or Azure, then loaded into the warehouse.
Transaction detail
Drill from a plan line to row-level transactions on billions of rows.
Analysis covers the data imported into Pigment Blocks.
Scenarios and versions
Controls drive what-if values, Input Tables hold assumptions, and version tags save final plans.
Built-in Scenarios and Versions for budgets, forecasts, and reforecasts.
Formulas
More than 200 spreadsheet functions and Excel-style pivots, plus SQL and Python in the warehouse.
Pigment's own Block-based formula language, with modifiers such as BY, ADD, and FILTER.
Workflow
Actions insert, update, and delete rows, call APIs and stored procedures, and run Sigma Agents.
Workflows chain up to 10 tasks and notifications with To do, On hold, and Done statuses.
Analytics on all your data
Dashboards, pivots, and drill down on any warehouse data, plus embedded analytics for customers.
Boards and Views report on data imported into Pigment.
AI
Sigma Assistant and Sigma Agents work on live warehouse data, with optional approval before an agent writes.
Modeler and Analyst agents, with usage drawn from annual AI credits.
Security
Enforces warehouse row- and column-level policies at query time. SAML SSO, SCIM, SOC 2 Type II, ISO 27001.
Roles and Access Rights Metrics. SAML SSO, SCIM, SOC 2 Type 2, ISO 27001.
Getting started
Start from App Library planning templates on data already in your warehouse.
Imports, connections, and modeler training. Pigment reports that over 70% of 2023 new customers worked with a partner.
Beyond planning
The same platform runs BI, data apps, embedded analytics, and agents.
Built for business planning and enterprise performance management.
Sigma
Pigment
Where plan data lives
In your warehouse. Input Tables write to a governed schema next to your actuals.
In Pigment's own storage on Google Cloud, in a Frankfurt or Oregon region.
Warehouse connection
Live queries on Snowflake, Databricks, BigQuery, Redshift, and more. No extracts.
Connectors run a query and import the result into Pigment, with up to four schedules per import.
Plans back to the warehouse
Already there. Every input is a warehouse table your team can query through a view.
Exported through the API to S3, Google Cloud Storage, or Azure, then loaded into the warehouse.
Transaction detail
Drill from a plan line to row-level transactions on billions of rows.
Analysis covers the data imported into Pigment Blocks.
Scenarios and versions
Controls drive what-if values, Input Tables hold assumptions, and version tags save final plans.
Built-in Scenarios and Versions for budgets, forecasts, and reforecasts.
Formulas
More than 200 spreadsheet functions and Excel-style pivots, plus SQL and Python in the warehouse.
Pigment's own Block-based formula language, with modifiers such as BY, ADD, and FILTER.
Workflow
Actions insert, update, and delete rows, call APIs and stored procedures, and run Sigma Agents.
Workflows chain up to 10 tasks and notifications with To do, On hold, and Done statuses.
Analytics on all your data
Dashboards, pivots, and drill down on any warehouse data, plus embedded analytics for customers.
Boards and Views report on data imported into Pigment.
AI
Sigma Assistant and Sigma Agents work on live warehouse data, with optional approval before an agent writes.
Modeler and Analyst agents, with usage drawn from annual AI credits.
Security
Enforces warehouse row- and column-level policies at query time. SAML SSO, SCIM, SOC 2 Type II, ISO 27001.
Roles and Access Rights Metrics. SAML SSO, SCIM, SOC 2 Type 2, ISO 27001.
Getting started
Start from App Library planning templates on data already in your warehouse.
Imports, connections, and modeler training. Pigment reports that over 70% of 2023 new customers worked with a partner.
Beyond planning
The same platform runs BI, data apps, embedded analytics, and agents.
Built for business planning and enterprise performance management.
Trusted by 2,000+ leading enterprises around the world
The 2025 Gartner® Magic Quadrant™ for Analytics & Business Intelligence
Read about Sigma's first-time recognition in this report.
Don't take it from us, take it from our customers
“Writeback changes the game. It lets us incorporate user inputs directly into our workflows, without spinning up a separate system.”
Albert Obeng
Head of Technology for Private Alternatives, AB CarVal
Top teams choose Sigma.
See for yourself. Sigma is a G2 crowd favorite, backed by countless reviews.
Additional resources
Automate 50% of finance: a guide for the office of the CFO
Learn why 50% finance automation is reachable now and how Sigma and Databricks give your team one governed place to start. Get the guide.
Automate the Manual Work of FP&A with AI and Sigma
Automate manual FP&A work with AI, governed data, and workflows to streamline reporting, analysis, and recurring finance processes.
Revenue forecasting
Spin up a revenue forecast scenario in minutes, adjust the inputs with AI guidance, and watch the impact update live, instead of waiting on a consultant or another spreadsheet.
Ready to see the difference?
Join thousands of data teams who have transformed how they work with Sigma.