Upload file to big query without specifying a scheme

Anonymous — Sat, 16 Nov 2024 08:31:23 GMT

Hello,

Is it possible to use one of BigQuery components without specifying a scheme?

I have a JSON file and I want to send it AS IS to BigQuery because it seems like Big Query creates a table with nested fields only while the input is a JSON file.

(My Json contains many nested classes and Talend parses only the first class and considers the rest as a string. In the end, it detects the scheme as a one string field and uploads the JSON as a string).

Thanks

Emma

, defines the scheme as the first class name and

Re: Upload file to big query without specifying a scheme

Anonymous — Thu, 29 Mar 2018 10:05:48 GMT

Hello,

So far, the shema structure will be needed in BigQuery components .

Have you tried to upload your json file to BigQuery by running console command? Is it working for you?

Best regards

Sabrina

topic Re: Upload file to big query without specifying a scheme in Talend Studio

Upload file to big query without specifying a scheme

Re: Upload file to big query without specifying a scheme