topic Re: tBigqueryInput multiple google session file in Talend Studio

tBigqueryInput multiple google session file

Parikhharshal — Sat, 16 Nov 2024 03:39:12 GMT

Dear Talend experts

I have a scenario where I have to ingest a day old google session file (file generated each day like this)

This part in sql always changes as soon as I select different day:

ga_sessions_20191005`

What's the best way to ingest this into Redshift?

Thanks

Harshal.

Re: tBigqueryInput multiple google session file

Anonymous — Fri, 10 Jan 2020 05:15:11 GMT

It seems you need to save the file to local system, and then read it. Don't know if there is an API to download the file automatically? If so, it will make the steps more programmatic.

Regards
Shong

Re: tBigqueryInput multiple google session file

Parikhharshal — Sat, 11 Jan 2020 12:02:40 GMT

Thanks @shong for your reply.

I have asked Google guys if they have got any API which we can use.

But you also mentioned that the files can be stored locally. How can I store from tbigqueryinput to local?

Re: tBigqueryInput multiple google session file

Anonymous — Sat, 11 Jan 2020 13:34:44 GMT

I don't meant to use tBigQueryInput to download the file to local, I see there is a Save.. button in your image, I guess this button is used to save the session file to local system.

Re: tBigqueryInput multiple google session file

Parikhharshal — Sat, 11 Jan 2020 13:36:03 GMT

Ohh.. That will be manual. I want to automate using Talend.

Re: tBigqueryInput multiple google session file

Anonymous — Sat, 11 Jan 2020 13:43:44 GMT

I see, let me know if you get any news from Google guys.