title: Update column values in a table in snowflake
body: <p>I have a table with numbers in a field <code>COL_1</code>. I want to replace values with <code>COL_1 * 2</code> (double all the values). I'm not sure the correct way to do this.</p>
  <p>Is the following code correct?</p>
  <pre class="lang-sql prettyprint-override"><code>update MY_TABLE
    set COL_1 = COL_1 * 2
  ;
  </code></pre>
  <p><strong>Note:</strong> Feel free to assume this transformation interacts with any self-referential field.</p>
  <p><em>If this were python code, you could execute using the following:</em></p>
  <pre class="lang-py prettyprint-override"><code>df['col_1'] = df['col_1'] * 2
  </code></pre>