Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Introdução aos repositórios
Este documento ajuda você a entender o conceito de repositórios no BigQuery. É possível usar repositórios para fazer o controle de versão dos
arquivos usados no BigQuery. O BigQuery usa o Git para registrar mudanças e gerenciar versões de arquivos.
Cada repositório do BigQuery representa um repositório Git. É possível usar os recursos integrados do Git no BigQuery ou se conectar a um repositório Git de terceiros. Em cada repositório, é possível criar um ou mais espaços de trabalho para editar o código armazenado no repositório.
Na página do BigQuery, seus repositórios são exibidos em ordem alfabética na pasta Repositórios do painel Explorer.
Repositórios de terceiros
Se quiser, você pode conectar um repositório do BigQuery a um repositório Git de terceiros. Nesse caso, o repositório de terceiros armazena
o código do repositório em vez do BigQuery. O BigQuery interage com o repositório de terceiros para permitir que você edite e execute o conteúdo dele em um espaço de trabalho do BigQuery. Dependendo do tipo de repositório escolhido, é possível se conectar a um repositório de terceiros usando SSH ou HTTPS.
A tabela a seguir lista os provedores do Git compatíveis e os métodos de conexão disponíveis para os repositórios deles:
Todos os repositórios do BigQuery estão conectados à conta de serviço padrão do Dataform. Essa conta de serviço é derivada do número do projeto no seguinte formato:
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-08-17 UTC."],[[["\u003cp\u003eBigQuery repositories allow for version control of files used within BigQuery, utilizing Git for managing changes and file versions.\u003c/p\u003e\n"],["\u003cp\u003eRepositories can either use BigQuery's built-in Git capabilities or connect to third-party Git repositories like Microsoft Azure DevOps Services, Bitbucket, GitHub, and GitLab via SSH or HTTPS.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery repositories are displayed alphabetically in the \u003cstrong\u003eRepositories\u003c/strong\u003e folder within the \u003cstrong\u003eExplorer\u003c/strong\u003e pane, and each can contain multiple workspaces for editing code.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery repositories are connected to the default Dataform service account and are subject to Dataform quotas, but there are no charges for creating, updating, or deleting a repository.\u003c/p\u003e\n"],["\u003cp\u003eThis is a Pre-GA feature that is subject to the "Pre-GA Offerings Terms" and might have limited support, with feedback and questions directed to bigquery-repositories-feedback@google.com.\u003c/p\u003e\n"]]],[],null,["# Introduction to repositories\n============================\n\n|\n| **Preview**\n|\n|\n| This product or feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA products and features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n| **Note:** To provide feedback or ask questions that are related to this Preview feature, contact [bigquery-repositories-feedback@google.com](mailto:%20bigquery-repositories-feedback@google.com).\n\nThis document helps you understand the concept of repositories in\nBigQuery. You can use repositories to perform version control on\nfiles you use in BigQuery. BigQuery uses Git to record\nchanges and manage file versions.\n\nEach BigQuery repository represents a Git repository. You can\nuse BigQuery's built-in Git capabilities, or you can connect to\na third-party Git repository. Within each repository, you can create one or more\n[workspaces](/bigquery/docs/workspaces-intro) to edit the code stored in the\nrepository.\n\nOn the BigQuery page, your repositories are displayed in\nalphabetical order in the **Repositories** folder of the **Explorer** pane.\n| **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 BigQuery repository. For scheduling and executing Dataform pipelines, you need to use Dataform repositories. For scheduling queries and notebooks, use BigQuery Studio. For more information, see [Scheduling queries](/bigquery/docs/scheduling-queries), [Schedule notebooks](/bigquery/docs/orchestrate-notebooks), and [Schedule pipelines](/bigquery/docs/schedule-pipelines).\n\nThird-party repositories\n------------------------\n\nYou can connect a BigQuery repository to\na third-party Git repository if you choose. In this case, the third-party repository stores\nthe repository code instead of BigQuery. BigQuery interacts with the third-party\nrepository to allow you to edit and execute its contents in a\nBigQuery workspace. Depending on the type of repository you\nchoose, you can connect to a third-party repository by using SSH or HTTPS.\n\nThe following table lists supported Git providers and the connection\nmethods that are available for their repositories:\n\nFor more information, see\n[Connect to a third-party repository](/bigquery/docs/repositories#connect-third-party).\n\nService account\n---------------\n\nAll BigQuery repositories are connected to the default\nDataform service account. This service account is derived from your\nproject number in the following format: \n\n service-\u003cvar translate=\"no\"\u003eYOUR_PROJECT_NUMBER\u003c/var\u003e@gcp-sa-dataform.iam.gserviceaccount.com\n\nLocations\n---------\n\nYou can create repositories in all\n[BigQuery Studio locations](/bigquery/docs/locations#bqstudio-loc).\n\nQuotas\n------\n\n[Dataform quotas](/dataform/docs/quotas#quotas) apply to use of\nBigQuery repositories.\n\nPricing\n-------\n\nYou are not charged for creating, updating, or deleting a repository.\n\nFor more information on BigQuery pricing, see [Pricing](/bigquery/pricing).\n\nWhat's next\n-----------\n\n- Learn how to [create repositories](/bigquery/docs/repositories).\n- Learn how to [create workspaces](/bigquery/docs/workspaces)."]]
