Skip to main content

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.

ToolConnect throughPage
MetabasePostgreSQL or MySQL with loaded records, BigQuery, Athena, Starburst or Trino, ClickHouse, Redshift, Snowflake; DuckDB driver for MotherDuckMetabase
Apache SupersetSQLAlchemy URI: DuckDB or MotherDuck, Trino, PostgreSQL, BigQuery, ClickHouseSuperset
GrafanaPostgreSQL or MySQL, ClickHouse, Trino, BigQuery, Athena data sourcesGrafana
EvidenceDuckDB source that reads the bucket, or MotherDuckEvidence
RillEmbedded DuckDB, loading bucket objects with an S3 or GCS connectorRill
Looker StudioBigQuery, PostgreSQL or MySQL connectorLooker Studio
TableauAthena, BigQuery, Snowflake, PostgreSQL, Redshift, Starburst or Trino connectorsTableau
Power BIFabric, Snowflake, BigQuery, PostgreSQL, Athena, Databricks connectorsPower 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.