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?

已提問 2 年前檢視次數 1289 次
1 個回答
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/

Letty
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南