How can I download big datasets?
Sometimes users end up with verly large tables that cannot be exported because of platform limitations. In order to bypass this problem, there is a workaround that solves the issue.
Create a map and download it as a .carto
The trick is to create a map using the dataset you want to download and then simply download your map as a .carto file. Read this article to learn about exporting and importing CARTO maps.
This .carto file is just a zip file containing your dataset as a Geopackage. The format is very compact and easy to convert to other formats using modern GIS software such as QGIS.