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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads