Upload file to big query without specifying a scheme

Four Stars

Upload file to big query without specifying a scheme

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 

Moderator

Re: Upload file to big query without specifying a scheme

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.