When you clean stop a task enabled for source

SQL ELT optimization

that reads from or writes to Google BigQuery and the target or source properties in the mapping contains pre-SQL or post-SQL statements, even if the select query is terminated, the job continues to run the target post-SQL query.

When you start a job enabled for full

SQL ELT optimization

and clean stop it immediately, and if the mapping is configured to create a new target at runtime, the table is created even if the job is terminated.