Soda Test Snowflake add oauth

[janhelmu]

Hello datacontract-team,

please can you add oauth login for snowflake?

sf = snowflake.connector.connect(
account=os.getenv("SNOWFLAKE_ACCOUNT"),
user= snf_user + "XXX",
password="",
role=os.getenv("SNOWFLAKE_ROLE"),
warehouse=os.getenv("SNOWFLAKE_WAREHOUSE"),
database=sf_db,
authenticator="oauth",
token= token
)

Thanks for your support.

best regards

Jan

[jochenchrist]

OK, this should be doable, as it is supported in soda-core-snowflake: https://github.com/sodadata/soda-core/blob/main/soda/snowflake/soda/data_sources/snowflake_data_source.py#L80

[janhelmu]

Hi Jochen thanks for your support. Yes I see it will be supported by soda.
Do you know how can I implemented with your package? I mean I use following in a yml file.

datacontracts:
variables:
DATACONTRACT_SNOWFLAKE_USERNAME: ${SNF_USER}
DATACONTRACT_SNOWFLAKE_PASSWORD: ${SNF_PASSWORD_LOCAL}
DATACONTRACT_SNOWFLAKE_WAREHOUSE: ${SNF_WAREHOUSE}
DATACONTRACT_SNOWFLAKE_ROLE: ${SNF_ROLE}

Thanks again for your help.

Jan

[jochenchrist]

Try to also set these ENV parameters to use oauth:

DATACONTRACT_SNOWFLAKE_AUTHENTICATOR=oauth
DATACONTRACT_SNOWFLAKE_TOKEN=your-token

[janhelmu]

Hi Jochen,

thanks for your quick response but it does not work.

datacontracts:
variables:
DATACONTRACT_SNOWFLAKE_USERNAME: ${SNF_USER}
DATACONTRACT_SNOWFLAKE_PASSWORD: ${SNF_PASSWORD_LOCAL}
DATACONTRACT_SNOWFLAKE_WAREHOUSE: ${SNF_WAREHOUSE}
DATACONTRACT_SNOWFLAKE_ROLE: ${SNF_ROLE}
DATACONTRACT_SNOWFLAKE_AUTHENTICATOR: "oauth"
DATACONTRACT_SNOWFLAKE_TOKEN: "eyJhbGcxxxxxxxxxxxxxxx"

I getting the following error message.

ERROR:soda.scan:[18:05:32] Could not connect to data source "snowflake": 250001 (08001): Failed to connect to DB: xxxx.eu-central-1.snowflakecomputing.com:443. Invalid OAuth access token.

Thanks and I wish you a great weekend.