Fine-grained DML (Data Manipulation Language) is a feature in BigQuery that allows users to optimize the execution of UPDATE, DELETE, and MERGE statements on tables. It does this by:
- Optimizing mutations. Fine-grained DML optimizes mutations at a more detailed level than the previous file-group approach.
- Reducing data rewrites. Fine-grained DML aims to minimize the amount of data that needs to be rewritten during operations.
To enable fine-grained DML, users can:
Set the enable_fine_grained_mutations
table option to TRUE
when running a CREATE TABLE
or ALTER TABLE
DDL statement.
You must log in or register to comment.