The groups I have been talking with recommend Fivetran to load the data into Snowflake. My sources are fairly simple - SQL Server and some flat files. Looking at extract/load then transform with views for reporting. Appreciate all the feedback on this. Just trying to build out the optimal solution. I don’t have a need for real-time. Would it be possible to just load directly from SQL server to snowflake with no other tools - then model from there?
