...
Click System Admin > Configuration.
Click Edit System Preferences.
In the Key field, enter
retain.staging.table
.In the Value field, enter
true
.Click Save & Close.
Now, when you run a Replication job, CDAP retains staging tables in BigQuery.
...