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?
Asked
Active
Viewed 45 times
0
-
What is the "workflow" that you would like to automate? Is it just using SQL against the CSV files, or does it involve moving files around? Do you need a User Interface? More information, please. – John Rotenstein Oct 20 '22 at 21:37
2 Answers
1
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.
John Rotenstein
- 241,921
- 22
- 380
- 470
0
While not exactly low code, AWS Athena uses SQL-like queries to analyze CSV files, among many other formats
Jader Dias
- 88,211
- 155
- 421
- 625