Creating a table

The following steps describe how to create a new table in the BigQuery project. The steps outlined here also explains few options available when creating tables:

  1. When first accessing the BigQuery web interface, you will be prompted to create a dataset. Once prompted, name the dataset ID testdataset. You will also be prompted to select a data location and whether you'd like the data to auto-expire. You can even create new datasets by clicking on the drop-down icon shown next to the project name on the left-hand-side navigation of the interface:
  1. Once your dataset is created, you can use the plus icon next to your dataset name to create a table.
  2. You will be prompted to select your table options:
  1. Click on Choose file and select a local .csv file you'd like to add to your table.
  2. The default options work for most of the remainder of this example, but make sure you give the table the name test and check the box for Automatically detect under Schema. This option will detect the schema based on the data in the .csv file. If this box is left unchecked, you will be able to name each column and select the data type and mode (nullable, required, or repeatable).
  1. Click on Create Table.

At this point, a job will start to upload your data and you will be given status updates during the process until it completes. Once complete, you should be able to query your data.

Data Manipulation Language (DML) statements are supported only in standard SQL and are not supported in legacy SQL mode.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.221.66.185