NORMALIZE is a Teradata extension to the ANSI SQL standard. When a SQL table includes a column that has a PERIOD data type, NORMALIZE combines values that meet or overlap in that column, to form a single period that consolidates multiple, individual period values. To use NORMALIZE, at least one column in the SQL SELECT list must be of Teradata's temporal PERIOD data type. For more information about NORMALIZE, see the Teradata documentation.
Amazon Redshift doesn’t support NORMALIZE, but you can implement this functionality by using native SQL syntax and the LAG window function in Amazon Redshift. This pattern focuses on using the Teradata NORMALIZE extension with the ON MEETS OR OVERLAPS condition, which is the most popular format. It explains how this feature works in Teradata and how it can be converted into Amazon Redshift native SQL syntax.
