October 2021link
Dashboard Improvementslink
Status page linklink
We have added the Status page link to the left navigation bar of the dashboard.
The Status page link in the left navigation bar:
Fivetran AWS Ireland Serverslink
We have added new servers in the AWS Ireland (eu-west-1) region.
If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in Ireland, your data does not leave Ireland during processing.
We now support AWS PrivateLink connections to sources and destinations in the eu-west-1 region.
For more information, see our data residency documentation.
Transformations for dbt Corelink
Long dbt log events truncatedlink
dbt commands may produce output too large to be sent to external logging systems as a part of dbt_run_succeeded
and dbt_run_failed
log events. Now, we truncate dbt output for those log events if it exceeds 200 lines. To get the complete log, go to the Transformations page in your Fivetran dashboard and select the transformation you want to check. Then, select the particular run and view the Run Details.
New connectorslink
ADP Workforce Nowlink
ADP Workforce Now is a payroll and HR platform.
Read our ADP Workforce Now connector documentation.
Typeformlink
Typeform is an online survey management solution.
Read our Typeform connector documentation.
Zoho CRMlink
Zoho CRM is an online CRM platform that manages your sales, marketing, and customer support activities.
Read our Zoho CRM connector documentation.
Schema changeslink
Asanalink
We now sync the Multi-select enums
custom field.
Facebook Adslink
We have added two new fields, approximate_count_lower_bound
and approximate_count_upper_bound
, to the CUSTOM_AUDIENCE_HISTORY
table.
We have removed the approximate_count
field because it has been deprecated.
GitHublink
We have added the following new tables:
COMMIT_PULL_REQUEST
stores linking information between commits and their relevant pull requestsNOTE: Re-sync your connector to sync the data for all commits.
DEPLOYMENT
stores deployment informationDEPLOYMENT_STATUS
stores deployment status informationRELEASE
stores release informationASSET
stores asset information
We are gradually rolling out this feature to all existing connectors. Once it is available for your connector, you can manage the tables from the Schema tab of your Fivetran dashboard.
Greenhouselink
We have added a new column, priority
, to the JOB_STAGE
table.
Leverlink
We have added the following new columns to the REQUISITION
table:
approval_id
approval_status
approval_startedAt
approval_approvedAt
approval_accountId
approval_createdBy
Rechargelink
We have replaced the is_deleted
column in the SUBSCRIPTION
table with a new _fivetran_deleted
column. We have removed the is_deleted
column. Be sure to update your queries.
Stripelink
We have added a new column, invoice_line_item
, to the CREDIT_NOTE_LINE_ITEM
table.
Zendesk Supportlink
We have added a new table, USER_VOTE
, which stores the votes cast by a specific user. For more information, see Zendesk's documentation.
Improvementslink
BigQuerylink
We have improved our JSON flattening feature. We now apply our standard naming conventions to the JSON child column names. For example, we rename source columns such as 3h
and ABC Column
as _3_h
and abc_column
, respectively, in your destination. Previously, we didn't use the standard naming conventions for the JSON child column names.
We have implemented this change to reduce write failures on your BigQuery destination caused due to unsupported JSON child columns names.
NOTE: After renaming the columns, if we detect a conflict in the column names, we display a Task alert on your dashboard. Rename the columns present in the JSON object to prevent data integrity issues.
Boxlink
You can now configure your Box connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
Facebook Adslink
Now, during connector setup, if you don't provide the business_management
permission to access the business details fields, the connector setup tests pass with a warning. The warning lists the fields that we’ll skip during the sync. In addition, we generate a warning alert on your Fivetran dashboard. Previously, the setup tests failed without this permission.
Google Analytics 360link
Our Google Analytics 360 connector is now generally available.
Read our Google Analytics 360 connector documentation.
Google Drivelink
You can now configure your Google Drive connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
Iterablelink
We now support the inboxMessageImpression
, inboxSession
, and purchase
events. We sync the data into the EVENT
table.
Jiralink
You can now specify the Consumer Key in the connector setup form while creating an application link between Fivetran and your Jira installation. Previously, it was impossible to create an application link if the Consumer key we provided was used by another external application in your Jira installation.
Microsoft Advertisinglink
To stay up to date with Microsoft Authentication with OAuth requirements, we migrated connectors from the deprecated Live Connect APIs to the new Microsoft Identity Platform.
Now, Microsoft Advertising connectors created using our REST API and the dashboard use the Microsoft Identity Platform API endpoints for authorization. You should obtain the refresh token passed to the API using the Microsoft Identity Platform endpoints.
Outreachlink
We now sync metadata information about third-party data sources. We sync the metadata to the DATA_CONNECTIONS
table.
Pinterest Adslink
We now sync the pin_stats
and influencer_pin_stats
extra properties for the PIN_HISTORY
table.
PostgreSQLlink
We now support logical replication using the pgoutput
plugin. The pgoutput
plugin allows you to use PostgreSQL's publications feature. This feature only replicates change events from tables in your publication, so you control which changes are replicated to Fivetran. Learn more in our pgoutput
plugin documentation.
Salesforcelink
We have upgraded our Salesforce connector from version 50.0 to 53.0 of the Salesforce REST API. We have added support for the AuthorizationFormTextFeed object. We have removed support for the AppleDomainVerification object. We are gradually rolling out this new feature to all existing customers. If you'd like to enable this feature on your connector, contact our support team.
ServiceNowlink
We now capture deletes for ServiceNow. We are gradually rolling out this feature to all existing connectors. See our ServiceNow documentation for details.
REST API Improvementslink
Added connector_id
to Connect Card token endpoint responselink
We now return the connector_id
field in the Connect Card token endpoint response.
For more information, see our Connect Card documentation.
Show button removedlink
For improved security, we will remove the Show button in the API config section on the Security tab of your Account Management page.
The API key and secret are essentially credentials that allow you to access your account using the API. Never share your API key or secret with anyone.