[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-03-24。"],[[["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.BI_CAPACITY_CHANGES\u003c/code\u003e view provides a history of all changes made to the BI Engine capacity within a project.\u003c/p\u003e\n"],["\u003cp\u003eYou need the \u003ccode\u003ebigquery.bireservations.get\u003c/code\u003e IAM permission to query the \u003ccode\u003eINFORMATION_SCHEMA.BI_CAPACITY_CHANGES\u003c/code\u003e view for BI Engine reservations.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view's query results represents a single update to the BI Engine capacity, and it contains details like the timestamp, project information, size, user, and preferred tables.\u003c/p\u003e\n"],["\u003cp\u003eQueries against the \u003ccode\u003eINFORMATION_SCHEMA.BI_CAPACITY_CHANGES\u003c/code\u003e view must include a region qualifier, and a project ID is optional.\u003c/p\u003e\n"],["\u003cp\u003eThe BI_CAPACITY_CHANGES view includes the details of who made changes to the capacity, which may be a user email, a subject of workforce identity federation, or even Google itself.\u003c/p\u003e\n"]]],[],null,["# INFORMATION_SCHEMA.BI_CAPACITY_CHANGES view\n===========================================\n\nThe `INFORMATION_SCHEMA.BI_CAPACITY_CHANGES` view contains history of changes\nto the BI Engine capacity. If you want to view the current state\nof BI Engine reservation, see the\n[`INFORMATION_SCHEMA.BI_CAPACITIES` view](/bigquery/docs/information-schema-bi-capacities).\n\nRequired permission\n-------------------\n\nTo query the `INFORMATION_SCHEMA.BI_CAPACITY_CHANGES` view, you need the\n`bigquery.bireservations.get` Identity and Access Management (IAM) permission for\nBI Engine reservations.\n\nFor more information about BigQuery permissions, see\n[Access control with IAM](/bigquery/docs/access-control).\n\nSchema\n------\n\nWhen you query the `INFORMATION_SCHEMA.BI_CAPACITY_CHANGES` view, the query\nresults contain one row for each update of BI Engine capacity,\nincluding the current state.\n\nThe `INFORMATION_SCHEMA.BI_CAPACITY_CHANGES` view has the following schema:\n\nSyntax\n------\n\nQueries against this view must include a\n[region qualifier](/bigquery/docs/information-schema-intro#syntax). A project ID\nis optional. If no project ID is specified, the project that the query runs\nin is used.\n\nReplace the following:\n\n- Optional: \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: the ID of your Google Cloud project. If not specified, the default project is used.\n- \u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e: any [dataset region name](/bigquery/docs/locations). For example, ```region-us```.\n\n \u003cbr /\u003e\n\n \u003cbr /\u003e\n\n | **Note:** You must use [a region qualifier](/bigquery/docs/information-schema-intro#region_qualifier) to query `INFORMATION_SCHEMA` views. The location of the query execution must match the region of the `INFORMATION_SCHEMA` view.\n\n\u003cbr /\u003e\n\n -- Returns the history of BI Engine capacity.\n SELECT * FROM myproject.`region-us`.INFORMATION_SCHEMA.BI_CAPACITY_CHANGES;\n\nExamples\n--------\n\nThe following example retrieves the current BI Engine capacity\nchanges from the `INFORMATION_SCHEMA.BI_CAPACITY_CHANGES` view.\n\nTo run the query against a project other than the project that the query is\nrunning in, add the project ID to the region in the following format:\n```````\u003cvar translate=\"no\"\u003eproject_id\u003c/var\u003e````.````\u003cvar translate=\"no\"\u003eregion_id\u003c/var\u003e````.INFORMATION_SCHEMA.BI_CAPACITY_CHANGES```.\n\nThe following example gets all changes made to BI Engine capacity\nby a user with email `email@mycompanymail.com`: \n\n SELECT *\n FROM `my-project-id.region-us`.INFORMATION_SCHEMA.BI_CAPACITY_CHANGES\n WHERE user_email = \"email@mycompanymail.com\"\n\nThe result looks similar to the following:\n\n\u003cbr /\u003e\n\n```\n +---------------------+---------------+----------------+------------------+--------------+---------------------+----------------------------------------------------------------------------------------+\n | change_timestamp | project_id | project_number | bi_capacity_name | size | user_email | preferred_tables |\n +---------------------+---------------+----------------+------------------+--------------+---------------------+----------------------------------------------------------------------------------------+\n | 2022-06-14 02:22:18 | my-project-id | 123456789000 | default | 268435456000 | email@mycompany.com | [\"my-project-id.dataset1.table1\",\"bigquery-public-data.chicago_taxi_trips.taxi_trips\"] |\n | 2022-06-08 20:25:51 | my-project-id | 123456789000 | default | 268435456000 | email@mycompany.com | [\"bigquery-public-data.chicago_taxi_trips.taxi_trips\"] |\n | 2022-04-01 21:06:49 | my-project-id | 123456789000 | default | 161061273600 | email@mycompany.com | [\"\"] |\n +---------------------+---------------+----------------+------------------+--------------+---------------------+----------------------------------------------------------------------------------------+\n \n```\n\n\u003cbr /\u003e\n\nThe following example gets BI Engine capacity changes for the last\nseven days: \n\n SELECT\n change_timestamp,\n size,\n user_email,\n preferred_tables\n FROM `my-project-id.region-us`.INFORMATION_SCHEMA.BI_CAPACITY_CHANGES\n WHERE change_timestamp \u003e TIMESTAMP_SUB(CURRENT_DATE(), INTERVAL 7 DAY)\n\nThe result looks similar to the following:\n\n\u003cbr /\u003e\n\n```\n +---------------------+--------------+----------------------+-------------------+\n | change_timestamp | size | user_email | preferred_tables | |\n +---------------------+--------------+----------------------+-------------------+\n | 2023-07-08 18:25:09 | 268435456000 | sundar@mycompany.com | [\"\"] |\n | 2023-07-09 17:47:26 | 161061273600 | pichai@mycompany.com | [\"pr.dataset.t1\"] |\n +---------------------+--------------+----------------------+-------------------+\n \n```\n\n\u003cbr /\u003e"]]
