class monad.ui.config.SnowflakeConfig
monad.ui.config.SnowflakeConfigDefines the data connection to Snowflake.
from monad.ui.config import SnowflakeConfig
SnowflakeConfig(
user="username",
password="strongpassword123",
account="xy12345.west-europe.azure",
warehouse="warehouse_name",
database="example_db",
db_schema="example_schema",
role="relevant_role",
)| Parameters |
|---|
user : str
Specifies the login name of the user for the connection. Environment variable can be called.
Examples: "firstnamelastname", "${SNOWFLAKE_USER}".
password: str
Specifies the password for the specified user. Environment variable can be called.
Examples: "strongpassword123", "${SNOWFLAKE_PASSWORD}".
account : str
Specifies the account identifier of your organisation. Environment variable can be called.
Examples: "ab12345.eu-central-2", "${SNOWFLAKE_ACCOUNT}".
warehouse: str
Specifies the virtual warehouse to use once connected, or specifies an empty string. The specified warehouse should be an existing warehouse for which the specified default role has privileges. Environment variable can be called.
Examples: "warehouse_name", "${SNOWFLAKE_WAREHOUSE}".
database: str
Specifies the default database to use once connected, or specifies an empty string. The specified database should be an existing database for which the specified default role has privileges.
Examples: "example_db".
db_schema: str
Specifies the default schema to use for the specified database once connected, or specifies an empty string. The specified schema should be an existing schema for which the specified default role has privileges.
Examples: "public".
role: str
Default: "PUBLIC"
Specifies the role to use. Environment variable can be called.
Examples= "DB_ADMIN", "${SNOWFLAKE_ROLE}".
