Executing this test results in the following error
('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'from'. (156) (SQLMoreResults)")The root issue is previous_column_name first referenced in the windowed cte is not being set. In dbt_utils, the Jinja is set as https://github.com/dbt-labs/dbt-utils/blob/22855099135cd4de445bed45601f11cb1caabb24/macros/generic_tests/sequential_values.sql#L9
This should resolve the error and seems to have been missed in the port of this test.
Executing this test results in the following error
The root issue is
previous_column_namefirst referenced in thewindowedcte is not being set. In dbt_utils, the Jinja is set as https://github.com/dbt-labs/dbt-utils/blob/22855099135cd4de445bed45601f11cb1caabb24/macros/generic_tests/sequential_values.sql#L9This should resolve the error and seems to have been missed in the port of this test.