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.

Step 1

Navigate to Settings→ integrations → User Level Connectors from the left navigation panel.

Snowflake-Integration

Step 2

On the Integrations page, click on the Manage button of the Snowflake connector.

Snowflake

Step 3

Now click on the Connect to Snowflake button.

Snowflake connect

Step 4

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.

Snowflake api

Step 5

Now the Profit.co account is successfully integrated with the Snowflake account.

snowflake manage

Step 6

Now click on Create Key result → Using form.

Snowflake form

Step 7

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.

Snowflake choose

Step 8

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.

Snowflake add

Step 9

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.

Snowflakefrom kpi

Step 10

After creating the key result if you update the key result you’ll get an updated preview of the value before check-in.

Snowflake check-in