Get Started

Google Drive

This plugin provides a connector to read/write data from Google Drive

A simple connector to read a sheet from a Google Drive document

Plugin information

Version 1.1.3
Author Dataiku (Alex Bourret)
Released 2019-11-26
Last updated 2022-06-21
License Apache Software License
Source code Github
Reporting issues Github

How to set up

There are two methods for accessing your Google Drive documents: via sharing with a service account, or direct access using Google’s Single Sign On.

From the Google service account tab, create a new Google Cloud Platform project:

  • Select a project > New Project and fill in the required information.

Using a service account

If you choose to use the service account method for sharing your data, you now have to create one such account in your GCP project:

  • In the service accounts tab, click on create service account
  • Fill in the details and skip step 2 if you want
  • On step 3, create a key using the JSON format:

  • Save the key and open it with a text editor. You can press Done
  • Write down the service account’s email address for later use

  • Go to the plugin’s settings page to add a preset (DSS > Plugins > Googledrive > Settings > Google Drive Token) and add a preset
  • In the `Access credentials` box, paste the JSON key copied from your text editor

Using Google’s Single Sign On

  • In the credential tabs of your GCP project, create a new OAuth Client ID with a Desktop app application type
  • Copy the client ID / client secret codes
  • Create an OAuth consent screen. You will need to save the form, but the screen does not need to be verified at this stage.
  • Go to the plugin’s settings page to add a preset (DSS > Plugins > Googledrive > Settings > Google Single Sign On) and add a preset
  • Paste client ID / client secret generated at the second step

In order to use the Single Sign On, each DSS user will first have to enable it for their account, by going to their profile > Credentials > Name of the Google SSO preset > Edit icon. This will redirect the user to Google’s SSO screen where they can login and accept DSS data access. Keep in mind that warning messages will appear for as long as the OAuth consent screen has not been verified.

How to use

  • Share the Google Drive document or directory with the service account email address you took note of
  • Take note of the directory ID, which is the part of the URL after the last slash character

  • Create a new dataset in Dataiku DSS by selecting Dataset > Googledrive
  • Click Googledrive Filesystem
  • Pick your preset for the connection, and in ID of root directory, paste the previously copied directory ID

Write data into Google Drive

  • In your DSS project flow, select Dataset > Folder
  • Choose Google drive in the Store into parameter and click Create. An External code failed error may appear because you have not selected your preset yet.
  • In the Settings tab of the folder, select the connection type and your preset, and save. You can now export your dataset into your newly created Google Drive managed folder.

Get the Dataiku Data Sheet

Learn everything you ever wanted to know about Dataiku (but were afraid to ask), including detailed specifications on features and integrations.

Get the data sheet