Big query : help on one query
Budget: €8 – €30 EUR
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
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