如何在BigQuery上保留数据集而没有到期日期 [英] How to keep data set on BigQuery without expiration date
问题描述
我最近从沙盒模式升级了Bigquery,并希望删除数据集的到期日期. 有人可以分享升级后应该更改的设置以及如何做吗?
I recently upgraded Bigquery from sandbox mode and would like to remove data set expiration date. Could anybody share which setting I should change after the upgrade and how to do it?
我已将表过期"更改为到从不".
I've changed "Table Expiration" to "Never".
但是,在Firebase上,BigQuery集成设置包含Google Analytics(分析)部分,并且仍显示有效数据:60天".我想知道如何更改它,这是否会影响BigQuery上导入的数据过期.
However, on Firebase, BigQuery integration setting has Google Analytics part and it is still showing "Data to live: 60days" and I'm wondering how to change it and whether this is going to affect the imported data expiration on BigQuery.
推荐答案
要更改保留设置,您必须从Google Analytics(分析)而不是在BigQuery中进行更改:
In order to change the retention settings you have to change it from Google Analytics rather than inside BigQuery:
- 转到 Google Analytics(分析)主页,然后选择正确的项目
- 单击主页底部的
Admin
- 在新打开的部分上,单击
Data Settings
,然后单击Data Retention
- 将
Event data retention
从最长保留期的2个月更改为14个月,然后单击Save
- Go to Google Analytics homepage and select the correct project
- Click on
Admin
which is in the bottom of the homepage - On the new opened section click on
Data Settings
and then onData Retention
- Change the
Event data retention
from 2 months to 14 months which is the longest retention period and click onSave
现在,您可以返回Firebase控制台,您会注意到实时数据"有变化.
Now you can go back to the Firebase Console and you will notice that the "Data to live" has change.
有关Google Analytics(分析)中数据保留的更多信息,请参见此处
More information about Data Retention from Google Analytics can be found here
这篇关于如何在BigQuery上保留数据集而没有到期日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!