ClickHouse Fivetran Destination moves to Beta

Fivetran has launched a beta version of its destination for ClickHouse Cloud, introducing a significant new feature called History Mode, which supports Slowly Changing Dimension Type 2 by preserving every version of your data for comprehensive audit trails and point-in-time analysis. Collaboratively developed with Fivetran's engineering team, the connector allows seamless data integration from platforms like Salesforce, Segment, and Stripe into ClickHouse without the need for custom code. History Mode adds three system columns to track data versions, enabling powerful analytics such as change tracking and historical reporting. Additionally, the setup includes features like compute-compute separation, which isolates ingestion workloads, and optimization strategies such as skip indexes, projections, and materialized views to enhance query performance. The connector is designed to efficiently manage inserts, updates, and deletes in ClickHouse by automatically creating tables with primary keys or generating unique identifiers when necessary. Future updates aim to support advanced schema changes directly from the Fivetran dashboard to enhance usability and flexibility for users.