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:
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_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.
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.
ADP Workforce Nowlink
ADP Workforce Now is a payroll and HR platform.
Typeform is an online survey management solution.
Zoho CRM is an online CRM platform that manages your sales, marketing, and customer support activities.
We now sync the
Multi-select enums custom field.
We have added two new fields,
approximate_count_upper_bound, to the
We have removed the
approximate_count field because it has been deprecated.
We have added the following new tables:
COMMIT_PULL_REQUESTstores linking information between commits and their relevant pull requests
NOTE: Re-sync your connector to sync the data for all commits.
DEPLOYMENTstores deployment information
DEPLOYMENT_STATUSstores deployment status information
RELEASEstores release information
ASSETstores 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.
We have added a new column,
priority, to the
We have added the following new columns to the
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.
We have added a new column,
invoice_line_item, to the
We have added a new table,
USER_VOTE, which stores the votes cast by a specific user. For more information, see Zendesk’s documentation.
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
ABC Column as
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.
You can now configure your Box connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
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.
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.
We now support the
purchase events. We sync the data into the
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.
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.
We now sync metadata information about third-party data sources. We sync the metadata to the
We now sync the
influencer_pin_stats extra properties for the
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.
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.
REST API Improvementslink
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.