Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
Habilita la zona de pruebas de BigQuery
La zona de pruebas de BigQuery te permite explorar las funciones limitadas de BigQuery sin costo para confirmar si BigQuery se ajusta a tus necesidades. La zona de pruebas de BigQuery te permite experimentar BigQuery sin proporcionar una tarjeta de crédito ni crear una cuenta de facturación para tu proyecto. Si ya creaste una cuenta de facturación, puedes usar BigQuery sin costo en el nivel de uso gratuito.
Comienza a usar la zona de pruebas de BigQuery
En la consola de Google Cloud, ve a la página de BigQuery.
También puedes abrir BigQuery en la consola de Google Cloud si ingresas la siguiente URL en el navegador:
https://console.cloud.google.com/bigquery
La consola de Google Cloud es la interfaz gráfica que utilizas para crear y administrar recursos de BigQuery, y ejecutar consultas en SQL.
Autentica con tu Cuenta de Google o crea una nueva.
En la página de bienvenida, haz lo siguiente:
En País (Country), selecciona tu país.
En Condiciones del Servicio (Terms of Service), selecciona la casilla de verificación si aceptas las condiciones del servicio.
Opcional: Si se te pregunta sobre las actualizaciones por correo electrónico, selecciona la casilla de verificación si deseas recibir actualizaciones por correo electrónico.
Haz clic en Aceptar y continuar (Agree and continue).
Haz clic en Crear proyecto.
En la página Nuevo proyecto, completa los siguientes pasos:
En Nombre del proyecto (Project name), ingresa un nombre para tu proyecto.
En Organización (Organization), selecciona una organización o Sin organización (No organization) si no eres parte de una. Las cuentas administradas, como las asociadas con instituciones académicas, deben seleccionar una organización.
Si se te solicita que selecciones una Ubicación (Location), haz clic en Explorar (Browse) y selecciona una ubicación para tu proyecto.
Haz clic en Crear. Se te redireccionará a la página BigQuery en la consola de Google Cloud.
Habilitaste correctamente la zona de pruebas de BigQuery. Ahora se muestra un aviso de zona de pruebas de BigQuery en la página BigQuery:
La zona de pruebas de BigQuery te permite explorar las funciones limitadas de BigQuery sin costo. Cuando desees aumentar las capacidades de almacenamiento y consulta, actualiza desde la zona de pruebas de BigQuery.
Se te otorgan los mismos límites de uso sin cargo que con el nivel gratuito de BigQuery, incluidos 10 GB de almacenamiento activo y 1 TB de datos de consulta procesados cada mes.
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Última actualización: 2025-04-21 (UTC)"],[[["\u003cp\u003eThe BigQuery sandbox allows users to explore BigQuery's capabilities at no cost without needing a credit card or billing account.\u003c/p\u003e\n"],["\u003cp\u003eEnabling the sandbox involves navigating to the BigQuery page in the Google Cloud console, authenticating with a Google Account, and creating a new project.\u003c/p\u003e\n"],["\u003cp\u003eThe BigQuery sandbox has limitations, such as a 60-day expiration for all tables and views, and it does not support streaming data, DML statements, or BigQuery Data Transfer Service.\u003c/p\u003e\n"],["\u003cp\u003eUsers can upgrade from the sandbox to increase storage and query capabilities by enabling billing for their project and selecting a suitable BigQuery edition.\u003c/p\u003e\n"],["\u003cp\u003eAfter enabling the BigQuery sandbox, users are encouraged to try one of the three quickstarts provided, which will allow them to query a public dataset with the Google Cloud console, the bq command-line tool or the client libraries.\u003c/p\u003e\n"]]],[],null,["# Enable the BigQuery sandbox\n===========================\n\nThe BigQuery sandbox lets you explore limited BigQuery capabilities\nat no cost to confirm whether BigQuery fits your needs. The\nBigQuery sandbox lets you experience BigQuery without\nproviding a credit card or creating a billing account for your project. If you\nalready created a billing account, you can still use BigQuery at\nno cost in the free usage tier.\n\nStart using the BigQuery sandbox\n--------------------------------\n\n1. In the Google Cloud console, go to the **BigQuery** page.\n\n [Go to BigQuery](https://console.cloud.google.com/bigquery)\n\n You can also open BigQuery in the Google Cloud console\n by entering the following URL in your browser: \n\n ```\n https://console.cloud.google.com/bigquery\n ```\n\n The Google Cloud console is the graphical interface that you use to create\n and manage BigQuery resources and to run SQL queries.\n2. Authenticate with your Google Account, or create a new one.\n\n3. On the welcome page, do the following:\n\n 1. For **Country**, select your country.\n\n 2. For **Terms of Service**, select the checkbox if you agree to the terms\n of service.\n\n 3. Optional: If you are asked about email updates, select the checkbox if\n you want to receive email updates.\n\n 4. Click **Agree and continue**.\n\n4. Click **Create project**.\n\n5. On the **New Project** page, do the following:\n\n 1. For **Project name**, enter a name for your project.\n\n 2. For **Organization** , select an organization or select\n **No organization** if you are not part of one. Managed accounts, such\n as those associated with academic institutions, must select an\n organization.\n\n 3. If you are asked to select a **Location** , click **Browse** and select a\n location for your project.\n\n 4. Click **Create** . You are redirected back to the **BigQuery** page in\n the Google Cloud console.\n\nYou have successfully enabled the BigQuery sandbox. A\nBigQuery sandbox notice is now displayed on the **BigQuery** page:\n\nWith the BigQuery sandbox now enabled, we recommend that you try the\n[Query a public dataset with the Google Cloud console](/bigquery/docs/quickstarts/query-public-dataset-console)\nquickstart next. You can also try a similar\n[quickstart for the bq command-line tool](/bigquery/docs/quickstarts/query-public-dataset-bq),\nwhich is useful for many administrative tasks, or a similar\n[quickstart for the client libraries](/bigquery/docs/quickstarts/quickstart-client-libraries),\nwhich let you use BigQuery with programming languages like\nJava and Python.\n\nUpgrade from the BigQuery sandbox\n---------------------------------\n\nThe BigQuery sandbox lets you explore\n[limited BigQuery capabilities](#limitations)\nat no cost. When you are ready to increase your storage and query\ncapabilities, upgrade from the BigQuery sandbox.\n\nTo upgrade, do the following:\n\n1. [Enable billing](/billing/docs/how-to/modify-project#enable_billing_for_a_project)\n for your project.\n\n2. Explore [BigQuery editions](/bigquery/docs/editions-intro)\n and determine the pricing model that is right for you.\n\nOnce you have upgraded from the BigQuery sandbox, you should\n[update the default expiration times for your BigQuery resources](/bigquery/docs/updating-datasets#table-expiration)\nsuch as tables, views, and partitions.\n\nLimitations\n-----------\n\nThe BigQuery sandbox is subject to the following limits:\n\n- All BigQuery [quotas and limits](/bigquery/quotas) apply.\n- You are granted the same free usage limits as the BigQuery [free tier](/bigquery/pricing#free-tier), including 10 GB of active storage and 1 TB of processed query data each month.\n- All BigQuery [datasets](/bigquery/docs/datasets-intro) have a [default table expiration time](/bigquery/docs/updating-datasets#table-expiration), and all [tables](/bigquery/docs/tables-intro), [views](/bigquery/docs/views-intro), and [partitions](/bigquery/docs/partitioned-tables) automatically expire after 60 days.\n- The BigQuery sandbox does not support several BigQuery\n features, including the following:\n\n - [Streaming data](/bigquery/docs/write-api)\n - [Data manipulation language (DML) statements](/bigquery/docs/data-manipulation-language)\n - [BigQuery Data Transfer Service](/bigquery/docs/dts-introduction)\n\nWhat's next\n-----------\n\n- Learn to [query a public dataset with the Google Cloud console](/bigquery/docs/quickstarts/query-public-dataset-console).\n- Learn to [query a public dataset with the bq tool](/bigquery/docs/quickstarts/query-public-dataset-bq).\n- Learn to [query a public dataset with the client libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n- For more information about using BigQuery at no cost in the free usage tier, see [Free usage tier](/bigquery/pricing#free-tier).\n- Get [updates about BigQuery releases](/bigquery/docs/release-notes).\n\n\u003c!-- --\u003e\n\n- If you are a Firebase user, see [Link BigQuery to Firebase](https://support.google.com/firebase/answer/6318765)."]]