duckdb version issue on superset using docker

[yeslawr2]

Environment: MacOS Ventura 13.4.1

Command: make docker-run-superset

Description: When I run the docker container for the superset visuals, I get the error shown below in the dashboard. I tried setting the duckdb-engine version to 0.7.1 in the meltano.yml file, but it still didn't work.

[matsonj]

Interesting. It looks like the version pinning in meltano.yml isn’t working, because it is set to duckdb-engine==0.6.8 which I think is actually for duckdb 0.6.0.

I’ll see if I can sort out the version pinning, but in the meantime, can you confirm what version of duckdb-engine is getting installed by meltano?

[matsonj]

Ok, so the issue is actually not anything to-do with duckdb-engine, but rather that it has a dependency on duckdb. So the fix is just pinning the duckdb version so it is the same in dbt + superset.

[matsonj]

Proof - running inside a codespace (on my iPad lol)

[yeslawr2]

That makes sense. Also, meltano installed duckdb 0.7.1 when I changed the value in the meltano.yml file. But looks like superset is able to connect to the db now. Thank you! 😃