Macros that prevent false positive validation errors

You can use these macros in your SQL load queries to prevent false positive validation errors in queries:

• --<<DONT_USE_VALIDATION>>

  Use this macro to get only the first record from the validation result set and improve load query performance.

• --<<DONT_USE_INSERTINTO>>

  Use this macro if you execute load query between the same source and target table. Specify this macro before you start specifying your SQL query.

You can combine both macros in one load query but specify each macro in a separate line in the query editor. For example:

--<<DONT_USE_VALIDATION>>
--<<DONT_USE_INSERTINTO>>
SELECT * …