Inputs.file & DuckDB

Community Help
1

Hi,

I wanted in a notebook to show how duckdb works with observablehq. Standard approach based on observable documentation works fine:

db = DuckDBClient.of({
  match : FileAttachment("example.csv")
})

after attaching the file. However, I wanted allow users to attach a file from disk based on Inputs.file. My code is

viewof csvfile = Inputs.file({label: "CSV file", accept: ".csv", required: true})

db_input = DuckDBClient.of({
  match : FileAttachment(csvfile["name"])
})

this gives me the following error:

image
image1199×804 31 KB

Is there a workaround ?

Reproducible example here

2

Maybe try this:

db_input = DuckDBClient.of({match: await csvfile.csv()})

1 Like
3

Thanks for the reply ! Worked like a charm !

1 Like