Automating CSV analysis?

Gautam
October 20, 2022
181 views
0 votes
2 Answers

My e-commerce company generates lots of CSV data. To track order status, the team must download a number of trackers. Creating a relationship and subsequently analyse,its a time-consuming process. Which AWS low-code solution can be used to automate the workflow?

Answers

- JaderDias
- October 20, 2022 at 11:11 pm
- 0 votes
0
While not exactly low code, AWS Athena uses SQL-like queries to analyze CSV files, among many other formats

Login or Signup to reply.

- JohnRotenstein
- October 20, 2022 at 11:36 pm
- 0 votes
0
Depending on what ‘workflow’ you require, a few options are:
- Amazon Honeycode, which is a low-code application builder
- You can Filter and retrieving data using Amazon S3 Select, which works on individual CSV files. This can be scripted via the AWS CLI or an AWS SDK
- If you want to run SQL and create JOINs between multiple files, then Amazon Athena is fantastic. This, too, can be scripted.
Login or Signup to reply.

Please signup or login to give your own answer.

Click here to cancel reply.