Snowflake Scalability

SR
Director -Data Architecture and Engineering at Decision Minds

Its scalability is really good. You can scale in both ways. You can actually scale up and down or scale out. Scaling up and down is done where we have an extra small warehouse, and we are moving to small, medium, large, or something like that. If you have a query that is running slow or a lot of data you are dealing with is slow, you can scale up. If you want to scale down from large to small, you can do that. 

If you want to get concurrency, scale-out architecture is available. I can actually do a cluster-based architecture where I can have two clusters, three clusters, or something like that. This way the concurrency can be improved.

In terms of the number of users, we have around 200 users.

View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant

The solution is quite scalable both horizontally and vertically. It's an easy job. We just need to resize it. 

Within our module, there are around eight to ten people who are working on Snowflake. In a full project, if I'm looking at the holistic picture, there are around 30 to 40 people who are using Snowflake.

View full review »
Erik Jones - PeerSpot reviewer
Head of BI and Analytics at HyperScience

Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it. We have five direct users and then, because Snowflake powers all the dashboards, 250 indirect users.

We plan to increase our Snowflake usage in the future. As we send more data through it and build out more sophisticated dashboards and reporting and especially statistical modeling, we will increase our usage.

View full review »
Buyer's Guide
Snowflake
April 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,789 professionals have used our research since 2012.
Rahul Saxena - PeerSpot reviewer
Manager - Business Technology Solutions at a consultancy with 1,001-5,000 employees

We have at least 1000 users in our organization. We will surely use the product in the future.

View full review »
Sreenivasan Ramanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Restoration Hardware

It is good at scaling. You can scale it horizontally or scale vertically. That's a big plus. Scaling easily is a big thing.

View full review »
Luis Miguel Goez - PeerSpot reviewer
Senior Manager Information Technology Infrastructure at SURA

The scalability is good. There are around 35 people in the company using Snowflake and six engineers dealing with maintenance. 

View full review »
TB
director of business operations at a logistics company with 51-200 employees

It's definitely scalable. We're on a very small usage compared to some of the other clients I know Snowflake has, so it's definitely scalable because we have tons of room to grow for our use.

Including myself, we currently have five users and they're data analysts.

View full review »
PG
BI Consultant at a tech consulting company with 201-500 employees

We have 250 or more users on the solution currently. They are predominantly IT specialists, including engineers and developers. It's for those on the application side of development. The solution is scalable. I'd rate the scalability nine out of ten.

View full review »
Ankit  Shukla - PeerSpot reviewer
Data Engineer at YASH Technologies

I would rate the scalability of this solution a 10, on a scale from one to 10, with one being the worst and 10 being the best. There are around five developers in our company and 500 end users for this solution.

View full review »
Anthony Fiorino - PeerSpot reviewer
SVP, Head of Enterprise Data Mgmt & Data Intelligence at a financial services firm with 5,001-10,000 employees

The power of Snowflake is that it scales automatically and indefinitely. We have around 500 internal users using the solution daily, and most of our applications use the product in some shape or form, so that's a few hundred thousand external users.

View full review »
OP
Cloud Data Engineer at Expo Design Center

If we need to scale up, it will impact our costs. I work in a consulting company. We have a department dedicated to Snowflake. We have seven to eight people on our team. Our clients were medium-sized businesses with 1000 employees. They are focused on data analytics solutions. They also have departments for Azure and AWS. I rate the tool’s scalability a seven or eight out of ten.

View full review »
HB
Senior Consultant at a consultancy with 10,001+ employees

It is scalable. The warehouses or auto-scaling features in the warehouses are great. You can go from small to medium to large all the way up to extra large, and there are different auto-scaling tasks that can happen. You can turn it on and turn it off based on the usage or auto-turn it on and turn it off. That's a pretty nice feature to have and we find it both sustainable and scalable for sure.

I work for clients, so last time when I worked for a client, there was a group of 100 people who were actually signed up to use Snowflake. 

View full review »
Stephen Ebrey - PeerSpot reviewer
Data Consultant at Omaze

This is a scalable solution. 

View full review »
BH
Manager IT BRM/FRM at a manufacturing company with 10,001+ employees

We have high confidence in its scalability. In terms of its users, for our solution, we only have a team of 10, but we have plans to increase its usage.

View full review »
Chris Hastie - PeerSpot reviewer
Data Lead at InterWorks

It is a highly scalable solution. There is no limit on storage or computing. They have everything on consumption-based pricing, but you can have what's known as a multi-cluster warehouse. So, warehouses are what you use for the compute.

The multi-cluster warehouses will sit there originally as a single cluster. But then, if there are enough concurrent queries taking place in that warehouse, it can, as it needs, just spin up another one from another one and another one to meet those current needs. And as soon as they can dive down again, it can switch those clusters off again one by one. And you can create as many clusters, warehouses, as many as you need. There is no scaling issue at all. I've seen it most, like, 10,000 queries a second, and it's run very, very smoothly.

View full review »
KR
Senior Software Engineer at a consultancy with 10,001+ employees

My impression is that this is a scalable solution. There are around 200 users of this solution at our company, including three administrators.

View full review »
DA
Vice President, Data Architecture and Management at a financial services firm with 10,001+ employees

Its scalability is high. I'd rate it an eight out of ten in terms of scalability.

At this time, we have no plans to increase its usage.

View full review »
MF
IT Consultant at Independent Consultant

I give the scalability an eight out of ten.

View full review »
MA
Owner at a consultancy with 1-10 employees
VipinGupta - PeerSpot reviewer
Sr Manager at Publicis Sapient

The scalability is very good and we have around two hundred data sets currently operating.

View full review »
Iqbal Hossain Raju - PeerSpot reviewer
Junior Software Engineer at a healthcare company with 10,001+ employees

We did not need to scale our Snowflake environment beyond what we needed. We have a fixed amount of traffic from a fixed number of clients. We know the load we need to handle, and based on that, our subscription is made.

View full review »
DT
Data Engineer at Natwest

I rate the solution's scalability as a nine.

View full review »
NP
DBA Individual Contributor at Aristeia Capital

We have approximately 10 people in the organization who are using Snowflake.

View full review »
Sushrit Moundekar - PeerSpot reviewer
Program Manager at InfoCepts

Around 400 users are using the solution in our organization.

View full review »
AB
Architect at a tech vendor with 10,001+ employees

I have gone to the extremes from a scalability perspective and I give Snowflake's scalability an eight out of ten.

View full review »
Vinoth Raj Prabhakaran - PeerSpot reviewer
Senior Data Architect at Tata Consultancy Services

The scalability of Snowflake is very good.

I have approximately six customers using this solution but in addition, I am directing more.

View full review »
YM
BI & BIG DATA Director at Malam-Team

It has very good scalability. Your data can grow in the platform. We have at least 50 users of this solution in an organization.

View full review »
Hussain Modu - PeerSpot reviewer
Technical Lead at Wipro Limited

The scalability is good. It handles a lot of data, and the processing speed is very high.

View full review »
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

Snowflake is a cloud solution that provides great scalability. However, I am not sure if it is cost-effective.

We have approximately 30 engineers using this solution. We have plans to scale our usage in the future. This is going to be a futuristic solution.

View full review »
Sanjay Bheemasenarao - PeerSpot reviewer
Director - Data Engineering expert at Sankir Technologies

It is scalable.

View full review »
Biraja Mishra - PeerSpot reviewer
Senior Principal Consultant at Genpact - Headstrong

It is scalable. As of now, there are 500 users, but slowly, we are planning to roll out to multiple regions. It is currently in Europe, and we will be rolling it out to the APAC and USA regions. By the year-end, there will be more than 1,000 users.

View full review »
Antonio Gouveia - PeerSpot reviewer
Business Intelligence Analyst at Clarivate Analytics

This is a scalable solution. 

View full review »
it_user1251369 - PeerSpot reviewer
Principal IT Technologist- BI Platform Architect at Medtronic

This is a scalable solution. 

View full review »
MM
Manager at SSM VIT Global Solutions

The most valuable aspect of Snowflake is its scalability. The volume of data, which I have seen across almost in terms of five terabytes and other terabytes of data, I didn't see issues.

View full review »
VP
Solution Architect at a wholesaler/distributor with 10,001+ employees

We can scale up or down based on our needs. We don't have tons and tons of data, but based on the quality feedback from our vendors, it can handle large volumes and has the competency. With the dynamic scale-up feature, we are confident that it is going to meet all our requirements.

Currently, our number of users is very limited because we have just started the migration. We don't have many users on the platform. All of our focus is on Snowflake because we're moving to Snowflake, and its usage will increase in the future.

View full review »
DominicMackenzie - PeerSpot reviewer
Senior data architect at a financial services firm with 51-200 employees

I've never had any issues with it. It is being extensively used. We have between a hundred and a thousand users using Snowflake.

View full review »
AS
Associate Data Engineer at a outsourcing company with 201-500 employees

The product is scalable. You can scale the solution’s computation and storage features separately.

View full review »
AN
Senior Data Engineer at a financial services firm with 10,001+ employees

It's an infinitely scalable system, but if you use terabytes or petabytes of data, then you need to tune the levels. Each day, we get four to five gigs and overall, our data warehouse has 100 gigs plus, it's huge data. 

View full review »
it_user1251369 - PeerSpot reviewer
Principal IT Technologist- BI Platform Architect at Medtronic

Scalability is very good and very simple.

Within the company, we currently have a total of fewer than 50 people using the product. Their general roles vary from data analyst to data scientist, to IT professionals, and maybe one or two of the upper managers.

View full review »
Sunny Kumar - PeerSpot reviewer
Specialist Programmer at Infosys

Snowflake is a scalable solution.

We have approximately 200 to 300 people using the solution.

View full review »
SM
CEO at a computer software company with 51-200 employees

Snowflake is scalable. It does cost more money, but it's some kind of magic they're doing behind the scenes that you don't have to think about. It's brilliant, and it's going to take over completely.

View full review »
VK
General Manager at itcinfotech

We're working in 32 countries with enterprise size customers. We're still waiting to see what happens with that level of scalability and how the solution performs. If this product can be further fine-tuned or optimized in such a way that it becomes a very good fit for the Azure platform, that would be great. 

View full review »
ST
Principal Director at a tech vendor with 10,001+ employees

I give the scalability an eight out of ten.

View full review »
NA
Marketing Communications Manager at a financial services firm with 1,001-5,000 employees

I give the scalability an eight out of ten.

View full review »
Adnan Shafiq - PeerSpot reviewer
Associate Vice President - Database Management (Principal Solutions Architect) at Northbay

We have two clients using this solution.

The solution is highly scalable.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.

We have about 100 people on the product currently.

View full review »
CP
Founder & CIO at a computer software company with 11-50 employees

The product scales quite well. If a company needs to expand it, it can do so without any problem.

We deal mostly with clients that have medium to large-scale organizations. It works well for both.

View full review »
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees

The product is scalable enough.

View full review »
ES
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees

We scaled it a little bit. We didn't have a lot of data to scale, as a lot of companies do. We only had a couple of terabytes of data, which is insignificant for a cloud platform. 

The development team had three or four people getting data in. Then report people were also using the platform, but they didn't really have to know that it was Snowflake because they were going at it through a reporting tool. There were probably 30 or 40 people writing queries against our reporting tools, which were, in turn, using Snowflake.

View full review »
DR
Sr. Software Developer at Tech Mahindra Limited

Snowflake does not require manual scaling because it does it for you. Developers just need to load the data and process the query. That's it. The developer's job is not to spend time improving performance, as it was with an on-premises solution. We had to do the partitioning, collect the stats, and everything else. In the case of this cloud-based solution, it doesn't require as much work. Instead, we can focus on the queries.

We are planning to increase our usage of Snowflake.

View full review »
JH
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees

The number of people at our company currently using the solution depends on what we are trying to accomplish. We have four developers in Snowflake and then we also have users who are leaving data with us for our further analysis. That may be around ten other users.

With the growing data set we have and the increase in the size of our business, we will increase the use of Snowflake, but not with respect to the number of users. We are a small company and all the users who need to use it are already using it. We have more data that we need to load and which we want to integrate before we will make more usage of Snowflake.

View full review »
VG
Architect at Sony Corporation of America

As long as you don't need to worry about storage or cost, this solution would be one of the best ones on the market for scalability purposes. We've migrated about 400-450 dealers onto the solution so far. We do intend to expand usage so there will be more users and more data. The drawbacks we've had with on-premises was space being a constraint and the user code having limitations.

View full review »
Varun Garg - PeerSpot reviewer
Senior Vice President at Polestar Solutions & Services India Pvt Ltd

The one thing that seems to be unclear for Snowflake customers is the cluster sizing. No one seems ot know how to compute that.

For example, if I'm running a warehouse that is extra small, as per my query performance, if I see like if this query will run perfectly on the machine I will have. However, I don't know which machine to go for. There's no direct comparison between an extra small, or a small, or a medium warehouse. I never get to know, unless I run the case query on different sizes, which to go for. It's hard to say "Buy only this and go for that particular size". Sizing seems to be a bit of trial and error. If they had some sort of benchmarking around their cluster size, that would be helpful.

View full review »
YM
Lead Data Engineer at a consultancy with 51-200 employees

It's a scalable solution, we have unlimited storage in Snowflake.

View full review »
AK
Senior Snowflake Data Architect @ COOP Financials NC at a tech services company with 1,001-5,000 employees

The scalability is built into this solution as being on the cloud. It is able to scale in all directions. Additionally, they have a multi-cluster warehouse, and based on the business use case it is very good.

There are approximately 4,000 portals. However, we do not know how many users our clients have that are using their portals.

We are building new data warehouses and we are migrating from SQL Server to Snowflake.

View full review »
SS
Senior Software Engineer at a financial services firm with 1,001-5,000 employees

The solution is definitely scalable. We're able to add nodes to grow it out when we need to. If an organization needs to expand the solution, they can do so easily. We find it to be very reliable.

There are about 300 people using the solution at this time. We don't plan on increasing usage at this time.

View full review »
RK
Solutions Architect at a recruiting/HR firm with 1-10 employees

The solution is highly scalable. 

View full review »
ST
Solutions Architect-AI & ML at a tech services company with 10,001+ employees

My impression is that this product is pretty scalable.

View full review »
TT
Soullution Architech at a tech services company with 51-200 employees

We have 20-30 solution users in our organization.

View full review »
RV
Director - Data Analytics at Sunera Technologies

A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.

View full review »
JC
General Manager of Data Science at a non-profit with 501-1,000 employees

It is very simple to scale up and down depending on the project or situation, which is an advantage.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

It is scalable. We have four users who are using Snowflake. 

View full review »
Rahul-Sahay - PeerSpot reviewer
Senior Solutions Architect at kipi.bi

I give the scalability a nine out of ten.

View full review »
SM
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees

It is scalable.

View full review »
DE
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees

Snowflake is quite scalable. We have four people who are using it.

View full review »
YR
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees

If you go with one cloud provider, you can't switch.

We have very few users. There is just a very limited number who are mostly developers. We did not roll out the end product. We did not roll out product and services based on that foundation/infrastructure yet.

View full review »
MR
Senior Information Management Architect at Raken

Snowflake is very scalable. Our client companies where we implement Snowflake are medium to large sized. These companies have offices in different parts of the world, not just some regions, but companies with office users in different parts of the world. We are dealing with international companies. Their tendency is to increase the use of the Snowflake platform. It would serve all the analytical needs in these companies.

View full review »
MA
Senior Solutions Architect at NessPRO Italy

If there is a need for scaling the setup is not so good. 

View full review »
Padmanesh NC - PeerSpot reviewer
Big Data Solution Architect - Spatial Data Specialist at SCIERA, INC
AS
Enterprise architect at a computer software company with 201-500 employees

I have found the solution to be scalable. We have a few employees working on this solution in my organization.

View full review »
FG
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees

Its scalability is great. We have data processing of one terabyte per month.

View full review »
VY
Chief Data Architect - Europe at a computer software company with 10,001+ employees

It is scalable.

View full review »
AB
Technology & Innovation at a consultancy with 201-500 employees

This is definitely a scalable solution.

View full review »
WM
Principal Consultant at a tech services company with 51-200 employees

The scalability is incredible. It's the best I've ever seen. Organizations can scale easily. I can scale up four times faster as well. Something that usually takes 60 minutes can be done in 15 or 20 minutes. It's faster and I save costs because I only pay for the time. Even though I'm paying "more" I end up saving money with this time based costing.

View full review »
DK
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees

We have not tested scalability, but the solution claims that it's scalable. It's on the cloud, so I imagine you could scale rather easily if you needed to. 

They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises. 

We have about 40 people using the solution. They're mostly business users.

View full review »
MH
Data & Analytics Practitioner (BIDW, Big Data) at a computer software company with 10,001+ employees

Snowflake scales well. If a company needs to expand, it can do so.

View full review »
OA
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees

It is very scalable. We currently have more than 50 users. We can increase its usage.

View full review »
MS
ML Lead at a tech services company with 201-500 employees

It is scalable. There are no problems with the scalability of this solution. There were 50 or 60 users using it at the same time.

View full review »
it_user865563 - PeerSpot reviewer
Data Engineer at Celebal Technologies

It's very easy to scale because Azure cloud's own data warehouse gives us that capabilities to scale up or down at any time we want. There are a great number of users on the solution, but it differs from client to client. One client, for example, has about 30,000 users.

View full review »
SS
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees

We haven't heard of clients having issues with scalability. It can expand well. A company that needs to grow it out can do so without any trouble.

View full review »
it_user1174809 - PeerSpot reviewer
Business Intelligence Consultant at a tech services company with 201-500 employees

With a different cloud that warehouses are the standard for now but the scalability is pretty straightforward.

View full review »
Buyer's Guide
Snowflake
April 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,789 professionals have used our research since 2012.