difference between amazon s3 and Amazon redshift

amazon-web-services amazon-s3 amazon-redshift
shivesh verma picture shivesh verma · Apr 1, 2015 · Viewed 29.3k times · Source

I am studying first time about Amazon Web Services. I want to know what is the difference or relation between Amazon s3 and Amazon Redshift. Thanks in advance.

Answer

Sandesh Deshmane picture Sandesh Deshmane · Apr 2, 2015

Amazon S3 is storage service.Amazon S3 a simple web services interface to store and retrieve any amount of data from anywhere on the web. With Amazon S3, you pay only for the storage you actually use.

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse.

Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources.

The relationship between Redshift and S3 is that data can be pumped into your warehouse from s3. More instructions can be found here.

Related questions

How to Load Data into Amazon Redshift via Python Boto3?

In Amazon Redshift's Getting Started Guide, data is pulled from Amazon S3 and loaded into an Amazon Redshift Cluster utilizing SQLWorkbench/J. I'd like to mimic the same process of connecting to the cluster and loading sample data into the …

Read More
Loading data (incrementally) into Amazon Redshift, S3 vs DynamoDB vs Insert

I have a web app that needs to send reports on its usage, I want to use Amazon RedShift as a data warehouse for that purpose, How should i collect the data ? Every time, the user interact with my app, …

Read More
Copy data from Amazon S3 to Redshift and avoid duplicate rows

I am copying data from Amazon S3 to Redshift. During this process, I need to avoid the same files being loaded again. I don't have any unique constraints on my Redshift table. Is there a way to implement this using …

Read More