For similar capabilities to AWS IoT Analytics, explore Amazon Kinesis, Amazon S3, and Amazon Athena. These services provide additional scalability and flexibility to meet your evolving analytics requirements. Learn how
here
SQL expressions in AWS IoT Analytics
Datasets are generated using SQL expressions on data in a data store. AWS IoT Analytics uses the same SQL queries, functions and operators as Amazon Athena.
AWS IoT Analytics supports a subset of ANSI standard SQL syntax.
SELECT [ ALL | DISTINCT ] select_expression [, ...] [ FROM from_item [, ...] ] [[ INNER | OUTER ] LEFT | RIGHT | FULL | CROSS JOIN join_item [ ON join_condition ]] [ WHERE condition ] [ GROUP BY [ ALL | DISTINCT ] grouping_element [, ...] ] [ HAVING condition ] [ UNION [ ALL | DISTINCT ] union_query ] [ ORDER BY expression [ ASC | DESC ] [ NULLS FIRST | NULLS LAST] [, ...] ] [ LIMIT [ count | ALL ] ]
For a description of the parameters, see Parameters in the Amazon Athena documentation.
AWS IoT Analytics and Amazon Athena doesn't support the following:
-
WITH
clauses. -
CREATE TABLE AS SELECT
statements -
INSERT INTO
statements -
Prepared statements, you can't run
EXECUTE
withUSING
. -
CREATE TABLE LIKE
-
DESCRIBE INPUT
andDESCRIBE OUTPUT
-
EXPLAIN
statements -
User-defined functions (UDFs or UDAFs)
-
Stored procedures
-
Federated connectors