Snowflake vs. ThoughtSpot

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Snowflake
Score 8.9 out of 10
N/A
The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.N/A
ThoughtSpot
Score 8.2 out of 10
N/A
ThoughtSpot is an Agentic Analytics Platform for enterprises where users ask data questions using natural language and get answers with AI. Code-first for data teams and code-free for business users, ThoughtSpot can handle large, complex cloud data at scale.
$50
per month (billed annually) per user (25-1000 users)
Pricing
SnowflakeThoughtSpot
Editions & Modules
No answers on this topic
Thoughtspot Analytics - Pro
$50
per month (billed annually) per user (25-1000 users)
Thoughtspot Analytics - Enterprise
Custom
Offerings
Pricing Offerings
SnowflakeThoughtSpot
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
SnowflakeThoughtSpot
Considered Both Products
Snowflake
Chose Snowflake
Snowflake provides various features, such as integration with Python using Snowpark. The reporting feature that caters to your small reporting needs is Snowsight. The Snowflake data marketplace is where you can get multiple data for free and even some of the data which you can …
Chose Snowflake
These are comparable products that can make sense depending on the specific needs of your organization. All are certainly serviceable and have varying pros and cons. Snowflake seems to provide the greatest degree of flexibility and easy scalability as new data gets brought into …
Chose Snowflake
Snowflake stacks up well against many of the other players in the space. We used Teradata before and it seems to perform better.
Chose Snowflake
We needed scalability and a new way of organizing our data; Snowflake allowed us to have a clearer view of our data warehouses and schemas. Snowflake is also way superior in terms of speed and quick insights from the raw data you query, which is very valuable to us.
Chose Snowflake
Snowflake has an attractive pricing model with auto-suspend and auto-resume and pay per use. AWS Redshift requires higher administrative efforts to maintain and scale the platform whereas with Snowflake those admin tasks are not needed or automatically taken care of.
Chose Snowflake
Cloud -Native architecture, Separation of Storage and Compute provides flexibility, Scalable Compute, Cost and Data Security
Chose Snowflake
We had a MS SQL server with over 2 TB of ram & 51 processors that we were using, that could no longer handle our workload. Snowflake can handle 3 times that workload with ease and efficiency.
Chose Snowflake
Snowflake is much faster and easier to write queries and pull data. But the visualization part of Snowflake is not as good as them. Also, Snowflake only supports SQL queries but not python or other languages. So basically Snowflake is the expert in its field but not suitable …
Chose Snowflake
We particularly liked Snowflake's security model as well as its unique storage (whereby everything is essentially a pointer to immutable micro-partitions, which is the key behind its zero-copy cloning, its secure sharing, its time travel, etc.). and also how it separates …
Chose Snowflake
While Snowflake is more open to cloud eco system, SAP integrated well with SAP eco system products like SAP ECC or SAP S/4. So for people who have invested heavily in SAP eco system including SAP ECC or S/4, it makes sense to go with SAP DWC which is also evolving very rapidly. …
Chose Snowflake
In my opinion, the other tools have similar and some different features; however, when I ran proof of technologies between Synapse and Snowflake. Snowflake did things better or just had functionality that the other tools did not. One that stuck out at the time was scale up …
Chose Snowflake
Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams …
Chose Snowflake
Azure and Snowflake compared very similarly, but Snowflake provided more options to integrate and connect with tools/companies that were not partners. It seemed to be a more flexible environment. The barrier for entry on Oracle and Google we just too complicated. In particular, …
Chose Snowflake
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system …
Chose Snowflake
Snowflake has won the match because it is giving an excellent performance with its efficient features and reliable results. This is a totally secure program for our precious and important data.
Chose Snowflake
Our initial data warehousing solution was Treasure Data. We had issues with the costly pricing model, which would be exhorbitant if we want to hold our data in memory and query using Presto. As a result, some heavy lifting was done in Hive (managed by Treasure Data); …
Chose Snowflake
Snowflake beats these other products in every category it was rated against
Chose Snowflake
In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best …
Chose Snowflake
Redshift compute and storage can be scaled up/down together (though they added some features recently, they don't quite add up). I haven't tried Avalanche or Firebolt but would love to in the near future, due to their pedigree or revolutionary billing methods.
Chose Snowflake
- Cost was the main aspect on the decision.
- Performance was in par or better compared to other tools in the market.
- Snowflake in my opinion stacks better than other tools I have used in the past.
Chose Snowflake
Accommodates future data types such as JSON and XML. Scalability is another advantage. Pay per use is beneficial for organizations like yours. Direct connectors with AWS help us to go with it. No limit on user creation and clone data not eating up extra disk space are a few …
Chose Snowflake
Since we switch from amazon redshift to Snowflake, we found Snowflake is much better than redshift in many ways, including the data integrate and data pull. However, comparing directly pull data from amazon s3, Snowflake is quite slow in terms of data pull speed and the more …
Chose Snowflake
Compared to Amazon Redshift, Snowflake is slightly easier and faster to achieve ROI but based on the user's perspective, the two tools have very little difference since both are leveraging SQL to pull data from AWS S3. Snowflake is also working with Microsoft Azure but it is …
Chose Snowflake
Our issue with Redshift was that it was very expensive. On top of that, queries were still slow and if we used more of Redshift's memory, then it would have cost even more. Snowflake is not cheap, but less costly for us. Plus, the performance was much better. Also, we got to …
Chose Snowflake
Snowflake is a lot faster, feels more lightweight, and is overall easier for our BI team to manage and grant warehouse accesses.
ThoughtSpot
Chose ThoughtSpot
I think PBI was terribly slow and clunky. UI was outdated. Solution was expensive for what we needed. ThoughtSpot was worlds different (in a better way).
Chose ThoughtSpot
They’re for different use cases. When I want a dynamic way to quickly obtain the data I need, I’d go with ThoughtSpot.
Chose ThoughtSpot
It is more flexible and PowerBI, easier work online, and share information with many users. Also the dashboards and beautiful, and the user experience is better. Performance used to be faster.

We use Looker for different use cases but, when it comes to reporting and sharing …
Chose ThoughtSpot
ThoughtSpot's user friendly interface, faster and accurate results, low-code support for building insights and vast availability of native charts, AI powered dashboards helps in faster decision making and helps in driving better business results. The mobile APP that ThoughtSpot …
Chose ThoughtSpot
It is more cost effective when compared to Tableau and more easy to use. ThoughtSpot integrates well with modern cloud data platforms like Snowflake, Google, and Bigquery, making it easy to analyze large datasets in real time. Sync insights into cloud tools. Users can sync …
Chose ThoughtSpot
ThoughtSpot provided a twist on the typical Analytics / report builder interface. The natural language query building is just so much easier to use.
Chose ThoughtSpot
ThoughtSpot is easy to build charts and it is probably the easiest tool to build things quickly. The quality of the charts is middle if not lower pack compared to others. The dbt integration is wildly oversold and does not add any value.
Chose ThoughtSpot
ThoughtSpot can handle large datasets A LOT better.
Chose ThoughtSpot
ThoughtSpot was much easier from an end-user perspective. Looker and Tableau allowed for more customization and detailed dashboards.
Chose ThoughtSpot
Thoughtspot is a fairly new tool when compared to Tableau. I'll just list the benefits of each one of threse below -
Tableau -
1. Much more customizable the Thoughtspot
Chose ThoughtSpot
Have not used as much, tried ThoughtSpot out for the first time for evaluation and testing purposes to see if this type of software would be helpful.
Chose ThoughtSpot
we were looking for something which provides self service capabilities and something which very eay to use from users perspective.
Chose ThoughtSpot
I liked thought spot because of the ad-hoc capabilities and their search functionality.
Chose ThoughtSpot
ThoughtSpot is more powerful of a tool than something like QlikView or QlikSense with the correct training.
Chose ThoughtSpot
ThoughtSpot is my top choice from the above two as the UI is the most modern and user-friendly as well.
Chose ThoughtSpot
ThoughtSpot is the leader in embedded analytics and is much easier to work with massive volumes of data. None of the other tools listed had both of those functionalities, which were most important to us. There are other features that they have such as easier drill down, …
Chose ThoughtSpot
much more extensible and much easier to embed
Chose ThoughtSpot
Compare to Kibana, which was we used previously, ThoughtSpot is definitely better in terms of UI, visualizations, usability, and the SpotIQ/ML components. The only disadvantage for ThoughtSpot is the lack of drill-down function/click-on filters.
Chose ThoughtSpot
The main reason for selecting Thoughtspot was to share reporting with other external vendors and ease of doing business.
Chose ThoughtSpot
We have been using tableau as the enterprise reporting tool and felt sending data to external people had few restrictions hence we tried with ThoughtSpot.
Chose ThoughtSpot
ThoughtSpot can similarly generate tables, visuals, and dashboards in Tableau, but in a faster and easier way.
Chose ThoughtSpot
We liked the support we were getting in the sales process (this has continued to be fantastic), I personally knew several people in the company. In the pilot we ran, our devs enjoyed working with ThoughtSpot.
Chose ThoughtSpot
We have multiple BI Applications that are used based on the needs of the different business users.
Chose ThoughtSpot
We selected ThoughtSpot with the promise that it would evolve into a Google search for business insights. To date, it has not gotten close in my opinion.
Features
SnowflakeThoughtSpot
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
7.6
Ratings
7% below category average
Pixel Perfect reports00 Ratings6.00 Ratings
Customizable dashboards00 Ratings9.00 Ratings
Report Formatting Templates00 Ratings7.70 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
7.7
Ratings
5% below category average
Drill-down analysis00 Ratings9.00 Ratings
Formatting capabilities00 Ratings7.60 Ratings
Integration with R or other statistical packages00 Ratings5.40 Ratings
Report sharing and collaboration00 Ratings8.90 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
8.8
Ratings
6% above category average
Publish to Web00 Ratings8.50 Ratings
Publish to PDF00 Ratings9.40 Ratings
Report Versioning00 Ratings7.90 Ratings
Report Delivery Scheduling00 Ratings9.10 Ratings
Delivery to Remote Servers00 Ratings9.10 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
8.0
Ratings
0% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.70 Ratings
Location Analytics / Geographic Visualization00 Ratings8.80 Ratings
Predictive Analytics00 Ratings8.00 Ratings
Pattern Recognition and Data Mining00 Ratings7.60 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
8.5
Ratings
0% above category average
Multi-User Support (named login)00 Ratings8.60 Ratings
Role-Based Security Model00 Ratings8.60 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.50 Ratings
Report-Level Access Control00 Ratings8.30 Ratings
Single Sign-On (SSO)00 Ratings8.60 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
7.5
Ratings
5% below category average
Responsive Design for Web Access00 Ratings7.10 Ratings
Mobile Application00 Ratings7.20 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Snowflake
-
Ratings
ThoughtSpot
6.5
Ratings
18% below category average
REST API00 Ratings5.10 Ratings
Javascript API00 Ratings4.80 Ratings
iFrames00 Ratings8.30 Ratings
Java API00 Ratings7.00 Ratings
Themeable User Interface (UI)00 Ratings7.00 Ratings
Customizable Platform (Open Source)00 Ratings7.10 Ratings
Best Alternatives
SnowflakeThoughtSpot
Small Businesses
Google BigQuery
Google BigQuery
Score 8.4 out of 10
BrightGauge
BrightGauge
Score 9.1 out of 10
Medium-sized Companies
Google BigQuery
Google BigQuery
Score 8.4 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Google BigQuery
Google BigQuery
Score 8.4 out of 10
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
SnowflakeThoughtSpot
Likelihood to Recommend
9.2
(0 ratings)
8.4
(0 ratings)
Likelihood to Renew
10.0
(0 ratings)
10.0
(0 ratings)
Usability
9.3
(0 ratings)
8.6
(0 ratings)
Availability
-
(0 ratings)
9.0
(0 ratings)
Performance
-
(0 ratings)
8.0
(0 ratings)
Support Rating
9.9
(0 ratings)
8.0
(0 ratings)
In-Person Training
-
(0 ratings)
5.0
(0 ratings)
Online Training
-
(0 ratings)
4.0
(0 ratings)
Implementation Rating
-
(0 ratings)
7.0
(0 ratings)
Configurability
-
(0 ratings)
8.0
(0 ratings)
Ease of integration
-
(0 ratings)
9.0
(0 ratings)
Product Scalability
-
(0 ratings)
8.0
(0 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(0 ratings)
Vendor pre-sale
-
(0 ratings)
9.0
(0 ratings)
User Testimonials
SnowflakeThoughtSpot
Likelihood to Recommend
If you need a quick query, snowflake is the way to go. It's super simple and scalable; we were struggling before with Azure, and with Snowflake, everything runs smoothly, and we have more control over our schemas and warehouses. Snowflake, in my opinion, is the next step when you want to scale your business and manage data. If your company is still small, there may be cheaper options.
Read full review
By using the power of cloud platforms like bigquery or snowflake, ThoughtSpot can deliver performance at scale ensuring that even the largest organization can quickly analyze and visualize data. The ability to seamlessly share live dashboards fosters collaborations, ensuring everyone in the organization is working from the same data source and aligned in decision making.
Read full review
Pros
  • Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
  • Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
  • Snowflake manages concurrency better in our trials than other premium competitors
  • Snowflake has little to no setup and ramp up time
  • Snowflake offers online training for various employee types
Read full review
  • Beautiful visualizations. The visuals are distinct, clean, and easy to discern from one another.
  • Intelligent querying functionality. When looking to manipulate the data, the search function makes it easy to manipulate the features in the data, along with aggregating them in the way you'd like.
  • Embedding! It has been a smooth process thus far for our product & technical teams to work with ThoughtSpot and bring it into our product.
Read full review
Cons
  • Add constraints for views and not just for tables
  • Do not force customers to renew for same or higher amount to avoid loosing unused credits. Already paid credits should not expire (at least within a reasonable time frame), independent of renewal deal size.
Read full review
  • It would be great if ThoughtSpot can add the feature to filter by clicking on visualizations. i.e if I click on a particular data point in the chart if the full dashboard can filter just for that particular data point.
  • Color coding the heatmap with different colors like green to orange to red.
Read full review
Likelihood to Renew
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Read full review
We have had success with the initial use cases and there are more use cases that can receive return on investment. I don't give it a 10 because other products like Tableau are building functionality that may start to compete in the coming years.
Read full review
Usability
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Read full review
The tool is easy to use if you know what you are doing and looking for. I know as they work towards improvements and simple language it will become even easier, but as of now they are doing a great job but there is room for improvement.
Read full review
Reliability and Availability
No answers on this topic
it's available unless there is a server or system update etc. sometimes the timing of this is bad (for example during a month end close)
Read full review
Performance
No answers on this topic
It does what it is supposed to. Would be nice to have a bit more insights
Read full review
Support Rating
We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.
Read full review
I give it this meeting because the team is not only help able to help us in the current solutions but also amazing and taking feedback and feeding it back to their development team which includes more products and features into ThoughtSpot
Read full review
In-Person Training
No answers on this topic
inhouse in-person training. Took a bit to long to get the basics.
Read full review
Online Training
No answers on this topic
poor instructions
Read full review
Implementation Rating
No answers on this topic
Understand use case and model and design accordingly
Read full review
Alternatives Considered
Snowflake provides various features, such as integration with Python using Snowpark. The reporting feature that caters to your small reporting needs is Snowsight. The Snowflake data marketplace is where you can get multiple data for free and even some of the data which you can buy according to your needs. And the integration options with various tools like Sigma are add-ons.
Read full review
It is more flexible and PowerBI, easier work online, and share information with many users. Also the dashboards and beautiful, and the user experience is better. Performance used to be faster. We use Looker for different use cases but, when it comes to reporting and sharing information, ThoughSpot is much better.
Read full review
Scalability
No answers on this topic
Because it is very reliable, inside the situation, we need strong internet connection to access a lot of data but easily never had any downtime except during the upgrades
Read full review
Return on Investment
  • With separate compute and storage feature, the queries get executed quickly and it improves our overall productivity.
  • Earlier we were using a different product for analytical purposes, but with Snowflake's in-built analytical feature we are now able to save money.
  • Snowflake is cost efficient, features like auto suspend for compute resources helped to control the costs.
Read full review
  • Time to market ROI is massive vs hiring the full-time dedicated team to build and maintain a frontend multi-tenant SaaS data viz product.
  • It will be interesting to see over time how the advanced features play out in terms of usability and end value, such as Natural Search, which we are very excited about, and the machine learning tools.
Read full review
ScreenShots

Snowflake Screenshots

Screenshot of Snowflake Installation

ThoughtSpot Screenshots

Screenshot of the ThoughtSpot home screenScreenshot of SpotIQ, which offers AI-driven insightsScreenshot of the Spotter AI agent that surfaces insights through natural language queriesScreenshot of AI Assist producing SQL in real timeScreenshot of SpotIQ, which offers AI-driven insightsScreenshot of the integration with dbt models and metrics