---
title: Snowflake
description: Learn how to connect Snowflake in Infoveave to query cloud data warehouse data for scalable analytics, dashboards, and reporting.
---

import { Aside, Steps } from '@astrojs/starlight/components';
import { MediaPlayerComponent } from "../../../../../components/video-player";
import RunScript from "../../../../../components/RunScript.astro";

# Snowflake

<MediaPlayerComponent
  video="snowflake.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 5,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 5,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 11,
    "text": "Select Snowflake Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'Snowflake' option."
  },
  {
    "start": 11,
    "end": 26,
    "text": "Configure Snowflake Details",
    "description": "In the 'New Snowflake Connection' dialog, enter the connection details. Type 'SnowflakeAutomation' for the Name, 'ibsmay-at22351' for the Server, 'suraj' for the Username, your password in the Password field, 'SNOWFLAKE_LEARNIND_DB' for the Database, and 'PUBLIC' for the Schema. Ensure the Port is set to '443'."
  },
  {
    "start": 26,
    "end": 30,
    "text": "Validate Snowflake Connection",
    "description": "Click the 'Validate' button to confirm that the provided Snowflake details and credentials are correct and that Infoveave can successfully connect."
  },
  {
    "start": 30,
    "end": 34,
    "text": "Save Snowflake Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'Postgres Infoveave' connection to your list of available connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Snowflake Connection"
  client:load
/>

Snowflake connection helps you connect to a **Snowflake database** and run queries directly from Infoveave.


## Adding a Snowflake Connection

To create a new Snowflake connection:
<Steps>
1. Go to the **Database** section.
2. Select **Snowflake** from the available connectors.
3. Fill in the required connection details in the **New Snowflake Connection** form.
</Steps>

## Connection Parameters

When setting up a Snowflake connection, you need to provide the following details:

| Field        | Description |
|--------------|-------------|
| **Name**     | A unique name to identify your connection. |
| **Port**     | Port number for Snowflake (default is `443`). |
| **Server**   | The Snowflake server endpoint. |
| **Username** | Your Snowflake database username. |
| **Password**   | The corresponding password for the username. |
| **Database**   | The Snowflake database you want to connect to. |
| **Schema**   | The schema inside the database to be used (optional). |





## Steps to Validate and Save
<Steps>
1. After filling in the details, click **Validate** to verify the connection.  
2. If validation succeeds, click **Save** to store the connection.  
3. You can now use Snowflake as a datasource in your Infoveave workspace.  
</Steps>


## Example Use Case

With a Snowflake connection configured, you can:

- Query and analyze data in Snowflake's cloud data platform.
- Leverage Snowflake's scalable compute and storage capabilities.
- Integrate Snowflake data into Infoboards for dashboards, reports, and insights.
- Perform complex analytical queries on large datasets with high performance.