This article guides you through the process of connecting Snowflake to Peaka, allowing you to seamlessly access your Snowflake data within the Peaka platform.

​
Prerequisites

Peaka provides two ways to connect to Snowflake:
  • Using Snowflake Password
  • Using Snowflake Private Key
Before you begin, ensure you have the following credentials from Snowflake:
  • Account
  • User
  • Password (for using Snowflake Password)
  • Private Key (for using Snowflake Private Key)
  • Private Key Passphrase (for using Snowflake Private Key)
  • Database Name
  • Role
  • Warehouse
  • Http Proxy
Follow the steps below to obtain it:
  1. To get the Account information, follow these steps:
    • Log in to your Snowflake account. If you are logging in for the first time, use the email you have received from Snowflake.
    • At the bottom left, click on your generated account name next to the Snowflake icon.
    • Copy the Account name shown and store them in a safe place.
  2. To get the User, follow these steps:
    • User fields are your Snowflake account’s login credentials.
  3. To get the Database Name information, follow these steps:
    • This is the name of your database before creation. If you haven’t created a database yet, you will need to do so.
  4. To get the Role information, follow these steps:
    • Navigate to Admin > Users & Roles in the left-hand menu.
    • Select the Roles tab, and your roles will be displayed. Copy the necessary role.
  5. To get the Warehouse information, follow these steps:
    • Navigate to Admin > Warehouses in the left-hand menu.
    • Your warehouses will be shown. Copy the required warehouse.
  6. To get the Http Proxy information, follow these steps:
    • If you need to set up an HTTP Proxy, refer to the following articles:

​
Authentication Methods

Choose one of the following authentication methods based on your security requirements:

​
Method 1: Private Key Authentication

  1. Private Key & Passphrase Setup:

​
Method 2: Password Authentication

  1. Password Setup:
    • Use your standard Snowflake account login password

​
Connecting Snowflake to Peaka

Now that you have your Snowflake Account, User,Password, Database Name, Role, Warehouse and Http Proxy, you can connect it to Peaka using the following steps:
  1. Navigate to the data model page in Peaka.
  2. In the side menu bar, click the “New Data Source” button to initiate the connection process.
  3. In the modal that appears, select “Snowflake” as your data source.
  4. Enter a name for your data source name and paste values that you before.
  1. Click “Connect” to create your Snowflake data source.
Congratulations! You’ve successfully connected Snowflake to Peaka. You can now access and manage your Snowflake data seamlessly within the Peaka platform.