SQL Server to Snowflake Replication

[CHolligan1644575715]

Hi,

We have a low-latency requirement for replicating data from sql server to snowflake using Stitch.

The website says 'near real-time' but this is contradicted by the documentation which says a 30min minimum for scheduling.

Does the product support sub-5min latency? There would be >200 million rows to be replicated per day.

Thanks

[Anonymous]

@Charlie Holligan​ , I have forwarded your question to our Stitch team, I will update to you once I have answers.

Regards

Shong

[Anonymous]

Hello

I got an reply from our developer as below:

"For database integrations we offer extractions every 1 minute. There will be additional latency between the extraction and the load time. So if they are looking for sub 5 minute from extraction to destination we do not offer that."

Regards

Shong

[CHolligan1644575715]

Thank you,

What's the minimum time we could expect for extraction to destination?

Furthermore, where does the additional latency come from? I.e. would it mainly be sql server, snowflake, or application based?