Documentation Index
Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
Use this file to discover all available pages before exploring further.
final class atoti_directquery_mssql.ConnectionConfig
Config to connect to a Microsoft SQL Server database.See also:
atoti_directquery_snowflake.ConnectionConfig for an example.auto_multi_column_array_conversion : AutoMultiColumnArrayConversion | None = None
When notNone, multi-column array conversion will be performed automatically.
column_clustered_queries : ‘all’ | ‘feeding’ = ‘feeding’
Control which queries will use clustering columns.feeding_query_timeout : Duration = datetime.timedelta(seconds=3600)
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 : ‘allow’ | ‘warn’ | ‘deny’ = ‘warn’
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 : Annotated[int, Field(gt=0)] = 500
Maximum number of sub queries performed when splitting a query into multi-step queries.password : str | None = None
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.