Tables
The connector models the data in Gmail as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Gmail Tables
| Name | Description |
| CSEIdentities | The client-side encryption (CSE) configuration for the email address of an authenticated user. Gmail uses CSE configurations to save drafts of client-side encrypted email messages, and to sign and send encrypted email messages. |
| CSEKeyPairs | Client-side encryption (CSE) key pairs used for signing and encryption operations. CSEKeyPairs store the private/public key pair information and associated metadata. |
| Delegates | Settings for a delegate. Delegates can read, send, and delete messages, as well as view and add contacts, for the delegator's account |
| Draft | Query Draft Messages in Gmail. |
| Filters | Query Filters in Gmail. |
| ForwardingAddresses | Query or create forwarding addresses. |
| Labels | Query Labels in Gmail. |
| MessageLabels | Query Message labels in gmail. A row will be returned for each label. |
| Messages | Query Messages in Gmail. |
| SendAs | Settings associated with a send-as alias, which can be either the primary login address associated with the account or a custom from address. Send-as aliases correspond to the Send Mail As feature in the web interface. |
| SendAsAliasSmimeInfo | Query, create or delete s/mime email configurations. |
| SENT | Query SENT Messages in Gmail. |