SQL examples for ODBC
The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Google Drive.
- Create a folder
- Delete a file
- Delete a file by name from a shared drive
- Delete a folder
- Download a file (my drive)
- Download a file from a shared drive
- Empty trash
- Empty trash for a shared drive
- Export file to another format (e.g., Excel or PDF)
- Get file information
- Get files list
- Get folders list
- Get information about a shared drive
- Get items list
- Get items list using query
- Get my drive information
- List / search files from a single shared drive
- List / search files from all shared drives
- List / search files from my drive
- List all shared drives
- List files
- List items from a parent folder (recursive or non-recursive)
- List trash
- List trash for a shared drive
- Update a file
- Upload a file with INSERT
- Upload file to shared drive folder (overwrite if exists)