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

# read_from_* session settings

> ClickHouse session settings in the read_from_* generated group.

These settings are available in [system.settings](https://clickhouse.com/docs/reference/system-tables/settings.md) and are autogenerated from [source](https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/Settings.cpp).

## read\_from\_distributed\_cache\_if\_exists\_otherwise\_bypass\_cache

Type

Bool

Default

0

Only has an effect in ClickHouse Cloud. Same as read\_from\_filesystem\_cache\_if\_exists\_otherwise\_bypass\_cache, but for distributed cache.

## read\_from\_filesystem\_cache\_if\_exists\_otherwise\_bypass\_cache

Type

Bool

Default

0

Allow to use the filesystem cache in passive mode - benefit from the existing cache entries, but don't put more entries into the cache. If you set this setting for heavy ad-hoc queries and leave it disabled for short real-time queries, this will allows to avoid cache threshing by too heavy queries and to improve the overall system efficiency.

## read\_from\_page\_cache\_if\_exists\_otherwise\_bypass\_cache

Type

Bool

Default

0

Use userspace page cache in passive mode, similar to read\_from\_filesystem\_cache\_if\_exists\_otherwise\_bypass\_cache.
