rename

Description

Renames fields.

Syntax

rename <src-field> AS <dst-field> [ , <src-field> AS <dst-field> ...]

Required Arguments

Parameter	Syntax	Description
src-field	<string>	Name of the source field.
dst-field	<string>	New name for the field.

Using Wildcards

The * symbol is supported for bulk field renaming. Multiple uses of * within a single pattern are allowed.

Query Example

Example №1

source radius_logs
| rename user as sysuser, password as secret

Example №2

source company_workers | rename company-* as *

Example №3

source company_workers | rename *-company-* as *-with-*