A community member was wondering if
transformSpec could be used to expand or generate rows. For their particular question, the better option was to leave the data nested and use the experimental nested columns feature introduced in Apache Druid 24.0.
transformSpec takes a single row as input and outputs a single value. It is an optional ingestion spec component, and it’s responsible for transforming and filtering records during ingestion time. Read more here.