INFORMATION_SCHEMA.RESERVATION_CHANGES 뷰에는 관리 프로젝트 내에 있는 모든 예약 변경사항에 대한 거의 실시간에 가까운 목록이 포함됩니다. 각 행은 단일 예약에 대한 변경사항을 나타냅니다. 자세한 내용은 예약 소개를 참조하세요.
필요한 권한
INFORMATION_SCHEMA.RESERVATION_CHANGES 뷰를 쿼리하려면 bigquery.reservations.list Identity and Access Management(IAM) 권한이 필요합니다.
사전 정의된 다음 IAM 역할에는 각각 필수 권한이 포함되어 있습니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-08-19(UTC)"],[[["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.RESERVATION_CHANGES\u003c/code\u003e view provides a real-time log of all changes made to reservations within the administration project, with each row representing a single change event.\u003c/p\u003e\n"],["\u003cp\u003eQuerying this view requires the \u003ccode\u003ebigquery.reservations.list\u003c/code\u003e IAM permission, which is included in several predefined roles like \u003ccode\u003eroles/bigquery.resourceAdmin\u003c/code\u003e and \u003ccode\u003eroles/bigquery.user\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eEach entry in the view includes details like the \u003ccode\u003echange_timestamp\u003c/code\u003e, \u003ccode\u003eproject_id\u003c/code\u003e, \u003ccode\u003ereservation_name\u003c/code\u003e, \u003ccode\u003eaction\u003c/code\u003e (CREATE, UPDATE, DELETE), and other information about the change.\u003c/p\u003e\n"],["\u003cp\u003eThe view retains data on current and deleted reservations for up to 41 days before they are removed.\u003c/p\u003e\n"],["\u003cp\u003eQueries to this view need to specify a region using a region qualifier, and the query execution location must match the region of the view.\u003c/p\u003e\n"]]],[],null,["# RESERVATION_CHANGES view\n========================\n\nThe `INFORMATION_SCHEMA.RESERVATION_CHANGES` view contains a near real-time list\nof all changes to reservations within the administration project. Each row\nrepresents a change to a single reservation. For more information, see\n[Introduction to reservations](/bigquery/docs/reservations-intro).\n\nRequired permission\n-------------------\n\nTo query the `INFORMATION_SCHEMA.RESERVATION_CHANGES` view, you need\nthe `bigquery.reservations.list` Identity and Access Management (IAM) permission on the\nproject.\nEach of the following predefined IAM roles includes the required\npermission:\n\n- BigQuery Resource Admin (`roles/bigquery.resourceAdmin`)\n- BigQuery Resource Editor (`roles/bigquery.resourceEditor`)\n- BigQuery Resource Viewer (`roles/bigquery.resourceViewer`)\n- BigQuery User (`roles/bigquery.user`)\n- BigQuery Admin (`roles/bigquery.admin`)\n\nFor more information about BigQuery permissions, see\n[BigQuery IAM roles and permissions](/bigquery/docs/access-control).\n\nSchema\n------\n\nThe `INFORMATION_SCHEMA.RESERVATION_CHANGES` view has the\nfollowing schema:\n\nData retention\n--------------\n\nThis view contains current reservations and deleted reservations that are\nkept for a maximum of 41 days after which they are removed\nfrom the view.\n\nScope and syntax\n----------------\n\nQueries against this view must include a [region qualifier](/bigquery/docs/information-schema-intro#syntax).\nIf you do not specify a regional qualifier, metadata is retrieved from all\nregions. The following table explains the region scope for this view:\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\nExample\n-------\n\nThe following example gets the history of changes for a given reservation. Use\nthis information to see the list of changes made to a specific reservation, such\nas creating or deleting the reservation. \n\n```googlesql\nSELECT\n *\nFROM\n reservation-admin-project.`region-us`.\n INFORMATION_SCHEMA.RESERVATION_CHANGES\nWHERE\n reservation_name = \"\u003cvar translate=\"no\"\u003emy-reservation\u003c/var\u003e\"\nORDER BY\n change_timestamp DESC;\n```"]]
