Can not authenticate with Snowflake - Single-factor password-only auth is deprecating.

[vbgcwood]

With piicatcher==0.21.2 + dbcat==0.14.2 the Snowflake integration is effectively password-only.

def add_snowflake_source(
    catalog: Catalog,
    name: str,
    account: str,
    username: str,
    password: str,
    database: str,
    warehouse: str,
    role: str,
) -> CatSource:
    with catalog.commit_context:
        return catalog.add_source(
            name=name,
            username=username,
            password=password,
            database=database,
            account=account,
            warehouse=warehouse,
            role=role,
            source_type="snowflake",
        )

https://github.com/tokern/dbcat/blob/main/dbcat/api.py

Snowflake is deprecating this method of sign-on:

In October 2025, Snowflake simplified the timeline discussed in this topic. The new timeline consolidates initial milestones and extends the final enforcement date from August 2026 to October 2026.

https://docs.snowflake.com/en/user-guide/security-mfa-rollout

Organizations that have prepared for this change would have already disabled the ability for users to use this auth method. In fact, Snowflake has distributed warnings to admins who manage accounts where users still have password-only sign-in.

This presents a conflict where many users would be unable to use the snowflake connector now, despite deprecation not being until October 2026.

Requested feature:

Please add support for key-based authentication.