title: FCM push notification data export to linked BigQuery not working
body: <p>I've recently linked my Firebase project to a BigQuery as indicated in the <a href="https://firebase.google.com/docs/cloud-messaging/understand-delivery#bigquery-data-export" rel="nofollow noreferrer">documentation</a>, and also installed the FCM SDK version 20.1.0 as indicated <a href="https://firebase.google.com/docs/cloud-messaging/understand-delivery#enable-message-delivery-data-export-on-android" rel="nofollow noreferrer">here</a>, but even after enabling the data export by calling <code>setDeliveryMetricsExportToBigQuery(true)</code> in a local app build, and sending some push notifications via production to capture some push metrics, nothing was exported to the <code>firebase_messaging</code> dataset, nor a single table was created by the integration. I've activated only the Cloud Messaging data export for this project on all app variants (debug, test, beta, production).</p>
  
  <p>I've tried receiving and interacting with push notification on both emulated and physical devices, and even after waiting more than 24h I was unable to find the push notification delivery metrics in the database.</p>
  
  <p>Running the following query against the created dataset after the integration link, I get no results back:</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from firebase_messaging.data limit 100
  </code></pre>
  
  <p>Error message: <code>Not found: Table *****:firebase_messaging.data was not found in location US</code> (I've hidden the project id).</p>
  
  <p>When looking at the <code>Firebase Messaging Export</code> job history of this same BigQuery, I find the following line within every daily run: <code>Source data not found for 'data$20200215'</code>.</p>
  
  <p>With that said, I have a few questions around what could be causing this:</p>
  
  <ol>
  <li>Is there anything else that needs to be done that may not be present in these documentation links I've shared?</li>
  <li>Is a local build a possible cause for this unexpected behavior, even by setting the production variant for it?</li>
  <li>Can the data export feature be affected by using the sandbox version of the BigQuery?</li>
  <li>I noticed is that the BigQuery uses US region and my app is distributed to the Brazil market, could this influence the push metrification?</li>
  </ol>