RAthena

RAthena copied to clipboard

Allow disabling role assumption when `AWS_ROLE_ARN` environment variable is set

1

### Issue Description The [code for `dbConnect()`](https://github.com/DyfanJones/RAthena/blob/d8646bc2c045d576b0ff30fb444043eef97b1e09/R/Driver.R#L184) checks if the `AWS_ROLE_ARN` environment variable is set, and performs an explicit assume role operation if it is. To perform the assume role...

JonMerlevede

assume role with web identity?

7

Possible method for connecting to AWS Athena. https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_temp_request.html#api_assumerolewithwebidentity https://developer.amazon.com/docs/login-with-amazon/web-docs.html https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/sts.html#STS.Client.assume_role_with_web_identity

DyfanJones

Can we have `endpoint_override` as an attribute if not yet?

23

### Create an attribute named `endpoint_override` in dbConnect Example: ```r library(RAthena) library(DBI) con

aoyh

Would be nice to have this package put in the anaconda distribution: https://docs.conda.io/projects/conda-build/en/latest/user-guide/tutorials/build-r-pkgs.html

DyfanJones

having datetime-strings in input parameters will produce errors

8

### Issue Description A query such as: ```r tbl(con, "table) %>% filter(date_col == "2020-01-31 51:59:25") ``` will produce an error, as Athena does not understand a literal of the form...

OssiLehtinen

reticulate enhancements

1

Make sure `RAthena` takes full advantage of the new changes to `reticulate`: https://blog.rstudio.com/2019/12/20/reticulate-1-14/

DyfanJones

Aws Athena ml capabilities?

1

Should RAthena and noctua support AWS Athena ml capabilities? MLcapabilities are created by sagemaker. Athena can be used to create an sql wrapper to call sagemaker models. https://docs.aws.amazon.com/athena/latest/ug/querying-mlmodel.html

DyfanJones

Upload and register flat files into Athena

2

To be able to upload a flat file saved on users computer and register it in AWS Athena without the requirement of having to upload it first into R.

DyfanJones

Athena Login Error: Error in h(simpleError(msg, call))

1

Error when trying to log in. Script ``` con_athena

luisccmm