template¶

Selects the message template that renders the INSERT statement sent to ClickHouse.

This parameter applies to omclickhouse: ClickHouse Output Module.

Name:: template
Scope:: input
Type:: word
Default:: `` StdClickHouseFmt``
Required?:: no
Introduced:: not specified

Description¶

This is the message format that will be sent to ClickHouse. The resulting string needs to be a valid INSERT Query, otherwise ClickHouse will return an error. Defaults to:

Note

The leading space in `` StdClickHouseFmt`` is intentional. Rsyslog registers its built-in templates with a leading space in the internal configuration state, and the module looks up the default by that exact name. When overriding the parameter yourself, use the natural form StdClickHouseFmt (without the space) as shown below.

"\"INSERT INTO rsyslog.SystemEvents (severity, facility, "
"timestamp, hostname, tag, message) VALUES ("
"%syslogseverity%, %syslogfacility%, "
"'%timereported:::date-unixtimestamp%', '%hostname%', "
"'%syslogtag%', '%msg%')\""

Input usage¶

module(load="omclickhouse")
action(type="omclickhouse" template="StdClickHouseFmt")

See also¶

See also omclickhouse: ClickHouse Output Module.

Support: rsyslog Assistant | GitHub Discussions | GitHub Issues: rsyslog source project

Contributing: Source & docs: rsyslog source project

© 2008–2025 Rainer Gerhards and others. Licensed under the Apache License 2.0.

nnnn