When you load data into a table or create an empty table in BigQuery, you must specify a schema. You can use the following template table for the schema. The table defines and describes the fields associated with Gemini Notebook logs in BigQuery.
Template table for Gemini Notebook
We occasionally update the schema components on this page. When new fields are added to the template table, the next daily table generated from the template has the new fields. If you want to query new fields, query daily tables generated after the template is updated.
Learn how to specify and modify schemas in BigQuery.
| Field name | Type | Mode | Description |
|---|---|---|---|
| ai_plan_tier | ENUM | NULLABLE | The user's generative AI subscription tier at the time the event took place. Possible values:
|
| prior_visibility | ENUM | NULLABLE | Notebook visibility prior to the event. Possible values:
|
| recipient | STRING | NULLABLE | User or group whose access was modified in the event. |
| recipient_access_type | ENUM | NULLABLE | Type of access granted to or removed from the recipient. Possible values:
|
| source_id | STRING | NULLABLE | Unique identifier for the source material that's referenced in the notebook. |
| source_name | STRING | NULLABLE | Display name of the source material that's referenced in the notebook. |
| source_type | ENUM | NULLABLE | Data type of the source. Possible values:
|
| source_url | STRING | NULLABLE | URL of the source. |
| studio_artifact_id | STRING | NULLABLE | Unique identifier for the generated Google Workspace Studio artifact. |
| studio_artifact_name | STRING | NULLABLE | Display name of the Workspace Studio artifact. |
| studio_artifact_type | ENUM | NULLABLE | Data type of the Workspace Studio artifact. Possible values:
|
| visibility | ENUM | NULLABLE | Notebook visibility following the event. Possible values:
|