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

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?

主題

遷移與現代化資料庫儲存空間

標籤

遷移與現代化資料庫儲存空間

語言

English

rePost-User-3666101

已提問 2 年前檢視次數 215 次

1 個回答

最新
最多得票
最多評論

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.

專家

AWS-User-Nitin

已回答 2 年前

專家

Chris_G

已審閱 2 年前

rePost-User-3666101
2 年前
That's very helpful. Thank you. It is a custom CSV. I will look into Glue right now!

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

相關內容