Goal: I need a csv export for a Retool Database based on filters
Steps: If I export directly from the database I get every entry and cannot apply any filters. If I try to first move it to a table inside an app, it doesn't allow me to pull the data cuz it's over 100mb.
This makes the database completely useless.
How can I get a database extract?
Hello @Nicole_Reiter!
Apologies for the inconvenience. I just tested out the export functionality for Retool Database and it is frustrating that filters applied to a table are not reflected in the exported data.
My first thought would be that you could query the data to a table, filter the data accordingly and then use a query to create a new table and add in the now-filtered data to its own Retool Database table that could then be exported to a CSV.
However, as you stated you are working with over 100mb of data, which is too much for a single action and would have to be batched/chunked into smaller amounts and then go through the process I outlined above.
I can definitely make a feature request to add in functionality to Retool Database to allow for "export filtered data", and I can keep you updated on this feature request in this thread.
In the short term, you may need to use a SQL query directly on the data to apply a filter and to export it. Are you self hosting your Retool instance? If so, it should be fairly straightforward to write commands directly to the underlying Postgres database that Retool Database is running on.
If you are on the cloud, I can do some research and see if that same process can be done. Although my hunch is that we might not be able to access the cloud database 