INFORMATION_SCHEMA.SESSIONS_BY_PROJECT 뷰에는 현재 프로젝트의 모든 BigQuery 세션에 대한 실시간 메타데이터가 포함됩니다.
필수 권한
INFORMATION_SCHEMA.SESSIONS_BY_PROJECT 뷰를 쿼리하려면 프로젝트에 대한 bigquery.jobs.listAll 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-09-04(UTC)"],[[["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.SESSIONS_BY_PROJECT\u003c/code\u003e view provides real-time metadata for all BigQuery sessions within a project.\u003c/p\u003e\n"],["\u003cp\u003eAccessing this view requires the \u003ccode\u003ebigquery.jobs.listAll\u003c/code\u003e IAM permission, which is included in the Project Owner and BigQuery Admin roles.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the query results corresponds to a single BigQuery session, containing information like creation time, expiration time, and user details.\u003c/p\u003e\n"],["\u003cp\u003eThis view retains data for currently running sessions and those completed within the past 180 days.\u003c/p\u003e\n"],["\u003cp\u003eQueries against this view must include a region qualifier, specifying the dataset region, and the query execution location must match the region of the view.\u003c/p\u003e\n"]]],[],null,["# SESSIONS_BY_PROJECT view\n========================\n\nThe `INFORMATION_SCHEMA.SESSIONS_BY_PROJECT` view contains real-time\nmetadata about all BigQuery sessions in the current project.\n\nRequired permissions\n--------------------\n\nTo query the `INFORMATION_SCHEMA.SESSIONS_BY_PROJECT` view, you need\nthe `bigquery.jobs.listAll` Identity and Access Management (IAM) permission for the project.\nEach of the following predefined IAM roles includes the\nrequired permission:\n\n- Project Owner\n- BigQuery Admin\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.SESSIONS_BY_*` views, the query results\ncontain one row for each BigQuery session.\n\nThe `INFORMATION_SCHEMA.SESSIONS_BY_*` view has the following schema:\n| **Note:** The underlying data is partitioned by the `creation_time` column and clustered by `project_id` and `user_email`.\n\nData retention\n--------------\n\nThis view contains currently running sessions and the history of sessions\ncompleted in the past 180 days.\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\nTo run the query against a project other than your default project, add the\nproject ID in the following format: \n\n```bash\n`PROJECT_ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.SESSIONS_BY_PROJECT\n```\nFor example, ```myproject`.`region-us`.INFORMATION_SCHEMA.SESSIONS_BY_PROJECT``. The following example lists all users or service accounts that created sessions for a given project within the last day:\n\n\u003cbr /\u003e\n\n```googlesql\nSELECT\n DISTINCT(user_email) AS user\nFROM\n `region-us`.INFORMATION_SCHEMA.SESSIONS_BY_PROJECT\nWHERE\n is_active = true\n AND creation_time \u003e= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY);\n```\n| **Note:** `INFORMATION_SCHEMA` view names are case-sensitive.\n\nThe result is similar to the following: \n\n```\n+--------------+\n| user |\n+--------------+\n| abc@xyz.com |\n+--------------+\n| def@xyz.com |\n+--------------+\n```"]]
