title: How to create a view for "yesterday"s data?
body: <p>I'm partitioning my data on BigQuery by day, and I want a quick way to query "yesterday's data".</p>
  
  <p>Is this possible? How can I write queries that automatically point to the latest data, without having to re-write the tables I want to query?</p>