Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Sync & update a Google Sheets File
Added on April 18, 2019 3:42PM
Likes: 0
Replies: 3
sanzot
Registered Posts: 2 ✭✭✭✭
Hi all,
Maybe a silly questions, but I do not know if it's possible to do what I am trying to. I have installed the GSheets plugin to connect to a GSheets files that it's constantly adding new data. I also did a dataset (with recipe and a dashboard) last week with that file. I would like to know if it's possible to sync this file to update the dataset, apply the recipe and update the charts in the dashboard. Or do I have to create a new dataset with the recipe and charts?
Thanks for your time.
Santi
Maybe a silly questions, but I do not know if it's possible to do what I am trying to. I have installed the GSheets plugin to connect to a GSheets files that it's constantly adding new data. I also did a dataset (with recipe and a dashboard) last week with that file. I would like to know if it's possible to sync this file to update the dataset, apply the recipe and update the charts in the dashboard. Or do I have to create a new dataset with the recipe and charts?
Thanks for your time.
Santi
Best Answer
-
Hi,
I'm sorry but I do not understand your question.
Here is what I can say:- If you want to update the data on your Dataiku DSS (pull from Google Sheets), you just need to run again the recipe(s).
- If you want to push data to Google Sheets, you can create a new dataset "Google Sheets" with the plugin and use this dataset as an output of a recipe.
I hope this helps.
Jeremy
Answers
-
Thanks Jereze,
Finally I founded. As u mentioned, it's a question of pulling again the Google Sheets and running the recipe.
Regards
Santi -
Emiel Registered, Frontrunner 2022 Finalist, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant Posts: 24 ✭✭✭✭✭In case you want to do this in a scenario, you can invalidate the cache of the Google Sheets dataset. Google sent me here when trying to figure out how to do that, so I thought I might add that information here.