You can use a Target transformation in advanced mode to write hierarchical data to complex files, such as Avro, JSON, and Parquet files.
Consider the following guidelines when you write hierarchical data:
You must use an Amazon S3 V2 or Azure Data Lake Storage Gen2 connection to write hierarchical data. For more information, see the help for the appropriate connector.
You must create a new target at run time.
Do not use a parameter for the target connection or the target object.