The issue occurs when the column names are quoted, causing a mismatch with the unquoted column names in the test_column_anomalies.sql file. This PR modifies the check in the test_column_anomalies.sql file to unquote the column names before testing. This ensures that the column names match regardless of whether they are quoted or not in the table.
Changes Made
Modified the check in test_column_anomalies.sql to unquote the column names before testing.
Replaced the existing check with UNQUOTE_IDENTIFIER(column_name) IN (SELECT column_name FROM columns).
Description
This PR addresses issue ELE-996.
The issue occurs when the column names are quoted, causing a mismatch with the unquoted column names in the
test_column_anomalies.sqlfile. This PR modifies the check in thetest_column_anomalies.sqlfile to unquote the column names before testing. This ensures that the column names match regardless of whether they are quoted or not in the table.Changes Made
test_column_anomalies.sqlto unquote the column names before testing.UNQUOTE_IDENTIFIER(column_name) IN (SELECT column_name FROM columns).Screenshots
N/A
Additional Context
Fixes #4.
To checkout this PR branch, run the following command in your terminal: