ConnectionConfig

atoti_directquery_databricks.ConnectionConfig(
    *,
    password: str | None = None,
    auto_multi_column_array_conversion: AutoMultiColumnArrayConversion | 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,
    feeding_url: str | None = None,
    time_travel: Literal[False, ‘lax’, ‘strict’] = 'strict',
)

>>> import os
>>> from atoti_directquery_databricks import ConnectionConfig
>>> connection_config = ConnectionConfig(
...     url="jdbc:databricks://"
...     + os.environ["DATABRICKS_SERVER_HOSTNAME"]
...     + "/default;"
...     + "transportMode=http;"
...     + "ssl=1;"
...     + "httpPath="
...     + os.environ["DATABRICKS_HTTP_PATH_SQL_WAREHOUSE"]
...     + ";"
...     + "AuthMech=3;"
...     + "UID=token;",
...     password=os.environ["DATABRICKS_AUTH_TOKEN"],
... )
>>> external_database = session.connect_to_external_database(connection_config)

​

Attributes

​

url

​

feeding_url

​

time_travel

• False: tables and views are queried on the latest state of the database.
• "lax": tables are queried with time travel but views are queried without it.
• "strict": tables are queried with time travel and querying a view raises an error.

​

auto_multi_column_array_conversion

​

column_clustered_queries

​

feeding_query_timeout

• the initial load to feed aggregate_providers and hierarchies;
• the refresh operations.

​

lookup_mode

​

max_sub_queries

​

password

​

query_timeout