Hello @darenhunter,
This is possible.
To get the Data into Retool, you would have to set up a Rest-API resource and run this as a GET request.
\
This will retrieve your data and retool can parse it.
You would need to write some form of JS query to manipulate this data into a form that can be loaded to a table component\