Hi Team, Can I override the field value to blank in ingestion transformation?

Using groovy, yes. What’s the reason for doing that?

I want to temporarily stop ingesting some fields. I tried groovy with like this

{
          "columnName": "<column>",
          "transformFunction": "Groovy({''})"
        },

but it didn't work, the values are still intact.

Why do you want to stop ingesting? Also empty value doesn’t mean ingestion stopped for them

Some PII fields need to be removed, There is no way to remove it from a live table. So until we find a suitable time and way to recreate the table. We just want to omit the data for these fields.

You can use one way hash functions (check docs) to anonymize those

All the usages have already been modified, we are specifically targeting to remove or omit those fields, is there a way ?

Groovy is the way, will need to check why it doesn’t work for you. It might be that it is deemed backward incompatible change and didn’t take effect (call get on it and see)