title: Google BigQuery: Add date to table name when creating a table
body: <p>I am writing a query I am planning to schedule using Big Query UI.</p>
  
  <p>I would like to add a _TABLE_SUFFIX to this table which is equal to CURRENT_DATE. </p>
  
  <p>How could I achieve that? </p>
  
  <p>This is the query I am working on: </p>
  
  <pre><code>IF 
    today != DATE_SUB(DATE_TRUNC(CURRENT_DATE(), MONTH), INTERVAL 1 DAY)
  THEN 
    CREATE TABLE `project.dataset.tablename_&lt;insert_current_date_here&gt;`
    AS
    SELECT CURRENT_DATE() as today;
  END IF;
  </code></pre>