BigQuery data retention

This guide describes how to configure data retention on BigQuery tables.

Depending on the Manufacturing Data Engine (MDE) operations log level a lot of data may be stored in the operations-log BigQuery table. Since MDE is using partitioned tables you can manage retention as described in the Managing partitioned tables guide.

Update the partition expiration example

You can use the ALTER TABLE SET OPTIONS statement to update the expiration as the following example shows:

ALTER TABLE mde_system.operations-log
  SET OPTIONS (
    -- Sets partition expiration to 30 days
    partition_expiration_days = 30);