# Snowflake

Snowflake is a cloud-based data warehousing platform that enables organizations to store, analyze, and share large volumes of data. It offers scalability, ease of use, and advanced analytics features. Built on cloud infrastructure, it supports various data types and integrates seamlessly with other cloud services, making data management more efficient.

### What you can do with the Snowflake connector:

* **Ingest contact data:** Ingest contact data and its properties from Snowflake into Bird to segment and activate campaigns and other updates to your customers on popular channels such as [Email](/applications/channels/channels/supported-channels/email.md), [SMS](/applications/channels/channels/supported-channels/sms.md), and [WhatsApp](/applications/channels/channels/supported-channels/whatsapp.md).

### Install the Snowflake integration in Bird.

1. Navigate to **Manage Integrations** and search for the Snowflake connector.

<figure><img src="/files/b3Jhj3oCyV49chCkdT7D" alt="" width="375"><figcaption></figcaption></figure>

2. Enter Name, Host, Role, Warehouse, Database, Schema, Table, Username, Password and click **Install**.

<figure><img src="/files/v3VuAyw6bKt446YFZNu3" alt="" width="375"><figcaption></figcaption></figure>

3. Once installed, navigate to the dataflows section under the Process Automation section of the product and create a new dataflow.

<figure><img src="/files/sJNLzpjWLw4XriXVypsK" alt="" width="375"><figcaption></figcaption></figure>

4. Give a name, select Source = Snowflake installed in #2 and Destination = Workspace contacts, click Create, **and continue**.

<figure><img src="/files/dn1DE28EpwaV8JPlZSyo" alt="" width="375"><figcaption></figcaption></figure>

5. Next, under transformation, go to Attribute mapping, select **Add mapping**, and pick and choose the source attributes from Snowflake that must be ingested along with the mapping to destination attribute in Bird.

<figure><img src="/files/X6M59QbsoqwwJrRXEo8q" alt="" width="375"><figcaption></figcaption></figure>

6. After completing the attribute mapping, proceed to the next step by clicking **Continue to destination** and map the identifiers like email address and phone number coming from Snowflake into Bird contact identifiers.

<figure><img src="/files/0DPJLWcohe8dSRRDBAzx" alt="" width="375"><figcaption></figcaption></figure>

7. Once the identifiers are mapped, click on **Save data flow**, and then you can now change the schedule or view the configuration of the dataflow.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXf89oIfz73qdu9bIOKrC8mYJ3w6o7M2g5UjEwuA7vexKjW1k_3sdXw9i3oOmeOxvr44YTf5wSMcRyk01oocx-cRE2sbFhqzXRFvmNHBOIV4hJ_BEHju5TKXy80MHTEcEz3q50HVII8iOXu88VwkHdc0i9k?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

8. You can modify the schedule by clicking on **Change schedule**, and it can be configured to run every few hours or minutes by entering the value in the following format. For example, for every 12hrs, you have to input @every 12h and for every 30mins, please input @every 30m.
9. Now, you can go ahead and enable the dataflow to start ingesting the contact data from Snowflake into Bird as contacts.

### FAQs

#### I don’t see the Manage Integrations option. What am I missing?

Please verify your Access role under 'Organization Settings'. If it's not present there, contact your admin for assistance.

#### **As a Snowflake admin with multiple Tables, can I connect each one to Bird?**

Absolutely! Install the Bird connector for each table as required. After installation, view all the tables under 'Your Connectors'. Remember, each installation is unique to one table, so you must install it for each table individually.

#### **What should I do if my Data sync displays a "Failed" status?**

Please contact our support team for assistance.

#### **Is it possible to restore a deleted connector?**

No, once you delete a connector, it's irreversible. However, you can always create a new connector to replace the one you deleted.

#### **What should I do if I notice errors in the Health status of my connector?**

It is crucial to address any errors promptly. If you can't resolve the connector errors, our dedicated support team is here to help.

#### **What happens with my audiences if my connector becomes defunct or is deleted?**

Your audience will still function but won't receive new updates.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bird.com/applications/integrations/integrations/supported-integrations/snowflake.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.