创建 BigQuery 表的快照
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
演示如何从托管式 BigQuery 表创建快照表。
代码示例
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis content demonstrates how to create a snapshot table from an existing managed BigQuery table.\u003c/p\u003e\n"],["\u003cp\u003eThe provided Python code sample utilizes the \u003ccode\u003egoogle.cloud.bigquery\u003c/code\u003e library to create the snapshot.\u003c/p\u003e\n"],["\u003cp\u003eSetting up Application Default Credentials is required for authenticating to BigQuery before running the code.\u003c/p\u003e\n"],["\u003cp\u003eThe process involves specifying the source table ID and the desired snapshot table ID within the code.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003ebigquery.OperationType.SNAPSHOT\u003c/code\u003e is used to identify the operation as creating a snapshot when configuring the copy job.\u003c/p\u003e\n"]]],[],null,["# create a snapshot of a BigQuery table\n\nDemonstrates creating a snapshot table from a managed BigQuery table.\n\nCode sample\n-----------\n\n### Python\n\n\nBefore trying this sample, follow the Python setup instructions in the\n[BigQuery quickstart using\nclient libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n\n\nFor more information, see the\n[BigQuery Python API\nreference documentation](/python/docs/reference/bigquery/latest).\n\n\nTo authenticate to BigQuery, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for client libraries](/bigquery/docs/authentication#client-libs).\n\n from google.cloud import https://cloud.google.com/python/docs/reference/bigquery/latest/\n\n # TODO(developer): Set table_id to the ID of the table to create.\n source_table_id = \"your-project.your_dataset.your_table_name\"\n snapshot_table_id = \"your-project.your_dataset.snapshot_table_name\"\n\n # Construct a BigQuery client object.\n client = https://cloud.google.com/python/docs/reference/bigquery/latest/.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.client.Client.html()\n copy_config = https://cloud.google.com/python/docs/reference/bigquery/latest/.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.CopyJobConfig.html()\n copy_config.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.CopyJobConfig.html#google_cloud_bigquery_job_CopyJobConfig_operation_type = https://cloud.google.com/python/docs/reference/bigquery/latest/.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.OperationType.html.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.job.OperationType.html#google_cloud_bigquery_job_OperationType_SNAPSHOT\n\n copy_job = client.https://cloud.google.com/python/docs/reference/bigquery/latest/google.cloud.bigquery.client.Client.html#google_cloud_bigquery_client_Client_copy_table(\n sources=source_table_id,\n destination=snapshot_table_id,\n job_config=copy_config,\n )\n copy_job.result()\n\n print(\"Created table snapshot {}\".format(snapshot_table_id))\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigquery)."]]