MongoDB query error

1

I’m using Dremio Enterprise in AWS Edition with vendor recommended EC2 coordinator machine.
I’m trying to create a dataset from mongodb collection, but when run (or save) this query, getting this error:
Query failed with error code 16820 and error message 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server <ip>:<port>.

How can I pass this parameter (alowDiskUse) to mongodb?

Thanks!

2

@joelhansen I would like to see if the push down to MongoDB failed with this error, the profile will also tell us if we pushed down any filters and joins. Could you please upload the profile so we can review?