Amazon Kinesis Data Analytics SQL Reference

Note

For new projects, we recommend that you use Kinesis Data Analytics Studio over Kinesis Data Analytics for SQL Applications. Kinesis Data Analytics Studio combines ease of use with advanced analytical capabilities, enabling you to build sophisticated stream processing applications in minutes.

The Amazon Kinesis Data Analytics SQL Reference describes the SQL language elements that are supported by Amazon Kinesis Data Analytics. The language is based on the SQL:2008 standard with some extensions to enable operations on streaming data.

For information about developing Kinesis Data Analytics applications, see the Kinesis Data Analytics Developer Guide.

This guide covers the following:

• Streaming SQL Language Elements – Data Types, Streaming SQL Operators, Functions.

• Standard SQL Operators – CREATE statements, SELECT statement.

• Operators for transforming and filtering incoming data – WHERE clause, JOIN clause, GROUP BY clause, WINDOW Clause (Sliding Windows).

• Logical Operators – AS, AND, OR, etc.