June 2025

Transformations for dbt Core

Account-level transformations

The transformation list now has items from all groups of the account the current user has access to. Adding a transformation to any destination of the account is now possible without switching the group The new "Manage projects" page containing all connected dbt projects in the account is now available

* 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.

Schema changes

Microsoft Dynamics 365 CRM

We have added a new column, renamed_attributename, to the STRINGMAP table. The column contains the values of attributename that are renamed according to the destination renaming rules. For more information, see our documentation.

Pipe17

Effective June 6, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to enhance its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

18 total changes • 17 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ARRIVAL_LINE_ITEM`
column	Primary Key Change	`arrival_id`	`arrival_id` 🔑	Added to primary key.
`CONNECTOR_ENTITY`
column	Primary Key Change	`connector_id`	`connector_id` 🔑	Added to primary key.
`FULFILLMENT_LINE_ITEM`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
column	Primary Key Change	`sku`	`sku` 🔑	Added to primary key.
column	New Column		`bundle_quantity_partial`
`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`
table	Discontinued Table	`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`		Data is available in the `bundle_quantity_partial` column of the `FULFILLMENT_LINE_ITEM` table.
`FULFILLMENT_TRACKING_NUMBER`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`FULFILLMENT_TRACKING_URL`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`ORDER_DISCOUNT`
column	Primary Key Change	`line_item_id` 🔑	`line_item_id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PRODUCT_PUBLISHED`
column	Primary Key Change	`sku` 🔑	`sku`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PURCHASE_LINE_ITEM`
column	Primary Key Change	`purchase_id`	`purchase_id` 🔑	Added to primary key.
`RECEIPT_LINE_ITEM`
column	Primary Key Change	`receipt_id`	`receipt_id` 🔑	Added to primary key.
`SHIPMENT_LINE_ITEM`
column	Primary Key Change	`shipment_id`	`shipment_id` 🔑	Added to primary key.
`SHIPPING_METHOD_MAPPED_METHOD`
column	Primary Key Change	`shipping_method_id`	`shipping_method_id` 🔑	Added to primary key.
`SUPPLIER_CONTACT`
column	Primary Key Change	`supplier_id`	`supplier_id` 🔑	Added to primary key.
`TRANSFER_LINE_ITEM`
column	Primary Key Change	`transfer_id`	`transfer_id` 🔑	Added to primary key.

SmartHR

Effective June 3, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to align with source changes.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name
`EMPLOYEE`
column	Discontinued Column	`department`
column	Discontinued Column	`position`
`EMPLOYEE_POSITION`
table	New Table		`EMPLOYEE_POSITION`

Transcend

Effective June 4, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

81 total changes • 54 possible breaking changes

Table/column	Change type	Old name	New name
`ACTIVITY`
table	New Table		`ACTIVITY`
`ASSESSMENT_FILE`
table	New Table		`ASSESSMENT_FILE`
`ASSESSMENT_FORM`
table	New Table		`ASSESSMENT_FORM`
`ASSESSMENT_FORM_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_ASSIGNEE`
`ASSESSMENT_FORM_ATTRIBUTE_VALUE`
table	New Table		`ASSESSMENT_FORM_ATTRIBUTE_VALUE`
`ASSESSMENT_FORM_COMMENT`
table	New Table		`ASSESSMENT_FORM_COMMENT`
`ASSESSMENT_FORM_EXTERNAL_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_EXTERNAL_ASSIGNEE`
`ASSESSMENT_FORM_REVIEWER`
table	New Table		`ASSESSMENT_FORM_REVIEWER`
`ASSESSMENT_FORM_SECTION`
table	New Table		`ASSESSMENT_FORM_SECTION`
`ASSESSMENT_FORM_SECTION_QUESTION`
table	New Table		`ASSESSMENT_FORM_SECTION_QUESTION`
`ASSESSMENT_FORM_TEMPLATE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE`
`ASSESSMENT_FORM_TEMPLATE_ATTRIBUTE_KEY`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_ATTRIBUTE_KEY`
`ASSESSMENT_FORM_TEMPLATE_SECTION`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION`
`ASSESSMENT_FORM_TEMPLATE_SECTION_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_ASSIGNEE`
`ASSESSMENT_FORM_TEMPLATE_SECTION_EXTERNAL_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_EXTERNAL_ASSIGNEE`
`ASSESSMENT_FORM_TEMPLATE_SECTION_QUESTION`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_QUESTION`
`ASSESSMENT_GROUP`
table	New Table		`ASSESSMENT_GROUP`
`ASSESSMENT_GROUP_ATTRIBUTE_VALUE`
table	New Table		`ASSESSMENT_GROUP_ATTRIBUTE_VALUE`
`ASSESSMENT_GROUP_REVIEWER`
table	New Table		`ASSESSMENT_GROUP_REVIEWER`
`ASSESSMENT_QUESTION`
table	New Table		`ASSESSMENT_QUESTION`
`ASSESSMENT_QUESTION_ANSWER_OPTION`
table	New Table		`ASSESSMENT_QUESTION_ANSWER_OPTION`
`ASSESSMENT_QUESTION_COMMENT`
table	New Table		`ASSESSMENT_QUESTION_COMMENT`
`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION`
table	New Table		`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION`
`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION_ANSWER`
table	New Table		`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION_ANSWER`
`ASSESSMENT_QUESTION_SELECT_OPTION`
table	New Table		`ASSESSMENT_QUESTION_SELECT_OPTION`
`ASSESSMENT_QUESTION_SELECTED_ANSWER`
table	New Table		`ASSESSMENT_QUESTION_SELECTED_ANSWER`
`ASSESSMENT_SECTION_COMMENT`
table	New Table		`ASSESSMENT_SECTION_COMMENT`
`COOKIE`
column	Discontinued Column	`avc_email_verified`
column	Discontinued Column	`business_user_overview`
column	Discontinued Column	`consent_do_not_sell_integration`
column	Discontinued Column	`controller_manual_instructions`
column	Discontinued Column	`datapoints_customizable`
column	Discontinued Column	`disqualification_reasons`
column	Discontinued Column	`form_config`
column	Discontinued Column	`has_api_functionality`
column	Discontinued Column	`has_avc_functionality`
column	Discontinued Column	`has_content_classification_functionality`
column	Discontinued Column	`has_plugins`
column	Discontinued Column	`has_silo_discovery_functionality`
column	Discontinued Column	`has_usp_api_support`
column	Discontinued Column	`hero_background_color`
column	Discontinued Column	`hero_image_url`
column	Discontinued Column	`integration_status`
column	Discontinued Column	`intro_message`
column	Discontinued Column	`is_complete`
column	Discontinued Column	`is_featured`
column	Discontinued Column	`is_prompt_avendor_compatible`
column	Discontinued Column	`is_suggested`
column	Discontinued Column	`minimum_sombra_version`
column	Discontinued Column	`plain_text`
column	Discontinued Column	`prompt_avendor_email_address`
column	Discontinued Column	`prompt_email_template_id`
column	Discontinued Column	`see_other_integrations`
column	Discontinued Column	`website`
`DATA_FLOW`
column	Discontinued Column	`avc_email_verified`
column	Discontinued Column	`business_user_overview`
column	Discontinued Column	`consent_do_not_sell_integration`
column	Discontinued Column	`controller_manual_instructions`
column	Discontinued Column	`datapoint_customizable`
column	Discontinued Column	`disqualification_reasons`
column	Discontinued Column	`form_config`
column	Discontinued Column	`has_api_functionality`
column	Discontinued Column	`has_avc_functionality`
column	Discontinued Column	`has_content_classification_functionality`
column	Discontinued Column	`has_plugin`
column	Discontinued Column	`has_silo_discovery_functionality`
column	Discontinued Column	`has_usp_api_support`
column	Discontinued Column	`hero_background_color`
column	Discontinued Column	`hero_image_url`
column	Discontinued Column	`integration_status`
column	Discontinued Column	`intro_message`
column	Discontinued Column	`is_complete`
column	Discontinued Column	`is_featured`
column	Discontinued Column	`is_prompt_avendor_compatible`
column	Discontinued Column	`is_suggested`
column	Discontinued Column	`minimum_sombra_version`
column	Discontinued Column	`plain_text`
column	Discontinued Column	`prompt_avendor_email_address`
column	Discontinued Column	`prompt_email_template_id`
column	Discontinued Column	`see_other_integrations`
column	Discontinued Column	`website`

Improvements

Snowflake

We now support Google Cloud Storage as an external stage for unstructured files. We have updated the destination setup form and changed the Storage for Unstructured Files toggle to a drop-down menu.