October 2021

Dashboard Improvements

Status page link

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 Servers

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 Core

Long dbt log events truncated

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 connectors

ADP Workforce Now

ADP Workforce Now is a payroll and HR platform.

Read our ADP Workforce Now connector documentation.

Typeform

Typeform is an online survey management solution.

Read our Typeform connector documentation.

Zoho CRM

Zoho CRM is an online CRM platform that manages your sales, marketing, and customer support activities.

Read our Zoho CRM connector documentation.

Schema changes

Asana

We now sync the Multi-select enums custom field.

Facebook Ads

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.

GitHub

We have added the following new tables:

• COMMIT_PULL_REQUEST stores linking information between commits and their relevant pull requests

  NOTE: Re-sync your connector to sync the data for all commits.

• DEPLOYMENT stores deployment information

• DEPLOYMENT_STATUS stores deployment status information

• RELEASE stores release information

• ASSET 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.

Greenhouse

We have added a new column, priority, to the JOB_STAGE table.

Lever

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

• approval_id
• approval_status
• approval_startedAt
• approval_approvedAt
• approval_accountId
• approval_createdBy

Recharge

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.

Stripe

We have added a new column, invoice_line_item, to the CREDIT_NOTE_LINE_ITEM table.

Zendesk Support

We have added a new table, USER_VOTE, which stores the votes cast by a specific user. For more information, see Zendesk's documentation.

Improvements

BigQuery

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.

Box

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 Ads

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 Drive

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.

Iterable

We now support the inboxMessageImpression, inboxSession, and purchase events. We sync the data into the EVENT table.

Jira

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 Advertising

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.

Outreach

We now sync metadata information about third-party data sources. We sync the metadata to the DATA_CONNECTIONS table.

Pinterest Ads

We now sync the pin_stats and influencer_pin_stats extra properties for the PIN_HISTORY table.

PostgreSQL

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.

Salesforce

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 connectors. If you'd like to enable this feature on your connector, contact our support team.

ServiceNow

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 Improvements

Added connector_id to Connect Card token endpoint response

We now return the connector_id field in the Connect Card token endpoint response.

For more information, see our Connect Card documentation.

Show button removed

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.