[BUG] duckdb doesn't support loading of extensions

[dataders]

error: dbt1308: DuckDB init SQL failed on 'LOAD motherduck':
InvalidArguments: IO Error: Extension "/Users/<user>/.duckdb/extensions/v1.4.4/osx_arm64/motherduck.duckdb_extension" could not be loaded:
dlopen(...): code signature ...
not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs

A similar failure can happen with non-MotherDuck extensions such as httpfs:

error: dbt1308: DuckDB init SQL failed on 'LOAD httpfs': InvalidArguments: IO Error: Extension "/Users/<user>/.duckdb/extensions/v1.4.4/osx_arm64/httpfs.duckdb_extension" could not be loaded: dlopen(...): code signature ... not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs

Important detail: with a MotherDuck path, this can still fail even if extensions: is empty, because Fusion still ends up executing LOAD motherduck as part of DuckDB initialization.

[oberalppaolof]

thanks to open this issue