Supernova home
Documentation menu

Postmark#

Connect Postmark with server and account API tokens. The source writes 5 fixed tables under titan.postmark.

sql
select
  id,
  name,
  description
from titan.postmark.message_streams
limit 10

Connect Postmark#

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

  2. Enter server and account API tokens.

  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#

Message streams, outbound messages, bounces, templates, and sender signatures 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#

message_streams#

titan.postmark.message_streams has 6 source columns.

postmark.message_streams6 columns
idstringpk

Source field id.

namestring

Source field name.

descriptionstring

Source field description.

message_stream_typestring

Source field messageStreamType.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

outbound_messages#

titan.postmark.outbound_messages has 8 source columns.

postmark.outbound_messages8 columns
message_idstringpk

Source field messageID.

tojson

Source field to.

fromstring

Source field from.

subjectstring

Source field subject.

statusstring

Source field status.

received_atdatetime

Source field receivedAt.

tagstring

Source field tag.

message_streamstring

Source field messageStream.

bounces#

titan.postmark.bounces has 8 source columns.

postmark.bounces8 columns
idintegerpk

Source field id.

typestring

Source field type.

message_idstring

Source field messageID.

descriptionstring

Source field description.

bounced_atdatetime

Source field bouncedAt.

emailstring

Source field email.

subjectstring

Source field subject.

message_streamstring

Source field messageStream.

templates#

titan.postmark.templates has 5 source columns.

postmark.templates5 columns
template_idintegerpk

Source field templateId.

namestring

Source field name.

subjectstring

Source field subject.

activeboolean

Source field active.

template_typestring

Source field templateType.

sender_signatures#

titan.postmark.sender_signatures has 5 source columns.

postmark.sender_signatures5 columns
idintegerpk

Source field id.

domainstring

Source field domain.

email_addressstring

Source field emailAddress.

confirmedboolean

Source field confirmed.

created_atdatetime

Source field createdAt.

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.