All Integrations
Snowflake
x

Connect Snowflake to Pigment and plan from warehouse data

Bring the actuals your data team already consolidates in Snowflake into Pigment, and export plan data back to the warehouse through Pigment’s API. FP&A teams load the data they need without manual file exports. IT sets up the connection once and controls which data and Applications it can reach.

Snowflake

Snowflake

Bring Snowflake warehouse data into Pigment for planning, and export plans from Pigment back to Snowflake

Category

Data Warehouses & Lakehouses

Integration method

Native Connector
API

Best for

Financial planning · Variance analysis · Data governance

See documentation

What can you do with Snowflake and Pigment?

  • Load this month's actuals before variance review. An FP&A analyst imports the latest Snowflake transactions into a Transaction list and compares them with plan.
  • Model drivers from data across the business. Pull operational figures consolidated in Snowflake into Metrics, then use them as forecast drivers.
  • Answer ad hoc questions with current data. When leadership asks about a segment, pull that slice from Snowflake into Pigment without waiting on a new extract.
  • Send approved plans back to the warehouse. Export budget or forecast Views so your data team can load them into Snowflake next to actuals.

How the Snowflake integration works

A Workspace Admin creates the connection once in the Integrations library and shares it with the Applications that need it. Users then choose Integration instead of Upload file in Import Data, enter a query, and Pigment loads the result into a List, Metric, or Table.

Sending data the other way uses the Pigment REST API. You export Views, Lists, Metrics, or Tables to Amazon S3, Google Cloud Storage, or Microsoft Azure, then load them into Snowflake. This requires an export API key, which only a Workspace Admin or Security Admin can manage.

Key capabilities

  • Bring in exactly the data you need. Pigment retrieves any query result into a Block, so you decide what level of detail reaches your model.
  • Set up once, share across Applications. Admins create one connection in the Integrations library, then use Application Access to choose which Applications can import.
  • Control which identity Pigment uses. Pigment authenticates as one Snowflake user through key-pair authentication and runs on that user's Default Role and Default Warehouse.
  • Limit what queries can do. Users write their own queries, so we recommend a read-only role without ALTER, CREATE, INSERT, or DROP privileges.
  • Export to cloud storage you control. Pigment exports Views and Blocks to Amazon S3, Google Cloud Storage, or Microsoft Azure, and your team loads them into Snowflake from there.
  • Reserve export rights for admins. Only Workspace Admins or Security Admins manage export API keys, so IT decides who moves data out of Pigment.

Frequently Asked Questions

How is the Snowflake connection authenticated?

Pigment uses Snowflake key-pair authentication. You associate a public key with a Snowflake user and give Pigment the unencrypted private key. We recommend a dedicated user for this connection.

What Snowflake data can I import into Pigment?

You can import any query result into a Pigment Block, such as a List, Metric, or Table.

Can I send Pigment data back to Snowflake?

Yes, through the Pigment REST API rather than the import connection. You export Views, Lists, Metrics, or Tables to Amazon S3, Google Cloud Storage, or Microsoft Azure, then load the data into Snowflake from there. Exports require an export API key, which only a Security Admin or Workspace Admin can manage.

Can FP&A pull warehouse data without waiting on the data team each cycle?

Yes. Once a Workspace Admin shares the connection with an Application, its users run their own imports by entering a query. Finance plans from the same figures the data team maintains in Snowflake, without keeping separate spreadsheet copies.

See Pigment in action

The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

Three colleagues focused on an iMac screen in a bright office with plants and modern artwork.

From 8 days to 4 min

Update P&L actuals & financial forecasting

80%

Time cut on data aggregation

12 hours

Saved per month on executive reporting

6 days faster

For scenarios creation and analysis