Best services for client data upload, data cleaning, ingestion into RDS

0

I'm having trouble figuring out the best AWS service/services for a scenario where a client uploads a .csv file, then these data are cleaned and ingested into RDS using and R script. FTP and code pipeline? Any suggestions?

已提问 2 年前215 查看次数
1 回答
2

Is this CSV a custom one or some database backup etc. ? Assuming that its former, then is R a mandate requirement to use? One quick option would be to use AWS Glue which can be used to do your ETL. The source of CSV can be S3. Glue automatically generates Scala or Python code for your ETL jobs that you can further customize using tools you are already familiar with.

profile pictureAWS
专家
已回答 2 年前
profile pictureAWS
专家
Chris_G
已审核 2 年前
  • That's very helpful. Thank you. It is a custom CSV. I will look into Glue right now!

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则