Data

Snowflake

Cloud data warehouse for storing, querying, and sharing large-scale structured and semi-structured datasets.

Roiva writes these metric observations on each sync. Reference the key in a value formula to use this data in your ROI calculations.

Compute Credits

snowflake.compute.credits_used Credits Used count

Query Statistics

snowflake.query.count Query Count count

snowflake.query.avg_execution_seconds Avg Execution Time (seconds) duration

Pull custom business metrics directly from your data warehouse for any initiative
Track ML model output quality or prediction accuracy over time
Measure data pipeline efficiency improvements from AI automation
Use processed event data as the source of truth for initiative outcomes

In Snowflake: Create a dedicated service account with SELECT access on the relevant schemas
In Snowflake: Generate an API key or use a username/password credential pair
Back in Roiva: Paste the credentials here and save the connection
Back in Roiva: After connecting, use Filters on your initiative link to pass the database, schema, and table context

Snowflake is the most flexible data source — any metric you can compute in SQL can become an observation
Use the Filters field to pass query scoping parameters (e.g. project_id, date_range) to your sync

Related integrations