# Xatu ClickHouse Database
> Direct database access to Ethereum network data.
Xatu is a data collection and processing pipeline for Ethereum network data.
- Xatu contains multiple "modules" that each derive Ethereum data differently
- The data is stored in a Clickhouse database and published to Parquet files
- ethPandaOps runs all modules, with community members also contributing data

## Looking for Public Parquet Files?
**If you want public access without authentication**, see https://raw.githubusercontent.com/ethpandaops/xatu-data/refs/heads/master/llms/parquet/llms.txt for Parquet file documentation.

## Endpoint

```
https://clickhouse.xatu.ethpandaops.io
```

**Production networks** (Mainnet, Sepolia, Holesky, Hoodi): tables live in the `default` database — filter with `meta_network_name`.

**Devnets**: each active devnet gets its own database named after the network (e.g. `` `glamsterdam-devnet-6`.table_name ``) — no `meta_network_name` filter needed. See https://raw.githubusercontent.com/ethpandaops/xatu-data/refs/heads/master/schema/experimental.md for the experimental catalog.

## Quick Start Examples

### curl + jq
```bash
CLICKHOUSE_USER="your-username"
CLICKHOUSE_PASSWORD="your-password"

echo """
SELECT
    toDate(slot_start_date_time) AS date,
    COUNT(*) AS blocks,
    quantile(0.5)(propagation_slot_start_diff) AS median_propagation_ms
FROM beacon_api_eth_v1_events_block FINAL
WHERE
    slot_start_date_time >= toDateTime('2024-04-01 00:00:00')
    AND slot_start_date_time < toDateTime('2024-04-02 00:00:00')
    AND meta_network_name = 'mainnet'
GROUP BY date
FORMAT JSON
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" \
    -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" \
    --data-binary @- | jq
```

### Python + SQLAlchemy
```python
from sqlalchemy import create_engine
import pandas as pd
import os

# Credentials from environment
endpoint = "clickhouse-raw.xatu.ethpandaops.io"
user = os.environ["CLICKHOUSE_USER"]
password = os.environ["CLICKHOUSE_PASSWORD"]

# Create connection
db_url = f"clickhouse+http://{user}:{password}@{endpoint}:443/default?protocol=https"
engine = create_engine(db_url)

# Query with proper partitioning
query = """
SELECT
    slot,
    block_root,
    proposer_index,
    slot_start_date_time
FROM canonical_beacon_block FINAL
WHERE
    slot_start_date_time >= toDateTime('2024-04-01')
    AND slot_start_date_time < toDateTime('2024-04-02')
    AND meta_network_name = 'mainnet'
LIMIT 1000
"""

df = pd.read_sql(query, engine)
```

### Jupyter Notebook Magic
```python
%load_ext sql

# Set connection
%sql clickhouse+http://$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD@clickhouse-raw.xatu.ethpandaops.io:443/default?protocol=https

# Query directly in cell
%%sql
SELECT
    meta_client_name,
    COUNT(*) as observations
FROM beacon_api_eth_v1_events_block FINAL
WHERE
    slot_start_date_time > NOW() - INTERVAL 1 HOUR
    AND meta_network_name = 'mainnet'
GROUP BY meta_client_name
ORDER BY observations DESC
```


## Available Datasets

### Beacon API Event Stream
> Events derived from the Beacon API event stream. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances. These tables are usually fairly slim and contain only a few columns. These tables can be joined with the canonical tables to get a more complete view of the data. For example, you can join the beacon_api_eth_v1_events_block table on block_root or slot with the canonical_beacon_block table to get the block data for each block.

**Table Prefix**: `beacon_api_`
**Availability**: public, ethpandaops-clickhouse

### Execution Layer P2P
> Events from the execution layer p2p network. This data is usually useful for 'timing' events, such as when a transaction was seen in the mempool by an instance. Because of this it usually has the same data but from many different instances.

**Table Prefix**: `mempool_`
**Availability**: ethpandaops-clickhouse, public

### Canonical Beacon
> Events derived from the finalized beacon chain. This data is only derived by a single instance, are deduped, and are more complete and reliable than the beacon_api_ tables. These tables can be reliably JOINed on to hydrate other tables with information

**Table Prefix**: `canonical_beacon_`
**Availability**: ethpandaops-clickhouse, public

### Canonical Execution
> Data extracted from the execution layer. This data is only derived by a single instance, are deduped, and are more complete and reliable than the execution_layer_p2p tables. These tables can be reliably JOINed on to hydrate other tables with information

**Table Prefix**: `canonical_execution_`
**Availability**: ethpandaops-clickhouse, public

### Consensus Layer P2P
> Events from the consensus layer p2p network. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances.

**Table Prefix**: `libp2p_`
**Availability**: ethpandaops-clickhouse, public

### MEV Relay
> Events derived from MEV relays. Data is scraped from multiple MEV Relays by multiple instances.

**Table Prefix**: `mev_relay_`
**Availability**: public, ethpandaops-clickhouse

### CBT (ClickHouse Build Tools)
> Pre-aggregated analytical tables for common blockchain queries. These tables are transformation tables similar to DBT, powered by [xatu-cbt](https://github.com/ethpandaops/xatu-cbt) using [ClickHouse Build Tools (CBT)](https://github.com/ethpandaops/cbt).

**Table Prefix**: ``
**Availability**: ethpandaops-clickhouse


### CBT (ClickHouse Build Tool) Tables

CBT tables are pre-aggregated analytical tables accessed via **network-specific databases**:

```sql
-- Query mainnet CBT table
SELECT * FROM mainnet.table_name LIMIT 10;

-- Query sepolia CBT table
SELECT * FROM sepolia.table_name LIMIT 10;
```

**Database naming**: `mainnet`, `sepolia`, `holesky`, `hoodi`

**Table types**:
- `dim_*` - Dimension tables
- `fct_*` - Fact tables
- `int_*` - Intermediate tables


### Auto-Discovered CBT Tables

### Code:
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.Code:`), sepolia (`sepolia.Code:`), holesky (`holesky.Code:`), hoodi (`hoodi.Code:`)
- **Tags**: 
### 194.
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.194.`), sepolia (`sepolia.194.`), holesky (`holesky.194.`), hoodi (`hoodi.194.`)
- **Tags**: 
### DB::Exception:
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.DB::Exception:`), sepolia (`sepolia.DB::Exception:`), holesky (`holesky.DB::Exception:`), hoodi (`hoodi.DB::Exception:`)
- **Tags**: 
### default:
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.default:`), sepolia (`sepolia.default:`), holesky (`holesky.default:`), hoodi (`hoodi.default:`)
- **Tags**: 
### Authentication
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.Authentication`), sepolia (`sepolia.Authentication`), holesky (`holesky.Authentication`), hoodi (`hoodi.Authentication`)
- **Tags**: 
### failed:
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.failed:`), sepolia (`sepolia.failed:`), holesky (`holesky.failed:`), hoodi (`hoodi.failed:`)
- **Tags**: 
### password
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.password`), sepolia (`sepolia.password`), holesky (`holesky.password`), hoodi (`hoodi.password`)
- **Tags**: 
### is
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.is`), sepolia (`sepolia.is`), holesky (`holesky.is`), hoodi (`hoodi.is`)
- **Tags**: 
### incorrect,
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.incorrect,`), sepolia (`sepolia.incorrect,`), holesky (`holesky.incorrect,`), hoodi (`hoodi.incorrect,`)
- **Tags**: 
### or
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.or`), sepolia (`sepolia.or`), holesky (`holesky.or`), hoodi (`hoodi.or`)
- **Tags**: 
### there
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.there`), sepolia (`sepolia.there`), holesky (`holesky.there`), hoodi (`hoodi.there`)
- **Tags**: 
### is
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.is`), sepolia (`sepolia.is`), holesky (`holesky.is`), hoodi (`hoodi.is`)
- **Tags**: 
### no
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.no`), sepolia (`sepolia.no`), holesky (`holesky.no`), hoodi (`hoodi.no`)
- **Tags**: 
### user
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.user`), sepolia (`sepolia.user`), holesky (`holesky.user`), hoodi (`hoodi.user`)
- **Tags**: 
### with
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.with`), sepolia (`sepolia.with`), holesky (`holesky.with`), hoodi (`hoodi.with`)
- **Tags**: 
### such
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.such`), sepolia (`sepolia.such`), holesky (`holesky.such`), hoodi (`hoodi.such`)
- **Tags**: 
### name
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.name`), sepolia (`sepolia.name`), holesky (`holesky.name`), hoodi (`hoodi.name`)
- **Tags**: 
### If
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.If`), sepolia (`sepolia.If`), holesky (`holesky.If`), hoodi (`hoodi.If`)
- **Tags**: 
### you
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.you`), sepolia (`sepolia.you`), holesky (`holesky.you`), hoodi (`hoodi.you`)
- **Tags**: 
### use
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.use`), sepolia (`sepolia.use`), holesky (`holesky.use`), hoodi (`hoodi.use`)
- **Tags**: 
### ClickHouse
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.ClickHouse`), sepolia (`sepolia.ClickHouse`), holesky (`holesky.ClickHouse`), hoodi (`hoodi.ClickHouse`)
- **Tags**: 
### Cloud,
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.Cloud,`), sepolia (`sepolia.Cloud,`), holesky (`holesky.Cloud,`), hoodi (`hoodi.Cloud,`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### password
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.password`), sepolia (`sepolia.password`), holesky (`holesky.password`), hoodi (`hoodi.password`)
- **Tags**: 
### can
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.can`), sepolia (`sepolia.can`), holesky (`holesky.can`), hoodi (`hoodi.can`)
- **Tags**: 
### be
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.be`), sepolia (`sepolia.be`), holesky (`holesky.be`), hoodi (`hoodi.be`)
- **Tags**: 
### reset
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.reset`), sepolia (`sepolia.reset`), holesky (`holesky.reset`), hoodi (`hoodi.reset`)
- **Tags**: 
### at
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.at`), sepolia (`sepolia.at`), holesky (`holesky.at`), hoodi (`hoodi.at`)
- **Tags**: 
### https://clickhouse.cloud/
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.https://clickhouse.cloud/`), sepolia (`sepolia.https://clickhouse.cloud/`), holesky (`holesky.https://clickhouse.cloud/`), hoodi (`hoodi.https://clickhouse.cloud/`)
- **Tags**: 
### on
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.on`), sepolia (`sepolia.on`), holesky (`holesky.on`), hoodi (`hoodi.on`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### settings
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.settings`), sepolia (`sepolia.settings`), holesky (`holesky.settings`), hoodi (`hoodi.settings`)
- **Tags**: 
### page
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.page`), sepolia (`sepolia.page`), holesky (`holesky.page`), hoodi (`hoodi.page`)
- **Tags**: 
### for
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.for`), sepolia (`sepolia.for`), holesky (`holesky.for`), hoodi (`hoodi.for`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### corresponding
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.corresponding`), sepolia (`sepolia.corresponding`), holesky (`holesky.corresponding`), hoodi (`hoodi.corresponding`)
- **Tags**: 
### service.
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.service.`), sepolia (`sepolia.service.`), holesky (`holesky.service.`), hoodi (`hoodi.service.`)
- **Tags**: 
### If
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.If`), sepolia (`sepolia.If`), holesky (`holesky.If`), hoodi (`hoodi.If`)
- **Tags**: 
### you
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.you`), sepolia (`sepolia.you`), holesky (`holesky.you`), hoodi (`hoodi.you`)
- **Tags**: 
### have
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.have`), sepolia (`sepolia.have`), holesky (`holesky.have`), hoodi (`hoodi.have`)
- **Tags**: 
### installed
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.installed`), sepolia (`sepolia.installed`), holesky (`holesky.installed`), hoodi (`hoodi.installed`)
- **Tags**: 
### ClickHouse
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.ClickHouse`), sepolia (`sepolia.ClickHouse`), holesky (`holesky.ClickHouse`), hoodi (`hoodi.ClickHouse`)
- **Tags**: 
### and
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.and`), sepolia (`sepolia.and`), holesky (`holesky.and`), hoodi (`hoodi.and`)
- **Tags**: 
### forgot
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.forgot`), sepolia (`sepolia.forgot`), holesky (`holesky.forgot`), hoodi (`hoodi.forgot`)
- **Tags**: 
### password
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.password`), sepolia (`sepolia.password`), holesky (`holesky.password`), hoodi (`hoodi.password`)
- **Tags**: 
### you
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.you`), sepolia (`sepolia.you`), holesky (`holesky.you`), hoodi (`hoodi.you`)
- **Tags**: 
### can
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.can`), sepolia (`sepolia.can`), holesky (`holesky.can`), hoodi (`hoodi.can`)
- **Tags**: 
### reset
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.reset`), sepolia (`sepolia.reset`), holesky (`holesky.reset`), hoodi (`hoodi.reset`)
- **Tags**: 
### it
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.it`), sepolia (`sepolia.it`), holesky (`holesky.it`), hoodi (`hoodi.it`)
- **Tags**: 
### in
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.in`), sepolia (`sepolia.in`), holesky (`holesky.in`), hoodi (`hoodi.in`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### configuration
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.configuration`), sepolia (`sepolia.configuration`), holesky (`holesky.configuration`), hoodi (`hoodi.configuration`)
- **Tags**: 
### file.
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.file.`), sepolia (`sepolia.file.`), holesky (`holesky.file.`), hoodi (`hoodi.file.`)
- **Tags**: 
### The
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.The`), sepolia (`sepolia.The`), holesky (`holesky.The`), hoodi (`hoodi.The`)
- **Tags**: 
### password
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.password`), sepolia (`sepolia.password`), holesky (`holesky.password`), hoodi (`hoodi.password`)
- **Tags**: 
### for
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.for`), sepolia (`sepolia.for`), holesky (`holesky.for`), hoodi (`hoodi.for`)
- **Tags**: 
### default
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.default`), sepolia (`sepolia.default`), holesky (`holesky.default`), hoodi (`hoodi.default`)
- **Tags**: 
### user
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.user`), sepolia (`sepolia.user`), holesky (`holesky.user`), hoodi (`hoodi.user`)
- **Tags**: 
### is
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.is`), sepolia (`sepolia.is`), holesky (`holesky.is`), hoodi (`hoodi.is`)
- **Tags**: 
### typically
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.typically`), sepolia (`sepolia.typically`), holesky (`holesky.typically`), hoodi (`hoodi.typically`)
- **Tags**: 
### located
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.located`), sepolia (`sepolia.located`), holesky (`holesky.located`), hoodi (`hoodi.located`)
- **Tags**: 
### at
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.at`), sepolia (`sepolia.at`), holesky (`holesky.at`), hoodi (`hoodi.at`)
- **Tags**: 
### /etc/clickhouse-server/users.d/default-password.xml
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet./etc/clickhouse-server/users.d/default-password.xml`), sepolia (`sepolia./etc/clickhouse-server/users.d/default-password.xml`), holesky (`holesky./etc/clickhouse-server/users.d/default-password.xml`), hoodi (`hoodi./etc/clickhouse-server/users.d/default-password.xml`)
- **Tags**: 
### and
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.and`), sepolia (`sepolia.and`), holesky (`holesky.and`), hoodi (`hoodi.and`)
- **Tags**: 
### deleting
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.deleting`), sepolia (`sepolia.deleting`), holesky (`holesky.deleting`), hoodi (`hoodi.deleting`)
- **Tags**: 
### this
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.this`), sepolia (`sepolia.this`), holesky (`holesky.this`), hoodi (`hoodi.this`)
- **Tags**: 
### file
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.file`), sepolia (`sepolia.file`), holesky (`holesky.file`), hoodi (`hoodi.file`)
- **Tags**: 
### will
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.will`), sepolia (`sepolia.will`), holesky (`holesky.will`), hoodi (`hoodi.will`)
- **Tags**: 
### reset
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.reset`), sepolia (`sepolia.reset`), holesky (`holesky.reset`), hoodi (`hoodi.reset`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### password.
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.password.`), sepolia (`sepolia.password.`), holesky (`holesky.password.`), hoodi (`hoodi.password.`)
- **Tags**: 
### See
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.See`), sepolia (`sepolia.See`), holesky (`holesky.See`), hoodi (`hoodi.See`)
- **Tags**: 
### also
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.also`), sepolia (`sepolia.also`), holesky (`holesky.also`), hoodi (`hoodi.also`)
- **Tags**: 
### /etc/clickhouse-server/users.xml
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet./etc/clickhouse-server/users.xml`), sepolia (`sepolia./etc/clickhouse-server/users.xml`), holesky (`holesky./etc/clickhouse-server/users.xml`), hoodi (`hoodi./etc/clickhouse-server/users.xml`)
- **Tags**: 
### on
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.on`), sepolia (`sepolia.on`), holesky (`holesky.on`), hoodi (`hoodi.on`)
- **Tags**: 
### the
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.the`), sepolia (`sepolia.the`), holesky (`holesky.the`), hoodi (`hoodi.the`)
- **Tags**: 
### server
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.server`), sepolia (`sepolia.server`), holesky (`holesky.server`), hoodi (`hoodi.server`)
- **Tags**: 
### where
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.where`), sepolia (`sepolia.where`), holesky (`holesky.where`), hoodi (`hoodi.where`)
- **Tags**: 
### ClickHouse
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.ClickHouse`), sepolia (`sepolia.ClickHouse`), holesky (`holesky.ClickHouse`), hoodi (`hoodi.ClickHouse`)
- **Tags**: 
### is
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.is`), sepolia (`sepolia.is`), holesky (`holesky.is`), hoodi (`hoodi.is`)
- **Tags**: 
### installed.
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.installed.`), sepolia (`sepolia.installed.`), holesky (`holesky.installed.`), hoodi (`hoodi.installed.`)
- **Tags**: 
### .
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet..`), sepolia (`sepolia..`), holesky (`holesky..`), hoodi (`hoodi..`)
- **Tags**: 
### (REQUIRED_PASSWORD)
- **Database**: Network-specific (see Networks below)
- **Description**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name

If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD)
- **Partitioning**: Code: 194. DB::Exception: default: Authentication failed: password is incorrect

If you use ClickHouse Cloud
on the settings page for the corresponding service.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (REQUIRED_PASSWORD) (none), 
- **Networks**: mainnet (`mainnet.(REQUIRED_PASSWORD)`), sepolia (`sepolia.(REQUIRED_PASSWORD)`), holesky (`holesky.(REQUIRED_PASSWORD)`), hoodi (`hoodi.(REQUIRED_PASSWORD)`)
- **Tags**: 

## Table Catalog

**Standard tables** (accessed via `default` database or directly):

### `beacon_api_eth_v1_beacon_committee`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, hourly)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API /eth/v1/beacon/states/{state_id}/committees data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_attestation`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, hourly)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "attestation" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_blob_sidecar`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "blob_sidecar" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_block`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "block" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_block_gossip`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "block_gossip" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_chain_reorg`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "chain reorg" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_contribution_and_proof`
- **Database**: `default`
- **Partitioning**: `contribution_slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "contribution and proof" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_data_column_sidecar`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, hoodi, sepolia
- **Description**: Contains beacon API eventstream "data_column_sidecar" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_finalized_checkpoint`
- **Database**: `default`
- **Partitioning**: `epoch_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "finalized checkpoint" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_head`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "head" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_events_voluntary_exit`
- **Database**: `default`
- **Partitioning**: `wallclock_epoch_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API eventstream "voluntary exit" data from each sentry client attached to a beacon node.

### `beacon_api_eth_v1_validator_attestation_data`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API validator attestation data from each sentry client attached to a beacon node.

### `beacon_api_eth_v2_beacon_block`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API /eth/v2/beacon/blocks/{block_id} data from each sentry client attached to a beacon node.

### `mempool_transaction`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Each row represents a transaction that was seen in the mempool by a sentry client. Sentries can report the same transaction multiple times if it has been long enough since the last report.

### `beacon_api_eth_v1_proposer_duty`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a proposer duty from a beacon block.

### `beacon_api_eth_v3_validator_block`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon API /eth/v3/validator/blocks/{slot} data from each sentry client attached to a beacon node.

### `canonical_beacon_block`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains beacon block from a beacon node.

### `canonical_beacon_committee`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical beacon API /eth/v1/beacon/committees data.

### `canonical_beacon_block_attester_slashing`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains attester slashing from a beacon block.

### `canonical_beacon_block_proposer_slashing`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains proposer slashing from a beacon block.

### `canonical_beacon_block_bls_to_execution_change`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains bls to execution change from a beacon block.

### `canonical_beacon_block_execution_transaction`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains execution transaction from a beacon block.

### `canonical_beacon_block_voluntary_exit`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a voluntary exit from a beacon block.

### `canonical_beacon_block_deposit`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a deposit from a beacon block.

### `canonical_beacon_block_withdrawal`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a withdrawal from a beacon block.

### `canonical_beacon_blob_sidecar`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a blob sidecar from a beacon block.

### `canonical_beacon_proposer_duty`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a proposer duty from a beacon block.

### `canonical_beacon_elaborated_attestation`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains elaborated attestations from beacon blocks.

### `canonical_beacon_validators`
- **Database**: `default`
- **Partitioning**: `epoch_start_date_time` (datetime, hourly)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a validator state for an epoch.

### `canonical_beacon_validators_pubkeys`
- **Database**: `default`
- **Partitioning**: `index` (integer, 50)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains a validator state for an epoch.

### `libp2p_gossipsub_beacon_attestation`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, hourly)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Table for libp2p gossipsub beacon attestation data.

### `libp2p_gossipsub_beacon_block`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Table for libp2p gossipsub beacon block data.

### `libp2p_gossipsub_blob_sidecar`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Table for libp2p gossipsub blob sidecar data

### `libp2p_gossipsub_data_column_sidecar`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, hoodi, sepolia
- **Description**: Table for libp2p gossipsub data column sidecar data.

### `libp2p_gossipsub_aggregate_and_proof`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Table for libp2p gossipsub aggregate and proof attestation data

### `libp2p_connected`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p connected events

### `libp2p_disconnected`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p disconnected events

### `libp2p_add_peer`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p add peer events

### `libp2p_remove_peer`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p remove peer events

### `libp2p_recv_rpc`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p recv rpc events

### `libp2p_send_rpc`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p send rpc events

### `libp2p_drop_rpc`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p drop rpc events

### `libp2p_join`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p join events

### `libp2p_leave`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p leave events

### `libp2p_graft`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p graft events

### `libp2p_prune`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p prune events

### `libp2p_duplicate_message`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p duplicate message events

### `libp2p_deliver_message`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p deliver message events

### `libp2p_handle_metadata`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p handle metadata events

### `libp2p_handle_status`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p handle status events

### `libp2p_rpc_meta_control_ihave`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta control ihave events

### `libp2p_rpc_meta_control_iwant`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta control iwant events

### `libp2p_rpc_meta_control_idontwant`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta control idontwant events

### `libp2p_rpc_meta_control_graft`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta control graft events

### `libp2p_rpc_meta_control_prune`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta control prune events

### `libp2p_rpc_meta_subscription`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta subscription events

### `libp2p_rpc_meta_message`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p rpc meta message events

### `mev_relay_bid_trace`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains MEV relay block bids data.

### `mev_relay_proposer_payload_delivered`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains MEV relay proposer payload delivered data.

### `mev_relay_validator_registration`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains MEV relay validator registrations data.

### `canonical_execution_block`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution block data.

### `canonical_execution_transaction`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution transaction data.

### `canonical_execution_traces`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution traces data.

### `canonical_execution_logs`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution logs data.

### `canonical_execution_contracts`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution contract data.

### `canonical_execution_four_byte_counts`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution four byte count data.

### `canonical_execution_address_appearances`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution address appearance data.

### `canonical_execution_balance_diffs`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution balance diff data.

### `canonical_execution_balance_reads`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution balance read data.

### `canonical_execution_erc20_transfers`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution erc20 transfer data.

### `canonical_execution_erc721_transfers`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution erc721 transfer data.

### `canonical_execution_native_transfers`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution native transfer data.

### `canonical_execution_nonce_diffs`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution nonce diff data.

### `canonical_execution_nonce_reads`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution nonce read data.

### `canonical_execution_storage_diffs`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: mainnet, holesky, sepolia
- **Description**: Contains canonical execution storage diffs data.

### `canonical_execution_storage_reads`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 1000)
- **Networks**: holesky, sepolia
- **Description**: Contains canonical execution storage reads data.

### `canonical_execution_transaction_structlog`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 100)
- **Networks**: mainnet
- **Description**: Contains canonical execution transaction structlog data from [`debug_traceTransaction`](https://geth.ethereum.org/docs/interacting-with-geth/rpc/ns-debug#debugtracetransaction).

### `canonical_execution_transaction_structlog_agg`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 100)
- **Networks**: mainnet
- **Description**: Contains aggregated canonical execution transaction structlog data from [`debug_traceTransaction`](https://geth.ethereum.org/docs/interacting-with-geth/rpc/ns-debug#debugtracetransaction).

### `consensus_engine_api_get_blobs`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet
- **Description**: Contains consensus engine API getBlobsV1 request data from each sentry client.

### `consensus_engine_api_new_payload`
- **Database**: `default`
- **Partitioning**: `slot_start_date_time` (datetime, daily)
- **Networks**: mainnet
- **Description**: Contains consensus engine API newPayload request data from each sentry client.

### `libp2p_rpc_data_column_custody_probe`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p RPC data column custody probe events.

### `libp2p_identify`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Table for libp2p identify events containing peer identification data including agent version, protocols, and connection metadata.

### `libp2p_synthetic_heartbeat`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, holesky, hoodi, sepolia
- **Description**: Table for libp2p synthetic heartbeat events.

### `node_record_consensus`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Contains consensus layer node records from discv5 discovery.

### `node_record_execution`
- **Database**: `default`
- **Partitioning**: `event_date_time` (datetime, daily)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Contains execution layer node records from discv4/discv5 discovery.

### `execution_state_size`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 5000000)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Contains execution layer state size metrics per block.

### `execution_transaction`
- **Database**: `default`
- **Partitioning**: `block_number` (integer, 5000000)
- **Networks**: mainnet, hoodi, sepolia
- **Description**: Contains execution layer transaction data.


## Advanced Query Patterns

### Proper JOIN with CTEs
```sql
-- ALWAYS use CTEs when joining to avoid cross-shard issues
WITH
    canonical AS (
        SELECT *
        FROM canonical_beacon_block FINAL
        WHERE slot_start_date_time BETWEEN toDateTime('2024-04-01') AND toDateTime('2024-04-02')
            AND meta_network_name = 'mainnet'
    ),
    events AS (
        SELECT *
        FROM beacon_api_eth_v1_events_block FINAL
        WHERE slot_start_date_time BETWEEN toDateTime('2024-04-01') AND toDateTime('2024-04-02')
            AND meta_network_name = 'mainnet'
    )
SELECT
    c.slot,
    c.block_root,
    c.proposer_index,
    COUNT(DISTINCT e.meta_client_name) as observer_count,
    MIN(e.propagation_slot_start_diff) as min_propagation
FROM canonical c
LEFT JOIN events e ON c.slot = e.slot
GROUP BY c.slot, c.block_root, c.proposer_index
ORDER BY c.slot;
```

### Time-Based Aggregation
```sql
SELECT
    toStartOfHour(slot_start_date_time) AS hour,
    COUNT(*) as block_count,
    quantile(0.5)(propagation_slot_start_diff) as p50_propagation,
    quantile(0.95)(propagation_slot_start_diff) as p95_propagation
FROM beacon_api_eth_v1_events_block FINAL
WHERE
    slot_start_date_time >= NOW() - INTERVAL 24 HOUR
    AND meta_network_name = 'mainnet'
GROUP BY hour
ORDER BY hour DESC;
```

### Network Consensus Analysis
```sql
-- Find missed slots
WITH expected_slots AS (
    SELECT number as slot
    FROM numbers(
        (SELECT MIN(slot) FROM canonical_beacon_block WHERE slot_start_date_time >= toDateTime('2024-04-01')),
        (SELECT MAX(slot) FROM canonical_beacon_block WHERE slot_start_date_time < toDateTime('2024-04-02'))
    )
)
SELECT
    e.slot,
    b.block_root IS NULL as is_missed
FROM expected_slots e
LEFT JOIN canonical_beacon_block b ON e.slot = b.slot
WHERE is_missed = 1;
```

### MEV Analysis
```sql
SELECT
    slot,
    builder_pubkey,
    value / 1e18 as value_eth,
    num_txs
FROM mev_relay_bid_trace FINAL
WHERE
    slot_start_date_time >= toDateTime('2024-04-01')
    AND slot_start_date_time < toDateTime('2024-04-02')
    AND meta_network_name = 'mainnet'
ORDER BY value DESC
LIMIT 20;
```

## Query Optimization Tips

1. **Always filter partitions first**
   ```sql
   WHERE slot_start_date_time BETWEEN '2024-04-01' AND '2024-04-02'  -- Good
   WHERE slot > 1000000  -- Bad (no partition filter)
   ```

2. **Use FINAL for ReplacingMergeTree**
   ```sql
   FROM canonical_beacon_block FINAL  -- Deduplicates rows
   ```

3. **Use CTEs for joins**
   ```sql
   WITH t1 AS (...), t2 AS (...)  -- Good
   FROM table1 JOIN table2  -- May cause cross-shard issues
   ```

4. **Use appropriate FORMAT**
   ```sql
   FORMAT JSON  -- For API consumption
   FORMAT Pretty  -- For terminal viewing
   FORMAT TabSeparated  -- For piping to other tools
   ```

## Dataset overview
- Data is stored in ClickHouse database. You MUST use CTEs when joining to avoid cross-shard issues.
- The data pipeline can be delayed by 10seconds to 10 minutes.
- IMPORTANT: If the table contains a `meta_client_name` column, there is a high chance that the data is being collected by multiple instances and you will see the same data multiple times. THIS IS A FEATURE OF THE DATASET.
- Querying the CBT tables should be a priority as they are pre-aggregated and are the most complete and reliable source of data.
- It is HIGHLY recommended to explore the available tables and understand the data before querying.

### Core Datasets
- **Beacon API Event Stream**: Events derived from the Beacon API event stream. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances. These tables are usually fairly slim and contain only a few columns. These tables can be joined with the canonical tables to get a more complete view of the data. For example, you can join the beacon_api_eth_v1_events_block table on block_root or slot with the canonical_beacon_block table to get the block data for each block. (Prefix: `beacon_api_`)
- **Execution Layer P2P**: Events from the execution layer p2p network. This data is usually useful for 'timing' events, such as when a transaction was seen in the mempool by an instance. Because of this it usually has the same data but from many different instances. (Prefix: `mempool_`)
- **Canonical Beacon**: Events derived from the finalized beacon chain. This data is only derived by a single instance, are deduped, and are more complete and reliable than the beacon_api_ tables. These tables can be reliably JOINed on to hydrate other tables with information (Prefix: `canonical_beacon_`)
- **Canonical Execution**: Data extracted from the execution layer. This data is only derived by a single instance, are deduped, and are more complete and reliable than the execution_layer_p2p tables. These tables can be reliably JOINed on to hydrate other tables with information (Prefix: `canonical_execution_`)
- **Consensus Layer P2P**: Events from the consensus layer p2p network. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances. (Prefix: `libp2p_`)
- **MEV Relay**: Events derived from MEV relays. Data is scraped from multiple MEV Relays by multiple instances. (Prefix: `mev_relay_`)
- **CBT (ClickHouse Build Tools)**: Pre-aggregated analytical tables for common blockchain queries. These tables are transformation tables similar to DBT, powered by [xatu-cbt](https://github.com/ethpandaops/xatu-cbt) using [ClickHouse Build Tools (CBT)](https://github.com/ethpandaops/cbt). (Prefix: ``). These tables exist in the $network databases.

### ⚠️ Critical: Query Optimization
**ALWAYS filter on partitioning columns:**
- Queries without partition filters will scan **billions of rows**
- Use `FINAL` modifier for tables with `ReplacingMergeTree` engine
- Use CTEs when joining to avoid cross-shard issues
- Check table partitioning column before querying

### Get Table Schema
```bash
# Download CREATE TABLE statement
curl -s https://raw.githubusercontent.com/ethpandaops/xatu-data/refs/heads/master/schema/clickhouse/$DATABASE/$TABLE_NAME.sql

# Example: canonical beacon blocks
curl -s https://raw.githubusercontent.com/ethpandaops/xatu-data/refs/heads/master/schema/clickhouse/default/canonical_beacon_block.sql
```

### Common Metadata Fields
- `meta_client_name` - Data collection client
- `meta_client_id` - Unique session ID
- `meta_network_name` - Network filter (mainnet, holesky, etc.)
- `event_date_time` - Event timestamp
- Partition column (see table catalog)

**Note**: CBT tables don't include meta fields; network selection is via database.


## Data Freshness

- **Real-time**: Streamed directly from Xatu collectors
- **Latency**: Typically seconds to minutes
- **Completeness**: No redactions or privacy filtering
- **Network coverage**: See table catalog for date ranges

## Additional Resources

- **Parquet Files**: https://raw.githubusercontent.com/ethpandaops/xatu-data/refs/heads/master/llms/parquet/llms.txt for public file access
- **Schema Repository**: https://github.com/ethpandaops/xatu-data/tree/master/schema/clickhouse
- **Config File**: https://raw.githubusercontent.com/ethpandaops/xatu-data/master/config.yaml
- **Contact**: ethpandaops@ethereum.org

## Hints (VERY IMPORTANT)
- It is HIGHLY recommended to explore the available tables and understand the data before querying.
- The CBT tables (in the $network database) MUST be your first choice for data. Inspect all the available tables and understand the data before querying.
- A large amount of CBT tables have _head and _canonical variants. Make sure you know which one you are querying as the data can be different.
- To check when a block was first seen by nodes in the Xatu network, check the $network.fct_block_first_seen_by_node table.
- A "best effort" table in $network.dim_node contains validator information like the entity running the validator. In devnets this also contains the node name that is running the validator.
- When asked for Grafana compatible queries you should make use of $__timeFilter() over the tables partition column. If asked for Grafana timeseries queries, you need to use $__timeInterval() over the tables partition column, usually with something like toStartOfFiveMinutes() or toStartOfHour().

## License
Data licensed under CC BY 4.0