duckdb / duckdb/dbt-duckdb

Support Javascript UDFs

Open
#809 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.4k
Forks
147
Avg merge
1d 19h
Merged PRs (30d)
12

Description

It seems that dbt-duckdb is not yet compatible with the [recently added Javascript UDFs](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.12?version=2.0&name=v2#extensions-to-udfs)

_[ERROR]: Function 'decode_url' uses JavaScript, which is not supported on 'duckdb'_

```
User Error: dbt failed during project compilation.
Consider running `dbt debug` or `dbt compile` to get more information from dbt.
dbt.exceptions.ParsingError: Parsing Error
[ERROR]: Function 'decode_url' uses JavaScript, which is not supported on 'duckdb'.
(.venv) x@x datahub-dbt % sqlfluff lint models/cep/cep_customers.sql
```

```
Core:
- installed: 1.12.0
- latest: 1.12.0 - Up to date!

Plugins:
- snowflake: 1.12.0 - Up to date!
- duckdb: 1.10.1 - Up to date!
```

Contributor guide

Open the contributing guide

Research direction

Start with the linked dbt 1.12 JavaScript-UDF upgrade notes and reproduce the failure with `dbt compile` or `dbt debug` using the shown versions; compare the DuckDB adapter's handling with the reported `decode_url` case. Done means a dbt project using a JavaScript UDF compiles under dbt-duckdb without the unsupported-on-duckdb error, and the existing `sqlfluff lint` check remains usable.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, python
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.