Закрыт

AWS Athena Database Setup

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

Квалификация: Интернет-услуги Amazon, Облачные вычисления, Управление базами данных, Linux, MySQL

Показать больше phpmotion database setup, sql database setup primavera, freelance database setup, boto3 athena, athena bucketing, athena insert into table, athena describe database, athena use database, what is athena, aws athena pricing, athena api, mysql database setup forms, enom api database setup, database setup phpbb3, online forms database setup, php admin database setup, mysql net read data type numeric code database, database setup feedback sheets, aws isbn database, primavera database setup

О работодателе:
( 0 отзыв(-а, -ов) ) Kuala Lumpur, Malaysia

ID проекта: #19665828

15 фрилансеров(-а) в среднем готовы выполнить эту работу за $278

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Больше

$250 USD за 4 дней(-я)
(28 отзывов(-а))
5.5
bishnudev3

I have web-development experience in PHP, wordpress, corePHP, HTML, HTML5, CSS, CSS3, BOOOTSTRAP3, RESPONSIVE WEBSITES, PARRALLAX WEBSITES I have versatile experience in setting-up and managing various servers, op Больше

$155 USD за 3 дней(-я)
(27 отзывов(-а))
4.1
NewHorizons2016

Hello there, I have written a high-performance C/C++ library which can parse millions of records in a few seconds. I can use that library, OR, simply show you how to use other built-in tools to create a MySQL or Больше

$400 USD за 3 дней(-я)
(2 отзывов(-а))
2.8
cooddooc

Hi!I'm very happy to have a chance of bidding your [login to view URL] can we talk?Please schedule a time? I am an excellent developer in this industry. If we work together, I will satisfy you fully. Please give me 10 minutes Больше

$140 USD за 7 дней(-я)
(2 отзывов(-а))
2.5
Scorpion09

Amazon certified AWS engineers can help you in this project. Also if awarded we will provide a months free assistance on the services.

$1111 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
CleverAmerican

What we want to do is create an AWS Glue Crawler that will fetch each of the text files from S3, add them to the table, and then make the table queryable via Athena. Keep in mind that you will not achieve the same l Больше

$222 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
deepapamnani16

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.

$222 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
jignaciodiazm

Dear, "check my profile" there you will find my skill which will give you an idea of ​​my work, I think Tom G.'s proposal is the same, that's why I offer you the same, I've been working on the AWS platform for years, O Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
electrobeam

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

$250 USD за 2 дней(-я)
(1 отзыв)
0.0
GuruprasadDBA

I have sound knowledge on database management and data design in Oracle Db,AWS and MySQL. the requirements I could fulfilled in given time and as addintional to that I give free. online support and oncall support at a Больше

$55 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
cameron2020

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

$400 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
DeftBOX

Hello, I've good experience in AWS ecosystem.I've created a table with the data given by you and you can see in screenshot; no " is there. Also made 2 more copies of it and it will update the table automatically as an Больше

$100 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
amitkumarads

Hi, We have extensive experience with AWS services and can definitely help you with this. We provide you 100% satisfaction guarantee. We can deliver it to you in 3 days. Let me know if you would like to have a quick Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Mindquadsolution

Hello Sir, Greetings from MindQuad! After a brief walk through of the job details , we are quite confident of providing you the best solution and I am absolutely sure that we can do the project very well. We can prov Больше

$140 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
oglaf

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.

$230 USD за 3 дней(-я)
(0 отзывов(-а))
0.0