I'm trying to export to .CSV from a query. It works for small files but I have files with 400k records and 700k records. It stops working on those. In the test section of the query, it hard exits. When I use PROCESS, it gets stuck.
Is there a limit on the file size?
I tried chopping it down to 100k records but still not working.
(Version 2020 on Win10)