title: data profiling on bigquery table covering min,max,unique, null count statistics
body: <p>I am looking for solution to perform data profiling on bigquery table covering below statistics for each column in table.  Some of the columns are ARRAY and STRUCT as given below.</p>
  
  <p>I tried multiple ways to generate dynamic query to cover below scenarios but no luck.. I will greatly appreciate your help/inputs. </p>
  
  <p>Metrics I want to calculate part of this solution are: </p>
  
  <ul>
  <li>MIN VALUE</li>
  <li>MAX VALUE</li>
  <li>MIN LENGTH OF THE FIELD</li>
  <li>MAX LENGTH OF THE FIELD</li>
  <li>NO OF UNIQUE RECORDS FOR EACH FIELD</li>
  <li>NO OF NULLS IN FIELD</li>
  <li>NO OF NON NULL VALUES IN FIELD.</li>
  <li>MIN DATE IN CASE OF DATE OR DATETIME FIELD</li>
  <li>MAX DATE IN CASE OF DATE OR DATETIME FIELD</li>
  </ul>
  
  <p>Sample Table Data:</p>
  
  <blockquote>
    <p><a href="https://i.stack.imgur.com/s7bbQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s7bbQ.png" alt="Blockquote"></a></p>
  </blockquote>
  
  <p>Desired output
  <a href="https://i.stack.imgur.com/eKdYe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eKdYe.png" alt="enter image description here"></a></p>