Snowflake How to Query Servername

Question

Does Snowflake have anything in the information schema (or elsewhere) where I can query the servername of the server I am actively connected to?

I am developing in a BI tool that connects to a Snowflake data warehouse. I am seeing some anomalies in the data. Although my connection properties are supposedly pointing me to one server & database, I am not convinced that is where the data is actually coming from. I'd like to query Snowflake in the BI tool.

I've already checked the INFORMATION_SCHEMA.DATABASES through the BI tool, and the database name is correct. I'd like to also verify the servername as well.

Answer 1

There is nothing in information schema you can find on the actual underlying resources you are connected too. From the documentation:

The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake.

But I doubt that is what is causing the anomaly. In snowflake the data is coming from Cloud Storage. There is a clear seperation of compute & storage. A virtual warehouse in snowflake is essentially a query execution engine. So even if you connect to a different server that should not matter in terms of what the query returns.

See also: https://docs.snowflake.net/manuals/user-guide/intro-key-concepts.html#database-storage.