BI and dashboards
A BI tool reads Send2Bucket data through a query engine or database, never from Send2Bucket itself. Pick the engine first, using the querying overview, then connect the tool to it with a read-only user. Tools that embed DuckDB, such as Evidence and Rill, read your bucket directly.
| Tool | Connect through | Page |
|---|---|---|
| Metabase | PostgreSQL or MySQL with loaded records, BigQuery, Athena, Starburst or Trino, ClickHouse, Redshift, Snowflake; DuckDB driver for MotherDuck | Metabase |
| Apache Superset | SQLAlchemy URI: DuckDB or MotherDuck, Trino, PostgreSQL, BigQuery, ClickHouse | Superset |
| Grafana | PostgreSQL or MySQL, ClickHouse, Trino, BigQuery, Athena data sources | Grafana |
| Evidence | DuckDB source that reads the bucket, or MotherDuck | Evidence |
| Rill | Embedded DuckDB, loading bucket objects with an S3 or GCS connector | Rill |
| Looker Studio | BigQuery, PostgreSQL or MySQL connector | Looker Studio |
| Tableau | Athena, BigQuery, Snowflake, PostgreSQL, Redshift, Starburst or Trino connectors | Tableau |
| Power BI | Fabric, Snowflake, BigQuery, PostgreSQL, Athena, Databricks connectors | Power BI |
Dashboards run the same queries again and again. A bucket destination stores gzip JSON, which every engine reads but none reads fast, so for a dashboard over more than a few days of data, query a table destination such as DuckLake or Apache Iceberg, or a table you load on a schedule.