Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: "ORA-28094: SQL construct not supported by data redaction" when trying to test query

Suskil
Alteryx
Alteryx
Created

Issue


The following Oracle error occurs when testing a simple query (select * from tablename) in the SQL Editor tab of the Visual Query Builder pop-up window. 

 
ORA-28094: SQL Construct Not Supported By Data Redaction


Environment Details

 
  • Alteryx Designer
    • 2020.1+
  • Oracle
    • 12.2
  • Oracle Instant Client
    • 12.2


Cause


An ORA-28094: SQL construct not supported by data redaction error is raised if a query involves a UNION of redacted columns and each branch of the UNION does not have the same redaction policy. In this case, the table was actually a view, which contained redacted columns, so is not immediately obvious to the user. Although Oracle Database does not support complex SQL that involves redacted columns, this error is not raised if the user who is executing a query with complex SQL has the EXEMPT REDACTION POLICY system privilege. 



Solution A


Rewrite the query to avoid using an unsupported construct. Consult the Oracle documentation for details.

 

Solution B


Where it's not possible to rewrite the query (e.g. querying a view that contains the mismatched redacted columns) contact your DBA to request the EXEMPT REDACTION POLICY privilege.

Additional Resources

 
No ratings