By using AWS re:Post, you agree to the Terms of Use
/AWS Glue ETL from SQL Server DB on premises to Snowflake on AWS cloud/

AWS Glue ETL from SQL Server DB on premises to Snowflake on AWS cloud

0

Need to know if it is possible and feasible to do ETL with help of AWS Glue from SQL Server DB on premises(JDBC Connector used ) to Snowflake(JDBC Connector)?

1 Answers
0

yes, it is.

AWS Glue offers a native connector for SQL server and has a connector available for in the Glue connector Marketplace for SnowFlake.

you can refer to this post to set up the connectivity to on-premises and to this other post to view how to use the Snowflake connector.

hope this helps

EXPERT
answered a month ago
  • Thanks Fabrizio@AWS, Do we need to store data in S3; or we can directly fetch the data from SQL Server and do the transformation and pushes directly into Snowflake? What do you suggest ?

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