Snowflake Connector 1.1 - Mule 4
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.
Before You Begin
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 Using Anypoint 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.