The BigQuery web interface looks like the following screenshot displaying the current project and the datasets and tables in that project. The COMPOSE QUERY button will open the panel to type the query as shown in the following screenshot:
Data can be inserted, queried, updated, and deleted via the BigQuery API or the Google BigQuery web interface. This section will cover creating and inserting data via the BigQuery web interface. The BigQuery web interface is useful as it provides some tools for manipulation and debugging not seen in most SQL development environments. The interface has tools for error checking, job history, job status, query history, as well as other things. There is no need to deal with confusing database connection settings as the user's Google login information acts as the connection credentials.