ClickHouse has native support for sampling https://clickhouse.com/docs/sql-reference/statements/select/...