title: Ignore extra columns in CSV when using COPY FROM in Cassandra
body: <p>I have a table with two columns <code>id, name</code> and I am ingesting data from a 3rd party that may add data to each row without my knowledge. I want to ensure the file still loads until I am ready to change my data model, ignoring any extra columns that are added to the end of each row.</p>
  
  <p>E.g. If the csv file changes to <code>id, name, email</code> at some point, I want my COPY FROM query to continue happily loading <code>id, name</code>.</p>
  
  <p>I've tried to implement <code>SKIPCOLS</code>, but as far as I can see, this only seems to work when there is a match between fields in the first place.</p>
  
  <p>i.e. The following is the correct usage of COPY FROM with SKIPCOLS but will not help my needs as I can't seem to reference a column that only exists in the csv.</p>
  
  <pre><code>COPY users (id, name) FROM 'users.csv' WITH SKIPCOLS = 'name';
  </code></pre>
  
  <p>Is there another way to do this or a different way to use SKIPCOLS that I am missing?</p>