Data Model
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Tables
The Tables section outlines standard SQL tables, while the Views section lists read-only SQL tables. Both sections provide examples of the files you might have access to in your Google Drive account.
The following tables and views are shipped with the add-in:
| Table | Description |
| Drives | Manages shared drives for a user by allowing creation, deletion, and querying of drive properties and membership. |
| Files | Handles operations on files and folders in Google Drive, such as retrieving file details, modifying metadata, and organizing file structure. |
| Permissions | Manages user and group access permissions for Drive resources, supporting fine-grained control over sharing and collaboration. |
| Docs | Returns metadata about Google Docs stored in a user's Drive, including document titles, creation dates, and sharing settings. |
| Folders | Provides detailed information about folder hierarchies and metadata in a user's Google Drive. |
| Photos | Retrieves image files from Google Drive along with metadata such as resolution, format, and upload timestamps. |
| Sheets | Returns metadata and properties for Google Sheets documents stored in Drive, such as spreadsheet titles and modification history. |
| Videos | Lists video files in Drive and provides metadata like duration, resolution, and playback compatibility. |
Stored Procedures
Stored Procedures are SQL scripts that extend beyond standard CRUD operations. They accept parameters, execute functions, manage OAuth authentication tokens, and return data from the service, indicating success or failure.