title: GCP Bigquery - query empty values from a record type value
body: <p>I'm trying to query all resources that has empty records on a specific column but I'm unable to make it work. Here's the query that I'm using:</p>
  
  <pre><code>SELECT
    service.description,
    project.labels,
    cost AS cost
  FROM
    `xxxxxx.xxxxx.xxxx.xxxx`
  WHERE
    service.description = 'BigQuery' ;
  </code></pre>
  
  <p>Here's the results: </p>
  
  <p><a href="https://i.stack.imgur.com/Ksf3C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ksf3C.png" alt="results"></a></p>
  
  <p>As you can see, I'm getting everything with that query, but as mentioned, I'm looking to get resources with empty records only for example record 229,230 so on.</p>
  
  <p>Worth to mention that schema for the column I'm trying to query is:</p>
  
  <pre><code>project.labels  RECORD  REPEATED
  </code></pre>
  
  <p>The above was mentioned because I tried using several combinations of <code>WHERE</code> but everything ends up in error.</p>