Profi.co enables you to integrate and connect your snowflake account and create key results via the database server of snowflake.
You can now integrate Snowflake with your Profit.co account and can create key results using password and username. This enables users to integrate the server with the new SQL database to get up-to-date information on your check-ins without the hassle of switching between the two platforms.
Navigate to Settings→ integrations → User Level Connectors from the left navigation panel.
On the Integrations page, click on the Manage button of the Snowflake connector.
Now click on the Connect to Snowflake button.
In the connect to Snowflake page, provide information for Connection Name, under server copy and paste the account name of your Snowflake account.
Give your Username & Password the same as that of your Snowflake login username and password.
Now the Profit.co account is successfully integrated with the Snowflake account.
Now click on Create Key result → Using form.
Now create the key results, here Increase KPI is selected. For example, set the KPI as the Total Sale Amount.
Enable the Auto Update toggle, choose connections and Tableau, and give a value.
Provide information for the following section SQL Query. After entering the value click Run. After that, you’ll be getting the current value present in the database.
Finally, click the Add button.
Once you click on the Run button, the current value will be updated automatically in the “From” field and you can click the Create button of the key Result.
After creating the key result if you update the key result you’ll get an updated preview of the value before check-in.