title: BigQuery standard SQL syntax: _TABLE_SUFFIX and .yesterday tables
body: <p>My goal is to query across multiple tables of a dataset using BigQuery standard SQL syntax.</p>
  
  <p>I can successfully make it work when all tables of a dataset follow the same number pattern. However, for datasets that contain additional tables like <code>.yesterday</code>, I get an error: <code>Views cannot be queried through prefix. Matched views are: githubarchive:day.yesterday</code></p>
  
  <p>Here is the query I used:</p>
  
  <pre><code>SELECT
    COUNT(*)
  FROM
    `githubarchive.day.*`
  WHERE
    type = "WatchEvent"
    AND _TABLE_SUFFIX BETWEEN '20170101' AND '20170215'
  </code></pre>