Cloud

Comment Support

Redpanda SQL fully supports comments in your queries. Comments provide a way to add explanatory notes and improve the readability of queries, making it easier for developers and stakeholders to understand complex queries.

There are two types of comments in Redpanda SQL: single-line and multi-line (block).

Single line comments

A single-line comment in Redpanda SQL starts with two consecutive hyphens (--) and extends to the end of the line. Use these comments to annotate specific parts of a query with brief explanations or notes that help readers understand the query.

Syntax

-- This is an example single line comment

Multi-line (block) comments

Redpanda SQL also supports multi-line comments, often referred to as block comments. These comments begin with / and end with /, allowing for multi-line explanations or temporarily disabling sections of the query.

Syntax

/*
This is an example multi-line comment.
It can span multiple lines and is useful for providing detailed explanations.
*/

Comment placement

In Redpanda SQL, single-line comments should always be placed at the end of the line they refer to, whereas multi-line comments can be positioned anywhere within the query.

Comment on a single line

SELECT column1, column2 -- This is an example single line comment
FROM default_redpanda_catalog=>table_name;

Comment on multiple lines

SELECT /* comment 1 */ column1, column2
FROM default_redpanda_catalog=>table_name /* comment 2 */
WHERE column3 = 42 /* comment 3 */ ;

Best practices for commenting

To maximize the benefits of comments in Redpanda SQL queries, follow these best practices:

  • Be concise. Write clear and concise comments that provide meaningful insights into the specific parts of the query.

  • Update comments during code changes. Whenever the query is modified, update the associated comments to reflect the changes accurately.

  • Avoid over-commenting. While comments are helpful, excessive commenting can clutter the code and reduce readability.