I have trouble placing session token to environment. I just created session token in CLI but whatever I try I get the following:
URL <- 'https://s3.amazonaws.com/athena-downloads/drivers/AthenaJDBC41-1.1.0.jar'
fil <- basename(URL)
if (!file.exists(fil)) download.file(URL, fil)
#The information that you received from the "aws sts get-session-token"
Sys.setenv(AWS_ACCESS_KEY_ID = "ACCESS KEY")
Sys.setenv(AWS_SECRET_ACCESS_KEY = "SECRET KEY")
Sys.setenv(AWS_SESSION_TOKEN = "SESSION TOKEN")
provider <- "com.amazonaws.athena.jdbc.shaded.com.amazonaws.auth.EnvironmentVariableCredentialsProvider"
drv <- JDBC(driverClass="com.amazonaws.athena.jdbc.AthenaDriver", fil, identifier.quote="'")
##I get error with the dbConnect:
con <- dbConnect(drv, 'jdbc:awsathena://athena.ap-southeast-1.amazonaws.com:443/',
-
s3_staging_dir="s3://athena-staging", -
schema_name="DEFAULT_DB_SCHEMA_NAME", -
user=Sys.getenv("AWS_ACCESS_KEY_ID"), -
password=Sys.getenv("AWS_SECRET_ACCESS_KEY"), -
token=Sys.getenv("AWS_SESSION_TOKEN"))
ERROR:
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1], :
com.amazonaws.athena.jdbc.shaded.com.amazonaws.services.athena.model.AmazonAthenaException: The security token included in the request is invalid. (Service: AmazonAthena; Status Code: 400; Error Code: UnrecognizedClientException; Request ID: c915f1d6-2c47-4d8d-a3d6-0190b66c3e4d)
If anyone has any ideas I would highly appreciate it. There is no documentation regarding R-Athena session token on MacOS.