Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and dbt 
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.
Astro by Astronomer
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.
QuerySurge
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.
Starburst
Visit Website
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Mid-Market (58.5% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
No pricing available
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansdbt
Star Rating
(191)4.7 out of 5
Market Segments
Mid-Market (58.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Free Trial is available
Learn more about dbtSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Amazon Redshift excels in data integration with a score of 8.8, allowing seamless connections to various data sources, while dbt shines in self-service data management with a score of 9.1, enabling users to easily manage their data workflows.
- Reviewers mention that Amazon Redshift's data compression feature scores 8.4, which helps in optimizing storage costs, whereas dbt's automated workflows receive a high score of 9.5, making it easier for users to automate repetitive tasks.
- G2 users highlight that Amazon Redshift's API connectivity is rated at 8.5, providing robust integration capabilities, while dbt's data transformation capabilities are rated at 9.4, allowing users to efficiently transform data for analysis.
- Users on G2 report that Amazon Redshift has a cloud deployment score of 8.9, indicating strong cloud capabilities, while dbt's cloud migration capabilities are rated even higher at 9.2, making it easier for users to transition to cloud environments.
- Reviewers mention that Amazon Redshift's quality of support is rated at 8.5, which is solid, but dbt outperforms with a score of 8.9, indicating a more responsive support system for users.
- Users say that Amazon Redshift's performance scalability is rated at 9.2, making it suitable for large enterprises, while dbt's data modeling capabilities score 9.1, providing users with powerful tools for structuring their data effectively.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
dbt
No pricing availableFree Trial
Amazon Redshift
Free Trial is available
dbt
Free Trial is available
Ratings
Meets Requirements
8.7
281
9.2
139
Ease of Use
8.7
281
9.0
141
Ease of Setup
8.6
138
8.6
80
Ease of Admin
8.4
128
8.5
58
Quality of Support
8.5
264
8.9
112
Has the product been a good partner in doing business?
8.7
127
8.8
52
Product Direction (% positive)
8.8
252
9.7
126
Features by Category
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
Not enough data
Not enough data
Self Service
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
Advanced Analytics
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
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
Data Source Access
Not enough data
8.8
48
Not enough data
9.2
50
Not enough data
8.6
41
Data Interaction
Not enough data
8.3
41
Not enough data
8.5
44
Not enough data
9.1
49
Not enough data
9.1
47
Not enough data
9.1
42
Not enough data
9.4
48
Not enough data
8.6
44
Not enough data
8.6
44
Data Exporting
Not enough data
8.5
42
Not enough data
8.6
43
Not enough data
9.1
45
Generative AI
Not enough data
6.5
27
Management
Not enough data
Feature Not Available
Not enough data
8.2
36
Functionality
Not enough data
Feature Not Available
Not enough data
9.2
41
Not enough data
Feature Not Available
Not enough data
9.4
38
Not enough data
9.2
36
Data Management
8.8
133
|
Verified
Not enough data
8.4
125
|
Verified
Not enough data
8.8
131
|
Verified
Not enough data
8.0
127
|
Verified
Not enough data
7.6
102
|
Verified
Not enough data
8.3
118
|
Verified
Not enough data
Integration
7.9
101
|
Verified
Not enough data
8.7
128
|
Verified
Not enough data
8.6
119
|
Verified
Not enough data
Deployment
8.1
102
Not enough data
8.9
130
|
Verified
Not enough data
Performance
8.9
134
|
Verified
Not enough data
Security
8.7
126
|
Verified
Not enough data
8.8
128
|
Verified
Not enough data
Generative AI
7.3
20
Not enough data
7.2
19
Not enough data
Storage
8.4
53
Not enough data
8.4
56
Not enough data
Availability
8.6
47
Not enough data
8.2
50
Not enough data
8.4
48
Not enough data
Performance
8.2
48
Not enough data
Security
8.7
47
Not enough data
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
Not enough data
Support
7.9
43
Not enough data
8.5
47
Not enough data
Data Management
Not enough data
9.2
49
Not enough data
9.1
51
Not enough data
9.1
49
Not enough data
9.3
50
Agentic AI - DataOps Platforms
Not enough data
7.6
9
Not enough data
7.7
8
Not enough data
8.3
10
Not enough data
8.0
9
Not enough data
8.5
9
Analytics
Not enough data
8.7
47
Not enough data
7.3
35
Monitoring and Management
Not enough data
8.7
43
Not enough data
8.9
50
Cloud Deployment
Not enough data
8.7
37
Not enough data
8.8
30
Generative AI
Not enough data
5.9
13
Not enough data
6.3
13
Automation
Not enough data
8.8
34
Not enough data
8.3
32
Not enough data
8.6
35
Not enough data
Feature Not Available
Functionality
Not enough data
8.6
34
Not enough data
8.6
33
Not enough data
8.4
33
Administration
Not enough data
8.4
36
Not enough data
8.9
34
Not enough data
9.1
34
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Deployment & Integration - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Connectivity & Federation - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Modeling & Metrics - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Performance Optimization - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Governance - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Intelligence - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI Enablement - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Transformation
Not enough data
8.5
32
Not enough data
9.4
38
Connectivity
Not enough data
8.5
27
Not enough data
8.6
28
Not enough data
8.5
34
Not enough data
9.0
31
Operations
Not enough data
Feature Not Available
Not enough data
9.4
37
Not enough data
8.6
31
Not enough data
8.6
30
Not enough data
8.5
29
Functionality
Not enough data
8.7
38
Not enough data
8.4
36
Not enough data
8.6
38
Not enough data
8.2
38
Not enough data
8.4
36
Management
Not enough data
8.4
38
Not enough data
9.2
42
Not enough data
8.9
37
Not enough data
8.2
39
Not enough data
8.3
41
Generative AI
Not enough data
6.3
20
Not enough data
6.7
20
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
Amazon Redshift and dbt are categorized as Big Data Integration Platforms
Unique Categories
Amazon Redshift is categorized as Columnar Databases and Data Warehouse
dbt is categorized as Big Data Analytics, Data Preparation, Data Quality, ETL Tools, Data Warehouse Automation, DataOps Platforms, and Semantic Layer Tools
Reviews
Reviewers' Company Size
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
dbt
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
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
Information Technology and Services
19.7%
Computer Software
16.5%
Financial Services
10.6%
Retail
4.8%
Marketing and Advertising
4.8%
Other
43.6%
Alternatives
Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What are the characteristics of redshift?
2 Comments
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read more
What is DBT data Modelling?
2 Comments
TH
dbt data modeling is not a thing. Dbt is a transformation tool that makes it easier to implement data modeling techniques like snowflake, data vault etc. Read more
What is DBT database tool?
1 Comment
SY
DBT (DataBase Transformations) uses SQL select statements, with some added magic from Jinja templating language, to model and transform data. It's a highly...Read 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.
