The BigQuery sandbox gives you free access to the power of BigQuery subject to the sandbox's limits. The sandbox allows you to use the web UI in the Cloud Console without providing a credit card. You can use the sandbox without creating a billing account or enabling billing for your project.
The web UI is the graphical interface that you can use to create and manage BigQuery resources and to run SQL queries. See the BigQuery web UI quickstart for a working introduction to the web UI.
Getting started with the sandbox
Currently, the BigQuery sandbox is only available through Firebase. If you aren't a Firebase user, click here to get started.
If you are a current Firebase user, see Link BigQuery to Firebase in the Firebase help for instructions on linking Firebase to BigQuery.
For updates on the BigQuery sandbox, see the Release Notes.
The BigQuery sandbox is subject to the following limits.
- All BigQuery Quotas and Limits apply.
- You are granted the same free usage limits as the free tier — 10 GB of active storage and 1 TB of processed query data per month.
- All datasets have the default table expiration time and the default partition expiration set to 60 days. Any tables, views, or partitions in partitioned tables automatically expire after 60 days.
Sandbox projects do not support:
Upgrading from the sandbox
To upgrade from the BigQuery sandbox:
- Enable billing for your project.
Update your BigQuery resources:
Troubleshooting the sandbox
If your tables have expired, you can recover them within 48 hours. For more information, see Restoring a deleted table.
You can also view information on your sandbox resources by using the audit logs. Audit logs will reveal details around whether a resource was created using the sandbox and details on when resources automatically expired.