tBigqueryInput multiple google session file

[Parikhharshal]

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.

[Anonymous]

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

[Parikhharshal]

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?

[Anonymous]

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.

[Parikhharshal]

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

[Anonymous]

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