evidence-dev / evidence

Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown
https://evidence.dev
MIT License
4.21k stars 199 forks source link

AWS Athena support #472

Closed rabidaudio closed 1 month ago

rabidaudio commented 1 year ago

What do you use this database for? I have a small hobbyist data project, and for that Athena is incredibly cost-effective.

Are there any popular and well-maintained clients for this database? The official connector is @aws-sdk/client-athena, there's also athena-express which hides some of the clunkiness of the official one.

Are you interested in contributing this database connector? Draft PR incoming

archiewood commented 7 months ago

Hello -looping back on connector requests

We have recently re-architected Evidence (since this issue was opened), and Evidence is now "pluggable", meaning you can write your own connectors, publish them, and use them in Evidence.

If you are interesting in writing a connector, here are some resources:

  1. Docs on creating a plugin: https://docs.evidence.dev/plugins/creating-a-plugin/datasources
  2. Template for a connector plugin: https://github.com/evidence-dev/datasource-template
  3. An example that I spun up for pulling stats from the npm API: https://github.com/archiewood/npm-stats

If you do write a plugin:

hughess commented 4 months ago

@morganchorlton3 has just published an Athena plugin here:

Repo: https://github.com/morganchorlton3/evidence-connector-aws-athena NPM: https://www.npmjs.com/package/evidence-connector-aws-athena