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

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)?

Topics
DatabaseAnalytics
Tags
Microsoft SQL ServerAWS GlueExtract Transform & Load Data
Language
English
Khushi19995
asked 2 years ago1659 views
1 Answer
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

AWS
EXPERT
Fabrizio@AWS
answered 2 years ago
  • Khushi19995
    2 years 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

Relevant content