UsernamePasswordAuth

relationalai.config.connections.snowflake

Configure Snowflake access using a username and password.

Use this authenticator when you sign in to Snowflake with a password. You can instantiate this class directly (for example, when building a create_config programmatically), or provide a config dict and let create_config validate and create it.

Instantiating this class is optional; you can also pass an equivalent dict to create_config.

When loading from a config dict or file, set authenticator="username_password".

Parameters

• account

  (str) - Snowflake account identifier.

• warehouse

  (str) - Snowflake warehouse name.

• user

  (str) - Snowflake username.

• password

  (str or SecretStr) - Snowflake password.

Examples

Create a programmatic config using this authenticator class:

from relationalai.config import Config, UsernamePasswordAuth

cfg = Config(
    connections={
        "sf": UsernamePasswordAuth(
            account="my_account",
            warehouse="my_warehouse",
            user="my_user",
            password="my_password",
        )
    }
)

Create a programmatic config using a plain dict (no authenticator import):

from relationalai.config import Config

cfg = Config(
    connections={
        "sf": {
            "type": "snowflake",
            "authenticator": "username_password",
            "account": "my_account",
            "warehouse": "my_warehouse",
            "user": "my_user",
            "password": "my_password",
        }
    }
)

Inheritance Hierarchy

Used By

 config > connections > snowflake
└──  SnowflakeAuthenticator

Referenced By

RelationalAI Documentation
└──  Build With RelationalAI
    └──  Understand how PyRel works > Configure PyRel
        └──  Configure Snowflake authentication
            └──  Configure username/password authentication