Datasources
OnlyMetrix connects directly to your data warehouse. No data is copied — queries run against your live data.
Supported warehouses
| Warehouse | Status | Default port |
|---|---|---|
| PostgreSQL | Supported | 5432 |
| ClickHouse | Supported | 8443 (secure) / 8123 |
| Snowflake | Supported | 443 |
Connecting a datasource
- Go to Datasources in the sidebar
- Select your warehouse type
- Enter connection details (host, database, credentials)
- Click Connect — OnlyMetrix will test the connection before saving
Connection details
| Field | Description |
|---|---|
| Host | Your warehouse hostname (e.g., my-cluster.snowflakecomputing.com) |
| Port | Usually auto-detected from warehouse type |
| Database | The database name to connect to |
| Schema | Schema to use (default: public for Postgres) |
| User / Password | Warehouse credentials |
| Secure | Enable TLS/SSL (required for cloud-hosted warehouses) |
TIP
For the host field, just enter the hostname — don't include https:// or port numbers. OnlyMetrix handles the protocol automatically.
After connecting
Once connected, OnlyMetrix will:
- Introspect your schema — discover tables, columns, and data types
- Suggest metrics — scan for common patterns and propose metrics
- Detect PII — flag columns that may contain personal data
Managing datasources
You can disconnect a datasource at any time from the Datasources page. Metrics associated with a disconnected datasource will remain in your catalog but won't be queryable until you reconnect.