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?
CodePudding user response:
While not exactly low code, AWS Athena uses SQL-like queries to analyze CSV files, among many other formats
CodePudding user response:
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.