search

AlexR2D2 / metabase_duckdb_driver

Metabase DuckDB Driver shipped as 3rd party plugin
Apache License 2.0
70 stars 21 forks source link

How to connect 'motherduck' database #27

Closed coderyeasin closed 3 months ago

coderyeasin commented 4 months ago

Previous issues was resolved! so that's why closed.

I want to connect with 'motherduck' using this driver can i do that?

vgrimaldi848 commented 3 months ago

You will need the 0.9.2 release of the jdbc driver to connect to Motherduck.

You will just need to setup the correct jdbc url according to:

https://motherduck.com/docs/integrations/dbeaver/

as you would connect with a normal JDBC client.

coderyeasin commented 3 months ago

@vgrimaldi848 Thnak you so much your response! it was version conflicts and resolve with this version.

coderyeasin commented 3 months ago

@vgrimaldi848 using this dbeaver successfully created connection with my motherduck database and i can see tables, can query as well as other stuff too.

according to this metabase-duckdb-driver requirement i'm successfully installed .jar file into /home/plugins folder and set .env using docker in ubuntu

Point is: so my point is how would i connect this motherduck database into metabase so that i can visualize data.

because i created several connection but its saved as blanked database, i'm provide 'duckdb' setup options in metabase please see my attached image, configuration is same according to this driver requirement but what i'm missing can't resolve yet.

@AlexR2D2 Can you please look into this.

Screenshot from 2024-03-13 01-23-08

coderyeasin commented 3 months ago

I am downgrade and upgrade but its not compatible so can't see any 'DuckDB to 0.9.2' in this driver versions, for above solution to connect motherduck using jdbc driver its successfully worked but can't integrate with metabase?

Screenshot from 2024-03-14 16-47-02