Pull data from google sheet and load into postgres DB
Currently, I want to pull data from google sheets, alter it with tMap and then load it into a postgres db. I am using tGoogleDriveConnection and then tGoogleDriveGet to retrieve the csv. However, I can't figure out how to use tMap because when the file is loaded, it doesn't have any column structure--it just says "content". Does anyone know how I may be able to load the data in correctly?
The tGoogleDriveGet component will only help you to get the file from Google Drive to your local machine at a directory of your choice.
Once the file is available in your local, you need to read it like any other file from local using file components. For example, if its a csv file, use a tFileInputDelimited to read the file present in the local folder. You need to provide necessary schema details in this File Input component.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
The tGoogleDriveGet component will only help you to get the file from Google Drive to your local machine at a directory of your choice.
Once the file is available in your local, you need to read it like any other file from local using file components. For example, if its a csv file, use a tFileInputDelimited to read the file present in the local folder. You need to provide necessary schema details in this File Input component.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Thank you for your response!
I made a little progress with your tip; however, now I am getting an error on my tGoogleDriveGet that says "invalid escape sequence". Do you know what may be creating this error?
Could you please mark the topic as resolved so that it will help other Talend community members?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Do we have any inbuilt tGoogleSheetInput connector in TOS -BD ? I want to read data from Google sheet and load it into DB. I can''t find any on TOS -BD v8.
