How to insert/append unstructured data to bigquery table
<p><strong>Background</strong></p>

<p>I want to insert/append newline formatted JSON into <code>bigquery</code> table through python client API.</p>

<p>Eg:</p>

<pre><code>{"name":"xyz",mobile:xxx,location:"abc"}
{"name":"xyz",mobile:xxx,age:22}
</code></pre>

<p>Issue is, all fields in a row are optional and there is no fixed defined schema for the data.</p>

<p><strong>Query</strong></p>

<p>I have read that we can use Federated tables, which supports autoschema detection.</p>

<p>However, I am looking for a feature, that would automatically detect schema from data,create tables accordingly and even adjust the table schema if any extra columns/keys appear in data instead of creating new table.</p>

<p>Would this be possible using python client API.</p>