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.