There is a dictionary map mechanism in ClickHouse
https://clickhouse.com/docs/en/sql-reference/functions/ext-dict-functions

It is necessary to add new functions in formula and their implementation in CH connector, depending on the types.

For example:

• dictGetString
• dictGetInt64
• dictGetOrDefault

Related:

• Add formulas to work with Clickhouse Dictionaries #105