9.2.32 Snowflake
Snowflake is a serverless data warehouse that runs on any of the following cloud
providers: Amazon Web Services (AWS), Google Cloud Platform (GCP), or
Microsoft Azure. Oracle GoldenGate provides two handlers to load data into
Snowflake:
- Snowflake Stage and Merge
- Snowflake Streaming Handler
Table 9-39 Differences between Stage and Merge, and Streaming Handlers
Details | Stage and Merge | Streaming Handler |
---|---|---|
Workload | Any | Inserts-only |
Latency | Micro-batch | Real-time |
Resources | Customer-managed virtual warehouse | Snowflake-managed serverless compute |
API | JDBC+SQL commands
(PUT /COPY INTO /MERGE )
|
Snowpipe Streaming |
Data load | Requires intermediary loading step from Int/Ext Stage. | Direct loading into Snowflake |
Topics: