Highlight's journey in developing a logging product involved leveraging Clickhouse and OpenTelemetry to create a seamless and integrated error monitoring solution. Initially inspired by their revamped error monitoring product that linked stack traces to session replays, Highlight aimed to provide comprehensive logging capabilities, including custom attributes and auto-linking features. Emphasizing multi-tenancy, they optimized their schema design by adding a ProjectId column and adjusted timestamp precision to improve query performance. To address pagination challenges, they utilized UUIDs for unique cursors and employed GraphQL's Relay for structuring pagination responses. The team also simplified their filtering approach to focus on key-value pairs and log messages, utilizing Go for implementation while benefiting from Clickhouse's SQL syntax and community support. Their efforts resulted in an efficient logging service that has encouraged them to consider Clickhouse for future developments and replacements within their tech stack.