I have a dilemma of sharing Snowflake data with several on-prem SQL server.
The question is if I should use CData to replicate data by batch from Snowflake to SQL server, or if I can create a Linked Server using CData driver to avoid data movement.
I understand there would be performance implications of each approach. However, I am curious to hear your thoughts.
Thanks,
Ming