Release Notes

July 2026

We have made the following schema changes to the Recurly connector.

We've added the following new tables:

EXTERNAL_ACCOUNT_HISTORY
EXTERNAL_SUBSCRIPTION
EXTERNAL_SUBSCRIPTION_PAYMENT_PHASE
GIFT_CARD
INVOICE_LINE_ITEM
INVOICE_TAX_DETAIL
INVOICE_TRANSACTION_HISTORY
LINE_ITEM_TAX_DETAIL
PLAN_ADD_ON_CURRENCY_PERCENTAGE_TIER
PLAN_ADD_ON_TIER_HISTORY
PLAN_SETUP_FEES
SUBSCRIPTION_CREDIT_INVOICE
SUBSCRIPTION_RAMP_INTERVAL
TRANSACTION_FRAUD_INFO_RISK_RULES_TRIGGERED
USAGE_RECORD
USAGE_RECORD_PERCENTAGE_TIERS
USAGE_RECORD_TIERS

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

account_geo_code
bill_date
dunning_campaign_id
entity_use_code
has_active_subscription
has_canceled_subscription
has_future_subscription
has_live_subscription
has_past_due_invoice
has_paused_subscription
invoice_template_id
override_business_entity_id
preferred_time_zone

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

account_geo_code
backup_payment_method
bill_date
billing_geo_code
entity_use_code
has_past_due_invoice
payment_gateway_references
payment_method_account_type
payment_method_billing_agreement_id
payment_method_card_network_preference
payment_method_cc_bin_country
payment_method_funding_source
payment_method_gateway_attributes_account_reference
payment_method_gateway_code
payment_method_last_two
payment_method_name_on_account
payment_method_routing_number
payment_method_routing_number_bank
payment_method_username
primary_payment_method

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

geo_code
street_1
street_2

We have added the available_credit_amount and processing_prepayment_amount column to the ACCOUNT_BALANCE_HISTORY table.

We have added a new column, acquired_at, to the ACCOUNT_ACQUISITION_HISTORY table.

We have added a new column, subscription_id, to the COUPON_REDEMPTION_HISTORY table.

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

address_geo_code
address_name_on_account
address_phone
address_street_1
address_street_2
billing_info_id
business_entity_id
credit_payments
customer_notes
dunning_campaign_id
dunning_events_sent
final_dunning_event
gateway_code
has_more_line_items
object
origin
reference_only_currency_conversion_currency
reference_only_currency_conversion_date
reference_only_currency_conversion_rate
reference_only_currency_conversion_source
reference_only_currency_conversion_subtotal_in_cents
reference_only_currency_conversion_tax_in_cents
refundable_amount
shipping_address_geo_code
shipping_address_id
shipping_address_nickname
shipping_address_object
shipping_address_street_1
shipping_address_street_2
shipping_address_vat_number
terms_and_conditions
used_tax_service
uuid
vat_number
vat_reverse_charge_notes

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

avalara_service_type
avalara_transaction_type
bill_for_account_id
destination_tax_address_source
external_sku
harmonized_system_code
item_code
item_id
liability_gl_account_code
origin_tax_address_source
performance_obligation_id
quantity_decimal
refunded_quantity_decimal
revenue_gl_account_code
shipping_address_id
tax_inclusive
unit_amount_decimal

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

add_on_type
avalara_service_type
avalara_transaction_type
external_sku
harmonized_system_code
item_code
item_description
item_id
item_name
item_object
item_state
liability_gl_account_id
measured_unit_id
performance_obligation_id
revenue_gl_account_id
usage_calculation_type
usage_percentage
usage_timeframe
usage_type

We have added the tax_inclusive and unit_amount_decimal columns to the PLAN_ADD_ON_CURRENCY_HISTORY table.

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

allow_any_item_on_subscriptions
avalara_service_type
avalara_transaction_type
dunning_campaign_id
harmonized_system_code
hosted_page_bypass_confirmation
hosted_page_cancel_url
hosted_page_display_quantity
hosted_page_success_url
liability_gl_account_id
performance_obligation_id
pricing_model
revenue_gl_account_id
revenue_schedule_type
setup_fee_liability_gl_account_id
setup_fee_performance_obligation_id
setup_fee_revenue_gl_account_id
setup_fee_revenue_schedule_type
trial_requires_billing_info
vertex_transaction_type

We have added the price_segment_id and tax_inclusive columns to the PLAN_CURRENCY_HISTORY table.

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

action_result
active_invoice_id
bank_account_authorized_at
billing_info_id
business_entity_id
credit_application_policy_mode
gateway_code
invoice_collection_charge_invoice_id
net_terms_type
next_action
price_segment_id
shipping_address_object
shipping_amount
shipping_method_code
shipping_method_id
shipping_method_name
shipping_method_object
tax
tax_inclusive
total

We have added the add_on_source and unit_amount_decimal columns to the SUBSCRIPTION_ADD_ON_HISTORY table.

We have added the billing_info_three_d_secure_action_result_token_id and tax_inclusive columns to the SUBSCRIPTION_CHANGE_HISTORY table.

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

action_result
backup_method_used
billing_geo_code
billing_phone
fraud_info_decision
fraud_info_object
fraud_info_reference
fraud_info_score
initiator
next_action_type
next_action_value
payment_method_account_type
payment_method_billing_agreement_id
payment_method_card_network_preference
payment_method_cc_bin_country
payment_method_funding_source
payment_method_gateway_attribute_account_reference
payment_method_gateway_code
payment_method_last_two
payment_method_name_on_account
payment_method_routing_number
payment_method_routing_number_bank
payment_method_username

We have added a new column, bulk_coupon_id, to the BULK_UNIQUE_CODE table.

October 2025

We unified each connector’s pre-built dbt Core–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

December 2024

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

November 2024

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

August 2024

We have made the following changes to the Schema tab for connections 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 connections created on or after August 13, 2024:

added a new table, SUBSCRIPTION_GIFT_CARD_MAPPING
removed the coupon_id column from the primary key of the COUPON_DISCOUNT table
removed the started_with_gift and converted_at columns from the SUBSCRIPTION_HISTORY table

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.

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 connections. 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 discontinue 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 connector. 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.