Skip to main content
Table of contents

dbtools

The Data Engineering Team have developed some simple packages to allow you to query our databases using R and Python on the Analytical Platform. pydbtools is a python module, while dbtools is an R package that uses pydbtools under the hood. You can use these packages to execute SQL queries on Athena databases, bringing the results into your environment as a DataFrame to do further analysis.

R - dbtools

The README in the dbtools repository gives details on how to install and use the package with R.

Python - pydbtools

The README in the pydbtools repository gives details on how to install and use the package with Python.

This page was last reviewed on 5 May 2021. It needs to be reviewed again on 5 May 2022 by the page owner #data_engineers .
This page was set to be reviewed before 5 May 2022 by the page owner #data_engineers. This might mean the content is out of date.