Overview
Learn essential and advanced techniques for integrating S3-compatible object storage with ClickHouse in this comprehensive webinar. Master standard use patterns including tiered storage implementation, Parquet archiving, and object storage configuration in ClickHouse tables through detailed demonstrations of storage policies, authentication methods, caching strategies, and zero-copy replication. Explore expert-level optimization techniques covering S3 cost management, mutable data design patterns, backup procedures, and performance tuning. Gain hands-on experience through practical examples and configurations while discovering best practices for implementing storage solutions in ClickHouse environments. Access supplementary materials including detailed presentation slides, documentation resources, and community support channels to enhance the learning experience and continue skill development beyond the webinar.
Syllabus
Introduction
Overview of ClickHouse
Setting up ClickHouse
Storage Configurations
Storage Configuration Example
Tiered Storage
Tiered Storage Configuration
S3 Cache
Cache Example
TTL
Move Partition
Performance
Background merges
Object Storage
Allow Remote File System
S3 Storage Summary
Data Lake
Parquet
Table Function
Performance Test
S3 Tables
S3 Credentials
Tradeoffs
S3 Telemetry
System Remote Data Pass Table
Coming Extractions
S3 Community
Best Practices
References
Contact Information
Taught by
Altinity