> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Metabase

> Connect Dune to Metabase for BI dashboards

Follow these steps to connect Dune as a data source in Metabase.

## Add the Database Connection

<Steps>
  <Step title="Open Admin settings">
    From the Metabase home page, click the <b>Settings</b> gear icon in the top-right corner.
    Select <b>Admin settings</b> from the dropdown menu.

    <Frame>
      <img src="https://mintcdn.com/dune/Sfv_5QdqAPVofYTY/images/trino-presto-connector/metabase-1.png?fit=max&auto=format&n=Sfv_5QdqAPVofYTY&q=85&s=cac1b521d3d5853359fee7897d076586" alt="Metabase step 1: Open Admin settings" width="728" height="760" data-path="images/trino-presto-connector/metabase-1.png" />
    </Frame>
  </Step>

  <Step title="Go to Databases">
    In the Admin panel, navigate to the <b>Databases</b> tab.

    <Frame>
      <img src="https://mintcdn.com/dune/Sfv_5QdqAPVofYTY/images/trino-presto-connector/metabase-2.png?fit=max&auto=format&n=Sfv_5QdqAPVofYTY&q=85&s=ca3ac9b7a0c932af726e73714d197bab" alt="Metabase step 2: Go to Databases" width="2872" height="356" data-path="images/trino-presto-connector/metabase-2.png" />
    </Frame>
  </Step>

  <Step title="Add database">
    Click the blue <b>Add database</b> button to open the configuration modal.

    <Frame>
      <img src="https://mintcdn.com/dune/Sfv_5QdqAPVofYTY/images/trino-presto-connector/metabase-3.png?fit=max&auto=format&n=Sfv_5QdqAPVofYTY&q=85&s=923552c92a278252c509ce42ed41a586" alt="Metabase step 3: Add database" width="2878" height="1618" data-path="images/trino-presto-connector/metabase-3.png" />
    </Frame>
  </Step>

  <Step title="Choose driver">
    In the modal, select <code>Starburst (Trino)</code> as the <b>Database type</b>.
  </Step>

  <Step title="Enter connection details">
    Fill in the form fields using the values from the [Connection Parameters](/api-reference/connectors/trino/overview#connection-parameters) section.
    For best performance in Metabase, we recommend disabling <b>Rerun queries for simple explorations</b> and <b>Periodically refingerprint tables</b> in the advanced settings.
  </Step>
</Steps>

<Note>
  Schema discovery queries such as <code>SHOW TABLES</code> or <code>SHOW SCHEMAS</code> may not be available in Metabase with this connector because Dune's catalog spans millions of tables. Many BI tools are not yet optimized to enumerate catalogs at this scale. An update with improved schema discovery is planned for the future.
</Note>

## Run a Test Query

After configuring and saving the connection, you can run a query to verify that everything is working.

<Steps>
  <Step title="Create a new SQL query">
    Click the <b>+ New</b> button and select <b>SQL query</b>.
  </Step>

  <Step title="Select database">
    In the editor, choose your newly created <b>Dune SQL</b> data source from
    the <b>Select a database</b> dropdown.
  </Step>

  <Step title="Paste example SQL">
    Paste the example query below into the editor.
  </Step>

  <Step title="Run the query">Run the query to verify the connection.</Step>
</Steps>

You can use this query to test your connection. It fetches the daily transaction count from the last year on Base.

```sql theme={null}
SELECT
  date_trunc('day', block_time) AS time,
  count(*) AS count
FROM base.transactions
WHERE block_time > now() - interval '12' month
GROUP BY 1
ORDER BY 1 DESC
```
