Reputation: 51

Where to find JDBC URL in Snowflake

I need to connect a Snowflake database to DB Schema. DB Schema is asking for the JDBC URL. Where can I find this in snowflake?

Upvotes: 5

Answers (3)

Reputation: 31

I don't have enough points to comment, so I'll steal from the best answer here IMO. system$whitelist is deprecated. The correct command is:

use role acountadmin;

select system$allowlist();

I've been pulling my hair out for an hour trying to get the correct JDBC URL into Datagrip.

Upvotes: 3

Reputation: 216

If you are referring to this:

"jdbc:snowflake://--accountname--.snowflakecomputing.com/

you can find your Snowflake account URL by running this SQL:

use role accountadmin;
select system$whitelist();

Your Snowflake account URL will is as follows: {"type":"SNOWFLAKE_DEPLOYMENT","host":"xxxxxxx.snowflakecomputing.com","port":443}

Upvotes: 5

Reputation: 9768

Upvotes: 0