dbtools: dbtools: A package for accessing AWS Athena from the...

dbtoolsR Documentation

dbtools: A package for accessing AWS Athena from the Analytical Platform.

About

The dbtools package is used to run SQL queries configured for the Analytical Platform. This package is a reticulated wrapper around the Python library pydbtools which uses AWS Wrangler's Athena module but adds additional functionality (like Jinja templating, creating temporary tables) and alters some configuration to our specification.

Alternatively you might want to use Rdbtools, which has the advantages of being R-native, so no messing with 'reticulate' and Python, and supporting 'dbplyr'. Please note the caveat about support, though.

See Also

https://github.com/moj-analytical-services/pydbtools

https://github.com/moj-analytical-services/Rdbtools


moj-analytical-services/dbtools documentation built on Sept. 29, 2024, 2:06 a.m.