Connecting from noctua in a local R-Studio session throws 'no region provided error'

DyfanJones / noctua

Connect R to Athena using paws SDK (DBI Interface)

https://dyfanjones.github.io/noctua/

Other

45 stars 5 forks source link

Connecting from noctua in a local R-Studio session throws 'no region provided error' #69

Closed ricardojcc closed 4 years ago

ricardojcc commented 4 years ago

Hey Dyfan,

I apologize for coming over here with yet another issue.

Issue Description

dbConnect() returns the following error: Error in get_region(cfgs$credentials$profile) : No region provided

Reproducible Example

library(noctua) library(DBI)

con <- dbConnect(noctua::athena(), aws_access_key_id='MyAccessKey', aws_secret_access_key='MyAccessKey', s3_staging_dir='s3://'my-staging-dir-us-west-2/', region_name='us-west-2')

DyfanJones commented 4 years ago

Apologies about this. I will look into it now

DyfanJones commented 4 years ago

@ricardojcc in the mean time please set the region name in the environmental variable "AWS_REGION". This should work until I have fixed the package.

ricardojcc commented 4 years ago

Will do. Thanks @DyfanJones

DyfanJones commented 4 years ago

@ricardojcc PR #70 fixes this issue. Thanks for point it out to me. It was a bigger problem than I realised. Will create unit test before merging.

DyfanJones commented 4 years ago

PR #70 passed unit tests and passes region correctly. If this issue persists please reopen this issue