When you use Workload Identity Federation authentication to connect to

Google BigQuery

, browsing metadata might take longer than expected if the project contains a large number of datasets.

When you configure the read mode as staging and use the Parquet staging file format in a Source or Lookup transformation, the Byte data type exceeding 4000 bytes gets truncated.

When you run a mapping enabled with

SQL ELT optimization

and use the

+

,

-

,

*

, and

%

operators within an Expression transformation inside parentheses, the query result might be incorrect because the parentheses for these operators are not honored and are removed from the query.

When you run a mapping configured with SQL ELT mode that contains a Joiner, Lookup, or Normalizer transformation connected to another Normalizer transformation, the mapping fails with the following error: