title: Redshift copy command not getting default value
body: <p>I have a file in S3 with the following format:</p>
  <pre><code>col1,col2
  number1,content1
  number2,content2
  number3,content3
  </code></pre>
  <p>I am creating a Redshift table with the structure bellow:</p>
  <pre><code>CREATE TABLE IF NOT EXISTS general.name.name_test (
     col1 VARCHAR(255),
     col2 VARCHAR(255),
     inserted_timestamp TIMESTAMP DEFAULT GETDATE()
  );
  </code></pre>
  <p>After that, I am using Redshift copy command to have the data available in the table I just created:</p>
  <pre><code>COPY general.name.name_test
      FROM 's3://.../name_test.txt'
      ACCESS_KEY_ID '' SECRET_ACCESS_KEY '' SESSION_TOKEN ''
      DELIMITER AS ','
      IGNOREHEADER AS 1
  csv;
  </code></pre>
  <p>The problem is that &quot;inserted_timestamp&quot; is NULL and Redshift is not taking the default value.</p>
  <p>Am I missing something? This is what I will get in Redshift:</p>
  <pre><code>col1,col2,inserted_timestamp
  number1,content1,null
  number2,content2,null
  number3,content3,null
  </code></pre>
  <p>It only works if I specify the columns but I wanted to avoid that if possible:</p>
  <pre><code>COPY general.name.name_test
      (col1,col2)
      FROM 's3://.../name_test.txt'
      ACCESS_KEY_ID '' SECRET_ACCESS_KEY '' SESSION_TOKEN ''
      DELIMITER AS ','
      IGNOREHEADER AS 1
  csv;
  </code></pre>
  <p>Thank you!</p>