Enable BigQuery Studio for asset management

BigQuery Studio lets you save, share, and manage versions of code assets such as notebooks and saved queries.

Automatic enablement of BigQuery Studio APIs

The following BigQuery Studio APIs are automatically enabled for all Google Cloud projects with BigQuery:

If you have automation scripts from before March 2024 that depended on the status of these APIs, you might need to update them.

These APIs don't incur any additional costs. Users with Identity and Access Management permissions to use enabled services on corresponding resources can incur charges, as described in BigQuery pricing, Dataform pricing, and Dataplex pricing.

You can prevent enablement of additional APIs by setting the Restrict Resource Service Usage organization policy constraint. You can disable selected APIs at any time.

Before you begin

To manually enable BigQuery Studio for code asset management, you must have the Identity and Access Management (IAM) Owner (roles/owner) role.

Manually enable BigQuery Studio code assets

You can manually enable BigQuery Studio for code asset management by enabling the following APIs:

  • The Compute Engine API
  • The Dataform API
  • The Vertex AI API

Enable code assets by following these steps:

  1. Go to the BigQuery page.

    Go to BigQuery

  2. Expand the New code management features dialog that appears at the bottom of the Explorer pane, and click Enable now.

    If you don't see the dialog, check if you have the required IAM Owner role.

  3. In the Enable features pane, in the Core feature APIs section, do the following:

    1. To enable version history and sharing of code assets, under Version history and sharing, click Enable.
    2. To enable notebooks, under Python notebooks, click Enable all.
    3. When the APIs have been enabled, click Next.

  4. Optional: Set user permissions in the Permissions section:

    • To grant principals the ability to create code assets, and to read, edit, and set permissions for the code assets they created, type their user or group names in Creator.
    • To grant principals the ability to read, edit, and set permissions for all code assets shared with them, type their user or group names in Owner.

  5. Click Next.

  6. Optional: Click Enable all in the Additional APIs section to enable the APIs that you need in order to create BigQuery remote procedures by using BigQuery DataFrames.

  7. If you chose not to enable the additional APIs, click Close to close the Enable features pane.

Set the default region for code assets

All code assets use the same default region. Follow these steps to set the default region for code assets:

  1. Go to the BigQuery page.

    Go to BigQuery

  2. In the Explorer pane, find the project in which you have enabled code assets.

  3. Click View actions next to the project, and then click Change my default code region.

  4. In Region, select the region that you want to use for code assets.

  5. Click Select.

Grant access to other users

After you have enabled BigQuery Studio for code asset management, you can give other users access to code assets by granting them the appropriate Identity and Access Management roles. For more information, see Grant access to notebooks and Grant access to saved queries.

What's next