Archive

### 2026[​](#2026 "Direct link to 2026")

- [January 12 - Find counts and sizes of wide or compact parts](/docs/knowledgebase/count-parts-by-type)- [February 3 - Understanding part types and storage formats](/docs/knowledgebase/understanding-part-types-and-storage-formats)- [February 4 - How to opt out of crash report collection](/docs/knowledgebase/opt-out-core-dump-collection)- [April 9 - Terraform example on how to use Cloud API](/docs/knowledgebase/terraform_example)

### 2025[​](#2025 "Direct link to 2025")

- [January 10 - Why is ClickHouse logging so verbose by default?](/docs/knowledgebase/why_default_logging_verbose)- [January 16 - How do I remove the default user?](/docs/knowledgebase/remove-default-user)- [January 29 - How to recover from a corrupt Keeper snapshot](/docs/knowledgebase/recovering-from-corrupt-keeper-snapshot)- [April 15 - AWS PrivateLink setup to expose MSK for ClickPipes](/docs/knowledgebase/aws-privatelink-setup-for-msk-clickpipes)- [May 16 - Create a custom DNS alias by setting up a reverse proxy](/docs/knowledgebase/custom-dns-alias-for-instance)- [July 20 - What is the difference between OPTIMIZE FINAL and FINAL?](/docs/knowledgebase/optimize_final_vs_final)- [July 25 - Memory limit exceeded for query](/docs/knowledgebase/memory-limit-exceeded-for-query)- [November 11 - How to Generate a HAR file for support](/docs/knowledgebase/generate-har-file)- [November 19 - How to restore a replica after storage failure](/docs/knowledgebase/restore-replica-after-storage-failure)- [December 30 - How to collect and draw a query trace](/docs/knowledgebase/collect-and-draw-traces)

### 2024[​](#2024 "Direct link to 2024")

- [January 9 - Fix the Developer Verification Error in MacOS](/docs/knowledgebase/fix-developer-verification-error-in-macos)- [February 14 - How to achieve data read consistency in ClickHouse?](/docs/knowledgebase/read_consistency)- [February 14 - Backing up a specific partition](/docs/knowledgebase/backing_up_a_specific_partition)- [April 12 - Why can't I see my data in a dictionary in ClickHouse Cloud?](/docs/knowledgebase/dictionaries-consistent-state)- [April 17 - Searching across nodes for tables with a wildcard](/docs/knowledgebase/search-across-node-for-tables-with-a-wildcard)- [April 22 - How to build LLVM and clang on Linux](/docs/knowledgebase/llvm-clang-up-to-date)- [April 27 - How to Ingest Data from Kafka into ClickHouse](/docs/knowledgebase/kafka-to-clickhouse-setup)- [May 20 - Mapping Windows Active Directory security groups to ClickHouse roles](/docs/knowledgebase/windows_active_directory_to_ch_roles)- [May 20 - Simple example flow for extracting JSON data using a landing table with a Materialized View](/docs/knowledgebase/json_simple_example)- [May 29 - How to set up ClickHouse on Docker with ODBC to connect to a Microsoft SQL Server (MSSQL) database](/docs/knowledgebase/how-to-set-up-ch-on-docker-odbc-connect-mssql)- [June 21 - How to use array join to extract and query varying attributes using map keys and values](/docs/knowledgebase/using-array-join-to-extract-and-query-attributes)- [July 2 - I am unable to access a ClickHouse Cloud service](/docs/knowledgebase/unable-to-access-cloud-service)- [July 2 - Tips and tricks on optimizing basic data types in ClickHouse](/docs/knowledgebase/tips-tricks-optimizing-basic-data-types-in-clickhouse)- [July 3 - How to create a table that can query multiple remote clusters](/docs/knowledgebase/how-to-create-table-to-query-multiple-remote-clusters)- [July 10 - ODBC authentication failed error when using the Power BI ClickHouse connector](/docs/knowledgebase/ODBC-authentication-failed-error-using-PowerBI-CH-connector)- [July 23 - Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom\_metrics`](/docs/knowledgebase/mapping-of-system-metrics-to-prometheus-metrics)- [July 25 - How to connect to ClickHouse using SSH Keys](/docs/knowledgebase/how-to-connect-to-ch-cloud-using-ssh-keys)- [November 6 - How can I use the new JSON Data Type with Kafka?](/docs/knowledgebase/kafka-clickhouse-json)- [November 13 - Profiling ClickHouse with LLVM's XRay](/docs/knowledgebase/profiling-clickhouse-with-llvm-xray)- [November 21 - How to output send logs level traces to file using the clickhouse-client](/docs/knowledgebase/outputSendLogsLevelTracesToFile)- [November 21 - How to use the exchange command to switch tables](/docs/knowledgebase/exchangeStatementToSwitchTables)- [November 27 - AWS PrivateLink setup to expose private RDS for ClickPipes](/docs/knowledgebase/aws-privatelink-setup-for-clickpipes)- [December 11 - Can you PIVOT in ClickHouse?](/docs/knowledgebase/pivot)- [December 11 - How to Enable SSL with Let's Encrypt on a Single ClickHouse Server](/docs/knowledgebase/enabling-ssl-with-lets-encrypt)- [December 12 - Why is my primary key not used? How can I check?](/docs/knowledgebase/why_is_my_primary_key_not_used)- [December 17 - How to insert all rows from one table to another?](/docs/knowledgebase/how-to-insert-all-rows-from-another-table)- [December 17 - How to filter a ClickHouse table by an array-column?](/docs/knowledgebase/how-to-filter-a-clickhouse-table-by-an-array-column)- [December 18 - Importing GeoJSON with a deeply nested object array](/docs/knowledgebase/importing-geojason-with-nested-object-array)- [December 18 - Adding a column to a table](/docs/knowledgebase/add-column)

### 2023[​](#2023 "Direct link to 2023")