Snowflake Connector Guide

Snowflake Connector Guide

Snowflake Connector Overview

Snowflake Connector Overview

You can use Snowflake Connector to securely read data from or write data to Snowflake. You can use Snowflake Connector to read data from and write data to Snowflake that is enabled for staging data in Azure or Amazon. 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 tasks. Create a mapping task to process data based on the data flow logic defined in a mapping.

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.


Updated September 05, 2019


Explore Informatica Network