Skip to main content

DROP

Remove specific fields from the dataset.

Syntax​

DROP field [, field]* [,]?

Parameters​

  • field - Name of the field to remove from the results

Description​

The DROP command removes specified fields from the dataset while preserving all other fields. Unlike SELECT, which defines exactly what fields to keep, DROP defines exactly what fields to exclude.

You can specify multiple fields in a single DROP command, separated by commas. Each identifier must refer to a field that exists in the current pipeline context. DROP also works for nested fields using dot notation (e.g., user.email).