Overview of SQL in AWS Clean Rooms
This reference describes the SQL that AWS Clean Rooms runs. AWS Clean Rooms SQL is based on Spark SQL. Use this reference to find the commands, functions, conditions, and data types that you can use in your queries.
The analysis rules on the configured tables that a query reads can further limit the SQL you can use. For more information, see Analysis rules in the AWS Clean Rooms User Guide.
AWS Clean Rooms runs only SELECT-type queries: SELECT statements, including
those that start with WITH, and CACHE TABLE statements. AWS Clean Rooms doesn't support other
statements, such as INSERT, CREATE TABLE, SET, and
EXPLAIN. Every query must include a FROM clause that reads from a
configured
table or an intermediate
table.
The following sections describe the SQL that you can use in AWS Clean Rooms.
For more information about AWS Clean Rooms, see the AWS Clean Rooms User Guide and the AWS Clean Rooms API Reference.