如何在不重新创建的情况下重命名表 [英] how to rename a table without re creating it

问题描述

我没有找到一个RENAME选项来改变表名。
我有一个情况，我必须重命名一个表，唯一的方法是选择结果到新表。这个查询花钱，花费很长时间没有理由。

当我需要重新命名一个嵌套表时，特别痛苦，所以我必须导出，甚至需要工作对结果集进行导入。

我失踪的任何方式？一切即将来临？

解决方案

没有重命名选项，但有一个复制操作，它使用快速快照过程。除了额外的存储成本外，这不会产生任何额外费用（当然，您可以删除原来的表格，因此您只能为存储收取一次费用）。

您可以通过点击表格名称和表格名称旁边的下拉箭头，然后选择复制表格来在BigQuery中执行此操作。或者，您可以在bq命令行工具中使用 bq cp 命令。

I didn't find a RENAME option to alter table name. I have a case that I must rename a table, and the only way is to select with result to new table. this query cost money, and taking long time for no reason.

It is especially painful when I need to rename a nested table, so I must export, need to even work on the result set in order to import it back.

Any way that I am missing? anything coming soon?

解决方案

There is no rename option, but there is a copy operation, which uses a fast snapshot process. This doesn't incur any additional charges other than the additional cost of storage (of course you can delete the original table so you only get charged for the storage once).

You can do this in the BigQuery by clicking on the table name and the dropdown arrow next to the table name, then selecting 'copy table'. Alternately you can use the bq cp command in the bq command-line tool.

这篇关于如何在不重新创建的情况下重命名表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！