Developer perspective: AWS Redshift

Queue-it’s CTO and Co-founder, Martin Pronk, recently gave a presentation on why and how Queue-it uses AWS’s Redshift. Amazon describes Redshift as a fast, fully managed, petabyte-scale data warehouse solution that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. Redshift is incorporated into Queue-it’s operations to help analyze large amounts of data collected during online queue events, such as online ticket releases that require an online queue to manage the end-user overload.

Published: 27. Mar 2015
Martin Larsen Senior Developer at Queue-it

Martin provided a case study on a Queue-it ticketing customer to showcase how Redshift helps analyze log data collected during a specific ticket release. Instead of manually trying to filter the myriad of data collected, Queue-it developers are able to use Redshift to seek out the exact log data from an individual queue, which can be found i.e. by the date, time, or name of the queue event. To showcase how fast Redshift is to use during online queues, Martin gave this example on copying data from S3 to use in Redshift:

Perf 1: Copy Data From S3

Perf 2: Copy Data From S3

Perf 3: Copy Data From S3Redshift Limitations

 

While Redshift is easy to implement, there are some limitations:

Redshift AWS Limitations

Alexander Yaremchuck, Software Developer at Queue-it, attended the presentation and found Martin’s presentation “insightful and relevant to our emerging business needs. Martin described the main capabilities of Redshift as a technological solution for data-warehousing. It enables the users to use it as a unified aggregate repository-system that can accommodate various types of data coming from other sources. It is particularly useful in the context of interoperability with other AWS services.”

Salman Nazir, Software Developer at Queue-it, additionally noted that Redshift is “very easy to use and to scale up and down to manage our data. Also, you don’t need to learn a new programming language to use it, and there’s no maintenance required if we have any issue with it.”

Martin encouraged the participants, most of whom were professionals in the area of data warehousing and big data, to use Redshift if it is feasible for their system, and is looking forward to any future feedback on the growth of the use of Redshift in cloud technologies. Please let us know your thoughts on Redshift, or contact us for more information.

Find out how Queue-it works with AWS