title: Populating a table with all dates in a given range in Google BigQuery
body: <p>Is there any convenient way to populate a table with all dates in a given range in Google BigQuery? What I need are all dates from 2015-06-01 till CURRENT_DATE(), so something like this:</p>
  
  <pre><code>+------------+
  | date       |
  +------------+
  | 2015-06-01 |
  | 2015-06-02 |
  | 2015-06-03 |
  | ...        |
  | 2016-07-11 |
  +------------+
  </code></pre>
  
  <p>Optimally, the next step would be to also get all weeks between the two dates, i.e.:</p>
  
  <pre><code>+---------+
  | week    |
  +---------+
  | 2015-23 |
  | 2015-24 |
  | 2015-25 |
  | ...     |
  | 2016-28 |
  +---------+
  </code></pre>
  
  <p>I've been fiddling around with the following answers I found, but I can't get them to work, mostly because core functions aren't supported and I can't find proper ways to replace them.</p>
  
  <p><a href="https://stackoverflow.com/questions/7812986/easiest-way-to-populate-a-temp-table-with-dates-between-and-including-2-date-par">Easiest way to populate a temp table with dates between and including 2 date parameters</a></p>
  
  <p><a href="https://stackoverflow.com/questions/7824831/generate-dates-between-date-ranges">Generate Dates between date ranges</a></p>
  
  <p>Your help is very much appreciated!</p>
  
  <p>Best,
  Max</p>