Query S3 with SQL and build dashboards
Query S3 with SQL and build dashboards
I'm Mike, founder at Definite ( https://www.definite.app/ ). We have a ton data sitting in S3 / GCP. Most BI / dashboard tools need you to pipe that data into a SQL database / data warehouse, but it's expensive and a pain to set up. We seen this enough times that we've built a way to directly query S3 and build dashboards without moving the data. Under the hood, our product[0] uses DuckDB as a data warehouse. DuckDB has some amazing features that made it pretty simple on our end. 4 minute demo here: https://www.youtube.com/watch?v=yrrCQnfKEig Here's how it works: 1. Add an S3 / GCP key and secret 2. Write SQL to access the data you care about (e.g. CSVs, parquet, JSON, JSONL, etc.) 3. Build a model on top of that data (we automatically create a basic model which you can tweak) 4. Share that model with non-technical business users (if they can use a pivot table, they'll be able to use Definite) 5. Ask our AI ("Fi") questions about the data. Fi can build reports and dashboards on top of S3.
Share cardActual performance
Launch Intel predictions
Analyze your own launch →Incorrect prediction on native model
Similar products
Query SQLite files stored in S3
BigBash.it – Turn your SQL query into a bash one-liner
Mixpanel Query Tool - SQL(ish) for Mixpanel
Use SQL Syntax to Query MongoDB
Query protobufs using SQL
cq – Query CSVs using SQL
AI-powered SQL query diagnostics across 5 dialects.
Eth.events – Query Ethereum with SQL
Query your unstructured text with SQL [video]
SQL to Mongo Query Translator