从 Python 更新 BigQuery 表属性会使表消失 [英] Updating BigQuery table properties from Python makes table disappear

问题描述

主题几乎说明了一切.当我运行 BigQuery 文档中的代码来更改表属性(在这种情况下，它的到期日期)时，它似乎只是暂时删除了表.(在 BQ GUI 中也找不到.)有人知道为什么吗?谢谢.

Subject pretty much says it all. When I run the code from the BigQuery docs to change the table property (in this case, its expiration date), it seems to just summarily delete the table instead. (Can't be found in the BQ GUI either.) Anyone know why? Thanks.

# Replace "dk" with your own initials before running this
s_table_id = 'hcwisdom.temp_tables.new_test_table'
from google.cloud import bigquery
client = bigquery.Client()
schema = [
    bigquery.SchemaField("full_name", "STRING", mode="REQUIRED"),
    bigquery.SchemaField("age", "INTEGER", mode="REQUIRED"),
]
try:
    client.get_table(s_table_id)  # Make an API request.
    print("Table {} exists.".format(s_table_id))
except:
    print("Creating table {}.".format(s_table_id))
    table = bigquery.Table(s_table_id, schema=schema)
    table = client.create_table(table)
# Verify
table = client.get_table(s_table_id)
print(
    "Found {} rows and {} columns in {}".format(
        table.num_rows, len(table.schema), s_table_id
    )
)
# Update table property
#   in the manner of https://cloud.google.com/bigquery/docs/samples/bigquery-update-table-expiration
import datetime
table = client.get_table(s_table_id)
table.expires = datetime.datetime.now() + datetime.timedelta(hours = 2)
client.update_table(table, ['expires'])
# Try to access the table -- you'll get a "not found" error
table = client.get_table(s_table_id)

推荐答案

您正在设置表在两小时后过期 - 所以可能与时区有关.检查这个理论"例如尝试设置 24 小时，看看问题是否仍然存在

You are setting to expire table in two hours - so might be timezone related. to check this "theory" try to set 24 hours for example and see if issue still exists

这篇关于从 Python 更新 BigQuery 表属性会使表消失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！