1

The SAP Analytics Cloud's Snowflake Connector needs these details for setting up a Snowflake connection

[

How can I get these details from Snowflake?

I'm trying to follow this guide

derHugo
  • 83,094
  • 9
  • 75
  • 115
Prasad P
  • 41
  • 1
  • 2

1 Answers1

4

It appears that you're attempting to configure SAP Analytics Cloud's Snowflake Connector.

The host and port of your Snowflake account (also known as its deployment URL) can be taken from the URL you use to connect to Snowflake's Web UI. Here's an example:

screenshot depicting a highlighted snowflake account URL in a browser window

For the above URL, the input in the Server field of the form will be mzf0194.us-west-2.snowflakecomputing.com:443 (the 443 port number is the default HTTPS port that Snowflake serves on).

Or alternatively, if you have access to any other Snowflake connected application (such as SnowSQL, etc.) that lets you run a SQL query, run the following to extract it:

select t.value:host || ':443' snowflake
from table(flatten(parse_json(system$whitelist()))) t
where t.value:type = 'SNOWFLAKE_DEPLOYMENT';

An example output that carries the host/port:

+---------------------------------------------+
| SNOWFLAKE                                   |
|---------------------------------------------|
| p7b41m.eu-west-1.snowflakecomputing.com:443 |
+---------------------------------------------+

If you're uncertain about what these all mean, you'll need to speak to other, current Snowflake users or administrators in your organization.