GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How can I control how often data is replicated into Snowflake?

Hi,

I use OGG MA 21.4 BigData for x86 linux.

Here is my replicant params:
```
REPLICAT sfrep
MAP "some_schema"."table1", TARGET "SOME_SCHEMA"."TABLE1";
```
Intent is: Unidirectional
I am using Snowflake Internal Stage.

Snowflake charges Compute time for a warehouse with a minimum of one minute. since startup.

When I have continues traffic on a trail GG replicate (MERGE INTO) Snowflake every 30 seconds. which means my warehouse is activated 24 hours.

I want to merge the CDC trail every 5 minutes and can not find a parameter that will achieve that.

Is this possible?

Thanks.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center