Document history for the AWS Clean Rooms SQL Reference
The following table describes the documentation releases for the AWS Clean Rooms SQL Reference.
For notification about updates to this documentation, you can subscribe to the RSS feed. To subscribe to RSS updates, you must have an RSS plug-in enabled for the browser you are using.
| Change | Description | Date |
|---|---|---|
AWS Clean Rooms Spark SQL supports query hints to optimize query performance and reduce compute costs. | January 20, 2026 | |
AWS Clean Rooms Spark SQL supports the CACHE TABLE command, which allows customers to cache existing tables or create and cache new tables from query results for improved query performance. | October 22, 2025 | |
AWS Clean Rooms Spark SQL supports the following Window functions: FIRST and LAST. | June 12, 2025 | |
Documentation-only update to accurately reflect supported Spark SQL functions. Removed documentation for 25 unsupported functions, including <=> operator, SIMILAR TO, LISTAGG, and ARRAY_INSERT. Corrected function names from DATEADD to DATE_ADD, DATEDIFF to DATE_DIFF, ISNULL to IS_NULL, and ISNOTNULL to IS_NOT_NULL. Fixed a typo in DATE_PART examples. | May 20, 2025 | |
Customers can now run queries using some SQL conditions, functions, commands, and conventions supported with the Spark SQL analytics engine. | October 29, 2024 | |
SQL commands and SQL functions – update | Examples have been added for the JOIN clause, EXCEPT set operator, CASE conditional expression, and the following functions: ANY_VALUE, NVL and COALESCE, NULLIF, CAST, CONVERT, CONVERT_TIMEZONE, EXTRACT, MOD, SIGN, CONCAT, FIRST_VALUE, and LAST_VALUE. | February 28, 2024 |
AWS Clean Rooms now supports the following SQL functions: Array, SUPER, and VARBYTE. The following math functions are now supported: ACOS, ASIN, ATAN, ATAN2, COT, DEXP, PI, POW, RADIANS, and SIN. The following JSON functions are now supported: CAN_JSON_PARSE, JSON_PARSE, and JSON_SERIALIZE. | October 6, 2023 | |
AWS Clean Rooms now supports nested data types. | August 30, 2023 | |
Documentation-only change to clarify reserved column names. | August 16, 2023 | |
General availability | The AWS Clean Rooms SQL Reference is now generally available. | July 31, 2023 |
