In Progress

Big query : help on one query

Job Description:

I have a table in google big query GCP

The table contains x rows and y colums.

I want to perform basic quality check with a query.

I this query i want to calculate:

1- for the whole table :how many fields / how many Empty, null field's/ how many non empty null filds : in pourcentage. Also show badic statistics of the table: how many rows, how many columns...

2- for each column: how many rows/ how many Empty, null field's/ how many non empty null filds : in pourcentage.

3- a histogram fir. Each column showing how many rows are empty and how much are filled

All this in one query gcp

Skills: BigQuery, SQL

About the Client:
( 5 reviews ) PARIS 13, France

Project ID: #35427453

Awarded to:

triventures

TriVentuers Technologies is a seasoned software development company with more than 14 years of experience in working with both small and large government and private organizations. We have successfully delivered while More

€19 EUR in 7 days
(0 Reviews)
0.0

8 freelancers are bidding on average €22 for this job

noureen23

Hi There, I hope you having good day. I have 15+ years of experience in Database Administration and Complex SQL query designing. My experience makes me confident to assure you 100 percent accurate solution according to More

€30 EUR in 4 days
(15 Reviews)
3.8
ziaahmedf17

Hello!, I have gone through your project description "Big query : help on one query" I’m full stack developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality an More

€17 EUR in 5 days
(0 Reviews)
0.0
davidstrager

☀️☀️☀️☀️☀️SQL EXPERT☀️☀️☀️☀️☀️ Hi. I am David. I have checked your project and I know what you want from this project. I've rich 10+years of experience and knowledge in BigQuery and SQL based Databases like MySQL, Post More

€30 EUR in 1 day
(0 Reviews)
0.0
SuperStar090

Hi! Client! Just ready your requirement, I have rich experience in SQL DataBase Administrator, BigQuery. once hired, I can do this in short time perfectly. Thanks. Jack Diaz

€30 EUR in 1 day
(0 Reviews)
0.0
ahmedtahash

Hello , I am an expert data scientist with profound python knowledge. It is SRD would be done in 1-2 days . Feel free to discuss more details. Regards, Ahmad Al Ashery

€19 EUR in 2 days
(0 Reviews)
0.0
kalbadry20

Hello I can make query to calculate you want Please contact me to discuss further Thank you Khaled Mohamed Ali

€15 EUR in 7 days
(0 Reviews)
0.0