CODEWITHSUNDEEP
amazon-web-servicesamazon-redshiftamazon-rdsdata-warehouse
Nemesius
Nemesius

Reputation: 179

AWS Redshift or RDS for a Data warehouse?

Right now we have an ETL that extracts info from an API, transforms, and Store in one big table in our OLTP database we want to migrate this table to some OLAP solution. This table is only read to do some calculations that we store on our OLTP database.

Which service fits the most here?

We are currently evaluating Redshift but never used the service before. Also, we thought of some snowflake schema(some kind of fact table with dimensions) in an RDS because is intended to store 10GB to 100GB but don't know how much this approach can scale.

Upvotes: 0

Views: 1793

Answers (2)

Prashant Suthar
Prashant Suthar

Reputation: 302

AWS Redshift is really great when you only want to read the data from the database. Basically, Redshift in the backend is a column-oriented database that is more suitable for analytics. You can transfer all your existing data to redshift using the AWS DMS. AWS DMS is a service that basically needs your bin logs of the existing database and it will automatically transfer your data we don't have to do anything. From my Personal experience Redshift is really great.

Upvotes: 1

gusto2
gusto2

Reputation: 12087

Which service fits the most here?

imho you could do a PoC to see which service is more feasible for you. It really depends on how much data you have, what queries and what load you plan to execute.

AWS Redshift is intended for OLAP on top of peta- or exa-bytes scale handling heavy parallel workload. RS can as well aggregate data from other data sources (jdbc, s3,..). However RS is not OLTP, it requires more static server overhead and extra skills for managing the deployment.

So without more numbers and use cases one cannot advice anything. Cloud is great that you can try and see what fits you.

Upvotes: 3

Related Questions