Data Model
Overview
This section shows the available API objects and provides more information on executing SQL to GoogleContacts APIs.
Key Features
- The connector models GoogleContacts entities like documents, folders, and groups as relational views, allowing you to write SQL to query GoogleContacts data.
- Stored procedures allow you to execute operations to GoogleContacts.
- Live connectivity to these objects means any changes to your GoogleContacts account are immediately reflected when using the connector.
- INSERT support for ContactGroups, My Contacts, and Starred tables. Note that the latter two are generated dynamically so are not part of this documentation.
Tables
The connector models the GoogleContacts API as relational Tables.
Views
Views offer additional metadata information from GoogleContacts.
Stored Procedures
Stored Procedures are function-like interfaces to GoogleContacts. Stored procedures allow you to execute operations to GoogleContacts, including downloading documents and moving envelopes.