# Google Drive

Google Drive Connector is a data storage service provided by Google that enables users to store data and access any amount of data, anytime, from anywhere on the web.

OvalEdge uses SDK (V2 1.32.1) to connect to the data source, which allows the user to crawl data objects such as Files & Folders.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeA6I1VJpbialg-7S0FQ4pk4fjb5uebMcdeyycZP6o7CnJOq8LXAETn3jyP5Aa6OlkriuM8SZHg7x4xulFy3cyp6SaOkZae56GvpknIcw4__EcEHO2FmOEOu7IPOtd51iB0i7wVTSraaD3IkobYydgs33od?key=EjEpFfm8pFWyCMl4pFTvsg" alt=""><figcaption></figcaption></figure>

| Important: This document focuses on specific information relevant to this particular connector. Details about Establishing Connections, Connector Parameters, and Connector Settings will be found in the "[Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit)" document. |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

## Connector Characteristics

| Connector Category                                                                                                                                    | File System |
| ----------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| Connectivity                                                                                                                                          | Java SDK    |
| <p>Connector Version</p><p>\[OvalEdge Connector Version Information]</p>                                                                              | 6.3.1       |
| <p>Google Drive source Versions Supported </p><p>\[Data Source Version from which OvalEdge started providing support]</p>                             | V2          |
| <p>OvalEdge Releases Supported (Available from)</p><p>\[OvalEdge Release Version in which the connector was included in the OvalEdge Application]</p> | 6.1 onwards |

## Supported Features

| Crawling of Metadata Objects                                                                                                                                                                                                                                                                                                                  | <p>Folders</p><p>Files</p>                                                                                                   |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| Metadata Source                                                                                                                                                                                                                                                                                                                               | Using Java SDK                                                                                                               |
| <p>Supported File Types:</p><p>Cataloged file types: configure at system settings</p><p><br></p>                                                                                                                                                                                                                                              | <p>CSV, XLS, XLSX, JSON, AVRO, PARQUET, ORC, GZ</p><p>Will be included in System Settings</p><p>Add System Settings link</p> |
| Profiling                                                                                                                                                                                                                                                                                                                                     | Not Supported                                                                                                                |
| Data Preview                                                                                                                                                                                                                                                                                                                                  | Not Supported                                                                                                                |
| <p>Data Quality Module</p><p>More info on DQ: <a href="https://docs.google.com/document/u/0/d/1I_F7aKv_QSVw1A1FWvEyMSZADueOVhfCnLAQDfwctGc/edit">Data Quality</a></p>                                                                                                                                                                         | Not Supported                                                                                                                |
| <p>RDAM (Remote Data Access Management) Support</p><p>More info: <a href="https://support.ovaledge.com/snowflake-rdam">RDAM</a></p>                                                                                                                                                                                                           | Not Supported                                                                                                                |
| <p>Bridge Support</p><p>\[The Bridge component is used as a Tunnel to Transfer Data from the Client-Hosted Cloud or Client-on-Premises Data Center. The handshake between the Bridge Server and Client is established with a Security Tool Kit (these differ from client to client and are generated based on the IP address/DNS, etc.).]</p> | <p>Supported</p><p>Note: Need to add Bridge configurations in detailed steps</p>                                             |
| <p>Crawl of Usage Statistics (Source System)</p><p>\[This involves systematically collecting, analyzing, and reporting on data related to user activities, including details on which users are accessing the system, their actions, and the frequency of their access.]</p>                                                                  | Not Supported                                                                                                                |
| <p>Certifications at Source (Source System)</p><p>\[This refers to endorsing metadata objects applied within the source system. These certifications are then fetched and displayed in OvalEdge, enabling more in-depth analysis.]</p>                                                                                                        | Not Supported                                                                                                                |

## Prerequisites (Prepare Google Drive Environment)

The following are the prerequisites required for establishing a connection:&#x20;

1. SDK Details

SDK is provided by default over the OvalEdge installation.&#x20;

| Type | Version | Details                                                                                              |
| ---- | ------- | ---------------------------------------------------------------------------------------------------- |
| SDK  | 1.32.1  | <https://mvnrepository.com/artifact/com.google.apis/google-api-services-drive/v2-rev20210707-1.32.1> |

2. Google Drive User Account and Permissions&#x20;

Create a Google Drive Connector service account to connect to OvalEdge with the following permissions to be able to crawl metadata into OvalEdge.&#x20;

| Operation             | Minimum Access Permission                               |
| --------------------- | ------------------------------------------------------- |
| Connection Validation | LIST, GET permission on Crawling Folders                |
| Crawling              | LIST, GET permission on Crawling Folders & File Objects |

3. Configure Environment Variables (Optional).

This section describes the settings or instructions you should know before establishing a connection. If your environments have been configured, skip this step.

For more information, refer to the "[Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit)" document.

### Establish Connection

In the OvalEdge application, the Google Drive connector allows you to crawl the data objects using Credential Manager Authentication.

The "[Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit)" document covers general settings and parameters common to most OvalEdge connectors. Here, we'll focus on the specific details required to configure the Google Drive Connector.

## Google Drive Connector-Specific Parameters

| Fields                   | Details                                                                                                                                                                |
| ------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Google Service Account\* | It is a special type of Google account intended for server-to-server interactions. It allows your application to authenticate and access Google APIs programmatically. |
| File Path\*              | The file path of Google Console access file  (.P12).                                                                                                                   |

Important: \* (asterisk) indicates the mandatory field to create a connection.&#x20;

After entering the required parameters, you can either save the connection details first or validate the connection and then save it.

### Errors & Resolution

You may encounter the following errors if the correct parameters are not provided while establishing the connection. Below are the most common error messages and their resolutions for your reference.&#x20;

If you continue to experience issues with establishing the connection, please contact your assigned OvalEdge Customer Success Management (CSM) team

| S.No. | Error Message(s)         | Error Description/Resolution                                                                                                                                                                                                                                                                                                   |
| ----- | ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 1     | Invalid Credentials      | <p>Error Description:</p><p>The service account credentials JSON file is incorrect or missing.</p><p>Resolution:</p><ul><li>Ensure the correct JSON file is used and that it hasn't been modified. </li><li>Verify that the credentials file corresponds to the service account created in the Google Cloud Console.</li></ul> |
| 2     | Insufficient Permissions | <p>Error Description:</p><p>The service account does not have the necessary permissions to access the specified file or folder.</p><p>Resolution:</p><ul><li>Share the required files or folders with the service account's email address and ensure it has the necessary permissions (e.g., Viewer or Editor).</li></ul>      |
| 3     | File Not Found           | <p>Error Description:</p><p>The specified file ID or URL is incorrect, or the file does not exist in Google Drive.</p><p>Resolution:</p><ul><li>Verify the file ID or URL and ensure the file exists in the shared Google Drive.</li></ul>                                                                                     |
| 4     | Access Denied            | <p>Error Description: </p><p>The Google Drive API is not enabled for the project.</p><p>Resolution:</p><ul><li>Enable the Google Drive API in the Google Cloud Console for the project associated with the service account.</li></ul>                                                                                          |

Connector Settings

After successfully validating the connection, you can access various settings to retrieve specific information from the data source.

The following are settings specific to Google Drive

* Crawler
* Access Instruction
* Business Glossary

For more information, refer to the "[Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit)" document.

### Limitations

| S.No. | Description                |
| ----- | -------------------------- |
| 1     | Profiling is not supported |

### Planned Upgrades

| S.No. | Expected Date | Upgrade Version | Description |
| ----- | ------------- | --------------- | ----------- |
| None  |               |                 |             |

### FAQs

1. How do you configure a Google Drive Connector?

Answer: Configuring a Google Drive Connector typically involves several steps, including setting up a Google Service Account, enabling the Google Drive API, and configuring your application to use the connector.&#x20;

## Additional Information

Step-by-Step Guide to Configuring a Google Drive Connector

### Create a Google Cloud Project

1. Go to Google Cloud Console: Visit the Google Cloud Console.
2. Create a New Project: Click on the project dropdown menu at the top and select "New Project." Fill in the project name and other required details, then click "Create."

### Enable the Google Drive API

1. Enable API:
2. Navigate to API & Services > Library.
3. Search for "Google Drive API."
4. Click on it and then click "Enable."

### Create a Service Account

1. Navigate to Service Accounts:
2. Go to API & Services > Credentials.
3. Click on "Create Credentials" and select "Service Account."
4. Configure Service Account:
5. Fill in the details such as name, ID, and description.
6. Click "Create" and then "Done."
7. Grant Permissions to Service Account:
8. Go to IAM & Admin > IAM.
9. Click on "Add" and enter the service account email.
10. Assign necessary roles (e.g., "Viewer" or "Editor").
11. Create and Download the Key:
12. Navigate back to API & Services > Credentials.
13. Click on your service account.
14. Go to "Keys" and click "Add Key" > "Create New Key."
15. Choose JSON format and download the key file. Store it securely as it contains sensitive information.

**Share Google Drive Files with the Service Account**

* Go to Google Drive and share the required files or folders with the service account's email address (e.g., <your-service-account@your-project-id.iam.gserviceaccount.com>).