Comment by akalitenya

Mprove creates permanent derived tables in BigQuery if the user wants it.

But you can't use BigQuery for OLTP.