The power of dynamic SQL!
This is the game changer.
This job type empowers you to perform advanced table and data manipulations not possible using the BigQuery CLI nor the BigQuery web interface.
For example: You can perform DML (Data manipulation Language) statements against multiple tables.
You could also manipulate tables in different datasets which is useful when you want to shard data.