duckdb.connect() takes a path string and either connects to or creates the duckdb file.
How does one create/connect to a duckdb file on a non-local filesystem?
e.g. I would expect that duckdb supports either
- fsspec paths, like
duckdb.connect("hdfs://...") - or had a filesystem parameter like ```duckdb.connect("/mypath", filesystem=myfilesystem)
- or accepts filelike parameters like
with open() as file: duckdb.connect(file)
Am I missing something or does a duckdb file always have to be on the local filesystem?