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.

We have added the new CONNECTOR_SDK_LOG table. The Fivetran Platform Connector now syncs Connector SDK logs to this table.

We have added a new nullable column, connector_id, to the DESTINATION_SCHEMA_METADATA, DESTINATION_TABLE_METADATA, and DESTINATION_COLUMN_METADATA tables in the Metadata Sharing section. This column, going forward, will be populated with the ID of the connector that each schema, table, or column belongs to.

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.

Read our Fivetran Platform Connector documentation.