데이터 제공업체는 목록의 사용량 측정항목을 추적할 수 있습니다. 공유 데이터의 사용량 측정항목을 가져오는 방법에는 두 가지가 있습니다.
BigQuery Sharing(이전 명칭: Analytics Hub)을 사용합니다. Sharing을 사용하면 일일 구독, 실행된 일일 작업, 각 조직의 구독자 수, 각 테이블의 작업 빈도가 포함된 목록의 사용량 측정항목 대시보드를 볼 수 있습니다. 공유 데이터의 사용량 측정항목은 INFORMATION_SCHEMA.SHARED_DATASET_USAGE 뷰를 쿼리하여 검색됩니다.
INFORMATION_SCHEMA 뷰를 사용합니다. INFORMATION_SCHEMA.SHARED_DATASET_USAGE 뷰를 직접 쿼리하여 구독자가 데이터 세트를 사용하는 방식을 추적할 수 있습니다.
Sharing 사용
Sharing을 사용하여 공유 데이터의 사용량 측정항목을 가져오려면 다음 단계를 수행합니다.
Google Cloud 콘솔에서 Sharing(Analytics Hub) 페이지로 이동합니다.
[[["이해하기 쉬움","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\u003eData providers can track usage metrics for their shared data listings using two primary methods: Analytics Hub and the \u003ccode\u003eINFORMATION_SCHEMA.SHARED_DATASET_USAGE\u003c/code\u003e view.\u003c/p\u003e\n"],["\u003cp\u003eAnalytics Hub provides a dashboard view of listing usage, including total subscriptions, subscribers, executed jobs, and bytes scanned, with data available for up to 60 days.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.SHARED_DATASET_USAGE\u003c/code\u003e view allows for direct querying to track subscriber activity, such as total jobs executed, most used tables, and top consuming organizations.\u003c/p\u003e\n"],["\u003cp\u003eYou can use the provided example queries to help check subscriber behavior, such as the number of jobs they run, the tables they are utilizing the most, or which orginizations are using it the most.\u003c/p\u003e\n"],["\u003cp\u003eWhen a data exchange and source datasets are in separate projects, usage metrics can be viewed by querying \u003ccode\u003eINFORMATION_SCHEMA.SHARED_DATASET_USAGE\u003c/code\u003e and specifying both the source dataset and data exchange.\u003c/p\u003e\n"]]],[],null,["# Monitor listings\n================\n\nAs a data provider, you can track the usage metrics for your listings. There are\ntwo methods to get the usage metrics for your shared data:\n\n- [Use BigQuery sharing (formerly Analytics Hub)](#use-analytics-hub). With Sharing\n you can view the usage metrics dashboard for your listings that includes\n daily subscriptions, daily executed jobs, number of subscribers for each\n organization, and jobs frequency for each table. The usage metrics for your\n shared data is retrieved by querying the\n `INFORMATION_SCHEMA.SHARED_DATASET_USAGE` view.\n\n- [Use the `INFORMATION_SCHEMA` view](#use-information-schema). You can track\n how subscribers use your datasets by directly querying the\n `INFORMATION_SCHEMA.SHARED_DATASET_USAGE` view.\n\nUse Sharing\n-----------\n\nTo get the usage metrics for your shared data by using Sharing,\nfollow these steps:\n\n1. In the Google Cloud console, go to the **Sharing (Analytics Hub)** page.\n\n [Go to Sharing (Analytics Hub)](https://console.cloud.google.com/bigquery/analytics-hub)\n2. Click the [data exchange](/bigquery/docs/analytics-hub-introduction#data_exchanges)\n name that contains the listing for which you want to view the usage metrics.\n\n3. Click **Usage metrics**, and then do the following:\n\n 1. From the **Listings** menu, select the listing.\n\n 2. Set the time range.\n\nThe page displays the following usage metrics:\n\n- **Total Subscriptions:** the number of current subscriptions on the selected listing. You can view total subscriptions for up to 60 days.\n- **Total Subscribers:** the number of unique subscribers across all subscriptions on the selected listing. You can view total subscribers for up to 60 days.\n- **Total jobs executed:** the number of unique jobs run on each table of the selected listing.\n- **Total bytes scanned:** the total number of bytes scanned from all tables of the selected listing.\n- **Daily Subscriptions:** the chart that tracks the number of subscriptions for the selected listing over a time period. You can view daily subscriptions for up to 60 days.\n- **Subscribers per organization:** lists the organizations and their number of subscribers that consume your selected listing.\n- **Daily Executed Jobs:** this chart displays the jobs consumption from the selected listing.\n- **Tables' job frequency:** the frequency at which the tables are accessed on the selected listing.\n\n| **Note:** You can also use the [Analytics Hub subscriber APIs](/bigquery/docs/reference/analytics-hub/rest/v1/projects.locations.subscriptions/list) to retrieve the **Total Subscriptions** , **Total Subscribers** , and **Daily Subscriptions** fields.\n\nUse `INFORMATION_SCHEMA` view\n-----------------------------\n\nIf you are a data provider, you can track how subscribers use your datasets by\nquerying the [`INFORMATION_SCHEMA.SHARED_DATASET_USAGE` view](/bigquery/docs/information-schema-shared-dataset-usage).\nEnsure that you have the required role to query this view.\n\nTo run the query against a project other than your default project, add the\nproject ID in the following format:\n\n`PROJECT_ID``.``region-REGION_NAME``.INFORMATION_SCHEMA.SHARED_DATASET_USAGE`\n\nFor example, `myproject.region-us.INFORMATION_SCHEMA.SHARED_DATASET_USAGE`.\n\nThe following examples describe how to view the usage metrics by querying the\n`INFORMATION_SCHEMA` view:\n\n### Get the total number of jobs executed on all shared tables\n\nThe following example calculates total jobs run by [subscribers](/bigquery/docs/analytics-hub-view-subscribe-listings) for a project: \n\n```googlesql\nSELECT\n COUNT(DISTINCT job_id) AS num_jobs\nFROM\n `region-us`.INFORMATION_SCHEMA.SHARED_DATASET_USAGE\n```\n\nThe result is similar to the following: \n\n```\n+------------+\n| num_jobs |\n+------------+\n| 1000 |\n+------------+\n```\n\nTo check the total jobs run by subscribers, use the `WHERE` clause:\n\n- For datasets, use `WHERE dataset_id = \"...\"`.\n- For tables, use `WHERE dataset_id = \"...\" AND table_id = \"...\"`.\n\n### Get the most used table based on the number of rows processed\n\nThe following query calculates the most used table based on the number of rows\nprocessed by subscribers. \n\n```googlesql\nSELECT\n dataset_id,\n table_id,\n SUM(num_rows_processed) AS usage_rows\nFROM\n `region-us`.INFORMATION_SCHEMA.SHARED_DATASET_USAGE\nGROUP BY\n 1,\n 2\nORDER BY\n 3 DESC\nLIMIT\n 1\n```\n\nThe output is similar to the following: \n\n```\n+---------------+-------------+----------------+\n| dataset_id | table_id | usage_rows |\n+---------------+-------------+----------------+\n| mydataset | mytable | 15 |\n+---------------+-------------+----------------+\n```\n\n### Find the top organizations that consume your tables\n\nThe following query calculates the top subscribers based on the number of bytes\nprocessed from your tables. You can also use the `num_rows_processed` column as\na metric. \n\n```googlesql\nSELECT\n subscriber_org_number,\n ANY_VALUE(subscriber_org_display_name) AS subscriber_org_display_name,\n SUM(total_bytes_processed) AS usage_bytes\nFROM\n `region-us`.INFORMATION_SCHEMA.SHARED_DATASET_USAGE\nGROUP BY\n 1\n```\n\nThe output is similar to the following: \n\n```\n+--------------------------+--------------------------------+----------------+\n|subscriber_org_number | subscriber_org_display_name | usage_bytes |\n+-----------------------------------------------------------+----------------+\n| 12345 | myorganization | 15 |\n+--------------------------+--------------------------------+----------------+\n```\n\nFor subscribers without an organization, you can use `job_project_number`\ninstead of `subscriber_org_number`.\n\n### Get usage metrics for your data exchange\n\nIf your [data exchange](/bigquery/docs/analytics-hub-introduction#data_exchanges)\nand source dataset are in different projects, follow\nthese step to view the usage metrics for your data exchange:\n\n1. Find all [listings](/bigquery/docs/analytics-hub-introduction#listings) that belong to your data exchange.\n2. Retrieve the source dataset attached to the listing.\n3. To view the usage metrics for your data exchange, use the following query:\n\n```googlesql\nSELECT\n *\nFROM\n source_project_1.`region-us`.INFORMATION_SCHEMA.SHARED_DATASET_USAGE\nWHERE\n dataset_id='source_dataset_id'\nAND data_exchange_id=\"projects/4/locations/us/dataExchanges/x1\"\nUNION ALL\nSELECT\n *\nFROM\n source_project_2.`region-us`.INFORMATION_SCHEMA.SHARED_DATASET_USAGE\nWHERE\n dataset_id='source_dataset_id'\nAND data_exchange_id=\"projects/4/locations/us/dataExchanges/x1\"\n```\n\nWhat's next\n-----------\n\n- Learn how to [manage Sharing listings](/bigquery/docs/analytics-hub-manage-listings).\n- Learn about [BigQuery pricing](/bigquery/pricing)."]]
