CODEWITHSUNDEEP
snowflake-cloud-data-platform
Enrique Castilla
Enrique Castilla

Reputation: 51

What are the specifications of a Snowflake server?

When it comes to cluster sizes, the documentation states that, for example an XS cluster consists on 1 server. But I have been looking for the server specifications and I can't seem to find any documentation on this topic.

Upvotes: 5

Views: 8496

Answers (2)

Simeon Pilgrim
Simeon Pilgrim

Reputation: 25903

For AWS snowflake, if you open the browser console in Chrome (F12) and run this SQL in the normal snowflake window:

SELECT 1/0;

you will get an error, the network responce for that message has too much information, but one part states the server EC2 instance type as

  "warehouseServerType" : "c5d.2xlarge",

which was an x-small

Upvotes: 11

Hans Henrik Eriksen
Hans Henrik Eriksen

Reputation: 2850

There are no apparent publicly available specs for the WAREHOUSE building blocks, other that on AWS, the compute nodes are EC2 servers. Most likely an 8-thread CPU, 30-40 GB RAM (higher on Azure), and maybe around 250GB SSD. Something like m5d.2xlarge, but I'm only guessing.

Importantly, those figures stack up when increasing the WAREHOUSE size, making most storage bound queries running faster.

Upvotes: 5

Related Questions