:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
ClickHouse utility UDFs
This module contains the executable ClickHouse UDFs used by PostHog:
JSONDropKeysandJSONDropKeysPoolJSONCleanPostHogEventJSONCleanPostHogEventPropertiesJSONCleanPostHogPersonPropertiesJSONCleanPostHogTemporaryPropertiesJSONStripEmptyStringsAndNullsdecompress(data, codec)
Run ./scripts/build.sh to test the module and build Linux amd64 and arm64 binaries into
posthog/user_scripts.
Run ./scripts/integration_test.sh to execute the stateless fixtures against ClickHouse.
See JSONDropKeys benchmarks for the file-based workloads and commands to compare throughput and allocations.
See decompression usage and benchmarks for supported codecs, Kafka envelope handling, and size limits.
These utility UDFs keep stable, unversioned names. Regenerating the deployment manifest does not
change UDF_VERSION, which only switches callers between versioned funnel UDF releases.