This product or feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of theService Specific Terms. Pre-GA products and features are available "as is" and might have limited support. For more information, see thelaunch stage descriptions.

This document describes how to create and manage analytics views. Afteryou create an analytics view, you can query it in a manner similar to queryinglog views. If you aren't familiar with analytics views, then seeAbout analytics views.

Before you begin

1. Verify that billing is enabled for your Google Cloud project.

2. To get the permissions that you need to create, manage, and use analytics views, ask your administrator to grant you the following IAM roles on your project:

   • Observability Analytics User (roles/observability.analyticsUser)
   • Logs View Accessor (roles/logging.viewAccessor)

   You can restrict a principal to a specific log view either by adding an IAM condition to the Logs View Accessor role grant made at the project level, or by adding an IAM binding to the policy file of the log view. For more information, seeControl access to a log view.

   For information about additional roles that you need to query views on user-defined buckets or to query the_AllLogs view of the_Default log bucket, seeCloud Logging roles.

3. Make sure that you have a log bucket that is upgraded to use Log Analytics. For information about this step, seeConfigure log buckets.

Create an analytics view

1. In the Google Cloud console, go to theLog Analytics page:

   Go toLog Analytics

   If you use the search bar to find this page, then select the result whose subheading isLogging.

2. Configure theLog Analytics page:
   1. Make sure that the toolbar displaysRun query. If the toolbar displaysRun in BigQuery, then clicksettingsSettings and selectLog Analytics (default).
   2. If theViews menu isn't shown, then go to the navigation pane and clicklast_pageViews and Schema.

3. Enter and validate the query that you want to save as an analytics view.

   You might want to load and edit the default query for thelog view that your analytics view will query.To load the default query, do the following:

   1. In theViews menu, go to thesegmentLogs section, find and then select thelog view that you want to query.

   2. In theSchema toolbar, clickQuery, and thenclickOverwrite.

      TheQuery pane is updated with a SQL query.

   3. Update the query until you're satisfied with the query results.

4. Create an analytics view:

   1. In the toolbar, clicksaveSave, and then selectSave as analytics view.

   2. Enter a name and description for the analytics view.

      The name is limited to 100 characters and can include only letters,digits, underscores, and hyphens.. You can't change the name after youcreate the analytics view.

   3. ClickSave.

   The system creates your analytics view and lists it in theViews pane,in thedata_tableAnalytics Views section.

Query an analytics view

You query an analytics view in a manner analogous to queryinglog views. To query analytics views ,use the following format for theFROM clause:

FROM`analytics_view.PROJECT_ID.LOCATION.ANALYTICS_VIEW_ID`

The fields in the previous expressions have the following meaning:

• PROJECT_ID: The identifier of the project.
• LOCATION: The location of the analytics view.
• ANALYTICS_VIEW_ID: The ID of the analytics view, which is limited to 100 characters and can include only letters,digits, underscores, and hyphens.

To learn more, seeQuery and analyze logs overview.

List analytics views

To list the analytics views in your Google Cloud project, do the following:

1. In the Google Cloud console, go to theLog Analytics page:

   Go toLog Analytics

   If you use the search bar to find this page, then select the result whose subheading isLogging.

2. Configure theLog Analytics page:
   1. Make sure that the toolbar displaysRun query. If the toolbar displaysRun in BigQuery, then clicksettingsSettings and selectLog Analytics (default).
   2. If theViews menu isn't shown, then go to the navigation pane and clicklast_pageViews and Schema.

3. In theViews menu, go to thedata_tableAnalytics Views section.

Get details about an analytics views

You can use options in theSchema pane to display the following informationabout an analytics view:

• Name.
• Create date.
• Last update.
• Schema.
• Query.

To view the details for an analytics views, list the analytics viewsin your project, and then do the following:

1. Select the analytics view whose information you want to view.
2. In theSchema toolbarclickmore_vertView analytics view options,and selectView details.

Modify an analytics view

To modify an analytics view, do the following:

1. In the Google Cloud console, go to theLog Analytics page:

   Go toLog Analytics

   If you use the search bar to find this page, then select the result whose subheading isLogging.

2. Configure theLog Analytics page:
   1. Make sure that the toolbar displaysRun query. If the toolbar displaysRun in BigQuery, then clicksettingsSettings and selectLog Analytics (default).
   2. If theViews menu isn't shown, then go to the navigation pane and clicklast_pageViews and Schema.

3. In theViews menu, go to thedata_tableAnalytics Views section, and selectthe analytics view that you want to modify.

4. In theSchema toolbar,clickmore_vertView analytics view options,and selectEdit view.

   A dialog opens that displays information about the analytics view.You can modify the description and query.

5. After you complete your modifications, clickOverwrite saved view.

Delete an analytics view

1. In the Google Cloud console, go to theLog Analytics page:

   Go toLog Analytics

   If you use the search bar to find this page, then select the result whose subheading isLogging.

2. Configure theLog Analytics page:
   1. Make sure that the toolbar displaysRun query. If the toolbar displaysRun in BigQuery, then clicksettingsSettings and selectLog Analytics (default).
   2. If theViews menu isn't shown, then go to the navigation pane and clicklast_pageViews and Schema.

3. In theViews menu, go to thedata_tableAnalytics Views section, and selectthe analytics view that you want to delete.
4. In theSchema toolbar,clickmore_vertView analytics view options,selectDelete view, and complete the dialog.

Limitations

The following limitations apply to analytics views:

• An analytics view can only query log views.
• The parent resource of an analytics view must be a Google Cloud project.
• You can only query an analytics view by using theLog Analytics page,and only when you use theLog Analytics (default) query engine.
• All views that an analytics view queries must be in the same location.
• You must use the Google Cloud console to create or manage youranalytics views.
• You can create at most 100analytics views per Google Cloud project.
• You can create a most 50analytics views per region.
• Per Google Cloud project, at most 10regions can contain an analytics view.

What's next

• Query and analyze logs overview
• Save and share a SQL query
• Chart SQL query results
• Sample SQL queries