IICS | Read Oracle data and write into Snowflake
1. Snowflake is a Data ware house as service platform.
2. Unlike, the conventional data ware house resides on premises. This one available cloud public to access using service provided like AWS, Azure and GCP.
3. It’s fully managed service which implies there is no infrastructure, storage, compute or maintenance requried (zero maintenance charges)
Today we are going to discuss about a sample HR data to read from Oracle and process into Snowflake.
1. Snowflake login walkthrough with test account was created earlier.
2. How to setup a snowflake connection under Administrator.
3. Mapping to implement the use case we discussed about
1. Define Source transformation - Oracle Source connection using custom query.
2. Define Target Transformation - Snowflake Source Connection, field map source/target columns
3. Run the mapping to ensure results are as expected.
![Complete online adult ballet center [30 minutes]](https://images.videosashka.com/watch/IgZEpRMQ-cE)
