Can I schedule a query somehow and get the results on email/local file?

Hi,

I have a use-case where I need to schedule run a query at let’s say 12 in the night and get the results on email or store it on a local file. How can I achieve this? I assume that Redash is not meant for such operations. But has someone tried to achieve something like this? If not, what tool should be best for this?

You’re right that Redash isn’t really built for this. But there are a few ways to accomplish it.

If it were me, I’d use my operating system’s task scheduler (CRON) to hit the Redash API endpoint for a CSV as midnight and save the results somewhere.