Completed

convert the Big Query result to json with group by.

Looking for someone with good knowledge in Python, json, API, Big Query etc.

Timeline: 1 to 2 day.

Background information..

1) Table schema in BQ:

Field name Type Mode

Date DATE NULLABLE

Item STRING NULLABLE

cost FLOAT NULLABLE

2) Query used to get the data:

Select date, Item, sum(cost) as cost

From table_xyz

Group by date, item

Task:

Pull the big query data and convert it to json with group by ”date”.

I will provide the sample output which I needed

Skills: Python, Google APIs, SQL, Google Cloud Platform

See more: input form database query result view, perl crontab mysql query result email, perl mysql query result email, bigquery json to struct, bigquery json column, bigquery json string to struct, bigquery result to json, bigquery unnest json array, bigquery json string to array, bigquery json extract keys, bigquery json extract, setting decimal places query result oracle, background information overview online exam system, sendmail mysql query result, background information chinese year, sample background information science project, myspace group background creator, shell script send query result email, vsto application pivot table fields query result, simple search query result mysql

About the Employer:
( 2 reviews ) Hicksville, United States

Project ID: #26643939

Awarded to:

ganesharmy95

Hello! I find myself eligible for this job since I am having 7 years of extensive experience. I am Good at Amazon Web Services, JavaScript, node.js, React.js and Python. Please Send a message so that we can discuss mor More

$20 USD in 7 days
(0 Reviews)
0.0
parthjaviya098

Hello, I have read your requirements. I can convert your data to json through api using python. I can complete this project in an hour. Let know if you are interested. Thank you.

$20 USD in 1 day
(8 Reviews)
3.4

7 freelancers are bidding on average $36 for this job

science64

Hello, Can you pleasae privde the output that I can convert it into json file? I can write python script to convert it. You may contact me visa chat. Best

$25 USD in 7 days
(19 Reviews)
4.2
abuakar21

Hi, I understand you wish to pull data from Big Query Tables and parse the data in Json format. I'm a python programmer with 3 years of experience. Using the inbuilt python Json library and other relevant resources, I More

$90 USD in 2 days
(4 Reviews)
3.4
gouriskumawat

Dear Client. I have expertise in BigQuery and Python. I can easily parse the Json file as well. I will finish the work in couple of hours with quality. I have seen the two point mentioned in the bid. shema detail and More

$25 USD in 1 day
(5 Reviews)
3.2
goodwork20k

I am good in powershell, api, query along with automation and development, i can help you to write script with powershell Please let me know if you are good to award this project to me

$55 USD in 2 days
(6 Reviews)
3.4
hassansystem

EXPERT in Java Script and jQuery. I can solve your issue related to json . Lets have a chat and discuss. I have 8+ year of experience in Web Designing and Development. I have read your requirements once we clear our re More

$20 USD in 7 days
(0 Reviews)
0.0