ConnectionConfig

atoti_directquery_snowflake.ConnectionConfig(
    *,
    time_travel: bool = True,
    password: RedactedStr | None = None,
    cache: bool = True,
    auto_multi_column_array_conversion: AutoMultiColumnArrayConversion | None = None,
    redacted_properties: FrozenMapping[str, RedactedStr] = frozendict(),
    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_warehouse_name: str | None = None,
    main_warehouse_name: str | None = None,
)

>>> import os
>>> from atoti_directquery_snowflake import ConnectionConfig
>>> connection_config = ConnectionConfig(
...     url="jdbc:snowflake://"
...     + os.environ["SNOWFLAKE_ACCOUNT_IDENTIFIER"]
...     + ".snowflakecomputing.com/?user="
...     + os.environ["SNOWFLAKE_USERNAME"],
...     redacted_properties={
...         "private_key_file": os.environ["SNOWFLAKE_PRIVATE_KEY_FILE"],
...         "private_key_file_pwd": os.environ["SNOWFLAKE_PRIVATE_KEY_PWD"],
...     },
... )
>>> external_database = session.connect_to_external_database(connection_config)

​

Attributes

​

url

​

feeding_warehouse_name

​

main_warehouse_name

​

auto_multi_column_array_conversion

​

cache

​

column_clustered_queries

​

feeding_query_timeout

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

​

lookup_mode

​

max_sub_queries

​

password

ConnectionConfig(
    url=url,
    password=password,  
    redacted_properties={password_property_name: password},  
)

​

query_timeout

​

time_travel

​

redacted_properties