Thread
#secoda-support
    p

    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
    b.
    ab12345.us-east-2.aws
    e

    elegant-house-93198

    7 months ago
    Hey Sawyer, do you know if you ran the queries specified in this documentation while being
    ACCOUNTADMIN
    https://help.secoda.co/en/articles/5013624-snowflake?
    Also you need to whitelist our IP address
    35.175.75.15/32
    p

    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
    b.
    ab12345.us-east-2.aws
    e

    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