hellonico/metabase-csv-sample

SETUP

Download jar files in this checkout:

• csvjdbc.jar
• metabase.jar

START METABASE

# start.bat 
# or
# start.sh
java -cp csvjdbc.jar:metabase.jar metabase.core

BURGERS CSV DATABASE SETTINGS

Name: burgers Path to csv file: BURGERS fileExtension: .csv separator , quotechar " indexedFiles YES fileTailPattern .(.*) fileTailParts date fileTailPrepend NO headerline columnTypes String,Double,Double,Double,Double,Double,Double,Double,Double,Double,Double,Date suppressHeaders NO commentChar ignoreNonParseableLines NO missingValue trimValues YES Enable Logging burgers.out trimHeaders YES timestampFormat timeFormat dateFormat yyyyMM

sql query

select * from BigMac where Country in ('Japan','France', 'Argentina');

screenshot