May 2024link
Transformation Improvementslink
Bulk Actions for Transformationslink
You can now use bulk actions for Transformations, which allow you to perform any of the following actions on multiple transformations at once:
- Pause selected transformations
- Resume selected transformations
- Edit schedule of selected transformations
- Remove selected transformations
Transformations for dbt Corelink
dbt Core version 1.7.14 supportlink
We now support dbt Core* version 1.7.14. You can use this version to run your projects.
NOTE: For dbt Core versions later than 1.1.5, we don't support MySQL destinations. These destinations are not currently supported by custom dbt Core adapters.
* 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 changeslink
Closelink
These schema changes are required due to a null primary key issue. We are also deprecating the CONTACT_INTEGRATION_LINK and LEAD_INTEGRATION_LINK tables. 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.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CONTACT | |||||
column | New Column | integration_links | |||
CONTACT_INTEGRATION_LINK | |||||
table | Deprecated Table | contact_integration_link | Data available in the INTEGRATION_LINK table. | ||
LEAD | |||||
column | New Column | integration_links | |||
LEAD_INTEGRATION_LINK | |||||
table | Deprecated Table | lead_integration_link | Data available in the INTEGRATION_LINK table. | ||
SMS_ATTACHMENT | |||||
column | Primary Key Change | media_id 🔑 | media_id | No longer primary key due to a null primary key issue. | |
column | Primary Key Change | index 🔑 | New primary key. |
DEARlink
These schema changes are required due to the addition of new endpoints. 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.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ADDRESS | |||||
column | Deprecated Column | customer_id | Data now available in the object_id column. | ||
column | Deprecated Column | supplier_id | Data now available in the object_id column. | ||
column | New Column | address_type | Utilize it for data filtering, encompassing only three values: customer, supplier, and lead. | ||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
ATTACHMENT | |||||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
BILL_OF_MATERIAL_PRODUCT | |||||
column | Deprecated Column | wastage_percent | Can be calculated with a query. | ||
BILL_OF_MATERIALS_PRODUCT (new table name: BILL_OF_MATERIAL_PRODUCT) | |||||
table | Rename Table | bill_of_materials_product | bill_of_material_product | Updated to adhere to standard naming conventions. | |
BILL_OF_MATERIALS_SERVICE (new table name: BILL_OF_MATERIAL_SERVICE) | |||||
table | Rename Table | bill_of_materials_service | bill_of_material_service | Updated to adhere to standard naming conventions. | |
CONTACT | |||||
column | Deprecated Column | customer_id | Data now available in the object_id column. | ||
column | Deprecated Column | supplier_id | Data now available in the object_id column. | ||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
CONTACTS (new table name: CONTACT) | |||||
table | Rename Table | contacts | contact | Updated to adhere to standard naming conventions. | |
CREDIT_NOTE (new table name: PURCHASE_CREDIT_NOTE) | |||||
table | Rename Table | credit_note | purchase_credit_note | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | credit_note_number | credit_note_number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
CREDIT_NOTE_REFUND (new table name: PURCHASE_CREDIT_NOTE_REFUND) | |||||
table | Rename Table | credit_note_refund | purchase_credit_note_refund | Updated to adhere to standard naming conventions. | |
CREDIT_NOTE_UNSTOCK (new table name: PURCHASE_CREDIT_NOTE_UNSTOCK) | |||||
table | Rename Table | credit_note_unstock | purchase_credit_note_unstock | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
CUSTOMER_PRODUCT_PRICE | |||||
column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
INVENTORY_MOVEMENT (new table name: PURCHASE_INVENTORY_MOVEMENT) | |||||
table | Rename Table | inventory_movement | purchase_inventory_movement | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
INVOICE | |||||
table | Deprecated Table | invoice | Data available in the PURCHASE_INVOICE table. | ||
INVOICE_ADDITIONAL_CHARGE | |||||
table | Deprecated Table | invoice_additional_charge | Data available in the PURCHASE_INVOICE_ADDITIONAL_CHARGE table. | ||
INVOICE_PAYMENT (new table name: PURCHASE_INVOICE_PAYMENT) | |||||
table | Rename Table | invoice_payment | purchase_invoice_payment | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | purchase_id | purchase_id 🔑 | Added to primary key. | |
JOURNAL | |||||
column | Primary Key Change | journal_number | journal_number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
JOURNAL_ATTACHMENT | |||||
column | Deprecated Column | journal_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | journal_number 🔑 | New primary key. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
JOURNAL_LINE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | journal_task_id | The field is unnecessary. | ||
column | New Column | journal_number | |||
column | New Column | purchase_id | |||
LEAD | |||||
table | New Table | LEAD | |||
LOCATION | |||||
table | New Table | LOCATION | |||
LOCATION_BIN | |||||
table | New Table | LOCATION_BIN | |||
MARKUP_PRICE (new table name: PRODUCT_MARKUP_PRICE) | |||||
table | Rename Table | markup_price | product_markup_price | Updated to adhere to standard naming conventions. | |
NEW_STOCK_LINE | |||||
table | New Table | NEW_STOCK_LINE | |||
NON_ZERO_STOCK_ON_HAND_PRODUCT | |||||
table | New Table | NON_ZERO_STOCK_ON_HAND_PRODUCT | |||
OPPORTUNITY | |||||
table | New Table | OPPORTUNITY | |||
table | New Table | OPPORTUNITY | |||
OPPORTUNITY_ADDITIONAL_CHARGE | |||||
table | New Table | OPPORTUNITY_ADDITIONAL_CHARGE | |||
OPPORTUNITY_LINE | |||||
table | New Table | OPPORTUNITY_LINE | |||
PRODUCT | |||||
column | Deprecated Column | assembly_instruction_url | This column is unnecessary. | ||
PRODUCT_CUSTOM_PRICE | |||||
column | Deprecated Column | product_cutstom_price_id 🔑 | No longer primary key. | ||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
column | New Column | customer_id | |||
column | New Column | price | |||
PRODUCT_FAMILY | |||||
column | Deprecated Column | short_description | Can be viewed in the description field. | ||
PRODUCT_MOVEMENT | |||||
column | Primary Key Change | number | number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
PRODUCT_PRODUCT_FAMILY (new table name: FAMILY_PRODUCT) | |||||
table | Rename Table | product_product_family | family_product | Updated to adhere to standard naming conventions. | |
PRODUCT_REORDER_LEVEL | |||||
column | Deprecated Column | location_name | Data available in the LOCATION table. | ||
PURCHASE | |||||
column | Deprecated Column | order_total | Can be calculated by other fields. | ||
column | New Column | blind_receipt | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_CREDIT_NOTE | |||||
column | Deprecated Column | total | Can be calculated by other fields. | ||
column | Deprecated Column | total_before_tax | Can be calculated by other fields. | ||
PURCHASE_CREDIT_NOTE_REFUND | |||||
column | Deprecated Column | credit_note_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | purchase_credit_note_number 🔑 | New primary key. | ||
PURCHASE_CREDIT_NOTE_UNSTOCK | |||||
column | Deprecated Column | credit_note_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | purchase_credit_note_number 🔑 | New primary key. | ||
PURCHASE_INVENTORY_MOVEMENT | |||||
column | Deprecated Column | id | The field is unnecessary. | ||
PURCHASE_INVOICE | |||||
column | Deprecated Column | advanced_purchase_invoice_purchase_id 🔑 | No longer primary key. | ||
column | Deprecated Column | combine_additional_charges | Can be calculated by other fields. | ||
column | Primary Key Change | invoice_number | invoice_number 🔑 | Added to primary key. | |
column | Deprecated Column | invoice_total_amount | Can be calculated by other fields. | ||
column | Deprecated Column | invoice_total_tax_amount | Can be calculated by other fields. | ||
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
column | Deprecated Column | tax | Can be calculated by other fields. | ||
column | Deprecated Column | total | Can be calculated by other fields. | ||
column | Deprecated Column | total_before_tax | Can be calculated by other fields. | ||
column | New Column | invoicing_and_receiving_number | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | paid | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
PURCHASE_INVOICE_ADDITIONAL_CHARGE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | purchase_invoice_task_id | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | purchase_id | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | purchase_invoice_number | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_INVOICE_LINE | |||||
column | Deprecated Column | purchase_invoice_task_id 🔑 | No longer primary key. | ||
column | New Column | product_custom_field_1 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_10 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_2 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_3 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_4 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_5 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_6 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_7 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_8 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_9 | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
column | Primary Key Change | purchase_invoice_number 🔑 | New primary key. | ||
PURCHASE_INVOICE_PAYMENT | |||||
column | Deprecated Column | invoice_task_id | The column is unnecessary. | ||
column | Primary Key Change | purchase_invoice_number 🔑 | New primary key. | ||
PURCHASE_LINE | |||||
table | Deprecated Table | purchase_line | Data available in the PURCHASE_INVOICE_LINE table. | ||
PURCHASE_LIST | |||||
table | Deprecated Table | purchase_list | Data available in the PURCHASE table. | ||
PURCHASE_ORDER | |||||
table | Deprecated Table | purchase_order | Data available in the PURCHASE table. | ||
PURCHASE_ORDER_ADDITIONAL_CHARGE | |||||
table | Deprecated Table | purchase_order_additional_charge | Data is available in the PURCHASE table. | ||
PURCHASE_ORDER_LINE | |||||
column | Deprecated Column | purchase_order_task_id 🔑 | No longer primary key. | ||
column | Deprecated Column | tax | Can be calculated by other fields. | ||
column | Deprecated Column | total | Can be calculated by other fields. | ||
column | New Column | dimensions_unit | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_1 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_10 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_2 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_3 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_4 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_5 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_6 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_7 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_8 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_9 | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key | ||
column | New Column | quantity | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_STOCK_AND_PUT_AWAY_STATUS | |||||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
PURCHASE_STOCK_STATUS (new table name: PURCHASE_STOCK_AND_PUT_AWAY_STATUS) | |||||
table | Rename Table | purchase_stock_status | purchase_stock_and_put_away_status | Updated to adhere to standard naming conventions. | |
SALE | |||||
table | New Table | SALE | |||
SALE_ATTACHMENT | |||||
table | New Table | SALE_ATTACHMENT | |||
SALE_CREDIT_NOTE | |||||
table | New Table | SALE_CREDIT_NOTE | |||
SALE_CREDIT_NOTE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_CREDIT_NOTE_ADDITIONAL_CHARGE | |||
SALE_CREDIT_NOTE_LINE | |||||
table | New Table | SALE_CREDIT_NOTE_LINE | |||
SALE_CREDIT_NOTE_REFUND | |||||
table | New Table | SALE_CREDIT_NOTE_REFUND | |||
SALE_CREDIT_NOTE_RESTOCK | |||||
table | New Table | SALE_CREDIT_NOTE_RESTOCK | |||
SALE_FULLFILLMENT | |||||
table | New Table | SALE_FULLFILLMENT | |||
SALE_FULLFILLMENT_PACK_LINE | |||||
table | New Table | SALE_FULLFILLMENT_PACK_LINE | |||
SALE_FULLFILLMENT_PICK_LINE | |||||
table | New Table | SALE_FULLFILLMENT_PICK_LINE | |||
SALE_FULLFILLMENT_SHIP_LINE | |||||
table | New Table | SALE_FULLFILLMENT_SHIP_LINE | |||
SALE_INVENTORY_MOVEMENT | |||||
table | New Table | SALE_INVENTORY_MOVEMENT | |||
SALE_INVOICE | |||||
table | New Table | SALE_INVOICE | |||
SALE_INVOICE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_INVOICE_ADDITIONAL_CHARGE | |||
SALE_INVOICE_LINE | |||||
table | New Table | SALE_INVOICE_LINE | |||
SALE_ORDER_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_ORDER_ADDITIONAL_CHARGE | |||
SALE_ORDER_LINE | |||||
table | New Table | SALE_ORDER_LINE | |||
SALE_QUOTE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_QUOTE_ADDITIONAL_CHARGE | |||
SALE_QUOTE_LINE | |||||
table | New Table | SALE_QUOTE_LINE | |||
SALE_TRANSACTION | |||||
table | New Table | SALE_TRANSACTION | |||
STOCK_ADJUSTMENT | |||||
table | New Table | STOCK_ADJUSTMENT | |||
STOCK_ADJUSTMENT_TRANSACTION | |||||
table | New Table | STOCK_ADJUSTMENT_TRANSACTION | |||
STOCK_TAKE | |||||
table | New Table | STOCK_TAKE | |||
STOCK_TAKE_TRANSACTION | |||||
table | New Table | STOCK_TAKE_TRANSACTION | |||
STOCK_TRANSFER | |||||
table | New Table | STOCK_TRANSFER | |||
STOCK_TRANSFER_LINE | |||||
table | New Table | STOCK_TRANSFER_LINE | |||
STOCK_TRANSFER_ORDER_LINE | |||||
table | New Table | STOCK_TRANSFER_ORDER_LINE | |||
TASK | |||||
table | New Table | TASK | |||
ZERO_STOCK_ON_HAND_PRODUCT | |||||
table | New Table | ZERO_STOCK_ON_HAND_PRODUCT |
Pipedrivelink
We have changed the data type of the progress
column in the GOAL
table from INT to DOUBLE.
PowerReviews Enterpriselink
We are making these schema changes to avoid potential data integrity issues due to misuse of the index column. 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.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
QUESTION | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Deprecated Column | index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
QUESTION_ANSWER | |||||
column | Primary Key Change | question_id 🔑 | question_id | No longer primary key. | |
column | Deprecated Column | question_index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
REVIEW | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Deprecated Column | index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
REVIEW_BADGE | |||||
column | Deprecated Column | review_id 🔑 | No longer primary key. | ||
column | Deprecated Column | review_product_page_id 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
REVIEW_CUSTOM_QUESTION_NAME | |||||
column | Deprecated Column | review_id 🔑 | No longer primary key. | ||
column | Deprecated Column | review_index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
REVIEW_MEDIA | |||||
column | Primary Key Change | review_id 🔑 | review_id | No longer primary key. | |
column | Deprecated Column | review_index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
REVIEW_MERCHANT_RESPONSE | |||||
column | Primary Key Change | review_id 🔑 | review_id | No longer primary key. | |
column | Deprecated Column | review_index 🔑 | No longer primary key. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. |
Productboardlink
These schema changes are required due to null primary key and paging cursor expiration issues. 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.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
NOTE_COMMENT | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
NOTE_FEATURE | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. |
Shortcutlink
We have added a new table, EPIC_STORY_CUSTOM_FIELD
, to capture custom field data from the EPIC STORY
table.
VWOlink
We are making these schema changes to avoid potential data integrity issues due to the misuse of the `index` column. 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.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CAMPAIGN_SHARE_LINK | |||||
column | Primary Key Change | campaign_id 🔑 | campaign_id | No longer primary key. | |
column | Deprecated Column | index 🔑 | No longer primary key. | ||
column | Primary Key Change | workspace_id 🔑 | workspace_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. |
Improvementslink
Care Quality Commissionlink
We have made the following changes to our Care Quality Commission connector to support the recent Care Quality Commission API changes:
In the connector setup form, we replaced the Partner code field with the Primary key field. For more information, see our setup instructions.
In the API config parameters, we replaced the
partner_code
parameter with theprimary_key
parameter. For more information, see our REST API documentation.
Dropboxlink
Our Dropbox connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.
Maxio Chargifylink
We now incrementally sync the COMPONENT
table and its child tables to capture new records.
We now also capture deletes for the COMPONENT
table.
Salesforcelink
We now translate formulas containing the /
operator only for the following destinations:
- BigQuery
- Databricks
- PostgreSQL
- Redshift
- Snowflake
Previously, we supported this operator for all destinations.
Salesloftlink
We can now sync the email templates used in Salesloft Cadences into the EMAIL_TEMPLATES
table. To backfill the historical data for this type of email templates, re-sync the EMAIL_TEMPLATES
table.
SharePointlink
Our SharePoint connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.
Squarelink
The Square connector now supports table blocking for all Square tables. You can choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.
If you want to sync a child table, you must include its parent table for the sync.
REST API Improvementslink
Create a Connector Schema Config endpointlink
Our Connector Management API now supports a new endpoint, Create a Connector Schema Config
. The endpoint allows to configure the schema before the initial sync without reloading. The endpoint is not in beta.