I can't add my SQL Data base to Metabase from my computer

rin · January 17, 2022, 10:49am

Hello,

I am new to metabase and I just accessed it through localhost:3000 and now access it with paid subscription. I'd like to know why I can't add my SQL database I've already converted from csv to sqlite (but the output is sql), it displays something like this.. Eventhough, I tried it on paid version, it still displays something like this.

"C:\Users\User\Downloads\classic-rock-lists.sql (No such file or directory)"

What should I do? What have been missing?

flamber · January 17, 2022, 11:06am

Hi @rin
Metabase Cloud does not have access to your computer, so that would not be possible:
https://www.metabase.com/cloud/docs/limitations.html
As for accessing an SQLite database via your own self-hosted, then it needs to be able to have access to the file, and the file has to be in SQLite-format, which is not the same as SQL-output.
And try using forward-slashes instead of back-slashes, so C:/Users/User/Downloads/classic-rock-lists.db

rin · January 17, 2022, 2:27pm

Hello @flamber ,
Thank you for your respond.

But how to convert from csv to sqlite online? I keep trying to find online solution since I've watched a lot of videos how to change csv to sql, yet all of them seems need to install something or give command prompt and it is very complicated and I could not follow the instructions, so I converted it online and choose "SQLite" yet the results are "SQL Source File" like this

The original file is from here

github.com

fivethirtyeight/data/blob/master/classic-rock/classic-rock-song-list.csv

Song Clean,ARTIST CLEAN,Release Year,COMBINED,First?,Year?,PlayCount,F*G
Caught Up in You,.38 Special,1982,Caught Up in You by .38 Special,1,1,82,82
Fantasy Girl,.38 Special,,Fantasy Girl by .38 Special,1,0,3,0
Hold On Loosely,.38 Special,1981,Hold On Loosely by .38 Special,1,1,85,85
Rockin' Into the Night,.38 Special,1980,Rockin' Into the Night by .38 Special,1,1,18,18
Art For Arts Sake,10cc,1975,Art For Arts Sake by 10cc,1,1,1,1
Kryptonite,3 Doors Down,2000,Kryptonite by 3 Doors Down,1,1,13,13
Loser,3 Doors Down,2000,Loser by 3 Doors Down,1,1,1,1
When I'm Gone,3 Doors Down,2002,When I'm Gone by 3 Doors Down,1,1,6,6
What's Up?,4 Non Blondes,1992,What's Up? by 4 Non Blondes,1,1,3,3
Take On Me,a-ha,1985,Take On Me by a-ha,1,1,1,1
"Baby, Please Don't Go",AC/DC,,"Baby, Please Don't Go by AC/DC",1,0,1,0
Back In Black,AC/DC,1980,Back In Black by AC/DC,1,1,97,97
Big Gun,AC/DC,1993,Big Gun by AC/DC,1,1,6,6
CAN'T STOP ROCK'N'ROLL,AC/DC,,CAN'T STOP ROCK'N'ROLL by AC/DC,1,0,5,0
Dirty Deeds Done Dirt Cheap,AC/DC,1976,Dirty Deeds Done Dirt Cheap by AC/DC,1,1,85,85
For Those About To Rock,AC/DC,1981,For Those About To Rock by AC/DC,1,1,46,46
Girls Got Rhythm,AC/DC,,Girls Got Rhythm by AC/DC,1,0,24,0
Hard As A Rock,AC/DC,1995,Hard As A Rock by AC/DC,1,1,1,1
Have a Drink On Me,AC/DC,1980,Have a Drink On Me by AC/DC,1,1,39,39

This file has been truncated. show original

and I download it in zip format which resulted as csv file like this..

and I converted it online from here:

and I choose "SQLite" format yet the output is like the picture above, still "SQL Source file".

Is the output really "SQLite" format eventhough it appears as "SQL Source file".

Maybe, are there reliable source which can produce output in SQLite format?

flamber · January 17, 2022, 2:37pm

@rin May I recommend that you just use the CSV driver instead of converting to SQLite:
https://github.com/Markenson/csv-metabase-driver

When using "konbert", then I'm guessing you're clicking the button "Export as SQL", which is exactly what it says, outputs SQL not a SQLite binary database.
Try this instead: https://www.rebasedata.com/convert-csv-to-sqlite-online

rin · January 18, 2022, 10:09am

@flamber

I tried "csv metabase driver" and it seems complicated cause I can't find directory/plugins in metabase but I am gonna try it later, but it worked with the sqlite converter online you mentioned above and it is easier. Thank you so much:slightly_smiling_face