ClicData vs. Snowflake

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClicData
Score 8.5 out of 10
N/A
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of data connectors ClicData has connectors that allow users to pull data automatically from hundreds of business applications and databases. Data warehousing and ETL…
$79
per month
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
Pricing
ClicDataSnowflake
Editions & Modules
Premium
$79
per month
Team
$269
per month
Business
$525
per month
Enterprise
Custom Quote
No answers on this topic
Offerings
Pricing Offerings
ClicDataSnowflake
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup Fee$71 data volume, type of data source and level of automationNo setup fee
Additional DetailsAll plans include multiple users licenses but dashboards can be shared with external users via live links, no license needed. Plans and pricing vary based on the data connectors, refreshes, and the level of automation needed. A few hours of Expert Service are including in all plans but more hours can be purchased. A white label option is also available for consultants and agencies.
More Pricing Information
Community Pulse
ClicDataSnowflake
Considered Both Products
ClicData
Chose ClicData
We tried and trialed everything we could before choosing ClicData and there's two main points that ClicData is just absolutely head and shoulders above the rest. Most importantly it's by far the easiest to use. We had working dashboard giving us meaningful data and insight in …
Chose ClicData
We chose ClicData over some other options because it was cost-effective and relatively easy to implement. It didn't require a server to set-up or manage which was nice.
Chose ClicData
ClicData was the most flexible. It is cloud-based and even has WebService access. You can publish your data for access from other applications. The sheer number of data connectors is amazing. The ability to not only create dashboards, but you can schedule them to be delivered …
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.
Features
ClicDataSnowflake
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
ClicData
10.0
Ratings
20% above category average
Snowflake
-
Ratings
Pixel Perfect reports10.00 Ratings00 Ratings
Customizable dashboards10.00 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
ClicData
9.0
Ratings
11% above category average
Snowflake
-
Ratings
Drill-down analysis8.00 Ratings00 Ratings
Formatting capabilities9.00 Ratings00 Ratings
Report sharing and collaboration10.00 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
ClicData
8.5
Ratings
2% above category average
Snowflake
-
Ratings
Publish to Web10.00 Ratings00 Ratings
Publish to PDF9.00 Ratings00 Ratings
Report Versioning7.00 Ratings00 Ratings
Report Delivery Scheduling8.00 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
ClicData
8.5
Ratings
6% above category average
Snowflake
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)10.00 Ratings00 Ratings
Location Analytics / Geographic Visualization7.00 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
ClicData
10.0
Ratings
16% above category average
Snowflake
-
Ratings
Multi-User Support (named login)10.00 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)10.00 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
ClicData
6.0
Ratings
27% below category average
Snowflake
-
Ratings
Responsive Design for Web Access7.00 Ratings00 Ratings
Mobile Application1.00 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile10.00 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
ClicData
10.0
Ratings
25% above category average
Snowflake
-
Ratings
iFrames10.00 Ratings00 Ratings
Themeable User Interface (UI)10.00 Ratings00 Ratings
Best Alternatives
ClicDataSnowflake
Small Businesses
BrightGauge
BrightGauge
Score 9.1 out of 10
Google BigQuery
Google BigQuery
Score 8.5 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
Google BigQuery
Google BigQuery
Score 8.5 out of 10
Enterprises
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
Google BigQuery
Google BigQuery
Score 8.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClicDataSnowflake
Likelihood to Recommend
10.0
(0 ratings)
9.2
(0 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(0 ratings)
Usability
10.0
(0 ratings)
9.3
(0 ratings)
Support Rating
10.0
(0 ratings)
9.9
(0 ratings)
User Testimonials
ClicDataSnowflake
Likelihood to Recommend
If you need to quickly and easily pull data and display it on a dashboard, there's really no better solution out there. We tried the big names like Tableau, Sisense, Microsoft, but they all were really more suited to a dedicated data scientist and had steep learning curves. ClicData allowed just about anyone on my team to start grabbing data and creating dashboards in just minutes, it really is that easy. If you have some very complicated data formulas that you need to use or create it can get a little convoluted...but I'm sure that's similar across the board.
Read full review
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
Pros
  • Ease of use when developing new dashboards.
  • Easy to customize.
Read full review
  • 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
Cons
  • I wish there were even more widgets for the dashboards such as calendar layouts.
  • It would also be nice to be able to query the back-end data using SQL Studio.
  • It would be nice to change data connections from the dashboard to dashboard even though they have the same fields and schema.
Read full review
  • 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
Likelihood to Renew
No answers on this topic
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
Usability
Like I mentioned before, the ease of use means we not only get very quick results and beautiful dashboards in minutes, it means my team is actually using it because they aren't frustrated in the learning curve or wasting time trying to accomplish simple tasks.
Read full review
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
Support Rating
We've only needed support a couple times in the beginning as we were learning the system and how to display our data in interesting ways. Every time we reached out we got very detailed responses and were connected to someone that you could tell was very interested in making sure we were happy with how things were going.
Read full review
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
Alternatives Considered
ClicData was the most flexible. It is cloud-based and even has WebService access. You can publish your data for access from other applications. The sheer number of data connectors is amazing. The ability to not only create dashboards, but you can schedule them to be delivered to specific recipients on a scheduled basis via PDF or a static HTML page.
Read full review
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
Return on Investment
  • ClicData was by far the most reasonable cost-wise, and we were able to get ROI within just minutes of using it.
Read full review
  • 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
ScreenShots

ClicData Screenshots

Screenshot of Screenshot of ClicData's data warehouse where all your company's data is centralized.Screenshot of Some of ClicData's connectors. 250+ data connections are available.Screenshot of Preview of a joint between datasets from two different sources. Do basic or advanced data transformations with ClicData's ETL features.Screenshot of Daily Sales Productivity dashboard exampleScreenshot of Financial KPIs Dashboard example

Snowflake Screenshots

Screenshot of Snowflake Installation