En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

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?

Sujets
Migration et modernisationBase de donnéesStockage
Balises
Migration et modernisationBase de donnéesStockage
Langue
English
rePost-User-3666101
demandé il y a 2 ans207 vues
1 réponse
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
EXPERT
AWS-User-Nitin
répondu il y a 2 ans
profile pictureAWS
EXPERT
Chris_G
vérifié il y a 2 ans
  • rePost-User-3666101
    il y a 2 ans

    That's very helpful. Thank you. It is a custom CSV. I will look into Glue right now!

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents