Release Notes
October 2024
The group-level Fivetran Platform Connector is now automatically paused when it is the only active connector in the group. This means that if there are other connectors in the group, but all of them are paused, we pause the group-level Fivetran Platform Connector.
We unpause the automatically-paused group-level Fivetran Platform Connector once there is at least one active connector present in the group.
August 2024
We have deprecated the broken
column of the CONNECTOR_TYPE
table.
See our Fivetran Platform Connector ERD for more information.
July 2024
The Fivetran Platform connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
We have made the following changes to the INCREMENTAL_MAR
table:
- Deprecated the
connector_id
column, which contains the connector name; - Added a new column,
connector_name
.
The ROLE
table has the connector_types
column, which creates a many-to-many relationship between the CONNECTOR_TYPE
and ROLE
tables. We added a new bridge/join table, role_connector_type
that has the connector_type
and role_id
columns to make this relationship more intuitive.
We have added a new column, connector_id
, to the RESOURCE MEMBERSHIP
table. It contains the connector ID (like the existing integration_id
column). Existing connectors now have both columns, connector_id
and integration_id
, while new connectors created after July 10, 2024 only have the connector_id
column.
The DESTINATION
table has the type
column, which contains the deployment type (Fivetran
or HVR
). For new connectors created after July 10, 2024 this column is replaced with the deployment_type
column.
See our Fivetran Platform Connector ERD for more information.
June 2024
We have added the destination_type
column to the DESTINATION
table. While the existing type
column has two possible values, Fivetran
and HVR
, destination_type
will contain the exact destination type (for example, Snowflake, Kafka, BigQuery, etc.).
May 2024
The Fivetran Platform connector now syncs 7 days' worth of historical data instead of 5 days.
You now can select tables to be included in or excluded from syncs on the Schema tab of the Fivetran Platform Connector details page.
We are gradually rolling out these changes to all existing connectors.
March 2024
We have removed the free_type
column from the deletion key of the INCREMENTAL_MAR
table. Previously, the deletion key included this column, which caused data discrepancy.
February 2024
We have updated the Quickstart packages for the following connectors:
- Facebook Ads to version 0.7.2
- Fivetran Platform Connector to version 1.4.3
- Intercom to version 0.9.1
- Zendesk Support to version 0.13.1
Automatic connector creation: We now add a destination-level Fivetran Platform Connector to every new destination that you create in your Fivetran dashboard. This way, you have full access to essential Fivetran technical information from the start, like logs and metadata.
NOTE: We don't currently add the Fivetran Platform Connector to destinations created using our REST API.
Immediate data sync: Once created, the connector immediately begins syncing data to the destination, so that you have access to this technical information from the start.
Smart Trial Management: During trial periods, we add the Fivetran Platform Connector, but its initial sync does not trigger the start of the trial period.
January 2024
We have updated the Quickstart packages for the following connectors:
- Fivetran Platform Connector to version 1.4.0
- Google Ads to version 0.10.1
* 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.
November 2023
We now sync metadata to the SOURCE_FOREIGN_KEY_METADATA
table. For more information, see our Fivetran Platform documentation and sample queries.
October 2023
We now sync source and destination metadata to the following tables:
COLUMN_LINEAGE
DESTINATION_COLUMN_METADATA
DESTINATION_SCHEMA_METADATA
DESTINATION_TABLE_METADATA
SCHEMA_LINEAGE
SOURCE_COLUMN_METADATA
SOURCE_SCHEMA_METADATA
SOURCE_TABLE_METADATA
TABLE_LINEAGE
This functionality replaced the Metadata API. If you are using the Metadata API, you should have received an email with details regarding the deprecation timeline.
We have updated the Quickstart packages for the following connectors:
- Fivetran Platform Connector to version 1.1.0
- Google Ads to version 0.9.3
- Intercom to version 0.8.0
- Jira to version 0.15.0
- NetSuite SuiteAnalytics to version 0.9.0
- QuickBooks to version 0.12.0
- Zendesk Support to version 0.11.2
* 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.
September 2023
We now populate the created_at
column as null in the DESTINATION
table if the is_active
column is false
.
We have added two new columns, is_active
and type
, to the DESTINATION
table.
We now sync HVR 6 usage data to the DESTINATION
and USAGE_COST
tables.
We now sync all roles to the ROLE
and ROLE_PERMISSION
tables. Previously, we synced only the custom roles with an associated account.
August 2023
We have renamed our Fivetran Log Connector to Fivetran Platform Connector. This name change applies to the Fivetran dashboard and our documentation.
June 2023
We have removed the following obsolete tables that we previously used for our Role-Based Access Control:
ACCOUNT_MEMBERSHIPS
MEMBERSHIPS
MEMBERSHIPS_ROLES
MEMBERSHIPS_ROLES_SOURCES
November 2022
We now sync dbt transformations' user-facing logs into the LOG
table.
October 2022
For the accounts that have the Role-Based Access Control (RBAC) feature enabled, we have added the following new tables:
ROLE
ROLE_PERMISSION
RESOURCE_MEMBERSHIP
TEAM
TEAM_MEMBERSHIP
We have added a new table, INCREMENTAL_MAR
, which stores the incremental daily active rows for every destination, connector, and table within your account. This is helpful in tracking and managing consumption in our new pricing model. This table contains both paid and free MAR. We have deprecated the ACTIVE_VOLUME
table, which stores the cumulative monthly active rows.
July 2022
We have added two new optional parameters, is_account_level_connector
and group
, to the Fivetran Platform Connector REST API Request. You can now opt to retrieve account-level logs.
January 2022
We have added a new table, USAGE_COST
.
We have added a new column, sync_id
, to the LOG
table.
We have deprecated the CREDITS_USED
table.
June 2021
From June 1, 2021 00:00 UTC, our Fivetran Platform Connector reports only paid Monthly Active Rows (MAR). This is a forward only change that will not be applied for the previous months. The Usage tab in the Dashboard will continue to display both free and paid MAR. We have increased visibility into free MAR in the Dashboard and made certain types of re-sync free. No action is required on your part. For more details, see the Expanded Free MAR Operations changelog.
May 2021
We have added a new column, sync_frequency
, to the CONNECTOR
table.
March 2021
We have added a new table, CONNECTOR_TYPE
, to capture a connector's release phase status.
We have added a new column, _fivetran_deleted
, to the USER
table to track when a user is deleted.
We have added a new column, _fivetran_deleted
, to the CONNECTOR
table to track when a connector is deleted.
December 2020
The Fivetran Platform Connector now supports the creation of account-level connectors. A Fivetran Account Administrator can now sync the connector logs for all destinations in the account. See our setup instructions for more information.
August 2020
We have released a pre-built, dbt Core-compatible data model for the Fivetran Platform Connector. Find the model 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.
July 2020
We have removed the service_version
column from the CONNECTOR
table.
June 2020
We have added a new table, CREDITS_USED
. This table stores the monthly credit usage summary per destination.
April 2020
We have renamed the TRANSFORMATION_TABLE
table to TRIGGER_TABLE
.
We have renamed the group_id
column to destination_id
in the TRANSFORMATION
, DESTINATION_MEMBERSHIP
, and USER
tables.
You can now configure the Fivetran Platform Connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
March 2020
We have added a new table, ACTIVE_VOLUME
, which stores the cumulative monthly active rows for every destination, connector, and table within your account. This will be helpful in tracking and managing consumption in our new pricing model.
July 2019
Fivetran Platform Connector syncs logs and metadata about your connectors.