Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

How to configure new CSV database #1

Closed
Markenson opened this issue Oct 11, 2019 · 5 comments
Closed

How to configure new CSV database #1

Markenson opened this issue Oct 11, 2019 · 5 comments

Comments

@Markenson
Copy link
Owner

Follow these instructions:

image

@Markenson Markenson changed the title How to configure new CSVdatabase How to configure new CSV database Oct 11, 2019
@whintu
Copy link

whintu commented Feb 3, 2020

Hello. I try to configure test connection to csv and get this message:

 java.lang.IllegalArgumentException: No method in multimethod 'connection-details->spec' for dispatch value: :csv
         at clojure.lang.MultiFn.getFn(MultiFn.java:156)
         at clojure.lang.MultiFn.invoke(MultiFn.java:233)
         at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invokeStatic(connection.clj:152)
         at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invoke(connection.clj:147)
         at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:158)
         at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:154)
         at metabase.driver.sql_jdbc$fn__71217.invokeStatic(sql_jdbc.clj:35)
         at metabase.driver.sql_jdbc$fn__71217.invoke(sql_jdbc.clj:34)
         at clojure.lang.MultiFn.invoke(MultiFn.java:234)
         at metabase.driver.util$can_connect_with_details_QMARK_$fn__22416.invoke(util.clj:32)
         at metabase.util$do_with_timeout$fn__9877.invoke(util.clj:302)
         at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
         at clojure.lang.AFn.call(AFn.java:18)
         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
         at java.lang.Thread.run(Thread.java:748)
 02-03 12:31:20 DEBUG middleware.log :: POST /api/database 400 13,0 ms (0 DB calls)

@vikashk77
Copy link

Hello, Markenson,

Gives same error to me. Are we missing anything in the coonfiguration.

I replicated your steps though

Kind Regards,
Vikash

@Markenson
Copy link
Owner Author

Markenson commented Apr 5, 2020

Hello. I try to configure test connection to csv and get this message:

 java.lang.IllegalArgumentException: No method in multimethod 'connection-details->spec' for dispatch value: :csv
         at clojure.lang.MultiFn.getFn(MultiFn.java:156)
         at clojure.lang.MultiFn.invoke(MultiFn.java:233)
         at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invokeStatic(connection.clj:152)
         at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invoke(connection.clj:147)
         at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:158)
         at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:154)
         at metabase.driver.sql_jdbc$fn__71217.invokeStatic(sql_jdbc.clj:35)
         at metabase.driver.sql_jdbc$fn__71217.invoke(sql_jdbc.clj:34)
         at clojure.lang.MultiFn.invoke(MultiFn.java:234)
         at metabase.driver.util$can_connect_with_details_QMARK_$fn__22416.invoke(util.clj:32)
         at metabase.util$do_with_timeout$fn__9877.invoke(util.clj:302)
         at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
         at clojure.lang.AFn.call(AFn.java:18)
         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
         at java.lang.Thread.run(Thread.java:748)
 02-03 12:31:20 DEBUG middleware.log :: POST /api/database 400 13,0 ms (0 DB calls)

Hi! I think this will solve the problem: #2 (comment).

Cheers,
Markenson

@Markenson
Copy link
Owner Author

Markenson commented Apr 5, 2020

Hello, Markenson,

Gives same error to me. Are we missing anything in the coonfiguration.

I replicated your steps though

Kind Regards,
Vikash

Hi! I think this will solve the problem: #2 (comment).

Cheers,
Markenson

@theauheral
Copy link

Am I doing anything wrong? I tried directory, file... etc. I have the error
I am using metabase v0.35.3 (Latest) and your latest csv driver.
Dataset: https://www.kaggle.com/doaaalsenani/usa-cers-dataset

Error: No suitable driver found for jdbc:relique:csv:file:/C:/Users/theau/Downloads/usa-cers-dataset/USA_cars_datasets.csv?separator=,&charset=utf-8

screenshot csv metabase

Logs CSV driver.txt.txt

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants