[Python] DuckDB in lightweight incremental Foundry transform

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?

Continue reading...