April 2019link
BigQuery DTSlink
The Replication frequency
field in the connector dashboard settings section now displays the exact replication frequency that you set in BigQuery DTS.
Reload Schemalink
You can now reload the schema from the connector schema tab to repopulate it with the latest changes in the source. This happens automatically on every sync, but now can be triggered manually on the connector details page.
New connectorslink
Kustomerlink
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.
Link to Kustomer Documentation
Squarelink
Square, Inc. is a financial services, merchant services aggregator, and mobile payment company.
Schema changeslink
Amplitudelink
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 those tables exist in
EVENT
table itself.
Google Adslink
We have removed support for the CAMPAIGN_CRITERIA_REPORT
because it does not contain a date
field, which we require for incremental updates.
Jiralink
Jira has deprecated the field key
and replaced it with account_id
(See JIRA deprecation note). 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
tableaccount_id
now populates theid
column - In the
USER_GROUP
tableaccount_id
now populates theuser_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.
Leverlink
We have added three new tables:
PANEL
PANEL_APPLICATION
PANEL_INTERVIEW
We have changed the data types of
head_count_total
,head_count_hired
andhead_count_infinite
fromInteger
toString
in theREQUISITION
table because Lever's API returns that data type as aString
.
Pendolink
We have changed the data type of n_id
in the VISITOR
table from Long
to String
.
QuickBookslink
- Added
credit_card_credit_id
field in theBILL_PAYMENT_LINE
table.
Shopifylink
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:
Table | Fields Added |
---|---|
PRODUCT_VARIANT | inventory_item_id |
FULFILMENT | location_id |
LOCATION | legacy , active |
ORDER_LINE_ITEMS | restock_type , location_id |
Stripelink
Added new table
CREDIT_NOTE
with the following fields:id
amount
created
currency
customer
invoice_id
livemode
memo
number
pdf
reason
refund_id
status
type
Zendesklink
In order to make it possible to create accurate measures of ticket metrics and SLA policy violations, we have improved how SCHEDULE's are represented. In a previous attempt, we added start_time_utc
and end_time_utc
to the SCHEDULE
table, but that did not account for daylight savings time. Instead, we are adding new tables that make it possible to accurately calculate the schedule in the applicable time zone throughout the year. To enact these improvments, we've made the following changes:
Added new table
DAYLIGHT_TIME
with the following fields:time_zone
year
daylight_start_utc
daylight_end_utc
daylight_offset
Added new table
TIME_ZONE
with the following fields:time_zone
standard_offset
Improvementslink
Facebook Ad Accountlink
Now supports multiple accounts with the same name.
Facebook Ad Insightslink
We have added an option to select your report configuration type in our setup form. You can use it to sync standard prebuilt reports.
Now supports week and month aggregations.
Now supports multiple accounts with the same name.
Google Analytics 360link
To improve sync speed for large datasets, we have implemented a method of syncing using a storage bucket. We have added the new field bucket_name
to the connector setup form. To leverage this improvement you need to:
1. Create a bucket. 2. Give its IAM account storage object admin
permission. 3. Enter its name in bucket_name
in the setup form.
Salesforcelink
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.
Zuoralink
We now capture deletes in V2 of our Zuora connector for the following tables:
- Account
- AccountingCode
- Amendment
- BillingRun
- ChargeMetrics
- CommunicationProfile
- Contact
- CreditBalanceAdjustment
- Export
- Feature
- Import
- Invoice
- InvoiceItem
- InvoiceItemAdjustment
- InvoicePayment
- JournalEntry
- JournalEntryItem
- JournalRun
- Order
- OrderAction
- OrderElp
- OrderItem
- OrderMrr
- OrderQuantity
- OrderTcb
- OrderTcv
- Payment
- PaymentMethod
- PaymentRun
- Product
- ProductFeature
- ProductRatePlan
- ProductRatePlanCharge
- ProductRatePlanChargeTier
- RatePlan
- RatePlanCharge
- RatePlanChargeTier
- Refund
- RefundInvoicePayment
- RevenueChargeSummary
- RevenueChargeSummaryItem
- RevenueEvent
- RevenueEventInvoiceItem
- RevenueEventInvoiceItemAdjustment
- RevenueEventItem
- RevenueEventItemCreditMemoItem
- RevenueEventItemDebitMemoItem
- RevenueEventItemInvoiceItem
- RevenueEventItemInvoiceItemAdjustment
- RevenueEventType
- RevenueSchedule
- RevenueScheduleCreditMemoItem
- RevenueScheduleDebitMemoItem
- RevenueScheduleInvoiceItem
- RevenueScheduleInvoiceItemAdjustment
- RevenueScheduleItem
- RevenueScheduleItemCreditMemoItem
- RevenueScheduleItemDebitMemoItem
- RevenueScheduleItemInvoiceItem
- RevenueScheduleItemInvoiceItemAdjustment
- Subscription
- SubscriptionProductFeature
- TaxationItem
- Usage