toddwschneider/nyc-taxi-data
A comprehensive project for importing, processing, and analyzing over 3 billion NYC taxi and for-hire vehicle trip records using PostgreSQL or ClickHouse databases.
ClickHouse/examples
The ClickHouse/examples repository is a comprehensive collection of resources and configurations designed to facilitate the use and experimentation with ClickHouse, a high-performance columnar database management system. This project includes a variety of example data sets, SQL queries, and configuration files that support the official ClickHouse blog and provide practical demonstrations of ClickHouse's capabilities. One of the key components of this repository is the ClickHouse Blog data, which contains the necessary data, DDL (Data Definition Language) statements, and SQL queries used in the ClickHouse official blog. This section also includes configurations for various agents like Vector and FluentBit, which are used to analyze Kubernetes logs within ClickHouse, showcasing the system's integration with modern observability tools. Additionally, the repository offers a rich set of Docker Compose recipes that simplify the deployment and testing of different ClickHouse environments. These recipes cover a wide range of scenarios, from single-node setups with Keeper to complex clustered environments with multiple nodes and replicas. The recipes also demonstrate integrations with other technologies such as Dagster, Grafana, MSSQL Server, MinIO S3, LDAP, Postgres, and syslog agents, providing users with ready-to-use configurations for diverse use cases. The project aims to provide users with quick and practical ways to get started with ClickHouse, whether for learning, development, or testing purposes. It encourages community contributions to expand and improve the collection of examples and recipes. Overall, this repository serves as a valuable resource for anyone looking to explore ClickHouse's features, experiment with different configurations, and understand how to integrate ClickHouse with other systems in real-world scenarios.
https://github.com/ClickHouse/examples
Also in Examples
droher/boxball
Boxball provides prebuilt Docker images with Retrosheet's complete baseball history data for multiple analytical database frameworks including Clickhouse, enabling easy access and analysis of comprehensive baseball datasets.
AlexeyKupershtokh/clickhouse-maxmind-geoip
A demonstration project showcasing the integration of ClickHouse with MaxMind GeoIP2 databases for geolocation, including dictionary definitions, table schemas, query examples, and Docker setup for easy experimentation.