ℹ️ Available on Supreme.
Connect Snowflake to Perdoo to update your goals straight from your data warehouse. Write a SQL query that returns a value, and Perdoo uses it to update a KPI, Key Result, or Initiative.
Once connected, Perdoo updates the goal for you as often as its sync frequency says. For more about progress drivers, see Progress drivers.
Connect Snowflake
Find Snowflake and click Enable (1).
Enter your Subdomain, Account Identifier, User Name, Private Key, and Fingerprint.
Click Connect.
Superadmins can also connect Snowflake in Configure > Integrations. After you connect it, click Settings to choose whether your connection is private or shared with everyone.
Update a goal with Snowflake
Open the KPI, Key Result, or Initiative. To set it up while you add a goal, open Advanced options.
In the Details panel, click Progress driver.
Select Integration and choose Snowflake.
Select your Connection, Warehouse, Database, and Schema.
Enter a SQL query that returns the value you want to track. To learn how, see Snowflake's SELECT reference.
Check the preview.
Click Save & Sync now.
Good to know
How often does Perdoo fetch the latest value?
As often as the goal's sync frequency says, for example daily or weekly. Every sync adds a progress update, even if the value hasn't changed. To update sooner, click Update on the goal.
What happens if the connection stops working?
You get an email, and the goal shows a red connection error. Reconnect Snowflake in Personal settings > Integrations.
Can others update a goal that uses my private connection?
Yes. Anyone who can update the goal can fetch the latest value, but only you can change the connection's settings.
Need help?
Start a live chat with our Support team by clicking on the ? at the bottom left or bottom right of your screen.