ℹ️ Available on Supreme.
The Snowflake integration automatically updates your goals based on a data field in Snowflake.
Enabling the Snowflake integration
ℹ️ This requires Superadmin rights.
To enable the Snowflake integration:
Click Enable.
In the modal, add:
Subdomain
Account Identifier
User Name
Private Key
Fingerprint
Click Connect.
After it's enabled, you can choose to keep the integration private or shared with everyone else under 'Settings'.
How to integrate a KPI, Key Result, or Initiative with Snowflake
When creating a KPI or Result, click on Advanced Options. If the goal already exists, you can edit from the details modal in the right side panel.
Select Snowflake under Progress driver > Integration.
Select Connection.
Select Warehouse.
Select Database.
Select Schema.
Enter your SQL Query.
Review Preview.
Click Save & Sync now.
How to write an SQL Query
An SQL Query is a command you write to interact with a database using SQL (Structured Query Language). It tells the database what you want to retrieve, insert, update, or delete. Learn more on how to write an SQL Query.
Important notes
Perdoo will check once a day for any changes — between 12-1AM CET — and will update in Perdoo if there was a change in the value.
If you'd like to update the goal at anytime, you can click "Update progress" and the latest value will be fetched, or open the integration and click "Save & Sync now".
Need help?
Contact our friendly Support team via the in-app chat at the bottom-right of your screen, or email support@perdoo.com.