Redash maintenance and Backup

Hello Everyone,
Greetings for the day!! Hope you all doing great today!

Team,
We have been using redash since couple of months. All of sudden last month redash went off due to an error message “No space left on device” results in corrupted Hard disk. Somehow after working with AWS support we could get back all the data and instances successfully back. Now we would like to periodic maintenance and backup on queries.

In some post I saw that all the queries that we fire at redash are stored in a table called queries. But I couldn’t find such table. Could someone help us in performing extra level of query backup on weekly basis to make sure the impact is very less in the event of failure?

Appreciate your time help!

1 Like

It’s easiest to do this with the API. Our documentation includes a script for exporting all your queries as files. Or if you wanted a simple JSON backup it’s even easier using the redash-toolbelt library:

from redash_toolbelt import Redash
import json

url = "your redash instance url"
key = "your api key"
path_to_file = "path to your file system for back-up"

client = Redash(url, key)

with open(path_to_file 'w') as fp:
    queries = client.paginate(client.queries)
    json.dump(queries,fp)

Thank you so much Susidapop for your immediate response. I’m trying to perform the steps as per the document. Will get back to you if something pops up!

1 Like

Hi @kylashpriya what you described has just happened to me. How did you get the data and instances back?

I’ve tried upsizing the volumes and CPU but still keep getting this No space left on device error every time the EC2 tries to start.

I figured it out without needing to contact AWS support, you can see the gist of it here:

Hello njachowski,
I got the issue fixed by expanding the EBS volume and moved couple of directories to another location ( as per aws support steps). Thanks a lot for your response!