Open Tauvic opened 2 years ago
Well, you could create a model adding the "Truncate table" algorithm as a first step.
However, I'll leave this feature request open to see if other users find it interesting. If so, I could implement it.
Hi, fast response. Did not know about the truncate trick. Now i found it. Great work its very useful. Im making a map on playgrounds and the ETL approach is a big help.
!(image)[https://tauvicr.files.wordpress.com/2021/11/qgis_buurtkaart-1.png]
For ETL it can be useful to clear the destination before inserting. Then we can do load, transform and dump the result.
For some processing i don't want to do upsert kind of insertion. Just a plain clear the target and insert is also very usefull.