April 2019

Reload Schema

You can now reload the schema from the Schema tab of your Fivetran dashboard to repopulate it with the latest changes in the source. This happens automatically on every sync, but now you can manually trigger it on the connector details page.

New connectors

Kustomer

Kustomer is a software platform for customer experience, service, and support integrated with a number of sources to give support staff a complete picture of a customer when they contact the company.

Read our Kustomer connector documentation.

Square

Square, Inc. is a financial services, merchant services aggregator, and mobile payment company.

Read our Square connector documentation.

Schema changes

Amplitude

We have deleted the USER table and all its dependent tables:

• USER_ALIAS_ID
• USER_AMPLITUDE_ID
• USER_ALIASING_PROFILE
• USER_PROPERTY
• USER_MERGE_TIME

All the information in these tables exist in the EVENT table.

Google Ads

We have removed support for the CAMPAIGN_CRITERIA_REPORT because it does not contain a date field, which we require for incremental updates.

Jira

Jira has deprecated the field key and replaced it with account_id.

Because we used key to form the primary key in the USER and USER_GROUP tables, we have made changes to those two tables:

• In the USER table, account_id now populates the id column.
• In the USER_GROUP, table account_id now populates the user_id column.

This change will cause the USER and USER_GROUP tables to have duplicated records based on our previous primary keys for them which were based on the deprecated key. To remove duplicate data in the USER and USER_GROUP tables, drop the USER and USER_GROUP tables and perform a full re-sync.

Lever

We have added three new tables:

• PANEL
• PANEL_APPLICATION
• PANEL_INTERVIEW

We have changed the data types of head_count_total, head_count_hired, and head_count_infinite from INT to STRING in the REQUISITION table because Lever's API returns that data type as a STRING.

Pendo

We have changed the data type of n_id column in the VISITOR table from LONG to STRING.

QuickBooks

We have added a new column, credit_card_credit_id, to the BILL_PAYMENT_LINE table.

Shopify

To integrate Shopify's multi location inventory support, we have added two new tables and added fields to four existing tables.

New tables added:

• INVENTORY_LEVEL
• INVENTORY_ITEM

New fields added:

Stripe

We have added a new table, CREDIT_NOTE with the following columns:

• id
• amount
• created
• currency
• customer
• invoice_id
• livemode
• memo
• number
• pdf
• reason
• refund_id
• status
• type

Zendesk Support

In order to make it possible to create accurate measures of ticket metrics and SLA policy violations, we have now improved the way SCHEDULEs are represented. Previously, we added start_time_utc and end_time_utc columns to the SCHEDULE table, but that did not account for daylight saving time. We have now added new tables to accurately calculate the schedule in the applicable time zone throughout the year. To implement these improvements, we have made the following schema changes:

• Added a new table, DAYLIGHT_TIME, with the following columns:

  • daylight_end_utc
  • daylight_offset
  • daylight_start_utc
  • time_zone
  • year

• Added a new table, TIME_ZONE, with the following columns:

  • standard_offset
  • time_zone

Improvements

Salesforce

You can now configure your Salesforce connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

Zuora

We now capture deletes in V2 of our Zuora connector for the following tables:

• ACCOUNT
• ACCOUNTING_CODE
• AMENDMENT
• BILLING_RUN
• CHARGE_METRICS
• COMMUNICATION_PROFILE
• CONTACT
• CREDIT_BALANCE_ADJUSTMENT
• EXPORT
• FEATURE
• IMPORT
• INVOICE
• INVOICE_ITEM
• INVOICE_ITEM_ADJUSTMENT
• INVOICE_PAYMENT
• JOURNAL_ENTRY
• JOURNAL_ENTRY_ITEM
• JOURNAL_RUN
• ORDER
• ORDER_ACTION
• ORDER_ELP
• ORDER_ITEM
• ORDER_MRR
• ORDER_QUANTITY
• ORDER_TCB
• ORDER_TCV
• PAYMENT
• PAYMENT_METHOD
• PAYMENT_RUN
• PRODUCT
• PRODUCT_FEATURE
• PRODUCT_RATE_PLAN
• PRODUCT_RATE_PLAN_CHARGE
• PRODUCT_RATE_PLAN_CHARGE_TIER
• RATE_PLAN
• RATE_PLAN_CHARGE
• RATE_PLAN_CHARGE_TIER
• REFUND
• REFUND_INVOICE_PAYMENT
• REVENUE_CHARGE_SUMMARY
• REVENUE_CHARGE_SUMMARY_ITEM
• REVENUE_EVENT
• REVENUE_EVENT_INVOICE_ITEM
• REVENUE_EVENT_INVOICE_ITEM_ADJUSTMENT
• REVENUE_EVENT_ITEM
• REVENUE_EVENT_ITEM_CREDIT_MEMO_ITEM
• REVENUE_EVENT_ITEM_DEBIT_MEMO_ITEM
• REVENUE_EVENT_ITEM_INVOICE_ITEM
• REVENUE_EVENT_ITEM_INVOICE_ITEM_ADJUSTMENT
• REVENUE_EVENT_TYPE
• REVENUE_SCHEDULE
• REVENUE_SCHEDULE_CREDIT_MEMO_ITEM
• REVENUE_SCHEDULE_DEBIT_MEMO_ITEM
• REVENUE_SCHEDULE_INVOICE_ITEM
• REVENUE_SCHEDULE_INVOICE_ITEM_ADJUSTMENT
• REVENUE_SCHEDULE_ITEM
• REVENUE_SCHEDULE_ITEM_CREDIT_MEMO_ITEM
• REVENUE_SCHEDULE_ITEM_DEBIT_MEMO_ITEM
• REVENUE_SCHEDULE_ITEM_INVOICE_ITEM
• REVENUE_SCHEDULE_ITEM_INVOICE_ITEM_ADJUSTMENT
• SUBSCRIPTION
• SUBSCRIPTION_PRODUCT_FEATURE
• TAXATION_ITEM
• USAGE