Forrest logo
back to the bq tool

bq:tldr:1feb7

bq: Create a new dataset or table in the US location.
$ bq mk --location=US ${dataset_name}.${table_name}
try on your machine

The command bq mk --location=US ${dataset_name}.${table_name} is used to create a new BigQuery table in the specified dataset with a specific table name.

Here's a breakdown of the command:

  • bq: This is the command-line tool (provided by Google) for interacting with BigQuery.
  • mk: This is a command within bq used to create a new resource, in this case, a table.
  • --location=US: This specifies the geographical location for the dataset. In this case, it's set to the United States.
  • ${dataset_name}.${table_name}: This is a placeholder for the dataset name and table name. You need to replace ${dataset_name} with the actual name of the dataset where you want to create the table, and ${table_name} with the desired name for the new table.

When you run the command with appropriate dataset and table names, it will create a new table in the specified dataset within the US geographical location.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.
back to the bq tool