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.
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.