Support API key authentication via query parameters for DuckDB integration

Posit Professional & Hosted Products Posit Connect
1

Hi, I wanted to know if it's possible to query my API hosted on POSIT Connect which exposes Parquet FIles to be queried directly via duckdb? If not, I'd like to make a feature request how would I do that?
Regards Christoph

2

Hello Christoph,

Can you please provide some details as to how you are hosting your Parquet data through an API on Connect? There may be a distinct format needing to be returned for DuckDB to read it properly.

In terms of authentication against API's hosted on Connect, it should be possible to set the Authorization header with your Connect API key like so: https://github.com/duckdb/duckdb/discussions/14165

The header should be: "Authorization: Key "

3

Hello thank you so much for your swift answer, I was not aware of that feature I will try as soon as possible and will comment if it worked!
Here is my endpoint code, it's a plumber2 API
Nothing special about it, just a plain table.

#* @get /data/readouts/<days_back>/<grid>
#*
#* @serializer parquet
#* @param days_back:integer Anzahl Tage zurück: Defaults 14
#* @param grid:string Ne######r: V## oder A##
function(days_back = 14, grid ) {
  fetch_readout_data_raw(days_back = days_back, grid = grid)
}
4

Okay great! Let us know.

Depending on the size of the dataset this may end up being slower than serving a static parquet file, but I will leave that for you to look into since that is outside of the authentication question.