Background
I want to insert/append newline formatted JSON into bigquery
table through python client API.
Eg:
{"name":"xyz",mobile:xxx,location:"abc"}
{"name":"xyz",mobile:xxx,age:22}
Issue is, all fields in a row are optional and there is no fixed defined schema for the data.
Query
I have read that we can use Federated tables, which supports autoschema detection.
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.
Would this be possible using python client API.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…