Connect to 'AWS Athena' using 'Boto3' ('DBI' Interface)
Assume AWS ARN Role
Athena Driver
Athena Connection Methods
Athena Driver Methods
List objects in a connection.
Preview the data in an object.
Athena Result Methods
Convenience functions for reading/writing DBMS tables
Athena S3 implementation of dbplyr backend functions (api version 1).
Athena S3 implementation of dbplyr backend functions (api version 2).
S3 implementation of db_compute for Athena
S3 implementation of db_connection_describe for Athena (api version ...
S3 implementation of db_copy_to for Athena
S3 implementation of db_desc for Athena (api version 1).
Connect to Athena using python's sdk boto3
dbConvertTable aws s3 backend file types.
List Athena Tables
Declare which version of dbplyr API is being called.
Install Amazon SDK boto3 for Athena connection
A method to configure RAthena backend options.
RAthena: a DBI interface into Athena using Boto3 SDK
Get Session Tokens for Boto3 Connection
AWS Athena backend dbplyr version 1 and 2
Creates query to create a simple Athena table
Converts data frame into suitable format to be uploaded to Athena
Athena Work Groups
Designed to be compatible with the R package 'DBI' (Database Interface) when connecting to Amazon Web Service ('AWS') Athena <https://aws.amazon.com/athena/>. To do this 'Python' 'Boto3' Software Development Kit ('SDK') <https://boto3.amazonaws.com/v1/documentation/api/latest/index.html> is used as a driver.
Useful links