Release Notes

October 2024

We have added the is_real_open column to the ES_CAMPAIGN_OPENS and ES_TRIGGERED_OPENS tables.

We have added the is_real_click column to the ES_CAMPAIGN_CLICKS and ES_TRIGGERED_CLICKS tables.

We have added the client_id column to the ES_FLOW table.

For more information, see Sailthru's Email Event Stream Data Sets documentation.

We have added a new field, Historical Sync Time Frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. The default value selected is ALL_TIME. For an existing connector, you can edit the connection details and set the time frame value. We have also added support for the historic_sync_time_frame field for connectors created using the Create a Connector endpoint. For more information, see our Sailthru documentation and REST API config.

The historical sync limit only applies to the following tables:

• CAMPAIGN_QUERY
• PURCHASE
• PURCHASE_ITEM

August 2024

We have added a new event_id fieild.

We have also updated the event_time field to enable the millisecond precission for event stream tables. For more information, see Event Stream Changes.

Fivetran will re-sync data from March 19, 2024, for all the event stream tables

July 2024

You can now use your own S3 bucket to sync Sailthru Connect data. Previously, you had to use Fivetran's S3 bucket. To support this enhancement, we have added two new fields, S3 Bucket and Role ARN, to the setup form. We are gradually rolling out this improvement to all existing connectors.

June 2024

We can now pack all the custom fields of the LIST_STAT and USER tables into a single JSON file and upsert it into a single column. We have added a new field, Pack Mode, to the connector setup form. The field provides you the option to choose how Fivetran should handle your custom fields. This feature is useful when the number of columns in a table exceeded 9,900 columns. If Unpacked Mode is selected and the number of columns of your table exceeds 9,900 then we will truncate the columns to 9,900. For more information, see our Sailthru connector documentation.

January 2023

We have added the following new columns to the CAMPAIGN table:

• email_hour_range
• end_date
• is_public

We have added the following new columns to the LIST_STAT table:

• active_count
• disengaged_count
• email_count
• emailable_count
• engaged_count
• lists_count
• lists_signup_count
• optout_count
• passive_count
• valid_count

We now sync custom fields to the LIST_STAT table.

We have added three new columns, ip, ip_type, and user_agent, to the following tables:

• ES_CAMPAIGN_CLICKS
• ES_CAMPAIGN_OPENS
• ES_TRIGGERED_CLICKS
• ES_TRIGGERED_OPENS

January 2022

Our Sailthru connector is now generally available.

Read our Sailthru connector documentation.

September 2021

The Sailthru connector now supports Sailthru Connect. You can now sync Event Stream data from your Sailthru account. For more information, see our setup instructions.

March 2021

The Sailthru connector now supports table blocking for all Sailthru tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.

If you want to sync a child table, you must include the parent table in the sync.

September 2018

Fivetran now sets the _fivetran_deleted column value to true for deleted records in the USER and USER_LIST tables.