atoti_directquery_clickhouse.ConnectionConfig(Config to connect to a ClickHouse database.
*,
password: str | None =None,
column_clustered_queries: ‘all’ | ‘feeding’ ='feeding',
feeding_query_timeout: Duration =datetime.timedelta(seconds=3600),
lookup_mode: ‘allow’ | ‘warn’ | ‘deny’ ='warn',
max_sub_queries: Annotated[int, Field(gt=0)] =500,
query_timeout: Duration =datetime.timedelta(seconds=300),
url: str,
)
See also:
atoti_directquery_snowflake.ConnectionConfig for an example.Attributes
url
The connection string. The pattern is:(clickhouse|ch):(https|http|...)://login:password@host:port/database?prop=value.
For example: "clickhouse:https://user:password@localhost:8123/mydb".
When a part is missing, its default value will be used.
column_clustered_queries
Control which queries will use clustering columns.feeding_query_timeout
Timeout for queries performed on the external database during feeding phases. The feeding phases are:- the initial load to feed
aggregate_providersandhierarchies; - the refresh operations.
lookup_mode
Whether lookup queries on the external database are allowed. Lookup can be very slow and expensive as the database may not enforce primary keys.max_sub_queries
Maximum number of sub queries performed when splitting a query into multi-step queries.password
The password to connect to the database. Passing it in this separate attribute prevents it from being logged alongside the connection string. IfNone, a password is expected to be present in url.