search

rstudio / shinyapps-package-dependencies

Collection of bash scripts that install R package system dependencies
https://www.shinyapps.io/
Other
79 stars 58 forks source link

Connecting to Amazon Athena with ODBC in shinyapps.io #157

Open ssouyris opened 6 years ago

ssouyris commented 6 years ago

Hello, The RStudio Professional Drivers do not include a driver for Amazon Athena.

Amazon Athena is a server-less SQL service that allows to query files (e.g., parquet, json, csv) in S3. Is it very useful for some use cases.

Would it possible to install that driver in www.shinyapps.io?

Driver is here: https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html

A reference on how to use it with library(odbc) and library(tidyverse) is here: https://rud.is/b/2018/04/20/painless-odbc-dplyr-connections-to-amazon-athena-and-apache-drill-with-r-odbc/

Thank you, Sebastian

jspiewak commented 4 years ago

The latest Professional Drivers do include one for AWS Athena. I will leave this open until we have pushed out the update.

ssouyris commented 4 years ago

@jspiewak great, thanks!