UsernamePasswordMFAAuth

relationalai.config.connections.snowflake

Configure Snowflake access using a username/password and an MFA passcode.

Use this authenticator when your Snowflake sign-in requires a time-based MFA code. When loading from a config dict or file, set authenticator="username_password_mfa".

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

Parameters

• account

  (str) - Snowflake account identifier.

• warehouse

  (str) - Snowflake warehouse name.

• user

  (str) - Snowflake username.

• password

  (str or SecretStr) - Snowflake password.

• passcode

  (str) - MFA passcode (typically a 6-digit code).

Examples

Create a programmatic config using this authenticator class:

>>> from relationalai.config import Config, UsernamePasswordMFAAuth
>>> cfg = Config(connections={
...     "sf": UsernamePasswordMFAAuth(
...         account="my_account",
...         warehouse="my_warehouse",
...         user="my_user",
...         password="my_password",
...         passcode="123456",
...     )
... })

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_mfa",
...         "account": "my_account",
...         "warehouse": "my_warehouse",
...         "user": "my_user",
...         "password": "my_password",
...         "passcode": "123456",
...     }
... })

Inheritance Hierarchy

Used By

 config > connections > snowflake
└──  SnowflakeAuthenticator

Referenced By

RelationalAI Documentation
└──  Build With RelationalAI
    └──  Understand how PyRel works > Configure PyRel
        └──  Configure snowflake auth
            └──  Configure username/password authentication with MFA