Google Drive Plugin " Use Google Sheets online format" option
![tgb417](https://us.v-cdn.net/6038231/uploads/lithium_attachments/n1980i7BE7BDB445EC1955.jpg)
With the Google Drive Plugin V1.1.4. There is an option on the New Google Drive Dataset labeled"
[ ] Use Google Sheets online format
In the Documentation I do not see a reference to this option. I see instead an option that says
[ ] Save Dataset as Google Doc
What is the use case for this Google Sheets online format option?
How does it differ from the Google Sheets Plugin?
Operating system used: Mac OS Ventura 13.3.1
Best Answers
-
Hi Tom!
The Google Drive plugin provides a files system access to your gdrive account, so you can access any file stored on it, whatever its format is. So typically that would be csv of xls files...
Now, when you create a Google Sheets document, it appears in a your Google Drive. However, this is not a real file stored in your drive, but merely a pointer to another API where you can access you Google Sheets.
In read mode, the plugin can find the right API to retrieve your data, so that's not relevant. When you want to save a dataset though, you might want to create a Google Sheets document instead of a csv file. In this instance, you can activate this option, which makes sure your dataset is stored both as a Google Sheets and a link accessible from your drive, instead of just a zipped csv file.
-
If you are using the Google Sheet format option, choose csv. If not, then the plugin is transparent so you can save in any format you want.
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
@AlexB
,Thanks for the reply. Will give this a try.
Do you know if the Google Drive plug-in has the same column name limitation (25 characters) as the Google Sheet plug-in. I’ve recently had to abandon the Google Sheet plug-in for some use cases because it only supports 25 character data set column names. (I’ve got some long column names.)
-
The Google Drive plugin does not have this limitation. However, you will only be able to see the first sheet of your document, where the Google Sheets plugin let you select which one you can retrieve.
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
I've had a bit of problem with this one.
When trying to write to Google Drive while having the created as "Google Sheet" option selected.
What kind of recipe do you use to drive the input into thus datastore. (In other words how do you setup the upstream recipie to use this function) For example if I use a Sync Recipie. Do I choose .XLSX or .CSV? If I'm using a Visual Prepare Recipe upstream of the Google Drive Folder, do I say to save as CSV? Or somethings else?