> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing a list of dictionary sources supported by the server along with their embedded documentation.

# system.dictionary_sources

<h2 id="description">
  Description
</h2>

Contains the list of dictionary sources supported by the server, along with embedded documentation for each source. A dictionary source determines where the dictionary data is loaded from; it is specified in the `SOURCE` clause of a `CREATE DICTIONARY` query.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/index)) — The name of the dictionary source, as specified in the SOURCE clause.
* `description` ([String](/reference/data-types/index)) — A high-level description of what the dictionary source does.
* `syntax` ([String](/reference/data-types/index)) — The structure of the SOURCE clause used to specify the source. Note that some sources are subject to access control when a dictionary is created from a DDL query (as opposed to a server configuration file); see the `description` of the individual source for details.
* `examples` ([String](/reference/data-types/index)) — Usage examples.
* `introduced_in` ([String](/reference/data-types/index)) — The ClickHouse version in which the source was first introduced, in the form major.minor.
* `related` ([Array(String)](/reference/data-types/index)) — The names of related dictionary sources.

<h2 id="example">
  Example
</h2>

```sql title="Query" theme={null}
SELECT name, syntax
FROM system.dictionary_sources
WHERE name IN ('clickhouse', 'file')
ORDER BY name
```

```text title="Response" theme={null}
┌─name───────┬─syntax─────────────────────────────────────────────────────────────────────────┐
│ clickhouse │ SOURCE(CLICKHOUSE(host 'host' port 9000 user 'default' password '' db 'db' table 'table')) │
│ file       │ SOURCE(FILE(path '/path/to/file' format 'CSV'))                                  │
└────────────┴────────────────────────────────────────────────────────────────────────────────┘
```

<h2 id="see-also">
  See also
</h2>

* [Dictionary sources](/reference/statements/create/dictionary/sources/overview) — Information about dictionaries and their sources.