We just rolled out an overhaul to the CSV data exporting feature, which paid users can see in the Data > App Data panel of the editor.
- No more 20k row limitation (should work on just about any table)
- The export is now done server-side, and the editor remains fully useable during the export
- When the export is complete, we will send an email to you with a link to it
- The result file will appear in your files as a private file only visible to users with editor access
- You can make several exports at once
- New file export format options: csv, json, and ndjson (newline-delimited JSON)
- A lot faster for simpler views!
- You can see exports in-flight and can cancel any there
Tips and gotchas:
- Behind the scenes, we export in batches that we stitch together: this means that rows deleted during an in-flight export may still end up in the export if a previous batch exported them already
- Don’t edit a data view during an export of that view! For the reason stated above, weird things may happen
- A view where columns contain data from other tables will be a lot slower to export than a table with only self-contained data. If you want the best possible speed, set all “primary fields” that appear in a given view to be unique ids.
Hope you like it, and be sure to report any problems you encounter with it!