...
The service account configured for BigQuery Transformation Pushdown must have permissions to read tables in the BigQuery Source's dataset.
The Datasets used in the BigQuery Source and the dataset configured for Transformation Pushdown must be stored in the same location.
Wrangler
...
Filter Pushdown (6.9.0+)
Wrangler Precondition Filter Pushdown is available in CDAP versions 6.9.0 and later. It lets you push down Precondition operations in the Wrangler plugin to BigQuery.
Wrangler Precondition Filter Pushdown is only supported with the SQL mode for Preconditions, also newly added in 6.9.0. In this mode, the plugin accepts a precondition expression in ANSI-standard SQL.
...
SQL mode for preconditions is currently unsupported for Wrangler plugins with multiple inputs.
Wrangler preconditions filters are executed in BigQuery in the following cases:
...