Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need info about tBigQueryOutput error

Hi,

I wish to load a table into BigQuery and am using tbigqueryoutput component to do the same. I thought, all that required was the dataset and the table name where it should be loaded and the data that is coming from talend.

But I see there are 2 other different parameters that are requested for

1. Local File Name

2. File on Google Storage Configuration.

My queries are

1. Why would there must be a local file name storing locally the output file to be pushed into bigquery? What do I have to do, if I do not wish to store any such details locally at all.

 0683p000009LuXb.jpg

 

2. What content does the Google storage configuration exactly contain? Where is this file created?

Because with out this file the loading is not happening. Where in Big Query do I have to put the details of the google storage and what kind of details should exactly be containing into it.

 

Lastly,

I tried pushing records from talend into a Bigquery, but it keeps asking for the bucket details. Can anyone of you explain what kind of details should be present in the gs://<<bucket_Name>>/<filename_to_be_used_in_talend>>. PFB the screenshot of what parameters do i really mean.

Labels (3)
12 Replies
Anonymous
Not applicable
Author

Hi, it is a file created by me. May I know what will be the content of the file usually. Also, is it possible to load the data directly into Big Query as it seems the data is not stored in Cloud Storage at all. May I know what is to be done in that case?

Anonymous
Not applicable
Author

totally clear

thay man hinh iphone 6

Anonymous
Not applicable
Author

About storing file locally in LocalFilename is there a way to avoid this as I am using talend cloud instance to run jobs and it keeps telling that the path doesn't eist.