Skip to content

Update Embedded DuckDB runtime to 1.5.5+ #1244

Description

@axz883

What

The current embedded runtime is v1.5.3 supporting Snowflake extension v0.1.0
Request is to update to v1.5.5+ supporting Snowflake extension v0.5.2

Why (problem/use case)

Embedded DuckDB v1.5.3 prevents use of newer Snowflake Extension features.
Specifically, the Snowflake extension inside DBCode cannot locate the ADBC Snowflake driver.
Snowflake extension v0.5.2 added support for ADBC driver path declaration. (SNOWFLAKE_ADBC_DRIVER_PATH)

Additional Context

Environment
DBCode Version: VS Code Version:

DBCode Embedded DuckDB: v1.5.3

Snowflake Extension: v0.1.0

Problem
I successfully connected DuckDB to Snowflake using:

DuckDB v1.5.5
Snowflake Extension v0.5.2
outside of DBCode.

However, DBCode uses DuckDB v1.5.3 and Snowflake Extension v0.1.0.

The Snowflake extension inside DBCode cannot locate the ADBC Snowflake driver. Support for override path added in later extension version for v1.5.5+ (SNOWFLAKE_ADBC_DRIVER_PATH)

Working Configuration
DuckDB CLI:

SELECT version();
returns:
v1.5.5

Snowflake extension:
SELECT snowflake_version();
returns:
Snowflake Extension v0.5.2

I set:
PowerShell
SNOWFLAKE_ADBC_DRIVER_PATH=
C:\Program Files\Microsoft Power BI Desktop\bin\ADBC Drivers\Snowflake\libadbc_driver_snowflake.dll

and Snowflake connectivity works successfully.

Failing Configuration

DBCode:
SELECT version();
returns:
v1.5.3

Snowflake extension:
SELECT snowflake_version();
returns:
Snowflake Extension v0.1.0

The same Snowflake secret fails with:
ADBC Snowflake driver (libadbc_driver_snowflake.so) not found

The old extension appears to ignore SNOWFLAKE_ADBC_DRIVER_PATH.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions