CODEWITHSUNDEEP
cloudsnowflake-cloud-data-platformelasticity
Saurabh
Saurabh

Reputation: 9

What is the maximum size of a single snowflake database instance?

I am trying to understand if snowflake can run peta byte sized database workload and what is the maximum size of a single snowflake database instance?

Upvotes: 0

Views: 2208

Answers (2)

Adrian White
Adrian White

Reputation: 1804

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Warehouse Size Credits / Hour Credits / Second Notes
X-Small 1 0.0003 Default size for warehouses created using CREATE WAREHOUSE.
Small 2 0.0006
Medium 4 0.0011
Large 8 0.0022
X-Large 16 0.0044 Default for warehouses created in the web interface.
2X-Large 32 0.0089
3X-Large 64 0.0178
4X-Large 128 0.0356
5X-Large 256 0.0711 Preview feature.
6X-Large 512 0.1422 Preview feature.

There is also Query Acceleration Service to help with high scans loads.

Storage $46/TB/Month however this is subject to your personal contract with Snowflake which may change.

Upvotes: 0

sprethepa
sprethepa

Reputation: 797

There is no limit set from Snowflake on the Storage.

When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage. Snowflake manages all aspects of how this data is stored — the organization, file size, structure, compression, metadata, statistics, and other aspects of data storage are handled by Snowflake. 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.

Documentation link for the architecture

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html#snowflake-architecture https://docs.snowflake.com/en/user-guide/intro-key-concepts.html#database-storage

You can refer to the below documentation links for the costs associated and storage considerations

https://docs.snowflake.com/en/user-guide/admin-usage-billing.html#understanding-your-cost https://docs.snowflake.com/en/user-guide/cost-overview.html#overview-of-managing-cost https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html#data-storage-considerations

Upvotes: 2

Related Questions