SendGrid Event Webhooks

Configure SendGrid Event Webhook following the official documentation.

Endpoint

https://ingest.YOUR_FIRETIGER_TENANT_NAME.firetigerapi.com/sendgrid/

SendGrid Configuration

1. Go to Settings > Mail Settings > Event Webhook
2. Enter the Firetiger endpoint URL: https://ingest.YOUR_FIRETIGER_TENANT_NAME.firetigerapi.com/sendgrid/
3. Select the event types you want to capture
4. Enable the webhook

Tables

Each SendGrid event type is stored in its own table under sendgrid/events/{event-type}:

Event Type	Table
processed	sendgrid/events/processed
delivered	sendgrid/events/delivered
deferred	sendgrid/events/deferred
bounce	sendgrid/events/bounce
dropped	sendgrid/events/dropped
open	sendgrid/events/open
click	sendgrid/events/click
spamreport	sendgrid/events/spamreport
unsubscribe	sendgrid/events/unsubscribe
group_unsubscribe	sendgrid/events/group_unsubscribe
group_resubscribe	sendgrid/events/group_resubscribe

Tables are created automatically when the first event of that type is received. Schema inference automatically adapts to new fields from SendGrid.

Example Query

SELECT event.email, event.response, timestamp
FROM "sendgrid/events/delivered"
WHERE timestamp > '2024-01-01'