By using AWS re:Post, you agree to the Terms of Use
AWS re:Postre:Post
/Can AWS Glue read data from different SQL Server table, generate csv files and zipping it to S3?/

Can AWS Glue read data from different SQL Server table, generate csv files and zipping it to S3?

0

I need to load data from multiple tables in a SQL server to S3 for some batch processing. Can AWS Glue read data from different SQL Server table, generate csv files and zipping it to S3? And can AWS Glue run R script functions?

Topics
StorageAnalyticsDatabase
Tags
Amazon Simple Storage ServiceAnalyticsAWS GlueData LakesExtract Transform & Load Data
PhoenixRising
asked 4 months ago17 views
1 Answers
1
Accepted Answer

Hi,

yes, AWS Glue can read from multiple SQL Server tables,apply transformation with Spark (Pyhotn or Scala) and write to Amazon in S3 in different output format, compressed CSV is one of them.

As mentioned, AWS Glue is a Serverless Spark environment and you can build your jobs wit Python and Scala. R is not natively supported.

hope this helps

EXPERT
Fabrizio@AWS
answered 4 months ago

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 questions