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

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?

주제

스토리지 분석 데이터베이스

태그

아마존 심플 스토리지 서비스 분석 AWS Glue 데이터 레이크 데이터 추출, 변환 및 로드

언어

English

PhoenixRising

질문됨 2년 전472회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

수락된 답변

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

전문가

Fabrizio@AWS

답변함 2년 전

전문가

Giovanni Lauria

검토됨 한 달 전

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

관련 콘텐츠