I have successfully created a query that formats the data the way I need it but I can't seem to find a way to automatically export the query results to an FTP site in csv format. All I see is the option to manually click csv. I looked at the intergration option but it won't let me choose a query that was already created as the source. Can this be done. I need the query to run once a day at a specific time so that it exports the file to the FTP site where another system will process it?
Please let me know, asap.