Google Drive Reader

Note

This adapter is in preview and is available on Striim Developer only. See Striim Developer for more information.

Google Drive is a cloud-based storage service that allows users to store, access, and share files online across multiple devices. It offers free web-based applications for creating documents, spreadsheets, and presentations, with 15 GB of free storage. Users can easily upload, organize, and collaborate on files from anywhere with an internet connection.

You can use the Google Drive Reader to connect with the Google drive platform and read data from objects/tables.

Feature summary

Feature		Supported?	Notes
Objects	Standard objects	✓
Objects	Custom objects	✓
Authentication	Basic authentication		Username and password
	OAuth authentication	✓	Manual configuration based
	Custom authentication methods		Not all methods may be supported
Operations	Automated mode	✓
	Initial load	✓
	Pull-based incremental load	✓
	Push-based incremental load
	Automated pipeline
Governance	Connection profile
	Sherlock AI
	Sentinel AI
Schema handling	Initial schema creation	✓	Works with supported targets
Schema handling	Schema evolution
Setup	Wizard template
	Flow Designer	✓
	Striim TQL	✓
Runtime	Resilience/recovery	✓
	Parallel execution
	Metrics	✓	Standard metrics

Supported authentication method

The Google Drive Reader supports OAuth authentication. To obtain the client credentials needed:

Create a project in the Google Cloud console.
Enable the Google Drive API.
To get the authorization URL for the Google Drive API construct this URL with the following key parameters:
```
https://accounts.google.com/o/oauth2/v2/auth?
client_id=CLIENT_ID&redirect_uri=http://127.0.0.1/&response_type=code&scope=
https://www.googleapis.com/auth/drive.readonly https://www.googleapis.com/auth/drive.metadata 
https://www.googleapis.com/auth/drive.file&access_type=offline
```
- CLIENT_ID: The client ID from your Google Cloud console credentials.
- scope: Specifies full Google Drive API access.
- redirect_uri: Indicates the authorization code will be returned in the browser window.

To get a refresh token:

curl -X POST \  
https://oauth2.googleapis.com/token \  
-H "Content-Type: application/x-www-form-urlencoded" \  
-d "code=[AUTHORIZATION_CODE]" \  
-d "client_id=[CLIENT_ID]" \  
-d "client_secret=[CLIENT_SECRET]" \  
-d "redirect_uri=http://127.0.0.1/" \  
-d "grant_type=authorization_code"

[AUTHORIZATION_CODE]: The authorization code you received from the Google OAuth consent screen.
[CLIENT_ID]: Your Google Cloud console client ID.
[CLIENT_SECRET]: Your Google Cloud console client secret.

Supported objects

The Google Drive Reader supports reading the following objects from Google Drive:

Docs
Drives
Files
Folders
Permissions
Photos
Sheets
Videos