Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot Connect to S3-Compatible Data Store #224

Open
ckarnes opened this issue Aug 29, 2024 · 1 comment
Open

Cannot Connect to S3-Compatible Data Store #224

ckarnes opened this issue Aug 29, 2024 · 1 comment

Comments

@ckarnes
Copy link

ckarnes commented Aug 29, 2024

I am unable to connect to connect to an s3-compatible data store using the following command:

con <- dbConnect(
  
  duckdb::duckdb(
  dbdir = "s3://test/mydatabase.duckdb", 
  config = list(s3_access_key_id=<accesskey>,
                s3_secret_access_key=<secretkey>,
                s3_region='us-east-1',
                s3_endpoint='example.com',
                ,s3_url_style='path'
                )
  )
)

I get back this in the console:
Error in h(simpleError(msg, call)) :
error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': cannot open the connection
In addition: Warning message:
In file(con, "w") :
cannot open file 's3://test/mydatabase.duckdb': No such file or directory

I use similar arguments in the aws.s3 package and am able to get information out of the bucket.

@cfljam
Copy link

cfljam commented Oct 17, 2024

Is this functionality that could be achieved by compiling with the httpfs extension? The ability to attach a remote duckdb is one of the major attractions but its not at all clear if or how this can be achieved currently with a database (though duckdbfs allows attaching tables via s3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants