View a markdown version of this page

Overview of SQL in AWS Clean Rooms - AWS Clean Rooms

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.