Release Notes

November 2024

The Recurly connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

We have updated the Quickstart packages for the following connectors:

• Amplitude to version 0.5.0
• Apple Search Ads to version 0.4.1
• Facebook Ads to version 0.8.0
• HubSpot to version 0.20.0
• Iterable to version 0.13.0
• Jira to version 0.19.0
• LinkedIn Ad Analytics to version 0.9.1
• Recurly to version 0.5.1
• Reddit Ads to version 0.3.1
• Zendesk Support to version 0.18.1

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

August 2024

We have made the following changes to the Schema tab for connectors created on or after August 13, 2024:

• We now display all table names in lowercase
• We now display all tables, including the empty tables
• We no longer support table-level selection and deselection for syncing

We have made the following schema changes for connectors created on or after August 13, 2024:

• Removed coupon_id as a primary key from the COUPON_DISCOUNT table
• Removed started_with_gift and converted_at columns from the SUBSCRIPTION_HISTORY table
• Introduced the new table, SUBSCRIPTION_GIFT_CARD_MAPPING

July 2023

We have added a new table, BULK_UNIQUE_CODE, to map bulk coupon codes with their respective unique coupon codes.

October 2022

We have released pre-built, dbt Core*-compatible data models for Recurly. Find the models in Fivetran's dbt hub. Learn more in our Fivetran Data Models documentation.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

March 2021

We have added two new columns, started_with_gift and converted_at, to the SUBSCRIPTION table. See Recurly's lookup subscription documentation for more information.

January 2021

We have added a new table, GIFT_CARD. We are gradually rolling out this new feature to all existing connectors. If you'd like to enable the table on your connector, contact our support team.

We have fixed a bug where the first name and last name values returned by the Recurly API were sometimes not synced to your destination. Trigger a re-sync to ensure data integrity.

October 2020

We now mask the characters you enter in the API Key field of the connector setup form. We have changed the API Key field type from TextField to PasswordField to improve security.

June 2020

We have added three new fields to replace the following fields in the TRANSACTION table:

• payment_gateway_id replaces payment_gatewayid
• payment_gateway_type replaces payment_gatewaytype
• payment_gateway_name replaces payment_gatewayname

Update your queries with the new field names to sync data into these fields.

April 2020

We have added a new child table, COUPON_DISCOUNT, to the COUPON_HISTORY table. We have moved the following fields from the parent table to the child table:

• discount_type
• discount_percentage
• discount_currency_type
• discount_currency_amount
• discount_trial_unit
• discount_trial_length

January 2020

We have added three new history tables to replace the following tables:

• COUPON_PLAN_HISTORY will replace COUPON_PLAN.
• INVOICE_SUBSCRIPTION_HISTORY will replace INVOICE_SUBSCRIPTION.
• SUBSCRIPTION_COUPON_REDEMPTION_HISTORY will replace SUBSCRIPTION_COUPON_REDEMPTION.

We will update all six tables with for three months, then deprecate the replaced tables. Be sure to update your queries with the new history table names before we remove the old tables.

July 2019

We have changed the way we perform the initial sync for our Recurly connectors. Previously during the initial sync, our Recurly connector scanned for records from EPOCH to the time when the initial sync started.

Now Fivetran scans in reverse and completes the initial sync in small batches. Every sync fetches records created in the past between two dates that differ by 7 days. This process continues until we reach the beginning of time.

May 2019

We have released a new version of the Recurly connector. The new version contains changed, added, and deprecated tables. In the existing tables we have added new columns and removed the deprecated ones. See the schema for details.

• Added tables:

  • ACCOUNT_BALANCE
  • ACCOUNT_NOTE
  • ACCOUNT_ACQUISITION
  • BILLING_INFO
  • COUPON_PLAN
  • CREDIT_PAYMENT
  • INVOICE_SUBSCRIPTION
  • LINE_ITEM
  • PAYMENT_METHOD
  • PLAN_ADD_ON_CURRENCY
  • PLAN_CURRENCY
  • SUBSCRIPTION_CHANGE
  • SUBSCRIPTION_COUPON_REDEMPTION
  • TRANSACTION_SUBSCRIPTION

• Deprecated tables

  • ADJUSTMENT
  • CURRENCY

Connect to the new Recurly connector.

Read our Recurly connector documentation..

May 2018

We have added two new columns, start_date and end_date, to the ADJUSTMENT table.