topic Re: SQL Server to Snowflake Replication in Stitch

SQL Server to Snowflake Replication

CHolligan1644575715 — Fri, 15 Nov 2024 22:20:41 GMT

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

Re: SQL Server to Snowflake Replication

Anonymous — Mon, 14 Feb 2022 05:44:24 GMT

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

Regards

Shong

Re: SQL Server to Snowflake Replication

Anonymous — Tue, 15 Feb 2022 01:48:33 GMT

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

Re: SQL Server to Snowflake Replication

CHolligan1644575715 — Tue, 15 Feb 2022 09:19:13 GMT

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?