DuckDB in lightweight incremental Foundry transform

Question

Unable to use DuckDB in an incremental lightweight xform. The docs read to access the duckdb object from the context, but it fails to do so.

from transforms.api import transform, incremental, Input, Output

@incremental(v2_semantics=True)
@transform.using(
    input=Input(""),
    output=Output(""),
)
def compute(ctx, input, output):
    ddb = ctx.duckdb(read_modes={input: ["current", "previous"]})

Error:

ddb = ctx.duckdb(read_modes={input: ["current", "previous"]})
          ^^^^^^^^^^
AttributeError: 'LightweightContext' object has no attribute 'duckdb'

All dependencies are up to data in Code Repository.

Wonder if anyone is using DuckDB in this same environment? Any example on how to access the duckdb object?

ZettaP · Accepted Answer · 2025-12-01 22:13:14Z

0

You should upgrade your code repository, via the upgrade PR, so that you get a higher version of transforms library (>3.123 should work !)

answered Dec 1 at 22:13

ZettaP

1,49412 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DuckDB in lightweight incremental Foundry transform

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related