Snowflake Connector Overview
You can use Snowflake Connector to securely read data from or write data to Snowflake. You can read data from other applications, databases, and flat files and write data to Snowflake.
You can create a Snowflake connection and use the connection in mappings and Mapping Configuration tasks. Create a Mapping Configuration task to process data based on the data flow logic defined in a mapping.
Note: Before you use a Snowflake connection, verify if the Snowflake Cloud Data Warehouse license is enabled under Connector Licences and the SDKPatch package is assigned under Packages.
Example
An enterprise application uses the Oracle database to store the product transaction details such as transactionID, customerID, productID, quantity, and OrderPlacedOn. You need to analyze the completed transactions, pending transactions and availability of stocks. Use Snowflake Connector to create a mapping to read all the transaction records from Oracle source, apply lookup on the Snowflake table, apply conditions, and write the records to Snowflake target for data analysis.