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)?
asked a month ago41 views
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
Relevant questions
Glue to Snowflake connector, is it mandatory?
Accepted Answerasked 4 months agoHow to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
asked 2 months agoAWS Glue ETL from SQL Server DB on premises to Snowflake on AWS cloud
asked a month agoCopying data from sql server to snowflake with AWS GLUE
asked 25 days agoAWS Glue for SQL Server(on-premises) Data Migration
asked a month agoIs it possible and OK to migrate Windows Server 2008 and SQL 2008 R2 as is
asked 3 years agoOracle db link from aws cloud to on-premises
asked a month agoIs it possible to use AWS RDS SQL Server as an AAG target from on premise primary?
asked 9 months agowhat are advantages of running ETL jobs in aws glue?
asked 18 days agoSQL Server on RDS Issue With Linked Server
Accepted Answer
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 ?