0

How to import SQLite data into DuckDB? Or is it possible to query the SQLite data files directly from DuckDB? A presentation from author of DuckDB mentioned such a feature.

user4157124
  • 2,809
  • 13
  • 27
  • 42
vega77
  • 52
  • 3

1 Answers1

2

yes it is possible to scan SQLite db files directly by using the sqlite extension

You first will need to install and load it

INSTALL sqlite_scanner
LOAD sqlite_scanner
CALL sqlite_attach('your_sqlite_db.db');

Then you should be able to query the sqlite tables.

Pedro Holanda
  • 261
  • 1
  • 3