AWS August Roundup: Now you can query streaming data with SQL

New Amazon services also improve load balancing and bring hourly billing to virtual desktop rental

The dog days of summer are over, and it's time to get back to work. While you were out enjoying the sunshine and sipping margaritas, Amazon continued to update its cloud platform with new services like Kinesis Analytics, which lets users query streaming data with SQL. 

There were also a ton of updates to existing services, with the company's load balancer service moving up the stack, hourly billing coming to virtual desktops and support for customers bringing their own encryption keys for Amazon to manage. 

Here's the detailed breakdown:

Kinesis Analytics is here to query streaming data with SQL

Amazon launched a new product to help users process and gain insights from large amounts of streaming data as it's coming in, rather than waiting to process it when it hits a database. Kinesis Analytics lets users set up SQL queries to run on batches of data as it arrives in Amazon's cloud.

That means people who know how to query databases will be able to take those tools to get live information from streams of data from the Internet of Things, detailed application telemetry, and other sources.

Amazon's load balancer moved up the stack

The Elastic Load Balancer system has been around for a while, to help manage the load put on web applications being run in Amazon's cloud. Now there's a new traffic cop in town: the Application Load Balancer, which sports a whole bunch of features like content-based routing, support for container-based apps, improved metrics and support for WebSocket and HTTP/2.

For you folks out there who understand the Open Systems Interconnection (OSI) model, the ALB runs at Layer 7, while the previous load balancers (now called Classic Load Balancers) will provide Layer 4 and Layer 7 functionality.

Customers using a Classic Load Balancer can use Amazon's Load Balancer Copy Utility to help them create an Application Load Balancer with the same configuration as one of the older models, and register existing EC2 instances to a new load balancer. The new load balancers are generally available now, and Amazon says they're 10 percent cheaper than their predecessors.

It's now easy to upload cost and usage reports to Redshift and QuickSight

Companies that are using a lot of AWS services are going to have big bills, and it can be useful to better understand where that cost and usage is coming from. To help manage all of that, Amazon now makes it easier for its customers to upload their usage reports to the company's Redshift relational database and QuickSight business intelligence service.

Users set up a usage report to upload to a S3 storage bucket, and enable it to work with Redshift and QuickSight. Sending a report to Redshift means that users will be able to run SQL queries on the usage data, while QuickSight can help them produce visualizations of their Amazon cloud spending.

Amazon's virtual desktops can now be rented on an hourly basis

Amazon WorkSpaces, the AWS-based virtual desktop-as-a-service offering, now supports billing by the hour, which means that customers can spin up a desktop when they need it and tear it down when they don't. To take advantage of the billing feature, users have to set up a WorkSpace in AutoStop mode, which will shut down after a defined period of user inactivity.

Priced hourly, Amazon still charges a monthly base fee for each WorkSpace, plus a fee for every hour it's in use, including the time when the workspace is inactive but AutoStop hasn't kicked in to shut it down. Amazon rounds up to the nearest full hour of usage when it comes to billing, so someone who uses a WorkSpace with a 60 minute delay until AutoStop kicks in (the default) for 3 hours and 15 minutes will be billed for five hours of use.

Roughly speaking, hourly billing is cheaper than monthly billing for WorkSpaces that are charged for 80  or fewer hours of use a month. After that, it's cheaper to just bite the bullet and pay for monthly billing.

Amazon also expanded the size of new WorkSpaces’ root volumes to 80GB, so users get more space to store applications without paying more.

Companies can bring their own keys to Amazon's Key Management Service

Customers who want to control how their data is encrypted in the AWS cloud have been able to use Amazon's Key Management Service to integrate encryption keys managed by the cloud platform with services that need their data encrypted. Users can now import keys from any key management or hardware security module that supports RSA PKCS #1.

That means those customers will be able to retain control of their keys and use them in private datacenters while also making it easy to manage them in the cloud.

That's a wrap for the past month -- stay tuned for more news coming out in September.

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Blair Hanley Frank

IDG News Service
Show Comments

Cool Tech

Toys for Boys

Family Friendly

Stocking Stuffer

SmartLens - Clip on Phone Camera Lens Set of 3

Learn more >

Christmas Gift Guide

Click for more ›

Brand Post

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill


I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?