Regarding the data amount limit of Snowflake

Question

・ Maximum number of records per table ・ Maximum capacity limit per table ・ Limitation on the number of tables that can be created with Snowflake Are there any restrictions such as?

Answer 1

There are no limits like that as of now.

For more read here.

Answer 2

I've used Snowflake extensively. In a previous position, we had more than 50 Petabytes of data in Snowflake, spread out over more than 10,000 tables (I don't have the exact number, I just stopped counting at 10,000).

In my current position, we have a single table with more than 100 TB of data - that is the compressed size on Snowflake. We can run text search queries on this table in a matter of seconds.