search

alitrack / duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL
MIT License
272 stars 18 forks source link

Compatibility with MotherDuck connection string #19

Closed williamong68 closed 6 months ago

williamong68 commented 9 months ago

I see that this current repo works with local duckdb server. Is there on the roadmap any plans for a connection to a duckdb server that is hosted on Motherduck using the connection string?

alitrack commented 9 months ago

does there exist a connection string on Motherduck?

williamong68 commented 9 months ago

Yes, there is a share option that I saw that when clicked, would give a connection url. The format looks like this: ''md:_share/my_db/'

alitrack commented 9 months ago

have you successfully attached it to your local DuckDB? I tried on My mac m2, got an error

Running query in 'duckdb:///'
(duckdb.InvalidInputException) Invalid Input Error: Initialization function "motherduck_init" from file "/Users/m2max/.duckdb/extensions/v0.8.1/osx_arm64/motherduck.duckdb_extension" threw an exception: "IO Error: Failed to download "http://api.motherduck.com/extension_version". Status code "403": Success" [SQL: ATTACH 'md:_share/my_db/<string_of_generated_numbers_and_digits>'] (Background on this error at: https://sqlalche.me/e/14/f405)
alitrack commented 6 months ago

@williamong68 here is a Chinese article about how to connect with MotherDuck through duckdb_fdw