atoti_directquery_clickhouse.ClickhouseTableOptions#

class atoti_directquery_clickhouse.ClickhouseTableOptions#

Options passed to atoti.Session.add_external_table().

clustering_columns: Set[str] | Sequence[str] = frozenset({})#

The names of the columns used for clustering.

Feeding aggregate providers from an external database can result in very large queries to be run on this database. Clustering columns split up queries made by DirectQuery to the external database when feeding aggregate providers.

keys: Sequence[str] | Set[str] | None = None#

The columns that will become the table keys.