I am trying to load httpfs duckdb extension to access parquet file on s3 but it looks like it cannot load even though the file httpfs.duckdb_extension is in the directory
library(DBI)
library(duckdb)
con <- dbConnect(duckdb::duckdb())
DBI::dbExecute(con, "INSTALL httpfs")
[1] 0
DBI::dbExecute(con, "LOAD httpfs")
Erreur : rapi_execute: Failed to run query Error: IO Error: Extension "C:\Users\xxxx\AppData\Roaming\R\data\R\duckdb.duckdb\extensions\v0.9.2\windows_amd64_rtools\httpfs.duckdb_extension" could not be loaded: Le module spécifié est introuvable.