# ClickHouse

Scheduled read-only queries.

Part of [Data warehouses](https://www.closefinch.com/integrations#warehouse). Read-only queries on a schedule bring warehouse rows onto accounts and contacts; records can be exported back.

## How it connects

- Connected once for the workspace, by an owner.
- You paste your password from ClickHouse; it's stored encrypted.
- New items are picked up about every 15 minutes.

## Connect it

1. In Closefinch, open Settings → Integrations and find ClickHouse under its category.
2. Choose ClickHouse and paste your password.
3. You'll also need your ClickHouse URL, under Advanced settings.
4. New items are picked up about every 15 minutes. You can pause it or disconnect at any time.

What the form asks for:

- Password: The password of a read-only ClickHouse user.

Nothing an agent sends out through a connection goes without Closefinch's policy checks and, by default, a person's approval. Every integration: [https://www.closefinch.com/integrations](https://www.closefinch.com/integrations).