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

# BI Integration

> Connect Metabase, Grafana, Tableau, and other BI tools to your Formo data warehouse using the HTTP interface for custom SQL queries and dashboards.

Formo is compatible with BI tools through our HTTP interface, enabling you to connect popular BI tools, SQL clients, and data visualization platforms directly to Formo.

This interface provides a standardized way to query your data using SQL, making it easy to integrate Formo with your existing analytics workflow and third-party tools.

## Configuration

To connect to Formo, use these standard connection parameters:

### Connection settings

* **Protocol**: HTTPS
* **Host**: `clickhouse.eu-central-1.aws.tinybird.co`
* **Port**: `443`
* **SSL/TLS**: Required (enabled)

### Authentication settings

* **Database name**: `formo`
* **Username**: `formo`
* **Password**: `<Your BI Read Key>` (Your Formo BI Read Token)

Find your **BI Read key** in the project settings page under 'Credentials'.

<Frame caption="Your BI Read Key under project settings">
  <img src="https://mintcdn.com/formo/YROrhpWjepQYfTR0/images/project-credentials.png?fit=max&auto=format&n=YROrhpWjepQYfTR0&q=85&s=2034d682244876bbc01f660b82a8a7f2" width="645" height="378" data-path="images/project-credentials.png" />
</Frame>

BI read keys expire in one week, but you can get a fresh key on the project settings page.

## Compatible tools

Formo works with various BI tools and SQL clients:

* Grafana
* Hex
* Metabase
* Superset
* Power BI
* Tableau

Any tool that supports ClickHouse® HTTP interface can potentially work with Formo.

## Limitations

The BI interface to Formo is read-only. You can use it to query, visualize, and analyze data from your Formo Data Sources, but you cannot modify data through this connection.

You cannot perform `INSERT`, `UPDATE`, `DELETE`, or any DDL operations (`CREATE`, `ALTER`, `DROP`).

## Troubleshooting

**Authentication failures**

Error: Authentication failed

* Check your BI Read Token is valid and not expired
* Ensure the token has read permissions for the workspace
* Verify the token is entered in the password field

**SSL/TLS errors**

Error: SSL connection error

* Ensure SSL/TLS is enabled in your client
* Use port 443 with HTTPS protocol
* Check that your client supports TLS 1.2 or higher

**Query timeouts**

Error: Query timeout

* Add appropriate WHERE clauses to filter data
* Use LIMIT to reduce result set size
* Consider querying materialized views instead of raw data

## Support

<CardGroup cols={2}>
  <Card title="Live support" icon="headset" href="https://formo.so/support">
    Chat with our support team
  </Card>

  <Card title="Email" icon="envelope" href="mailto:yos@formo.so">
    Email our founder at [yos@formo.so](mailto:yos@formo.so)
  </Card>
</CardGroup>