Supernova home
Documentation menu

SendGrid#

Connect SendGrid with an API key. The source writes 6 fixed tables under titan.sendgrid.

sql
select
  id,
  email,
  first_name
from titan.sendgrid.contacts
limit 10

Connect SendGrid#

  1. Open Apps, choose Connect app, and select SendGrid.

  2. Enter an API key.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Contacts, lists, campaigns, email templates, suppressions, and global unsubscribes sync together.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

contacts#

titan.sendgrid.contacts has 9 source columns.

sendgrid.contacts9 columns
idstringpk

Source field id.

emailstring

Source field email.

first_namestring

Source field firstName.

last_namestring

Source field lastName.

citystring

Source field city.

countrystring

Source field country.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

custom_fieldsjson

Source field customFields.

lists#

titan.sendgrid.lists has 5 source columns.

sendgrid.lists5 columns
idstringpk

Source field id.

namestring

Source field name.

contact_countinteger

Source field contactCount.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

campaigns#

titan.sendgrid.campaigns has 6 source columns.

sendgrid.campaigns6 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

send_atdatetime

Source field sendAt.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

templates#

titan.sendgrid.templates has 4 source columns.

sendgrid.templates4 columns
idstringpk

Source field id.

namestring

Source field name.

generationstring

Source field generation.

updated_atdatetime

Source field updatedAt.

suppressions#

titan.sendgrid.suppressions has 4 source columns.

sendgrid.suppressions4 columns
emailstringpk

Source field email.

reasonstring

Source field reason.

statusstring

Source field status.

created_atdatetime

Source field createdAt.

global_unsubscribes#

titan.sendgrid.global_unsubscribes has 2 source columns.

sendgrid.global_unsubscribes2 columns
emailstringpk

Source field email.

createddatetime

Source field created.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.