- class atoti_directquery_mssql.MsSqlConnectionInfo#
Information needed to connect to a Microsoft SQL Server database.
- __init__(url, /, *, auto_multi_column_array_conversion=None, lookup_mode='warn', max_sub_queries=50, password=None, query_timeout=datetime.timedelta(seconds=3600))#
Create a Microsoft SQL Server connection info.
url (str) – The JDBC connection string. See https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16 for more information.
auto_multi_column_array_conversion (AutoMultiColumnArrayConversion | None) – When not
None, multi column array conversion will be performed automatically.
lookup_mode (Literal['allow', 'warn', 'deny']) – 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 (int) – Maximum number of subqueries performed when splitting a query into multi-steps queries.
password (str | None) –
The password to connect to the database.
Passing it in this separate parameter allows to avoid having it logged alongside the connection string.
None, a password is expected to be present in the passed url.
query_timeout (timedelta) – Timeout for queries performed on the external database.