Currently we don't have the option to configure the schema/destination of our choice specific to Big query as the destination. If given an option to dump the transformed tables anywhere within bigquery maybe even a different project will be of great help. This is because many people prefers separating raw data with transformed data when they expose it to business and w.r.t in BQ It's a different project for us.

Thanks