This article walks through the steps required to initially set up a
Mass Ingestion Databases
environment and then configure and implement a database ingestion combined initial and incremental load job that replicates Oracle data to a Snowflake Data Cloud target. The initial load portion of the job initially populates the Snowflake target with point-in-time data from Oracle. The incremental load portion of the job replicates the Oracle change data in real time to keep the source and target in sync. In this scenario we will also set schema drift options to automatically replicate some types of source DDL changes to the target.
The use cases for replicating real-time change data from a mission-critical Oracle production system to a Snowflake data warehouse include:
Minimizing intrusive, non-critical work, such as offline reporting or analytical operations on the Oracle source database system.
Reducing costly CPU usage, disk space, and CDC processing time on the Oracle source database system.
Getting the latest database changes to your data warehouse in real time for downstream processing. After an initial batch load of data to the data warehouse,
Mass Ingestion Databases
can propagate data changes continuously from a source database to keep the data in the data warehouse up to date.
Migrating to a subscription-based Cloud environment.
ASK INFAPreview
