Cannot set Allow quoted newlines property in bigquery using python?
<p>I cannot able to enable property "Allow quoted newlines" in google bigquery load job.</p>

<pre><code>configuration = {
        'load': {
            'createDisposition': create_disposition,
            'destinationTable': {
                'projectId': destination_project,
                'datasetId': destination_dataset,
                'tableId': destination_table,
            },
            'schema': {
                'fields': schema_fields
            },
            'sourceFormat': source_format,
            'sourceUris': source_uris,
            'writeDisposition': write_disposition,
            'allowJaggedRows': True,
            'allowQuotedNewlines': True,
            'ignoreUnknownValues': True
        }
    }

    if source_format == 'CSV':
        configuration['load']['skipLeadingRows'] = skip_leading_rows
        configuration['load']['fieldDelimiter'] = field_delimiter
        configuration['load']['encoding'] = 'UTF-8'
        configuration['load']['quote'] = ''

jobs = self.service.jobs()
        job_data = {
            'configuration': configuration
        }
query_reply = jobs \
            .insert(projectId=self.project_id, body=job_data) \
            .execute()
        job_id = query_reply['jobReference']['jobId']
        job = jobs.get(projectId=self.project_id, jobId=job_id).execute()
</code></pre>

<p>But property <em>'allowQuotedNewlines': True</em> is not working.  When I inspected using bigquery UI(web view), this property is not checked. </p>

<p><a href="http://i.stack.imgur.com/JPH7M.png" rel="nofollow"><img src="http://i.stack.imgur.com/JPH7M.png" alt="enter image description here"></a> </p>

<p>Did I miss something? what is the issue?</p>

<p>Try to remove the row
configuration['load']['quote'] = ''</p>

<p>If you want to allow quoted newlines, you have to specify a non-empty quote char.</p>

python python-2.7 google-bigquery google-api-client google-api-python-client