title: Behavior of DEFAULT option in Snowflake Tables
body: <p>I've created a table and added default values for some columns.<br />
  E.g.</p>
  <pre><code>Create table Table1( COL1 NUMBER(38,0),
                       COL2 STRING,                    
                       MODIFIED_DT STRING DEFAULT CURRENT_DATE(),
                       IS_USER_MODIFIED BOOLEAN DEFAULT 'FALSE' )
  </code></pre>
  <p><strong>Current Behavior</strong>:<br />
  During data load, I see that when running inserts, my column 'MODIFIED_DT' is getting inserted with default values.
  However, if there are any subsequent updates, the default value is not getting updated.</p>
  <p><strong>Expected Behavior</strong>:</p>
  <ol>
  <li><p>My requirement is that the column value should be automatically taken care by ANY INSERT/UPDATE operation.
  E.g. In SQL Server, if I add a Default, the column value will always be inserted/updated with the default values whenever a DML operation takes place on the record
  Is there a way to make it work? or does default value apply only to Inserts?</p>
  </li>
  <li><p>Is there a way to add logic to the DEFAULT values.
  E.g. In the above table's example, for the column IS_USER_MODIFIED, can I do:</p>
  <p>Case when CURRENT_USER() = 'Admin_Login' then 'FALSE' Else 'TRUE' end</p>
  <p>If not, is there another option in snowflake to implement such functionality?</p>
  </li>
  </ol>