Redshift Vs Athena. Retrieve the Amazon Redshift cluster public key and cluster node IP addresses. Athena stores query results on S3 and they can be loaded into Redshift from there. This includes any ancillary data operations that process data into a Redshift warehouse or unique and complex data types supported by Redshift that may break existing workflows. 1972019 Athena is serverless similar to Lambda so it means that you dont have any infrastructure to spin up or manage for computing your queries.
This includes any ancillary data operations that process data into a Redshift warehouse or unique and complex data types supported by Redshift that may break existing workflows. On the other hand Redshift is a PostgreSQL based data warehouse which is much more complicated and flexible than Athena. This could be a deal breaker for some. Being a cloud service the former also supports various other forms of encryption. Posted by 3 years ago. While Redshift does the job with a security group Athena uses the identity access management technology to protect user data from the prying eyes.
Apart from Redshift all other Data Warehouses Snowflake Hive BigQuery Athena supports complex data structures like arrays maps and structs as first class citizens.
Athena provides a cheaper and more portable way to query data while Redshift offers unrivalled performance and scalability. With Redshift Spectrum you have control over resource provisioning while in the case of Athena AWS allocates resources automatically. On the other hand Redshift is a PostgreSQL based data warehouse which is much more complicated and flexible than Athena. While managing the cluster you need to define the number of nodes initially. Results of queries run on Athena can be stored on S3 and loaded to Redshift if needed. 662016 Redshift requires framework management and data preparation while Athena bypasses that and gets straight to querying data from Amazon S3.