How to create and delete a BigQuery dataset and table?

Creating a BigQuery dataset and table:

1. Go to the BigQuery web UI in the Cloud Console.
2. Click the project drop-down and select the project that you want to create the dataset and table in.
3. Click the plus button to the left of “BigQuery” to create a new dataset.
4. Enter a name for the dataset and select a location.
5. Click “Create dataset” to create the dataset.
6. Click the dataset that you just created.
7. Click the Create Table button.
8. Select the “Create Table” option.
9. Select the options for your new table:
10. upload a file
11. import from external data source like Google Drive, Bigtable, and Cloud storage or write SQL to create an empty table.
12. After the table is created, You can upload or query data into the table.

Deleting a BigQuery dataset and table:

1. Go to the BigQuery web UI in the Cloud Console.
   Click the project drop-down and select the project that the dataset and table you want to delete.
   Click the checkbox next to the dataset or table you want to delete.
   Click the trash icon to delete the dataset or table.
   Confirm the deletion by clicking “Delete” in the dialog box.
   It’s worth noting that if a dataset or table is deleted, the data is permanently deleted and can not be recovered. In addition, if the table or dataset is being used in a query or a view, deletion will fail. To delete such table or dataset, you have to first delete or modify the dependent queries and views.

Read more on bigquery here