Release Noteslink
May 2024link
We have released a new May 2024 schema on May 10, 2024. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
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.
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.
21 total changes • 21 possible breaking changes
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. |
November 2023link
Lite connectors are now available for the following sources: