atoti_directquery_snowflake.connection_info module

class atoti_directquery_snowflake.SnowflakeConnectionInfo

Information needed to connect to a Snowflake database.

__init__(url, /, *, password=None, feeding_warehouse=None)

Parameters

• url (str) – The JDBC connection string. See https://docs.snowflake.com/en/user-guide/jdbc-configure.html#jdbc-driver-connection-string for more information.

• password (Optional[str]) –

  The password to connect to the database.

  Passing it in this separate parameter allows to avoid having it logged alongside the connection string.

  If None, a password is expected to be present in the passed url.

• feeding_warehouse (Optional[str]) – The warehouse used to do the initial feeding. If None, the main warehouse will be used.

Example

>>> import os
>>> from atoti_directquery_snowflake import SnowflakeConnectionInfo
>>> connection_info = SnowflakeConnectionInfo(
...     "jdbc:snowflake://"
...     + os.environ["SNOWFLAKE_ACCOUNT_IDENTIFIER"]
...     + ".snowflakecomputing.com/?user="
...     + os.environ["SNOWFLAKE_USERNAME"],
...     password=os.environ["SNOWFLAKE_PASSWORD"],
... )