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

The following table summarizes the differences between the two handlers:

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:

• Snowflake Stage and Merge Handler
  
• Snowflake Streaming Handler