What is the best way to programatticaly export a CSV from a SQL query output?
We pipe all our production metrics into a SQL DB accessbile via Redash. Our customer support team wants to take the output of one of their SQL queries and push it to another dashboard tool they're using. This particular tool doesn't have a typical REST API importer, instead they suck in CSVs off of a shared S3 bucket.
So I need to figure out a way to programatticaly export a CSV from a SQL query in Redash. This way the customer support team can modify the query as they wish to change what gets imported into their tool.
Is there a way to trigger the CSV export functionality via an API call to Redash? IE,
curl an endpoint and get the CSV back?