BillBishop
New Contributor III

NOTE: I got it to work by aliasing the customer_name column, it's documented here: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-materialized-view#l...

However, it wasn't clear that "Non-column reference expressions require an alias" applies to ALL functions, not just  aggregate functions like the example.

View solution in original post