Description

Check for SQL usage on DB connectors and stages. Developers should avoid using SQL to filter data and instead utilise DataStage's features

This currently only allows generated SQL where there are no other clauses specified in stages with that option. Any user-defined SQL, generated SQL with additional clauses, or query file inputs will fail this rule.

Actions

Configure your Connector Stages to use auto-generated SQL.

Notes

This rule is mutually exclusive to the SELECT * used in custom SQL rule. Choose your preferred approach and adopt/adapt these example rules as appropriate.