I am trying to use AWS Athena to build a database for my large CSV files, in order for me to analyse in PowerBI.
I have 30 CSV files of 2 GB each in S3, all 30 have same columns. I have managed to test one file in Athena and have it successfully connected to PowerBI.
However the data type might be a bit off because I have all cells in inverted commas, need that to be removed
I need help to combine all 30 in one single database, I have no coding knowledge at all. We can do via TeamViewer.
Let me know if this can be done
15 фрилансеров(-а) в среднем готовы выполнить эту работу за $278
Hi, I am having 3 years experience in AWS and I have worked on Athena and can easily work on this and do the task. Please give me an opportunity and we can discuss this for days and bid.
Hello, I'm a well experienced AWS certified professional solutions architect. I'm capable of doing what you want to do. Contact me if you have any questions. Thank you, have a great Day
I have a lot of experience with using the AWS ecosystem for big data work. It seems like you need some Jobs written to clean the data and then connecting PowerBI to Athena. I can help with all this work. thanks
I would be happy to help you with the setup of your Athena database. As I worked on the very similar setup before based on the attached files I could already identify your issue and I can see the potential solution.