By using AWS re:Post, you agree to the Terms of Use

Copying data from sql server to snowflake with AWS GLUE

0

Can we directly transfer or copy data from Sql Server on premises to Snowflake with help of AWS Glue?

1 Answers
0

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/

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions