jwills / target-duckdb

A Singer.io target for DuckDB
Other
17 stars 12 forks source link

Fully qualified path error #21

Closed jaypeedevlin closed 1 year ago

jaypeedevlin commented 1 year ago

Describe the bug

It's not clear whether this is a Meltano issue or a duckdb issue, I'm getting the following error when I try to load data using a recent installation of target-duckdb

duckdb.BinderException: Binder Error: Ambiguous reference to catalog or schema "myschema" - use a fully qualified path like "myschema.myschema"`

To Reproduce

  1. Use a clean installation of target-duckdb in Meltano
  2. Send some data through the target
  3. When the target tries to create a table, it raises the error above.

Expected behavior When I change the load_schema property in Meltano from myschema to myschema.myschema, everything works as expected. Using an earlier installation of target-duckdb (same version of the target but installs an earlier version of duckdb itself) it worked fine defining that property as myschema only.

Screenshots If applicable, add screenshots to help explain your problem.

Your environment

Additional context I'm happy with my workaround as above, just wanted to flag this in-case it was an issue on the target side worth fixing.

jwills commented 1 year ago

0.5.0 is now up on pypi with the fix!