Release Notes
July 2024
Effective July 17, 2024 we use a new July 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We have made these schema changes to improve schema 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.32 total changes • 32 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
LOCATION_GAC_SERVICE_TYPE | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
LOCATION_HISTORIC_OVERALL_KEY_QUESTION_RATING | |||||
column | Deprecated Column | location_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | location_historic_rating_index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_RATING | |||||
column | Primary Key Change | report_link_id 🔑 | report_link_id | No longer primary key | |
column | Primary Key Change | index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_SERVICE_KEY_QUESTION_RATING | |||||
column | Primary Key Change | location_historic_service_rating_index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_SERVICE_RATING | |||||
column | Deprecated Column | location_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | location_historic_rating_index 🔑 | Part of composite primary key | ||
LOCATION_REGULATED_ACTIVITY_CONTACT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_regulated_activity_code 🔑 | Part of new composite primary key | ||
LOCATION_REPORT_RELATED_DOCUMENT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_report_link_id 🔑 | Part of new composite primary key | ||
PROVIDER_CONTACT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_id 🔑 | Part of new composite primary key | ||
PROVIDER_HISTORIC_OVERALL_KEY_QUESTION_RATING | |||||
column | Deprecated Column | provider_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | provider_historic_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_RATING | |||||
column | Primary Key Change | report_link_id 🔑 | report_link_id | No longer primary key | |
column | Primary Key Change | index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_SERVICE_KEY_QUESTION_RATING | |||||
column | Primary Key Change | provider_historic_service_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_SERVICE_RATING | |||||
column | Deprecated Column | provider_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | provider_historic_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_REPORT_RELATED_DOCUMENT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_report_link_id 🔑 | Part of new composite primary key |
May 2024
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.
November 2023
Lite connectors are now available for the following sources: