title: How to select multiple custom Firebase event parameters in BigQuery?
body: <p>I exported Firebase events to BigQuery and now I'm trying to select two parameters from a certain event. Here is the query for selecting one parameter:</p>
  
  <pre><code>select event_dim.params.value.int_value as level_id
  from [com_company_appname_ANDROID.app_events_20161210]
  where event_dim.name = "level_replays_until_first_victory" and  event_dim.params.key = "level_id"
  </code></pre>
  
  <p>Both parameters are int values, name of the first parameter is <code>level_id</code>, and the second parameter is <code>count</code>. What I would like is to show is <code>level_id</code> in first column and <code>count</code> in second column.</p>