title: BigQuery streaming insert data availability delay
body: <p>I've been using BigQuery for about 2 months. During that time I've used streaming insertion to add thousands of entries every minute. I've been able to then query over that data within a few minutes, if not practically instantly.</p>
  
  <p>Starting a few days ago though, one of my tables suddenly starting showing delays in data availability ranging from 20 to 60 minutes. This only occurs with one of my tables. Data inserted into other tables remain available nearly instantly.</p>
  
  <p><strong>Is this kind of data availability delay normal for BigQuery?</strong></p>
  
  <p>The table experiencing this problem is <code>accuAudience.trackPlays</code>. I will gladly provide project ID and other info to a Google team member.</p>
  
  <p>The results of the streaming inserts into the problematic table are: </p>
  
  <blockquote>
    <p>{'kind': 'bigquery#tableDataInsertAllResponse'} </p>
  </blockquote>
  
  <p>Example query from problematic table, <code>accuAudience.trackPlays</code> (ordered by date desc):</p>
  
  <blockquote>
    <p>ROW   DATE    COUNT<br>
    1 2015-03-30 12:35:32 UTC 67<br>
    2 2015-03-30 12:35:31 UTC 65<br>
    3 2015-03-30 12:35:30 UTC 56<br>
    4 2015-03-30 12:35:29 UTC 45<br>
    5 2015-03-30 12:35:28 UTC 60   </p>
  </blockquote>
  
  <p>Same query made seconds later to different table (<code>accuAudience.trackSkips</code>). Note the date field is 30 minutes ahead of the earlier query.</p>
  
  <blockquote>
    <p>ROW   DATE    COUNT<br>
    1 2015-03-30 13:04:03 UTC 1<br>
    2 2015-03-30 13:04:02 UTC 1<br>
    3 2015-03-30 13:04:01 UTC 3<br>
    4 2015-03-30 13:04:00 UTC 3<br>
    5 2015-03-30 13:03:59 UTC 6   </p>
  </blockquote>
  
  <p>If there's other information needed, please let me know! </p>