Hi there!

From the notes, I understand that you would like to know if it’s possible to copy data from an on premises SQL Server to Snowflake with help of AWS Glue. Please note that AWS Glue can connect to a variety of on-premises JDBC data stores such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, and MariaDB [1]. Therefore, in your case, you can configure the on-premises SQL database table as a source for the ETL (extract, transform, and load) job, which transforms the data into Apache Parquet format and saves it to the destination S3 bucket. You can then unify your datasets in your S3 bucket data lake with data in Snowflake and read and transform it [2].

I hope you find the above information helpful.

Have a great day ahead!

References:

[1] https://aws.amazon.com/blogs/big-data/how-to-access-and-analyze-on-premises-data-stores-using-aws-glue/