# AWS Clean Rooms Spark SQL functions
<a name="sql-functions-topic-spark"></a>

AWS Clean Rooms Spark SQL supports the following SQL functions:

**Topics**
+ [Aggregate functions](sql-functions-agg-spark.md)
+ [Array functions](Array_Functions.md)
+ [Conditional expressions](sql-functions-conditional-expressions-spark.md)
+ [Constructor functions](sql-functions-constructor.md)
+ [Data type formatting functions](Data_type_formatting.md)
+ [Date and time functions](date-time-functions-spark.md)
+ [Encryption and decryption functions](encryption-decryption-functions.md)
+ [Hash functions](s_hash-functions.md)
+ [Hyperloglog functions](hyperloglog-functions.md)
+ [JSON functions](json-functions-spark.md)
+ [Math functions](Math_functions-spark.md)
+ [Scalar functions](scalar_functions.md)
+ [String functions](String_functions_spark.md)
+ [Privacy-related functions](privacy-related-functions.md)
+ [Window functions](Window_functions.md)