title: auto increment field in BigQuery
body: <p>I'm creating an empty table using the Google BigQuery WebUI, and I'd like to have a field that auto-increments every time I add a record to the table. In MYSQL it would look something like this</p>
  
  <pre><code>CREATE TABLE smoker_info (
  ID int NOT NULL AUTO_INCREMENT,
  meat_type string,
  kilos varchar(255), 
  PRIMARY KEY (ID) );
  </code></pre>
  
  <p>Is there a way to create the <code>ID</code> field in BigQuery?</p>
  
  <p>My plan is to use the <code>smoker_info</code> table to hold general information about the meat I'm smoking, and I would have another table that holds temperature readings.</p>
  
  <p>Thanks</p>