The main reason is that ClickHouse is an open source project, and if you don't write the docs, nobody does. "Incomplete or Confusing Documentation" is the top complaint about open source software by the results of a Github Open Source Survey of 2017. Documentation is highly valued but often overlooked. One of the most important contributions someone can make to an open source repository is a documentation update.

Many developers can say that the code is the best docs by itself, and they are right. But, ClickHouse is not a project for C++ developers. Most of its users don't know C++, and they can't understand the code quickly. ClickHouse is large enough to absorb almost any change without a noticeable trace. Nobody will find your very useful function, or an important setting, or a very informative new column in a system table if it is not referenced in the documentation.

If you want to help ClickHouse with documentation you can face, for example, the following questions:

• "I don't know how to write."

  We have prepared some recommendations for you.

• "I know what I want to write, but I don't know how to contribute to docs."

  Here are some tips.

Writing the docs is extremely useful for project's users and developers, and grows your karma.

Contents

• What is the ClickHouse Documentation
• How to Contribute to ClickHouse Documentation
  • Markdown Dialect Cheatsheet
  • Adding a New File
  • Adding a New Language
• How to Write Content for ClickHouse Documentation
  • Documentation for Different Audience
  • Common Recommendations
  • Description Templates
• How to Build Documentation

The documentation contains information about all the aspects of the ClickHouse lifecycle: developing, testing, installing, operating, and using. The base language of the documentation is English. The English version is the most actual. All other languages are supported as much as they can by contributors from different countries.

At the moment, documentation exists in English, Russian, and Chinese. We store the reference documentation besides the ClickHouse source code in the GitHub repository, and user guides in a separate repo Clickhouse/clickhouse-docs.

To get the latter launch the get-clickhouse-docs.sh script.

Each language lies in the corresponding folder. Files that are not translated from English are symbolic links to the English ones.

You can contribute to the documentation in many ways, for example:

• Fork the ClickHouse and ClickHouse-docs repositories, edit, commit, push, and open a pull request.

  Add the pr-documentation label to this pull request for proper automatic checks applying. If you do not have permission to add labels, then the reviewer of your PR will add it.

• Open a required file in the ClickHouse repository and edit it from the GitHub web interface.

  You can do it on GitHub, or on the ClickHouse Documentation site. Each page of ClickHouse Documentation site contains an "Edit this page" (🖋) element in the upper right corner. Clicking this symbol, you get to the ClickHouse docs file opened for editing.

  When you are saving a file, GitHub opens a pull-request for your contribution. Add the documentation label to this pull request for proper automatic checks applying. If you have no permissions for adding labels, the reviewer of your PR adds it.

Contribute all new information in English language. Other languages are translations from English.

• Headings: Place them on a separate line and start with # , ## or ### . Use the Title Case for them. Example:

  # The First Obligatory Title on a Page.
  

• Bold text: **asterisks** or __underlines__.

• Links: [link text](uri). Examples:

  • External link: [ClickHouse repo](https://github.com/ClickHouse/ClickHouse)
  • Cross link: [How to build docs](tools/README.md)

• Images: ![Exclamation sign](uri). You can refer to local images as well as remote in internet.

• Lists: Lists can be of two types:

  • - unordered: Each item starts from the -.
  • 1. ordered: Each item starts from the number.

  A list must be separated from the text by an empty line. Nested lists must be indented with 4 spaces.

• Inline code: `in backticks`.

• Multiline code blocks:

  ```lang_name
    code
    lines
    ```

• Note:

  !!! info "Header"
      4 spaces indented text.
  

• Warning:

  !!! warning "Header"
      4 spaces indented text.
  

• Text hidden behind a cut (single sting that opens on click):

  <details markdown="1"> <summary>Visible text</summary>
      Hidden content.
  </details>`.
  

• Colored text: <span style="color: red;">text</span>.

• Heading anchor to be linked to: # Title {#anchor-name}.

• Table:

  | Header    1 | Header    2 | Header    3 |
  | ----------- | ----------- | ----------- |
  | Cell     A1 | Cell     A2 | Cell     A3 |
  | Cell     B1 | Cell     B2 | Cell     B3 |
  | Cell     C1 | Cell     C2 | Cell     C3 |
  

{## When adding a new file:

• Make symbolic links for all other languages. You can use the following commands:

  $ cd /ClickHouse/clone/directory/docs
  $ ln -sr en/new/file.md lang/new/file.md

##}

1. Create a new docs subfolder named using the ISO-639-1 language code.
2. Add Markdown files with the translation, mirroring the folder structure of other languages.
3. Commit and open a pull-request with the new content.

When everything is ready, we will add the new language to the website.

When writing documentation, think about the people who read it. Each audience has specific requirements for terms they use in communications.

ClickHouse documentation can be divided up by the audience for the following parts:

• Conceptual topics like tutorials and overviews.

  These topics are for the most common audience. When editing text in them, use the most common terms that are comfortable for the audience with basic technical skills.

• Query language reference and related topics.

  These parts of the documentation are dedicated to those who use ClickHouse for data analysis. Carefully describe syntax, input, and output data for expressions. Don't forget the examples.

• Description of table engines and operation details.

  Operation engineers who help data analysts to solve their tasks should know how to install/update a ClickHouse server, maintain the ClickHouse cluster, how to integrate it with other tools and systems, how to get the maximum performance of their entire environment.

• Developer's guides.

  The documentation provides code writers with information about how to write code for ClickHouse and how to build it in different environments.

• When searching for a position for your text, try to place it in the most anticipated place.
• Group entities. For example, if several functions solve similar tasks or belong to a specific group by use case or an application type, place them together.
• Try to avoid slang. Use the most common and specific terms possible. If some terms are used as synonyms, state this explicitly.
• Add examples for all the functionality. Add basic examples to show how the function works by itself. Add use case examples to show how the function participates in solving specific tasks.
• Any text concerning politics, religion, or other social related themes are strictly prohibited in all the ClickHouse texts.
• Proofread your text before publishing. Look for typos, missing punctuation, or repetitions that could be avoided.

When writing docs, you can use prepared templates. Copy the code of a template and use it in your contribution. Sometimes you just need to change level of headers.

Templates:

• Function
• Server Setting
• Database or Table engine
• System table
• Data type
• Statement

You can build your documentation manually by following the instructions in the docs repo contrib-writing-guide. Also, our CI runs the documentation build after the documentation label is added to PR. You can see the results of a build in the GitHub interface. If you have no permissions to add labels, a reviewer of your PR will add it.