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

问题描述

我在尝试将 Google Cloud SQL 数据库移动到 BigQuery 时遇到了问题.我已将数据库备份从 Cloud SQL 导出到 Cloud Storage，但是在尝试将其导入 BigQuery 时，出现错误:'Not found: URI' for gs://bucket-name/文件名

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

我正在尝试做的事情有可能吗?我希望以某种方式直接将 Cloud SQL 数据上传到 BigQuery.这是一个大表 (>27GB)，我在使用 Cloud SQL 时遇到了很多连接问题，因此导出为 CSV 或 JSON 并不是最佳选择.

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 不支持 mysql 备份格式，所以最好的方法是从云 sql 数据库生成 csv 或 json 并将这些文件持久化到云存储中.

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.

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

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

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