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?
What is the maximum size of a single snowflake database instance?
1.2k Views Asked by Saurabh At
2
There are 2 best solutions below
0
On
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
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
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.