Introducing G2.ai, the future of software buying.Try now
Compare Pentaho Data Integration and Snowflake 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
At a Glance
Market Segments
Mid-Market (41.2% of reviews)
Enterprise (44.8% of reviews)
Entry-Level Pricing
No pricing available
$2 Compute/Hour
Pentaho Data Integration
Star Rating
(17)4.3 out of 5
Market Segments
Mid-Market (41.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Pentaho Data IntegrationSnowflake
Star Rating
(665)4.6 out of 5
Market Segments
Enterprise (44.8% of reviews)
Pros & Cons
Entry-Level Pricing
$2 Compute/Hour
Free Trial is available
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Snowflake excels in its Query Language with a score of 9.3, making complex queries easier to handle compared to Pentaho Data Integration, which scored 8.6 in this area. Reviewers mention that Snowflake's SQL capabilities are robust and user-friendly.
- Reviewers mention that Snowflake's Data Replication feature is highly rated at 9.0, allowing for seamless data synchronization across different environments. In contrast, Pentaho Data Integration, while functional, received a lower score of 8.9, indicating it may not be as efficient in this regard.
- Users on G2 highlight Snowflake's superior Performance Analysis capabilities, scoring 8.9, which allows for better insights into data operations. Pentaho Data Integration, with a score of 8.6, is seen as less effective in providing detailed performance metrics.
- Reviewers say that Snowflake's Cloud Deployment is rated at 9.2, showcasing its strong cloud capabilities, while Pentaho Data Integration's on-premise deployment scored only 7.5, indicating a potential limitation for users preferring cloud solutions.
- G2 users report that Snowflake's Data Security features, including Data Encryption and User Access Control, are rated highly at 9.2 and 9.1 respectively, providing peace of mind for enterprises. Pentaho Data Integration, while secure, scored slightly lower in these areas, with users mentioning concerns about its overall security framework.
- Users say that Snowflake's Scalability is a standout feature, rated at 9.2, allowing businesses to grow without performance issues. In comparison, Pentaho Data Integration's scalability received a lower score, which users report can lead to challenges as data needs expand.
Pricing
Entry-Level Pricing
Pentaho Data Integration
No pricing availableSnowflake
Standard
$2
Compute/Hour
Compute usage is billed on a per-second basis, with a minimum of 60 seconds. You can secure price discounts with pre-purchased Snowflake capacity options.
- Complete SQL Data Warehouse
- Secure Data Sharing across regions / clouds
- Premier Support 24 x 365
Free Trial
Pentaho Data Integration
No trial information availableSnowflake
Free Trial is available
Ratings
Meets Requirements
8.7
15
9.1
503
Ease of Use
8.6
15
9.0
539
Ease of Setup
8.0
9
8.9
324
Ease of Admin
8.6
7
8.6
203
Quality of Support
7.2
12
8.7
460
Has the product been a good partner in doing business?
8.6
6
9.0
204
Product Direction (% positive)
9.2
14
9.2
473
Features by Category
Management
8.7
5
Not enough data
9.0
5
Not enough data
Functionality
9.7
5
Not enough data
9.7
5
Not enough data
9.3
5
Not enough data
8.3
5
Not enough data
8.7
5
Not enough data
Deployment
Not enough data
9.2
12
Not enough data
8.9
12
Not enough data
9.0
12
Not enough data
9.3
12
Not enough data
9.3
12
Deployment
Not enough data
9.3
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.5
10
Not enough data
9.3
10
Management
Not enough data
9.2
12
Not enough data
9.0
12
Not enough data
9.2
12
Not enough data
9.0
12
Operations
Not enough data
8.8
10
Not enough data
8.8
10
Not enough data
9.5
10
Management
Not enough data
9.2
10
Not enough data
9.3
9
Not enough data
9.0
10
Generative AI
Not enough data
8.7
10
Not enough data
8.3
10
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Agentic AI - Cloud Migration
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
System
Not enough data
9.2
28
Model Development
Not enough data
9.1
27
Not enough data
8.5
27
Not enough data
8.3
27
Not enough data
8.7
27
Model Development
Not enough data
8.7
27
Machine/Deep Learning Services
Not enough data
8.6
27
Not enough data
8.6
27
Not enough data
8.4
27
Not enough data
8.4
26
Machine/Deep Learning Services
Not enough data
8.5
27
Not enough data
8.5
24
Deployment
Not enough data
9.1
29
Not enough data
9.0
27
Not enough data
9.3
27
Generative AI
Not enough data
8.4
25
Not enough data
8.3
25
Not enough data
8.5
25
Agentic AI - Data Science and Machine Learning Platforms
Not enough data
8.2
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.5
13
Not enough data
8.2
13
Not enough data
8.3
13
Not enough data
8.2
12
Data Management
Not enough data
9.0
182
|
Verified
Not enough data
8.9
167
|
Verified
Not enough data
9.0
174
|
Verified
Not enough data
8.3
169
|
Verified
Not enough data
8.2
150
|
Verified
Not enough data
8.7
153
|
Verified
Integration
Not enough data
8.2
140
|
Verified
Not enough data
8.9
168
|
Verified
Not enough data
8.8
159
|
Verified
Deployment
Not enough data
7.8
140
|
Verified
Not enough data
9.2
174
|
Verified
Performance
Not enough data
9.2
178
|
Verified
Security
Not enough data
8.9
165
|
Verified
Not enough data
9.1
176
|
Verified
Generative AI
Not enough data
8.0
79
Not enough data
8.1
80
Management
Not enough data
8.9
83
Not enough data
9.2
83
Not enough data
9.5
88
Not enough data
9.0
86
Not enough data
9.1
87
Maintenance
Not enough data
9.3
85
Not enough data
9.0
84
Not enough data
9.3
85
Security
Not enough data
9.2
85
Not enough data
9.2
88
Storage
Not enough data
9.2
44
Not enough data
9.2
44
Availability
Not enough data
9.1
39
Not enough data
9.2
37
Not enough data
9.2
41
Performance
Not enough data
9.2
44
Security
Not enough data
9.1
44
Not enough data
9.2
45
Not enough data
8.9
38
Not enough data
9.2
38
Support
Not enough data
9.2
36
Not enough data
9.1
35
Centralized computation
Not enough data
9.3
25
Localized computation
Not enough data
9.0
24
Database
Not enough data
8.9
98
Not enough data
9.3
101
Not enough data
9.3
95
Integrations
Not enough data
8.6
76
Not enough data
8.7
81
Platform
Not enough data
9.1
91
Not enough data
9.0
97
Not enough data
8.7
81
Processing
Not enough data
9.3
96
Not enough data
9.1
94
Data Transformation
Not enough data
9.2
86
Not enough data
9.4
86
Connectivity
Not enough data
8.5
78
Not enough data
8.7
79
Not enough data
9.1
80
Not enough data
9.1
81
Operations
Not enough data
8.6
83
Not enough data
9.2
79
Not enough data
8.9
75
Not enough data
8.8
80
Not enough data
8.7
77
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Pentaho Data Integration and Snowflake are categorized as Big Data Integration Platforms and Big Data Processing and Distribution
Unique Categories
Pentaho Data Integration is categorized as Cloud Migration, ETL Tools, On-Premise Data Integration, and Data Mapping
Snowflake is categorized as Data Clean Room, Columnar Databases, MLOps Platforms, Big Data Analytics, Database Management Systems (DBMS), Data Warehouse, and Data Science and Machine Learning Platforms
Reviews
Reviewers' Company Size
Pentaho Data Integration
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Snowflake
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.3%
Telecommunications
11.8%
Banking
11.8%
Internet
5.9%
Information Services
5.9%
Other
29.4%
Information Technology and Services
14.3%
Computer Software
12.9%
Financial Services
10.4%
Marketing and Advertising
4.7%
Hospital & Health Care
3.7%
Other
53.9%
Alternatives
Discussions
Pentaho Data Integration has no discussions with answers
What's the best way to manage change data capture in Snowflake?
4 Comments
VT
Please go through this link: https://docs.snowflake.com/en/user-guide/streams
You might get a pertinent response from it.
Please click on this link...Read more
which is best snowflake or My sql
2 Comments
LH
Depends on your needs. MySQL is open source/free. It or Postgres (another open source db) is good for pretty much any normal need. You can install on...Read more
Snowflake - how to connect to Snowflake using NodeJS
2 Comments
DW
Does this help? https://www.ameexusa.com/blogs/connecting-node-js-snowflakeRead more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
