/
Drop directive
Drop directive
The DROP directive is used to drop a column in a record.
Syntax
drop :column [,:column]*
The :column
is the name of the column in the record to be dropped.
Usage Notes
After the DROP directive is applied, the column and its associated value are removed from the record. Later directives will not be able to reference the dropped column.
Example
Using this record as an example:
{
"id": 1,
"timestamp": 1234434343,
"measurement": 10.45,
"isvalid": true
}
Applying this directive:
drop :isvalid,:measurement
results in a record with no isvalid
or measurement
fields:
{
"id": 1,
"timestamp": 1234434343
}
, multiple selections available,
Related content
Set Column directive
Set Column directive
Read with this
Router Transformation (Deprecated)
Router Transformation (Deprecated)
More like this
Rename directive
Rename directive
Read with this
Snowflake to Cloud Storage Action (Deprecated)
Snowflake to Cloud Storage Action (Deprecated)
More like this
Flatten directive
Flatten directive
Read with this
Parquet Dynamic Partitioned Dataset Sink (Deprecated)
Parquet Dynamic Partitioned Dataset Sink (Deprecated)
More like this
Created in 2020 by Google Inc.