I would like to do an Data integration between Sql Server and Snowflake data warehouse. But I am not sure what is the best practice.
What I need is data ETL between the DB and Data warehouse by schedules and sliding window automatically.
My question is if SQL Server and Snowflake are both sitting on-prem. My thought was to use Snowflake data piepline but not sure if that supports ETL on both directions (from SQL DB to Snowflkae, and from Snowflake to SQL Server)? Did someone have better approach for this scenario?
And if use Azure Sql Server, then maybe ADF is the best way to do the bidirectional data ETL?
Any advice and suggestions would be high appreciated!