PROPERTY_GRAPHS view

The INFORMATION_SCHEMA.PROPERTY_GRAPHS view contains one row for each property graph in the dataset or region that you specify.

Required permissions

To get the permissions that you need to query the INFORMATION_SCHEMA.PROPERTY_GRAPHS view, ask your administrator to grant you the following IAM roles on the project:

For more information about granting roles, see Manage access to projects, folders, and organizations.

These predefined roles contain the permissions required to query the INFORMATION_SCHEMA.PROPERTY_GRAPHS view. To see the exact permissions that are required, expand the Required permissions section:

Required permissions

The following permissions are required to query the INFORMATION_SCHEMA.PROPERTY_GRAPHS view:

  • bigquery.propertyGraphs.get
  • bigquery.propertyGraphs.list

You might also be able to get these permissions with custom roles or other predefined roles.

For more information about BigQuery permissions, see Access control with IAM.

Schema

When you query the INFORMATION_SCHEMA.PROPERTY_GRAPHS view, the query results contain one row for each property graph in the resource scope that you specify.

The INFORMATION_SCHEMA.PROPERTY_GRAPHS view has the following schema:

Column name Data type Value
property_graph_catalog STRING The name of the project that contains the dataset where the property graph is defined.
property_graph_schema STRING The name of the dataset that contains the property graph.
property_graph_name STRING The name of the property graph.
property_graph_metadata_json STRING The JSON representation of the property graph definition. This representation contains information about the graph, such as its nodes, edges, labels, properties, creation timestamp, and modification timestamps.
ddl STRING A DDL statement that can be used to create the property graph.

Scope and syntax

Queries against this view must include a dataset or a region qualifier. For queries with a dataset qualifier, you must have permissions for the dataset. For queries with a region qualifier, you must have permissions for the project. For more information see Syntax. The following table explains the region and resource scopes for this view:

View name Resource scope Region scope
[PROJECT_ID.]`region-REGION`.INFORMATION_SCHEMA.PROPERTY_GRAPHS Project level REGION
[PROJECT_ID.]DATASET_ID.INFORMATION_SCHEMA.PROPERTY_GRAPHS Dataset level Dataset location
Replace the following:
  • Optional: PROJECT_ID: the ID of your Google Cloud project. If not specified, the default project is used.
  • REGION: any dataset region name. For example, `region-us`.
  • DATASET_ID: the ID of your dataset. For more information, see Dataset qualifier.

Example

The following example retrieves the property_graph_name, property_graph_metadata_json, and ddl columns from the INFORMATION_SCHEMA.PROPERTY_GRAPHS view:

SELECT
  property_graph_name, property_graph_metadata_json, ddl
FROM
  `region-REGION`.INFORMATION_SCHEMA.PROPERTY_GRAPHS;

The result is similar to the following:

+---------------------+------------------------------------------------+------------------------------------------------------+
| property_graph_name | property_graph_metadata_json                   | ddl                                                  |
+---------------------+------------------------------------------------+------------------------------------------------------+
| FinGraph            | {"creationTime":"2026-01-05T22:22:22.365394Z", | CREATE PROPERTY GRAPH `my_project.graph_db.FinGraph` |
|                     | "edgeTables":[{"dataSourceTable":{"datasetId": | NODE TABLES (`my_project.graph_db.Account` AS        |
|                     | "graph_db","projectId":"my_project","tableId   | Account KEY (id)                                     |
|                     | ...                                            | ...                                                  |
+---------------------+------------------------------------------------+------------------------------------------------------+