Lukket

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

Evner: Amazon Web Services, Cloud Computing, Database Administration, Linux, MySQL

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Kuala Lumpur, Malaysia

Projekt ID: #19665828

15 freelancere byder i gennemsnit $278 på dette job

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 Flere

$250 USD in 4 dage
(28 bedømmelser)
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 Flere

$155 USD in 3 dage
(27 bedømmelser)
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 Flere

$400 USD in 3 dage
(2 bedømmelser)
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 Flere

$140 USD in 7 dage
(2 bedømmelser)
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 in 10 dage
(0 bedømmelser)
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 Flere

$222 USD in 2 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 Flere

$250 USD in 3 dage
(0 bedømmelser)
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 in 2 dage
(1 bedømmelse)
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 Flere

$55 USD in 4 dage
(0 bedømmelser)
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 in 7 dage
(0 bedømmelser)
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 Flere

$100 USD in 2 dage
(0 bedømmelser)
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 Flere

$250 USD in 3 dage
(0 bedømmelser)
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 Flere

$140 USD in 3 dage
(0 bedømmelser)
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 in 3 dage
(0 bedømmelser)
0.0