I see there’s an MS SQL Server source plugin that’s still in a “coming soon” state. I was curious about the Azure plugin, though. It’s a little unclear to me, but would this work for pulling data from a managed Azure SQL Server?
Hi
If I’m understanding your question correctly, the short answer is “no”. The Azure plugin is mainly used for building a cloud asset inventory, so it might sync metadata about your Azure SQL servers, but it won’t sync the actual data from them to another database. I think your best bet will be the (coming soon) MS SQL Server source plugin.
Could you elaborate on what your use case is? One-time data transfer, continuous CDC, … something else?
Cheers for the reply!
Use case here: we’ve got quite a few SQL servers that are part of our legacy tech debt stack. Part of the strategy I’m trying to implement over the coming year is moving our SQL Server data to Snowflake and setting our engineering team loose on rebuilding our integrations & reporting solutions to point directly to Snowflake and eventually sunsetting the SQL servers. When all’s said and done, it should be a pretty epic migration.
So ultimately, I wanted to use CloudQuery as an archival solution into Snowflake.