Hi, I am facing an error while using tap-snowflake...
# troubleshooting
a
Hi, I am facing an error while using tap-snowflake. The error is:
Copy code
sqlalchemy.exc.DatabaseError: (snowflake.connector.errors.DatabaseError) 250001 (08001): None: Failed to connect to DB: <http://fwqiebo-bl90324.snowflakecomputing.com:443|fwqiebo-bl90324.snowflakecomputing.com:443>. Incorrect username or password was specified.
(Background on this error at: <https://sqlalche.me/e/20/4xp6>)
The tap-snowflake config is:
Copy code
- name: tap-snowflake
    variant: meltanolabs
    pip_url: meltanolabs-tap-snowflake
    config:
      account: fwqiebo-bl90324
      database: SNOWFLAKE_INTEGRATION_TEST
      role: LS_ADMIN
      schema: SCHEMA
      tables:
      - PUBLIC.CUSTOM_ATTRIBUTION_VIEW
      user: TESTER
      warehouse: COMPUTE_WH
I tested this couple of months ago and it worked fine, now sure what where I'm going wrong. Thanks in advance. Cheers!
e
Can you confirm that your password is still valid?
n
I ran into this today. you sure MFA isn't enabled? I had to change to private key authentication. They are gonna kill password auth anyway in Novemeber so you might want to switch now anyway.
💡 1
a
Yeah, MFA isn't enabled and the password is valid. Thanks for the heads-up on password auth deprecation
n
use snowsql from the box with the same creds and see what error you get.