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.
Note: Snowflake Connector is an earlier version. Informatica recommends that you use Snowflake Data Cloud Connector for all new use cases.