1. Original `.csv` file: 165MB
![[CleanShot 2025-05-24 at
[email protected]]]
2. In your terminal run
```bash
gzip 2024-09-12T22-41-00_mspo_smallholder_list.csv
```
3. After compression, the file size is now 5.9MB (-96.4% reduction)
![[CleanShot 2025-05-24 at
[email protected]]]
4. Read from the `gzip` file using [[DuckDB]]
(The cell only takes (230k rows) 1.49s to run!)
![[CleanShot 2025-05-24 at
[email protected]]]