[[["わかりやすい","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.SCHEMATA_LINKS\u003c/code\u003e view provides information about linked datasets, with each row representing a single linked dataset accessible to the user.\u003c/p\u003e\n"],["\u003cp\u003eQuerying this view requires the \u003ccode\u003ebigquery.datasets.get\u003c/code\u003e IAM permission at the project level, which is included in roles like \u003ccode\u003eroles/bigquery.admin\u003c/code\u003e, \u003ccode\u003eroles/bigquery.dataEditor\u003c/code\u003e, \u003ccode\u003eroles/bigquery.dataOwner\u003c/code\u003e, and \u003ccode\u003eroles/bigquery.dataViewer\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe view's schema includes details like the catalog and schema names, linked dataset project name and number, linked dataset name, creation time, and the organization display name.\u003c/p\u003e\n"],["\u003cp\u003eQueries against \u003ccode\u003eSCHEMATA_LINKS\u003c/code\u003e must use a region qualifier to specify the region, and the execution location of the query needs to match the region of the \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e view.\u003c/p\u003e\n"],["\u003cp\u003eYou can use \u003ccode\u003eSCHEMATA_LINKS\u003c/code\u003e to list all linked datasets against another project, or list all linked datasets by a shared dataset by using the relevant example queries.\u003c/p\u003e\n"]]],[],null,["# SCHEMATA_LINKS view\n===================\n\nThe `INFORMATION_SCHEMA.SCHEMATA_LINKS` view contains one row for each linked\ndataset. A linked dataset links to a shared dataset in a project to which the\ncurrent user has access.\n\nRequired permission\n-------------------\n\nTo query the `INFORMATION_SCHEMA.SCHEMATA_LINKS` view, you need the\n`bigquery.datasets.get` Identity and Access Management (IAM) permission at the project\nlevel.\n\nEach of the following predefined IAM roles includes the\npermissions that you need in order to query the\n`INFORMATION_SCHEMA.SCHEMATA_LINKS` view:\n\n- `roles/bigquery.admin`\n- `roles/bigquery.dataEditor`\n- `roles/bigquery.dataOwner`\n- `roles/bigquery.dataViewer`\n\nFor more information about BigQuery permissions, see [Access\ncontrol with IAM](/bigquery/docs/access-control).\n\nSchema\n------\n\nThe `INFORMATION_SCHEMA.SCHEMATA_LINKS` view has the following schema:\n\nScope and syntax\n----------------\n\nQueries against this view must include a [region\nqualifier](/bigquery/docs/information-schema-intro#syntax). If you do not\nspecify a regional qualifier, metadata is retrieved from the US region. The\nfollowing 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\nExamples\n--------\n\nThis section lists examples to query the `INFORMATION_SCHEMA.SCHEMATA_LINKS`\nview.\n\n**Example: List all linked datasets against another project**\n\nThe following example lists all the linked datasets against another project\nnamed `otherproject` within the `eu` region: \n\n```\nSELECT * FROM `otherproject`.`region-eu`.INFORMATION_SCHEMA.SCHEMATA_LINKS;\n```\n\nThe output is similar to the following. Some columns are omitted to simplify the\noutput. \n\n```\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n| catalog_name | schema_name | linked_schema_catalog_name | linked_schema_catalog_number | linked_schema_name | linked_schema_org_display_name |\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n| otherproject | myschema1 | subscriptionproject1 | 974999999291 | subscriptionld1 | subscriptionorg2 |\n| otherproject | myschema2 | subscriptionproject2 | 974999999292 | subscriptionld2 | subscriptionorg2 |\n| otherproject | myschema3 | subscriptionproject3 | 974999999293 | subscriptionld3 | subscriptionorg3 |\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n```\n\n**Example: List all linked datasets by a shared dataset**\n\nThe following example lists all the all the linked datasets by a shared dataset\nnamed `sharedataset` in the `US` multi-region: \n\n```\nSELECT * FROM INFORMATION_SCHEMA.SCHEMATA_LINKS WHERE schema_name = 'sharedataset';\n```\n\nThe output is similar to the following. Some columns are omitted to simplify the\noutput. \n\n```\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n| catalog_name | schema_name | linked_schema_catalog_name | linked_schema_catalog_number | linked_schema_name | linked_schema_org_display_name |\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n| myproject | sharedataset| subscriptionproject1 | 674999999291 | subscriptionld1 | subscriptionorg1 |\n| myproject | sharedataset| subscriptionproject2 | 774999999292 | subscriptionld2 | subscriptionorg3 |\n+----------------+-------------+----------------------------+------------------------------+--------------------+--------------------------------+\n```"]]
