I am trying to connect with snowflake using DBT with SSO Authentication Mechanism. For this an external browser window should open for passing the credentials. To connect with snowflake I build the profile.yml file as below
test_dbt_snowflake:
target: dev
outputs:
dev:
type: snowflake
account: ****.east-us-2.azure
user: ****
role: sysadmin
# SSO config
authenticator: externalbrowser
database: tgt
warehouse: compute_wh
schema: tgt_schema
threads: 1
client_session_keep_alive: False
but when I try to connect it gives the below error
Running with dbt=0.17.0
For upgrading instructions, consult the documentation:
https://docs.getdbt.com/docs/guides/migration-guide/upgrading-to-0-17-0
Found 1 model, 0 tests, 0 snapshots, 0 analyses, 136 macros, 0 operations, 0 seed files, 0 sources
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Encountered an error:
Runtime Error
Database error while listing schemas in database "tgt"
Database Error
390190 (08001): Failed to connect to DB: *****.east-us-2.azure.snowflakecomputing.com:443, There was an error related to the SAML Identity Provider account parameter. Contact Snowflake support.