将Google Cloud SQL备份上传到Bigquery [英] Upload Google Cloud SQL backup to Bigquery

问题描述

我尝试将Google Cloud SQL数据库迁移到BigQuery时遇到了麻烦。我已将数据库备份从Cloud SQL导出到云存储，但试图将其导入BigQuery时，出现错误：'not found：URI'for gs：// bucket-name / file-name

我试图做甚么可能吗？我希望以某种方式直接将Cloud SQL数据上传到BigQuery。这是一个很大的表（> 27GB），我一直与云SQL有很多连接问题，所以导出为CSV或JSON不是最好的选择。

>解决方案

BigQuery不支持mysql备份格式，所以最好的路线是从云端sql数据库生成csv或json，并将这些文件保存到云存储中。

有关导入数据的更多信息，请参阅 BigQuery文档。

I have had troubles trying to move a Google Cloud SQL database to BigQuery. I have exported the database backup from Cloud SQL to Cloud Storage, but when trying to import this into BigQuery, I get the error: 'Not found: URI' for gs://bucket-name/file-name

Is what I'm trying to do even possible? I'm hoping to somehow directly upload the Cloud SQL data to BigQuery. It's a large table (>27GB) and I have been having a lot of connection issues with Cloud SQL, so exporting as CSV or JSON isn't the best option.

解决方案

BigQuery doesn't support the mysql backup format, so the best route forward is to generate csv or json from the cloud sql database and persist those files into cloud storage.

More information on importing data can be found in the BigQuery documentation.

这篇关于将Google Cloud SQL备份上传到Bigquery的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！