I m trying to connect Snowflake I ve got a SECODA USER that | Secoda-support

Channels

Channels

Thread

#secoda-support

polite-microphone-78573

7 months ago

I’m trying to connect Snowflake. I’ve got a

SECODA_USER

that’s been granted

SECODA_ROLE

I’ve verified that 1. the

SECODA_USER

can login to the snowflake console via OAuth 2. the

SECODA_USER

can connect via JDBC + username+password 3. the

SECODA_USER

has appropriate privileges Yet Secoda cannot connect -

errno=ER_FAILED_TO_CONNECT_TO_DB, snowflake.connector.errors.OperationalError: 250001: Could not connect to Snowflake backend after 0 attempt(s).

I’ve tried many variations of login credentials -1. with and without the

SECODA_ROLE

2. two different warehouses (

compute_wh

and my

AIRBYTE_WAREHOUSE

) 3. different account formats a.

ab12345.us-east-2

ab12345.us-east-2.aws

elegant-house-93198

7 months ago

Hey Sawyer, do you know if you ran the queries specified in this documentation while being

ACCOUNTADMIN

Also you need to whitelist our IP address

35.175.75.15/32

polite-microphone-78573

7 months ago

Yup. executed the instructions in Secoda’s docs line by line

should it be a.

ab12345.us-east-2

ab12345.us-east-2.aws

elegant-house-93198

7 months ago

Can you send the URL of your Snowflake instance in a DM pls. I’ll be able to answer with that info

View count: 1