How to use Windsor.ai native connectors for Snowflake

Windsor.ai native connectors for Snowflake enable automated integration between your data sources and Snowflake’s cloud data platform, allowing you to centralize, analyze, and act on your business data in the warehouse with ease. 

Designed for high performance, scalability, and simplicity, our no-code connectors automate data ingestion from 325+ apps directly into Snowflake without the need for complex ETL processes and custom scripts.

Built to complement Snowflake’s Data Cloud, Windsor.ai connectors empower teams to leverage Snowflake’s advanced analytics and storage capabilities while maintaining flexibility and control over their data pipelines.

• Unified data access: Aggregate data from diverse sources, including marketing platforms, CRMs, ad networks, and analytics tools, into Snowflake for a single source of truth.
• Automated data pipelines: Schedule and automate data synchronization in less than 5 minutes to keep your Snowflake datasets always up-to-date, removing manual effort and operational overhead.
• Enhanced data sharing: With Windsor.ai connectors, different departments can link multiple data sources to Snowflake using relational database logic, ensuring simultaneous access to the latest information.
• Automated data mapping: Windsor applies normalization and transformation rules under the hood and matches schemas between sources and Snowflake, ensuring you work with consistent and accurate data.

Ready to experience these benefits using Windsor.ai native connectors for Snowflake? Follow the steps below to build your first integration.

1. Create a Windsor.ai account and log in.

2. Select the data source from which you want to stream data, e.g., Facebook Ads. Grant Facebook Ads access, select the account(s), and click Next.

3. You’ll see your Facebook Ads data displayed in your Windsor.ai account. Copy the API key from the connector URL line (you’ll need it for further integration with Snowflake).

You can also find your API key in the Account Management settings, API Access section.

1. Go to your Snowflake account and select Marketplace. Search for Windsor, and select the appropriate connector you want to use, e.g, Facebook Ads Connector.

2. Click Get, and the connector will be installed in your account.

3. Once the connector is installed, click Open.

4. The connector page, along with a privileges dialog box, will open. Grant the necessary permissions by clicking Grant Privileges.

5. Select the data warehouse you want to use for the compute and click Save.

6. You’ll see a dialog box for connecting with external endpoints; click Connect.

7. Paste the Windsor API Key you copied from your Windsor.ai dashboard and click Connect. 

Now, the connector is ready to create destination tasks.

8. Click Create New Task and enter the following details in the task form:

• Name: You can use any name.
• Fields: Choose the fields you want to retrieve data for.
• Accounts: Data source accounts you need.
• Database, schema, table: You can give any descriptive names (they’ll be auto-created).

When the form is completed, click Save.

9. Your task will be created, and first, its status will be pending after the data is loaded. In a moment, the task’s status will change to success.

10. Congratulations, your task has run successfully, and your data is now in your database. 

Let’s preview the integrated data. Go to your Snowflake account and select Database Explorer from the Catalog menu.

11. Select your Database -> Schema -> Table that you entered while creating the task. 

Before you can preview the data, you need to give privileges to the user to view the table data. After selecting the table, click +Privilege.

12. The Privileges dialog box will open. Select your User from the Roles dropdown and select the appropriate privileges (e.g, Select) from the Privileges dropdown. Confirm with the Grant Privileges button.

13. Now, click Data Preview, and you will be able to see your data.

That’s it! You’ve just streamed your first dataset to Snowflake using a Windsor.ai native connector. To load the next datasets from this or other data sources, follow the same steps.

You can also send data to Snowflake right from your Windsor.ai dashboard. Find the instructions in the Snowflake Integration Documentation.