Release Noteslink
April 2024link
We have released a new 2024 April schema on April 11, 2024. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
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.
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 • 16 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
RULE_CLAUSE | |||||
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key | ||
SEGMENT | |||||
column | Primary Key Change | environment_key | environment_key 🔑 | Added as a part of the composite primary key | |
column | Primary Key Change | project_key | project_key 🔑 | Added as a part of the composite primary key | |
SEGMENT_ACCESS | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Calculation Change | |
column | New Column | environment_key | |||
column | New Column | project_key | |||
SEGMENT_CONTEXTS | |||||
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key | ||
SEGMENT_FLAG | |||||
column | Primary Key Change | segment_key | segment_key 🔑 | Added as a part of the primary key | |
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key | ||
SEGMENT_RULE | |||||
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key | ||
SEGMENT_TAGS | |||||
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key | ||
SEGMENT_TARGET | |||||
column | Primary Key Change | environment_key 🔑 | New primary key | ||
column | Primary Key Change | project_key 🔑 | New primary key |
February 2024link
We have added a new primary key column, fivetran_id
, to the FLAG_DEFAULT_PROJECT
table.
We have changed the primary key of the FLAG_DEFAULT_PROJECT_TAG
table. The new composite key is a combination of the index
and _fivetran_id
columns.
October 2023link
Lite connectors are now available for the following sources: