Firebase Analytics - 为 BigQuery 设置数据位置 [英] Firebase Analytics - Set data location for BigQuery

问题描述

我们有一个 Firebase 项目设置，配置了分析和导出到 BigQuery.

We have a Firebase Project setup, with Analytics and export to BigQuery configured.

集成已成功，我们的活动正在顺利迁移到 BigQuery.

The integration has been successful and our events are being migrated to BigQuery just fine.

但是，我们在 BigQuery 中设置的数据位置存在问题.

However, we face an issue with the data location set in BigQuery.

我们的 Firebase 项目将默认 GCP 资源位置设置为 eur3(欧洲-西部).在设置 Firebase Analytics 和 BigQuery 之间的集成期间，我们无法设置任何数据位置.

Our Firebase project has Default GCP resource location set as eur3 (europe-west). During setting up the integration between Firebase Analytics and BigQuery, we had no option to set any data location.

我们可以在 BigQuery 中看到数据集的位置是 US.我相信欧盟数据中心现在支持 BigQuery，我们如何使用欧盟位置而不是美国位置?

We can see the location for the dataset is US in BigQuery. I believe BigQuery is now supported in EU data centres, how can we use the EU location rather than US?

推荐答案

从 2021 年末开始，BigQuery 的 Analytics 导出现在在 Google Analytics 管理控制台中进行管理，您可以在设置时指定数据位置或链接到所需区域中的现有 BigQuery 数据集.但是，无法更改现有数据集的区域.

As of late 2021, BigQuery exports for Analytics are now managed in the Google Analytics admin console, and you can specify the data location at setup time or link to an existing BigQuery dataset in the desired region. However, it isn't possible to change the region for an existing dataset.

另请参阅 Klemen 的回答，其中提出了一种迁移现有数据的风险解决方法.Google 文档中不建议这样做，并且不太可能得到支持，但可能会有所帮助.

Also see Klemen's answer, which suggests a risky workaround for migrating existing data. This is not suggested in Google docs, and is unlikely to be supported, but potentially helpful.

在 2021 年底之前，Google Analytics for Firebase BigQuery 数据集是在美国创建的，无论开发者从哪个位置创建他们的 Firebase 项目.

Prior to late 2021, Google Analytics for Firebase BigQuery dataset was created in the US, regardless from which location a developer created their Firebase project.

您通常无法控制 Analytics 数据的位置，只能控制 BigQuery 导出.GA 数据分布在 Google 数据中心.

You cannot control the location of Analytics data in general, only BigQuery exports. GA data is distributed across Google data centers.

这篇关于Firebase Analytics - 为 BigQuery 设置数据位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！