Introduction to repositories

Preview

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

Note: To provide feedback or ask questions that are related to this Preview feature, contact [e-mail].

This document describes BigQuery repositories, which provide version control for the files you use within BigQuery. These repositories help you track changes to BigQuery assets like queries and notebooks, collaborate with your team, and revert to previous versions.

BigQuery repositories function as Git repositories. You can use the built-in Git capabilities of BigQuery or connect to an existing third-party Git repository. Within each repository, you create workspaces to edit the code stored there.

To view repositories, on the BigQuery page, in the left pane, click Explorer, and then click Repositories. Your repositories are displayed in alphabetical order in a new tab in the details pane.

Important: If you create an asset in a BigQuery repository—for example, a query, notebook (including a notebook with an Apache Spark job), BigQuery pipeline, or Dataform workflow—you cannot schedule it for execution in a BigQuery repository. For scheduling and executing Dataform workflows, you need to use Dataform repositories. For scheduling queries and notebooks, use BigQuery Studio. For more information, see Scheduling queries, Schedule notebooks, and Schedule pipelines.

Third-party repositories

You can connect a BigQuery repository to a third-party Git repository if you choose. In this case, the third-party repository stores the repository code instead of BigQuery. BigQuery interacts with the third-party repository to allow you to edit and execute its contents in a BigQuery workspace. Depending on the type of repository you choose, you can connect to a third-party repository by using SSH or HTTPS.

The following table lists supported Git providers and the connection methods that are available for their repositories:

Git provider	Connection method
Microsoft Azure DevOps Services	SSH
Bitbucket	SSH
GitHub	SSH or HTTPS
GitLab	SSH or HTTPS

For more information, see Connect to a third-party repository and Manage code with BigQuery Studio Git repositories.

Service account

All BigQuery repositories are connected to the default Dataform service agent. This service account is derived from your project number in the following format:

[e-mail]

Strict act-as mode is enforced and requires all repositories to use a custom service account or user credentials for a Google Account to schedule pipelines and notebooks.

Locations

You can create repositories in all BigQuery Studio locations.

Quotas

Dataform quotas apply to use of BigQuery repositories.

Pricing

You are not charged for creating, updating, or deleting a repository.

For more information on BigQuery pricing, see Pricing.

What's next

• Learn how to create repositories.
• Learn how to create workspaces.
• Learn how to manage code with BigQuery Studio Git repositories.