Learning Google BigQuery

Creating a new table within a dataset

The following code creates a table within the specified dataset with the given schema. The code checks whether the given table is already created under the specified dataset; if the table does not exist, it creates the new table. The table schema can be plaintext in which each column specification is delimited by, and each column is specified in, the format ColumnName:DataType. In the schema provided as plaintext, all columns are assumed to be NULLABLE. The table schema can also be in JSON format, which provides the option to specify the mode for the columns; they can be one of the following:

• NULLABLE: The column allows null values to be stored in it
• REPEATED: The column allows storing of nested objects ...