To access BigQuery via a browser, go to https://bigquery.cloud.google.com. Once you log in, you will be seeing the BigQuery console; click on the down arrow in the project name and choose the Create new dataset option. Enter a name for your dataset in Dataset ID and choose the Data location and Never for Data expiration. Click on Ok to finish creating the dataset.
To create a new table under the dataset:
- Click on the down arrow and choose Create new table; you will be presented with the following screen.
- Choose the options as shown in the screenshot and click on Choose file button. Upload the file that you downloaded from https://github.com/hthirukkumaran/Learning-Google-BigQuery/blob/master/chapter1/employeedetails.csv.
- Choose Automatically detect for Schema and click on Create table. This option will automatically use the column names specified as the first row in the file for the table and import rest of the rows into the table:
Once the table is created, you can see its details by clicking on the table name in the left-hand-side navigation under the dataset name. You can click on the schema, details, and preview table to see information about the table and the data in the table without running any query:
To import a file from Google Cloud storage:
- Create a new table as done previously and then choose Google Cloud storage in the Location option as shown in the following screenshot
- Enter the name of the bucket created previously and the file that was uploaded to that bucket
- Click on Create Table to create the table from the file in Google Cloud storage:
