SendGrid

SendGrid is a cloud-based solution for email deliveries.

How to Connect

There are two ways to connect to Sendgrid: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the Data Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the SendGrid button in the list of connectors or type ‘sendgrid’ in the search field:

3. Contact the support team via chat to connect SendGrid.

Usage

The SendGrid API connector introduces a new virtual schema sendgrid that contains the following stored procedures:

• EmailActivities
• EmailActivitiesEvents

In addition to these public API procedures, there is the SendGrid_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping sendgrid_examples.