Used to extend the current dataset to columns as per the requirement. In this example, a new column named “ BootSince_newColumn ” is added to the output using the extend operator. This new variable calculates the time difference since boot time and now. The output shows the newly added column BootSince_newColumn with the value 2342, which is the number of hours since the boot time. For a more commonly applicable real world example, extend operator can be used to calculate the number of days since the last login date.
Project operator is used to customize the query result output as per your needs. This doesn't remove or modify any logs. It only affects how it is presented for that particular query, for that particular run. To keep only one particular column details instead of all available columns. If you wish to remove only a column and keep all other available columns, then use project-away project-rename option can be used to rename the column name. Here in this example, the column with name "Computer" is renamed to "device". To reorder the columns, use project-reorder To summarize, Operator Description project Determines the columns to include, rename, or drop, and insert new computed columns. project-away Determines which columns from the input should be excluded from the output. project-keep Determine what columns from the input to keep in the output using a column name pattern match. project-rename Renames columns in the output project-reorder Reorder columns in the ...