Snowflake Connector 1.0 - Mule 4

Support Category: Select

Anypoint Connector for Snowflake (Snowflake Connector) enables you to connect with your Snowflake instance to load data, run queries in Snowflake tables, and sync data with external business applications.

For information about compatibility and fixed issues, see the Snowflake Connector Release Notes.

Prerequisites

To use this connector, you must be familiar with:

  • The Snowflake API

  • Anypoint Connectors

  • Mule runtime engine (Mule)

  • Elements and global elements in a Mule flow

  • How to create a Mule app using Anypoint Studio

Before creating an app, you must have:

  • Credentials to access the Snowflake target resource

  • Anypoint Platform

  • Anypoint Studio version 7.5 or later

Common Use Cases for the Connector

These are some common use cases for Snowflake Connector:

  • Load bulk or continuous data into your Snowflake instance.

  • Run queries to insert, delete, update, and merge data in Snowflake tables.

  • Sync data:

    • Keep unstructured data (files) in an external data location in sync with unstructured data in Snowflake, when the external data location is the source of truth.

    • Keep unstructured data (files) in an external data location in sync with unstructured data in Snowflake, when Snowflake is the source of truth.

    • Keep structured data (tables) in an external data location in sync with Snowflake (in tables), when the external data location is the source of truth.

    • Keep structured data (tables) in an external data location in sync with Snowflake (in tables), when Snowflake is the source of truth.

Connection Types

Snowflake connections use the Snowflake Connection type to connect to Snowflake.

For information about configuring authentication types, see Use Studio to Configure Snowflake Connector.

Next Step

After you complete the prerequisites, you are ready to create an app and configure the connector using Anypoint Studio.