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
8 freelancers are bidding on average €22 for this job
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
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