Release Notes
August 2024
Effective August 5, 2024 we use a new August 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
This schema change is required due to invalid combined 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.17 total changes • 10 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
APPLICANT_BACKGROUND_CHECK | |||||
column | Primary Key Change | applicant_id | applicant_id 🔑 | Added to primary key. | |
column | Primary Key Change | candidate_id 🔑 | candidate_id | No longer primary key. | |
column | Primary Key Change | report_id 🔑 | report_id | No longer primary key. | |
column | New Column | background_applicant_id | |||
column | Primary Key Change | index 🔑 | Added to primary key. | ||
APPLICANT_COURSE_RESULT | |||||
table | New Table | APPLICANT_COURSE_RESULT | |||
APPLICANT_LABEL | |||||
table | New Table | APPLICANT_LABEL | |||
APPLICANT_LESSONLY_RESULT | |||||
column | Primary Key Change | applicant_id | applicant_id 🔑 | Added to primary key. | |
column | Primary Key Change | lesson_url 🔑 | lesson_url | No longer primary key. | |
column | Primary Key Change | index 🔑 | Added to primary key. | ||
APPLICANT_PATH_RESULT | |||||
table | New Table | APPLICANT_PATH_RESULT | |||
APPLICANT_RESULT | |||||
table | Deprecated Table | APPLICANT_RESULT | Data now available in the APPLICANT_PATH_RESULT and APPLICANT_COURSE_RESULT tables. | ||
LABEL | |||||
table | Deprecated Table | LABEL | Data now available in the STAGE_LABEL and APPLICANT_LABEL tables. | ||
STAGE_LABEL | |||||
table | New Table | STAGE_LABEL | |||
TEMPLATE_FUNNEL | |||||
table | New Table | TEMPLATE_FUNNEL | |||
TEMPLATE_TIMESTAMP_FUNNEL | |||||
table | Deprecated Table | TEMPLATE_TIMESTAMP_FUNNEL | Data now available in the TEMPLATE_FUNNEL and TIMESTAMP_FUNNEL tables. | ||
TIMESTAMP_FUNNEL | |||||
table | New Table | TIMESTAMP_FUNNEL |
January 2024
We have added a new configuration option, URL format, to the connector setup form to support all regional variants of the Fountain URL. For more information, see our setup instructions and REST API config.
April 2023
You can now configure your Fountain connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
We have renamed the template_template_type
column to template_type
in the APPLICANT_SCORE_CARD_RESULT
table. To sync the historical data for this column, contact our support team.
We have removed the following tables:
AVAILABLE_SLOT
BANK
CALENDAR_BOOKED_SLOT
CALENDAR_SLOT
CALENDAR_SLOT_STAGE
Lite connectors are now available for the following sources: