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 the Infor ION Development documentation for more details on Compass load query syntax.