SQLite is not supported
clariBI does not connect to SQLite or accept .sqlite or .db uploads. Export the tables you need as CSV and upload those, or keep the data in one of the four databases clariBI connects to.
SQLite is not in the connection form. The old option only read a file path on clariBI's own server, which you cannot put a file into, so it was removed. There is no SQLite file upload.
Use a CSV export instead
Export from SQLite
Open the file with the sqlite3 command-line tool or a viewer such as DB Browser for SQLite and export each table as CSV.
Upload the file
In clariBI, open Data Sources > Add Data Source > File upload and drop the CSV or Excel file. Files can be up to 50 MB each.
Use the dashboard
clariBI detects the columns and builds a dashboard for the file. On the trial and on Starter and above you can ask questions about it in plain English. Upload a new export when you need fresher numbers.
Connectors that do work
- CSV and Excel uploads, up to 50 MB per file
- PostgreSQL, MySQL, SQL Server or Oracle, if the data can live in a database server that clariBI can reach over the internet
About SQLite and clariBI
Can I upload the .db file itself?
No. File uploads accept CSV, Excel, JSON, XML, Parquet and text files, not database files.
Try clariBI with an export
The trial lasts 14 days, includes 50 AI credits and needs no card. When it ends, your account moves to the Free plan and keeps its data and dashboards.