SQLite Local import

Get Help
1

Hello,

I am new to this community and environnement.

So I will try to be as precise as possible.

I looking to create a test environnement for a dashboard app localy to learn how to use the tools.

I have download the jar file since I don't know how to configure it with docker.
I have manage to lauch it, and manage to the main menu.

My issue is when I try to connect my local SQLite DB (‪C:\Users\username\Desktop\SQLite\databasename.db)
I get an error message "Incorrect file, directory, volume syntax".

I have try to look for a linked topic but I didn't find out one which could help me.

Diag info :
{
"browser-info": {
"language": "fr-FR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"h2"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-11-26",
"tag": "v0.51.5",
"hash": "d79d949"
},
"settings": {
"report-timezone": null
},
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "2.1.214 (2022-06-13)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "2.1.214 (2022-06-13)"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "23.0.1+11-39",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "https://java.oracle.com/",
"java.version": "23.0.1",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "23.0.1+11-39",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "fr",
"user.timezone": "Europe/Paris"
}
}

Thanks a lot for your help :slight_smile:

2

I manage to fix it via Docker :

I create a volume (docker volume create my_volume)

Then I mount my local data base on the volume

docker run -d -i -p 3000:3000 --name metabase -v metabase-data:/data -v C:\Users\my_user\Desktop\sqlite_db.db:/data/database.db metabase/metabase-enterprise:latest

To connect the db in the web app, just put this path : /data/database.db

It should work properly

1 Like