Skip to content

bug: special characters in password cause authentication failures #281

Closed
@pnadolny13

Description

@pnadolny13

Related to https://github.com/snowflakedb/snowflake-sqlalchemy?tab=readme-ov-file#escaping-special-characters-such-as---signs-in-passwords. The tap will hit authentication failures if the password has special characters in it. Sqlalchemy suggests that they be encoded using:

import urllib.parse
urllib.parse.quote("kx@% jj5/g")

One backwards compatibility thing is that some users may have already hit this and manually encoded their password. In that case we shouldnt double encode it. We could attempt a login and if authentication fails, attempt a second login with the encoded version of the password or just bump the release version and warn of a change to the defaults.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions