I am trying to get data from Sharepoint to S3 using appflow and am able to build the flow.

The data is getting partitioned by the Execution ID. Searched the web and the AWS documentation which suggests that there is an option “Partitioned and aggregation” section where I can remove this partition. However, that option doesn’t exist in the flow for me. I am currently using AWS Redshift serverless free tier.

So, Flow is working but unable to remove partitioned loading of data into S3.

Any suggestions to fix this is highly appreciable, thanks.

Checked AWS Documentation –
https://docs.aws.amazon.com/appflow/latest/userguide/flows-partition.html

This option is not popping up for me: