Sign inGet started
← Back to all guides

How to create a table from query in BigQuery

By Nick Barth

Updated on March 6, 2024

In BigQuery, you can create a table from a query result by using the BigQuery web UI, the bq command-line tool, or the BigQuery REST API. Here's a simple example using the web UI:

  1. Navigate to the BigQuery web UI in the Google Cloud Console.
  2. Enter your SQL query in the Query editor.
  3. Before executing the query, click on the "Save results" dropdown button.
  4. Choose "BigQuery table" from the dropdown menu.
  5. Specify the dataset and provide a name for the new table.
  6. Click "Run" to execute the query and save the results to the specified table.

This process creates a new table based on the result of your query, which can then be used for further analysis or sharing with your team. Remember to set the proper permissions for the dataset to ensure data governance.

That’s it, time to try Deepnote

Get started – it’s free
Book a demo



  • Integrations
  • Pricing
  • Documentation
  • Changelog
  • Security




  • Privacy
  • Terms

© Deepnote