Stay organized with collections
Save and categorize content based on your preferences.
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 TABLESET OPTIONS statement to update the expiration as
the following example shows:
ALTERTABLEmde_system.operations-logSETOPTIONS(-- Sets partition expiration to 30 dayspartition_expiration_days=30);
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[],[],null,["# BigQuery data retention\n=======================\n\nThis guide describes how to configure data retention on BigQuery\ntables.\n\nDepending on the Manufacturing Data Engine (MDE) operations log level a lot of data\nmay be stored in the [operations-log](/manufacturing-data-engine/docs/reference/bigquery-schemas#operations_logs)\nBigQuery table. Since MDE is using partitioned\ntables you can manage retention as described in the [Managing partitioned tables](/bigquery/docs/managing-partitioned-tables) guide.\n\nUpdate the partition expiration example\n---------------------------------------\n\nYou can use the `ALTER TABLE` `SET OPTIONS` statement to update the expiration as\nthe following example shows: \n\n ALTER TABLE mde_system.operations-log\n SET OPTIONS (\n -- Sets partition expiration to 30 days\n partition_expiration_days = 30);"]]