title: Create partitioned table with date suffix in bigquery using SQL or web UI
body: <p>I want to create such table:</p>
  
  <pre><code>CREATE TABLE sometable
  (SELECT columns, columns, date_col)
  PARTITIONED BY date_col
  </code></pre>
  
  <p>And I want it to be date partitioned with the date in table suffix: sometable$date_partition</p>
  
  <p>I read the docs, but can't complete this neither with web UI nor with SQL.</p>
  
  <p>The web UI shows such error "Missing argument for parameter DATE."</p>
  
  <pre><code>My table name is "daily_export_${DATE}"
  My partitioning column isn't blank, it's date_col.
  </code></pre>
  
  <p>Can I have a simple example, please?</p>