When a task enabled for SQL ELT optimization is running, you can clean stop the job to terminate all the issued statements and processes spawned by the job.
Use the Clean Stop option on the My Jobs page in Data Integration and the All Jobs and Running Jobs page in Monitor.
See the following exceptions before you clean stop a SQL ELT optimization task:
•When you clean stop a task enabled for source SQL ELT optimization that reads from or writes to Snowflake and the target or source properties in the mapping contains pre-SQL or post-SQL statements, the job continues to run the target post-SQL query even though the select query is terminated.
•When you run a mapping configured to create a new target at runtime and clean stop the job immediately, Data Integration creates the target table even if the job is terminated.