|Author||Dataiku (Alex Bourret)|
|License||Apache Software License|
With this plugin, you will be able to retrieve events from your Google Calendar account
How to set up
If you are a Dataiku and Google Cloud admin user, follow these configuration steps right after you install the plugin. If you are not an admin, you can forward this to your admin and scroll down to the How to use section.
1. Create an API key in Google Calendar
- Go to your Google App’s credential page, select your project or create a new one.
- Go to Library and search for the word Calendar. Select Google Calendar API and activate it.
- Back to your project page, create a OAuth Client ID credential with a Desktop app type. Take note of the credentials’ Client ID and Client secret.
- Activate an OAuth consent screen. Note that at this stage, there is no need to get it verified by Google.
2. Create and configure a Single Sign On preset in DSS
In Dataiku DSS, go to App > Plugins > Google Calendar > Google Single Sign On, create and name a new preset and complete the connection details gathered at step 3.
How to use
Before the plugin can be used for a given DSS user, it has to be enabled with its own profile. To do so, go to the DSS profile page > Credential, and click on the edit icon corresponding to the google-calendar preset. This will redirect the user to the Google Authentication page where they can allow DSS to access the data from their Calendar account.
This plugin has two components: a custom dataset and a recipe.
In a DSS flow, you can add a dataset by clicking on +Dataset > Google Calendar. Then, select the authentication preset created and activated in the previous steps. Specify the id of the calendar you want to consult. By default, it will be “primary”. You can narrow your Calendar Events search by adding a start and/or end date.
In some instance, you may want to retrieve the calendar of several resources, several time ranges, or a combination of both. To do so, create a dataset containing the combinations you want to retrieve, says a list of calendar ids of several resources.
Then use it as an input to the Google Calendar recipe: in your DSS flow, click +Recipe > Google Calendar.
Use the list of calendar id as input and create an output dataset. Pick a column name corresponding to each condition you want to search (any combination of calendar ids, from dates and end dates).
Next, run the recipe and the calendars corresponding to each line of the input dataset will be retrieved in the output dataset.
Obtain Google Calendar IDs
In many places, additional resources, such as room booking… can be obtained from your Google Calendar account. You can retrieve events related to them, using the plugin’s dataset or custom recipe. To do so, access the settings of the calendar you want access to.
Then, scroll down to the Integrate Calendar section and copy the calendar ID. Then use this ID directly in the calendar ID section of the dataset, or in a calendar ID column which of a dataset you then feed to the plugin’s recipe.