Release Notes
January 2025
We have added table re-sync support. Previously, we only supported connector-level re-syncs.
NOTE: Event-based tables and tables with a retention period at the source don't support this feature.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
November 2024
Lite connectors are now available for the following sources:
- AccuLynx
- Algolia
- Betterworks
- Cimis
- Clazar
- Clubspeed
- Coassemble
- Compliance Checkpoint
- Dialpad
- Everflow
- Exact Online
- ExpenseIn
- e-conomic
- Formstack
- FourKites
- Freshsales
- Freshsuccess
- Google Classroom
- Google Tasks
- GreenPowerMonitor
- Jamf
- Jibble
- JobNimbus
- Khoros Communities
- Konnect Insights
- Lucca
- Mailjet
- Malomo
- NICE
- Nylas
- Packiyo
- PandaDoc
- Pigment
- Placer.ai
- Prisma Cloud
- REVIEWS.ai
- Rundeck
- SafeBase
- Sage HR
- Sana
- Sentry
- SugarCRM
- Unicommerce
- Vimeo
- Visit by GES
- Visma
- Walmart Marketplace
- Web Scraper
- Wicked Reports
- Xactly
August 2024
Effective August 26, 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.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 updating the connector schema to prevent or resolve data integrity issues.
43 total changes • 31 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AVERAGE_CLICK_POSITION | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
CLICK_POSITION | |||||
| column | Primary Key Change | end_date 🔑 | end_date | No longer a primary key. | |
| column | Rename Column | index 🔑 | index_name 🔑 | ||
| column | Primary Key Change | start_date 🔑 | start_date | No longer a primary key. | |
| column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
CLICK_POSITION_POSITION | |||||
| column | Discontinued Column | click_position_end_date 🔑 | No longer a primary key. | ||
| column | Rename Column | click_position_index 🔑 | click_position_index_name 🔑 | ||
| column | Discontinued Column | click_position_start_date 🔑 | No longer a primary key. | ||
| column | Primary Key Change | click_position_fivetran_id 🔑 | New primary key. | ||
CLICK_THROUGH_RATE | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
CONVERSION_RATE | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
COUNTRY | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
FILTER | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
HIT | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Rename Column | index | index_name | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
INDEX | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
INDEX_DETAIL | |||||
| column | Rename Column | index | index_name | ||
INDEX_REPLICA | |||||
| column | Rename Column | index_id 🔑 | index_name 🔑 | ||
RULE | |||||
| column | Rename Column | index | index_name | ||
SEARCH | |||||
| column | Rename Column | index | index_name | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
SEARCH_COUNT | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Rename Column | index | index_name | ||
SEARCH_NO_CLICK | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Rename Column | index | index_name | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
SEARCH_NO_CLICK_RATE | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
SEARCH_NO_RESULT | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Rename Column | index | index_name | ||
| column | New Column | end_date | |||
| column | New Column | start_date | |||
SEARCH_NO_RESULT_RATE | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||
SETTINGS | |||||
| column | Rename Column | index | index_name | ||
TOP_SEARCH (new table name: SEARCH) | |||||
| table | Rename Table | TOP_SEARCH | SEARCH | ||
USER_COUNT | |||||
| column | Rename Column | index 🔑 | index_name 🔑 | ||