September 2020link
Audit Tableslink
We have deprecated the two audit tables, _fivetran_audit
and _fivetran_audit_warning
. We will stop populating the tables on November 6, 2023.
You can use our Fivetran Platform Connector along with our Fivetran Platform Connector data model to recreate the _fivetran_audit
table in your destination. The pre-built data model uses the data stored in the log tables to create fivetran_platform__audit_table
matching the _fivetran_audit
table.
Single Sign-on Using Azure Active Directorylink
We have added Microsoft Entra ID (formerly Azure Active Directory) as an officially supported SAML identity provider. Now you can find Fivetran in the Microsoft Entra ID application gallery. This feature is in beta.
Read our setup guide to learn how to set up SSO with Microsoft Entra ID.
Transformations for dbt Corelink
We have released the beta version of dbt Transformations. Now you can connect directly to your Git provider and orchestrate your dbt models through Fivetran.
Read our dbt Transformations documentation to learn more.
We have updated our dbt runtime environment to version 0.18.0. Check the dbt migration guide and make sure your dbt projects work correctly with the new version.
Schema changeslink
Braintreelink
We have added a new table, LOCAL_PAYMENT_DETAILS
. See Braintree's documentation for more information.
HubSpotlink
We have added a new child table, CALENDAR_USER
, to the CALENDAR_EVENT
table.
Pendolink
We now sync property data in the TRACK_TYPE_EVENT
table. We sync each property to the destination in its own column and add the prefix property_
to the column name. For example, the file
property is synced to the destination as the property_file
column.
Shopifylink
We have added two new tables, GIFT_CARD
and USER
to support Shopify Plus APIs.
We have replaced the COLLECT
table with the COLLECTION_PRODUCT
table. We have deprecated the COLLECT
table because the Shopify API no longer supports the Collect endpoint.
We have added the following new fields to the tables below:
app_id
to theORDER
tablenote
to theCUSTOMER
table
Stripelink
We have added the following new columns to the tables below:
is_deleted
andcapabilities_platform_payments
to theACCOUNT
tableverification_data_expiry_check
to theAUTHORIZATION
tablelivemode
to theORDER_RETURN
tableid
to theSUBSCRIPTION_DISCOUNT
table
We now support metadata_*
columns in the AUTHORIZATION
table.
Xerolink
We have added a new column, manual_journal_id
, to the MANUAL_JOURNAL_LINE_HAS_TRACKING_CATEGORY
table.
Zendesk Supportlink
We have added a new table, ARTICLE
, which stores details about all Help Center articles. Learn more in Zendesk's Articles documentation.
Improvementslink
Adobe Analyticslink
We now support Adobe Analytics 2.0 APIs. All new connectors created after September 22, 2020 will support Analytics 2.0 APIs. Existing connectors will continue to use Analytics 1.4 APIs.
Adobe Analytics Data Feedlink
You can now opt not to split array elements into child tables. By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.
On the connector setup form, set the Should Split Arrays toggle to OFF, and we will sync the arrays as a JSONArray into your destination.
AdRolllink
The AdRoll connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. AdRoll's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.
To learn more, see our priority-first sync documentation.
Apple App Storelink
We have renamed our iTunes Connect connector to Apple App Store. This name change applies to the Fivetran dashboard and our documentation.
AWS Inventorylink
We now sync data from all the regions that are available in your AWS account. To learn how to configure your account to give us access to data from all regions, see our AWS Inventory setup guide.
BigQuerylink
We have added a new connector setup test to validate if billing has been enabled for the BigQuery project.
Campaign Managerlink
We now support the Path to Conversion report type in our Campaign Manager connector. If you'd like to enable this feature on your connector, contact our support team.
Criteolink
The Criteo connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Criteo's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.
To learn more, see our priority-first sync documentation.
Facebook Ad Insightslink
We have added support for the video_continuous_2_sec_watched_actions
field.
Google Adslink
We improved the way we sync Placement Performance report data. Previously, the only AdNetworkTypes that the report contained were Display Network. Now, it receives placement data for all network types: Display Network, Search Network, YouTube Search, YouTube Videos, and Cross-network.
Google Analytics 360link
We have modified the connector setup tests. We now validate your BigQuery dataset permissions and Google Cloud Storage bucket permissions in two different steps. Previously, we validated the service account’s permissions on the dataset and the bucket permissions in a single step.
Google Sheetslink
We simplified setup for our Google Sheets connector. We now only require the URL of the Google spreadsheet. You no longer need to identify the value between the "/d/" and the "/edit" in your spreadsheet URL when setting up new connectors.
Jiralink
We enable the improved schema by default for connectors set up after September 10, 2020. See our June 2020 release note for details about the improvements, which were previously opt-in, but are now default.
Kustomerlink
You can now exclude the following tables from the sync:
CARD
COMPANY
CONVERSATION
CUSTOMER
KOBJECT
MESSAGE
NOTE
NOTIFICATION
QUEUE
SHORTCUT
SNOOZE
TAG
TEAM
TEAM_QUEUE
USER
On your connector details page, go to the Schema tab and deselect the tables you want to exclude.
Microsoft Advertisinglink
We have released pre-built, dbt Core-compatible data models for Microsoft Advertising. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Optimizelylink
You can now exclude the following tables from the sync:
DECISION
CONVERSION
RESULT
On your connector details page, go to the Schema tab and deselect the tables you want to exclude.
Pinterest Adslink
We have released pre-built, dbt Core-compatible data models for Pinterest Ads. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
PostgreSQLlink
We have added a new test in the PostgreSQL destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your PostgreSQL destination, you must grant the fivetran
user permission to create temporary tables in your PostgreSQL database. To learn how, see the setup guide for your PostgreSQL implementation:
Redshiftlink
We have added a new test in the Redshift destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your Redshift destination, you must grant the fivetran
user permission to create temporary tables in your Redshift warehouse. To learn how, see our Redshift setup guide.
Salesforcelink
We now use Salesforce's Bulk API 2.0 for your connector's historical syncs. Previously, we used the REST API for the historical syncs. 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.
You can now select the FIVETRAN_FORMULA
and FIVETRAN_FORMULA_HISTORY
tables to sync from the Schema tab on your connector details page. 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.
Shopifylink
We have released pre-built, dbt Core-compatible data models for Shopify. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Snowflakelink
We have added a new test in the Snowflake destination setup form to verify CREATE SCHEMA and CREATE TEMPORARY TABLES permissions. When you set up your Snowflake destination, the new test will automatically validate these permissions.
SQL Serverlink
We have optimized the queries that we use to retrieve table and column metadata from your database during our data syncs. Our new queries improve your sync speed, especially if you have large schemas.
Twiliolink
You can now select the accounts you want to sync in your Twilio connector. See our Twilio setup guide for details.
Verizon Medialink
We have renamed our Yahoo Gemini connector to Verizon Media. This name change applies to the Fivetran dashboard and our documentation.
YouTube Analyticslink
Our YouTube Analytics connector is now generally available.
Read our YouTube Analytics connector documentation.
Zendesk Chatlink
We have added a new table, ENGAGEMENT
, which stores information about your agents' chat engagements.
Zendesk Supportlink
We have released pre-built, dbt Core-compatible data models for Zendesk Support. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
REST API Improvementslink
Connect Cardlink
We have added a new optional parameter, hide_setup_guide
, to our Connect Card. It lets you hide the embedded setup guide.
New Public API Endpointslink
We have implemented a new Connector Management API endpoint for our REST API. You can now leverage the new Retrieve Source Table Columns Config feature.
Log eventslink
New Log Eventlink
We have added a new log event, change_schema_config_via_sync
. See our Logs documentation for more information.