Add basic 'Data Explorer' tool to AP tools

[tom-webber]

Idea Description

Add a basic Athena wrapper tool to AP control panel that allows users to directly query data they have access to. Basically just a box with a run button, and somewhere to present results.

This would be a re-implementation of DBT's Data Explorer tool. Their data platform frontend ('Data Workspace'), which includes tools such as the Data Explorer, is available here. Data Workspace is built around a PostgreSQL backend, so everything is piped through that (auth, query parsing, data storage and retrieval, query storage and retrieval). For our implementation, we would likely need to go through boto3 to athena.

DBT's Data Explorer tool:

Why Should We Do This

Gives users a fast way to preview data without all of the setup required in python / R, or needing to go to the aws console to athena.

Definition of Done

• Tool available on control panel
• Figure out if we'd need to show users region / Athena workspace settings
• Autocomplete / intellisense?

What skills do we need?

Dev

Notes

No response

[tom-webber]

Notes for getting a local version of the Data Workspace running (instructions here):

• In order to successfully load data workspace I needed to rebuild the JavaScript bundles with

cd dataworkspace/dataworkspace/static/js/react/
npm install
npm run build

• It's listed in the instructions, but you'll also need to open a separate terminal when running the app to run npm run dev from the .../react directory as per the instructions
• When running locally, Data Explorer is available at http://dataworkspace.test:8000/data-explorer