i keep getting this error:
"exception_type":"IO","exception_message":"Could not read from file \ : Operation not permitted","errno":"1"}
con <- DBI::dbConnect(duckdb::duckdb(), dbdir = "/dafak.duckdb", read_only = FALSE)
# Schemas
DBI::dbExecute(con, "CREATE SCHEMA IF NOT EXISTS jar;")
# Tables
DBI::dbExecute(con,
" CREATE TABLE IF NOT EXISTS jar.jar_fa_rodikliai_blns (
ja_kodas VARCHAR,
finansiniai_metai INTEGER,
ja_pavadinimas VARCHAR,
beginning_date DATE,
turning_date DATE,
formavimo_data DATE,
ataskaita VARCHAR,
reiksme BIGINT
) "
)
DBI::dbDisconnect(con)
Up until this point all works fine.
When I try to connect again:
con <- DBI::dbConnect(duckdb::duckdb(), dbdir = "/dafak.duckdb", read_only = FALSE)
I get an error:
"exception_type":"IO","exception_message":"Could not read from file \ : Operation not permitted","errno":"1"}
Linux mint
duckdb 1.4.1
duckdb is stored on mounted gcloud though rclone (if that helps at all)
R