title: BigQuery: Load from CSV, skip columns
body: <p>Say I have a table with existing data, with a schema like:</p>
  
  <pre><code>{ 'name' : 'Field1', 'type' : 'STRING' },
  { 'name' : 'Field2', 'type' : 'STRING' }
  </code></pre>
  
  <p>Our data is CSV: </p>
  
  <pre><code>Field1,Field2
  Value1,Value2
  ...
  </code></pre>
  
  <p>We load data by creating a new job, loading a CSV directly from Google Cloud Storage (GCS). Our data files now have an additional column and different ordering, such that the data is now structured: </p>
  
  <pre><code>Field1,Field3,Field2
  Value1,Value3,Value2
  ...
  </code></pre>
  
  <p>Is there a way to specify in the load job that we would like to skip the second column, and only load columns 1 and 3 (named Field1 and Field2)?</p>
  
  <p>I am using the Python API e.g.,  service.jobs().insert(job_body)</p>
  
  <p>Basically I want to do something like this: </p>
  
  <pre><code>job_body = {
    'projectId': projectId,
    'configuration': {
        'load': {
          'sourceUris': [sourceCSV],
          'schema': {
            'fields': [
              {
                'name': 'Field1',
                'type': 'STRING'
              },
              { # this would be the skipped field
                'name': None
                'skip': True
              },
              {
                'name': 'Field2',
                'type': 'String'
              },
            ]
          },
          'destinationTable': {
            'projectId': projectId,
            'datasetId': datasetId,
            'tableId': targetTableId
          },
        }
      }
    }
  </code></pre>
  
  <p>Thanks!</p>