Create Table in BigQuery

You can create a table in BigQuery in the following ways: Manually using the Cloud Console or the bq command-line tool bq mk command. Programmatically by calling the tables. insert API method.

1. In the Cloud Console, open the BigQuery page.

   Go to BigQuery

2. In the Explorer panel, expand your project and select a dataset.

3. Expand the more_vert Actions option and click Open.

4. In the details panel, click Create table add_box.

5. On the Create table page, in the Source section, select Empty table.

6. On the Create table page, in the Destination section:

   • For Dataset name, choose the appropriate dataset.

     

   • In the Table name field, enter the name of the table you're creating in BigQuery.

   • Verify that Table type is set to Native table.

7. In the Schema section, enter the schema definition.

   • Enter schema information manually by:

     • Enabling Edit as text and entering the table schema as a JSON array.

       Note: You can view the schema of an existing table in JSON format by entering the following command:

       bq show --format=prettyjson dataset.table.
       

     • Using Add field to manually input the schema.

8. For Partition and cluster settings leave the default value — No partitioning.

9. In the Advanced options section, for Encryption leave the default value: Google-managed key. By default, BigQuery encrypts customer content stored at rest.

10. Click Create table.

For your Reference : Bigquery Table