Analysts routinely spend lots of time debugging complex SQL queries. To help with this, Google BigQuery includes an error checking indicator. The error checking validation indicator checks for correct datasets, correct column names, syntax, as well as other issues. Error messages are shown below the query dialog, along with the row and character location. In the preceding example, the column name is incorrectly spelled:

When a query is correctly formatted, the error dialog displays a valid message, along with a calculation of how much data will be processed when the query runs. This feature is rare and extremely useful. While these validation features are made with novice users in mind, skilled developers will also appreciate their presence: