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

Question

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

Answer

yes, it is.

AWS Glue offers a [native connector for SQL server](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-connect.html) 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 ](https://aws.amazon.com/blogs/big-data/how-to-access-and-analyze-on-premises-data-stores-using-aws-glue/) and to this other post to view how to use [the Snowflake connector.](https://aws.amazon.com/blogs/big-data/ingest-data-from-snowflake-to-amazon-s3-using-aws-glue-marketplace-connectors/)

hope this helps

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

Conteúdo relevante