How to Create BigQuery Table in Google Cloud Platform Easily Using Google Api Explorer


There are some ways to create BigQuery Table in Google Cloud platform, but I found there is easiest way, which uses Google Api Explorer.

Here are the steps I used:

  • Go to Api Explorer for BigQuery : https://developers.google.com/apis-explorer/#p/bigquery/v2/ that will show lists of BigQuery API v2
  • Select bigquery.tables.insert until it shows the page UI
  • Click switch button “Authorize Requests using Oauth 2.0” to do authentication first in the bigquery.tables.insert Api explorer page  (see picture below)
  • Fill the project_id, dataset_id, and the json in Request Body .
    Note: on the request body, select Freeform Editor on combox box that appears when we click on it so we can type json we wants
  • Example Json:
{
 "tableReference": {
 "projectId": "xxxxxxx",
 "datasetId": "log",
 "tableId": "log_table_name"
 },
 "schema": {
 "fields": [
 {
 "name": "company_id",
 "type": "INTEGER"
 },
 {
 "name": "user_id",
 "type": "INTEGER"
 },
 {
 "name": "timestamp",
 "type": "INTEGER"
 },
 {
 "name": "status",
 "type": "BOOLEAN"
 }
 ]
 }
 }

Here is screenshot of the page of API Explorer for bigquery.tables.insert:
insert_big_query