Unsupported characters in the names of tables and columns

You must use only SQL ANSI 92 compliant characters in the load queries that you execute against the relational data source. For example, do not use spaces or special characters such as !, @, #, $, or %.

Load queries that you execute against Data Lake must meet the Compass standards.

See Infor ION Development Guide-Cloud Edition on Infor Support Portal for more details on Compass load query syntax.