DuckDB can be a great help in many areas. Because it is so easy to use, because it is already included in SQL DATA LENS: no installation, no driver download, so you can get on with your work.

DuckDB can be incredibly helpful for the little things! DuckDB can be a huge time saver, even if you just want to quickly analyse some local csv \ parguet files. Just run a: “SELECT * FROM ‘\\path to my datafile'” on a file and let auto_detect do the work.

To get started, simply create a new in-memory connection by right-clicking in the connection tree::

Now open a new query window and start working on some files.

However, it is faster to simply drag and drop the file onto the connection in the connection tree. SQL DATA LENS will create the necessary SQL statements for you with some nice details:

Drag and drop files for easy analysis
Drag and drop files for easy analysis