Save and share SQL queries

Console

To save a query, do the following:

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

   Go to Log Analytics

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

2. Populate the Querypane with a query.

   You can populate the Querypane by entering a new query, by selecting a query from the Recenttab, or by selecting a query from the Savedtab.

   When the query in the Querypane is valid, the save Saveis enabled.

3. Click save Saveand complete the Nameand Descriptionfields. The values you set for these fields are shown on the Savedtab.

4. Optional: To let everyone with access to the Log Analytics page for the Google Cloud project view and run your saved query, enable the Share with projecttoggle.

   By default, this toggle is disabled and the visibility is restricted to you.

5. Click Save query.

6. Optional: To view, sort, and run saved queries that are visible to you, select the Savedtab.

   You can sort and filter your saved queries by their name, description, and visibility label. You can also filter by the contents of the query.

You can edit and delete queries that you created by using options on the Savedtab:

• To edit a query, click more_vert More Optionsand select Edit. You can modify the values for the Nameand Descriptionfields; however, the query itself can't be modified.

• To delete a saved query, click more_vert More Optionsand select Delete.

API

To save a query by using the Logging API, use the savedQueries.create method. For more information about this method, its parameters, and the response data, see the reference page for savedQueries.create .

You can execute the savedQueries.create method by using the APIs Explorer widget on the method's reference page. For Log Analytics queries, you must specify the opsAnalyticsQuery field. The following example illustrates a sample request body, which contains an instance of SavedQuery :

{
  "parent": "projects/my-project/locations/global"
  "saved_query":
  {
     "ops_analytics_query":
     {
        "sql_query_text" :
           "SELECT
           timestamp, log_name, severity, json_payload, resource, labels
           FROM
           ` TABLE_NAME_OF_LOG_VIEW 
`
           WHERE
           timestamp > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR)
           ORDER BY timestamp ASC
           LIMIT 100"
     }
     "visibility": "PRIVATE"
  }
}

Console

When troubleshooting a problem, or when you see anomalous results, you might want to share a query and its results with a teammate. When you are viewing query results on the Log Analytics page, you can copy a URL that, when opened, displays the query you ran and its results.

To share a query and results with a teammate, do the following:

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

   Go to Log Analytics

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

2. Populate the Querypane with a query and then click Run query.

   You can populate the Querypane by entering a new query, by selecting a query from the Recenttab, or by selecting a query from the Savedtab.

3. Click link Share link.

4. Send the link to your teammate.

   When your teammate opens the link, the Log Analytics page is opened. This page displays the query that you ran and the results of the query.

   To open the URL successfully, your teammate's Identity and Access Management role on the Google Cloud project must include the permissions required to view Logging pages.

API

You can use the Logging API to create a shared query by using the savedQueries.Create method, and specifying a value of SHARED in the visibility field. For more information, see the reference page for savedQueries.create .