Athena lets you use SQL to query arbitrary data stored in S3.

1. Get Secret Key

You can find your Secret Key under the "API Keys" section of your Stripe account.

Dashboard > Developers > API Keys

2. Add to Retool

Create a new resource in Retool, and select "Stripe" as the type. Enter your secret key in the "Access Key" field, and press "Save".

Resources > Add > Stripe

3. Create Queries

You can now select your newly-created Stripe resource from the Resource dropdown when creating queries in your Retool apps. There is an optional parameter that you can read about here: https://stripe.com/docs/api#expanding_objects.

You can display the results of Stripe queries as with any other query in Retool. You will have to examine the response to see which part of it you actually want to display. In this case, the data we care about is in stripeQuery.data.response.data rather than just stripeQuery.data.