Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from http://cloud.google.com/bigquery/docs/saved-queries-introduction below:

Introduction to saved queries | BigQuery

Stay organized with collections Save and categorize content based on your preferences.

This document provides an introduction to saved queries in BigQuery. You can use saved queries to create and manage SQL scripts. Changes to a saved query are automatically saved so that you don't lose your work when you close the query editor. Saved queries improve collaboration and query management with the following options:

• Share saved queries with specific users and groups by using Identity and Access Management (IAM).
• Review the query version history.
• Revert to or branch from previous versions of the query.

Saved queries are BigQuery Studio code assets powered by Dataform. Notebooks are also code assets. All code assets are stored in a default region. Updating the default region changes the region for all code assets created after that point.

Saved query capabilities are available only in the Google Cloud console.

You control access to saved queries by using Identity and Access Management (IAM) roles. For more information, see Share saved queries.

BigQuery Studio lets you save, share, and manage saved queries. The following table lists the regions where BigQuery Studio is available:

For more information, see Saved query quotas and limits.

Saved queries have the following limitations:

• You can grant public access to saved queries only to the allAuthenticatedUsers principal. You can't grant access to saved queries to the allUsers principal.
• If your Google Cloud project contains more than 2500 classic saved queries, you can't use batch migration to migrate classic saved queries to saved queries.

Classic saved queries are an earlier way of saving and sharing SQL queries. Classic saved queries provide the query text, and the only query setting retained by a classic saved query is the SQL version. This setting governs whether the query uses legacy SQL or GoogleSQL. To query the data, users must have access to the data that the saved query accesses.

You can see classic saved queries in the (Classic) Queries folder of the Explorer pane:

There are 3 types of classic saved queries:

• Personal. Personal classic saved queries are visible only to the user who creates them. They are identified with the person icon.
• Project-level. Project-level saved queries are visible to principals that have the required permissions. They are identified with the people icon.
• Public. Public classic saved queries are visible to anyone with a link to the query. They are identified with the share icon.

You can migrate classic saved queries to saved queries to take advantage of the new capabilities, or continue to maintain them as classic saved queries until deprecation. The timeline for deprecation is being reviewed.

The classic saved query feature is available only in the Google Cloud console.

The saved queries feature of BigQuery Studio will replace classic saved queries. The deprecation timeline is being reviewed. To edit existing classic saved queries after deprecation, you must migrate classic queries to BigQuery Studio saved queries.

If users, including yourself, have personal queries with information that shouldn't be made available to others with access to data in the project, then the query's owner must delete the queries or the information before completing the migration.

To support this transition, the following BigQuery IAM roles were updated in February 2024:

• BigQuery Admin (roles/bigquery.admin) will get Dataform Admin (roles/dataform.admin) permissions.

• BigQuery Job User (roles/bigquery.jobUser) will get the following permissions:

  • dataform.locations.get
  • dataform.locations.list
  • dataform.repositories.create
  • dataform.repositories.list

• BigQuery User (roles/bigquery.user) will get the following permissions:

  • dataform.locations.get
  • dataform.locations.list
  • dataform.repositories.create
  • dataform.repositories.list

To let users without the BigQuery Admin, BigQuery Job User, or BigQuery User roles use saved queries, grant them the required permissions in IAM.

Custom roles won't be automatically updated. To update a custom role with the required permissions, see Edit an existing custom role.

• To learn how to create saved queries, see Create saved queries.
• To learn how to manage saved queries, see Manage saved queries.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["Saved queries in BigQuery allow users to create and manage SQL scripts, enhancing collaboration through options like sharing and version history."],["These queries, which are code assets within BigQuery Studio and powered by Dataform, save both the query text and settings, and are stored in a default region that can be updated."],["Access to saved queries is controlled using Identity and Access Management (IAM) roles, and they are only available in the Google Cloud console."],["Classic saved queries, which are an earlier version of the feature, will be fully replaced by BigQuery Studio saved queries in the future, and are deprecated."],["The migration from classic saved queries to BigQuery Studio saved queries is recommended to leverage the latest features and will be needed in the future due to deprecation."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4