title: How to get gender and age in BigQuery from Firebase Analytics?
body: <p>I am using Analytics Events and trying to take advantage of the user data.</p>
  
  <p>I can get pretty much data.</p>
  
  <p>With this Query.</p>
  
  <pre><code>SELECT
  *
  FROM
  `test-project-23471.analytics_205774787.events_20191120`,
  UNNEST(event_params) AS event_params
  WHERE
  event_name ='select_content'
  AND event_params.value.string_value = 'a_item_open'
  </code></pre>
  
  <p>However, I don't need all. So, I did</p>
  
  <pre><code>SELECT
  event_params.value.string_value,
  event_previous_timestamp,
  device,
  geo,
  app_info
  FROM
  `test-project-23471.analytics_205774787.events_20191120`,
  UNNEST(event_params) AS event_params
  WHERE
  event_name ='select_content'
  AND event_params.value.string_value = 'a_item_open'
  </code></pre>
  
  <p>And then, I realized that <a href="https://support.google.com/firebase/answer/7029846?hl=ko" rel="nofollow noreferrer">the result</a> doesn't have gender data and age data. And in the document, <a href="https://cloud.google.com/bigquery/external-data-bigtable?hl=ko" rel="nofollow noreferrer">it</a> says Firebase automatically gets the information. I'd like to combine sex, age(or age group) with the result from the query above.</p>
  
  <p>How can I get it?</p>