Fix BigQuery "Unrecognized Name" Error: Scoping and Syntax Rules

By Sharon Ben-Moshe · September 29, 2026 · 1 min read

Sharon Ben-Moshe is the founder of sqlfmt, a browser-based SQL formatter and validator with misspelled-keyword suggestions across PostgreSQL, MySQL, SQLite, SQL Server, and BigQuery.

Fix Google BigQuery's "Unrecognized name: column" error. Learn alias visibility rules across WHERE and QUALIFY, case sensitivity, and struct unnesting.

Quick answer

Google BigQuery's "Unrecognized name: X" error occurs when the query parser cannot resolve an identifier in the current clause scope. The most frequent cause is referencing a SELECT column alias inside the WHERE clause (which executes before SELECT). In BigQuery, resolve this by repeating the expression in WHERE, using a CTE, or using QUALIFY for window function filters.

FAQs

Why can't I use SELECT aliases in BigQuery WHERE clauses?

In SQL logical query processing, WHERE is evaluated before SELECT. At the time WHERE filters rows, the column alias defined in SELECT does not exist yet. BigQuery strictly enforces this scope boundary.

Does BigQuery GROUP BY allow aliases?

Yes! Unlike traditional SQL Server or Oracle, BigQuery allows column aliases in GROUP BY and HAVING clauses. However, WHERE remains evaluated prior to alias resolution.

How does QUALIFY help with BigQuery alias errors?

QUALIFY is evaluated after window functions. Instead of nesting subqueries to filter on ROW_NUMBER() or RANK(), you can write `QUALIFY ROW_NUMBER() OVER (...) = 1` directly.

Are column names in BigQuery case-sensitive?

BigQuery standard SQL column names are case-insensitive for standard tables. However, nested STRUCT field names, JSON path keys, and external partitioned table paths can be case-sensitive depending on configuration.

SQL Errors

SQLite "Datatype Mismatch" (Error 20): Type Affinity and Strict Tables

By Sharon Ben-Moshe · Sep 26, 2026

Understand SQLite Error 20 (datatype mismatch). Learn how SQLite type affinity, CHECK constraints, and STRICT tables enforce data integrity.

Read post

SQL Errors

PostgreSQL statement_timeout (Error 57014): Causes and Prevention

By Sharon Ben-Moshe · Sep 23, 2026

Fix PostgreSQL Error 57014: canceling statement due to statement_timeout. Learn how to tune query plans, configure timeouts per session, and avoid lock waits.

Read post

SQL Errors

Try it now

Paste your SQL into sqlfmt — format, validate, and catch typos free in your browser.

Open SQL Formatter →

Key takeaways

Column aliases created in SELECT cannot be referenced in WHERE; use a CTE or duplicate the expression.

BigQuery allows SELECT aliases in GROUP BY, HAVING, and QUALIFY, but never in WHERE.

For STRUCT columns, use dot notation (record.field); unnest ARRAY columns before querying fields.

Escape column names containing hyphens or reserved words with backticks (`dataset-name.table`).

The WHERE clause alias trap in GoogleSQL

Developers migrating from Python, Snowflake, or pandas often expect aliases created in SELECT to be available throughout the query. In BigQuery, this raises an immediate error:

WHERE clause alias failure versus CTE solution

-- FAILS: Unrecognized name: total_revenue at [5:9]
SELECT
  order_id,
  quantity * unit_price AS total_revenue
FROM `project.analytics.orders`
WHERE total_revenue > 1000;

-- FIXED Option A: Repeat the calculation in WHERE
SELECT
  order_id,
  quantity * unit_price AS total_revenue
FROM `project.analytics.orders`
WHERE (quantity * unit_price) > 1000;

-- FIXED Option B: Use a Common Table Expression (CTE)
WITH calculated_orders AS (
  SELECT
    order_id,
    quantity * unit_price AS total_revenue
  FROM `project.analytics.orders`
)
SELECT *
FROM calculated_orders
WHERE total_revenue > 1000;

Filtering window functions cleanly with QUALIFY

Trying to reference a window function alias in WHERE raises an unrecognized name error. In BigQuery, use the `QUALIFY` clause instead of wrapping the query in a subquery:

Filtering window functions using QUALIFY in BigQuery

-- Clean, idiomatic BigQuery: filter top rows without a subquery
SELECT
  customer_id,
  order_id,
  order_date,
  ROW_NUMBER() OVER (
    PARTITION BY customer_id
    ORDER BY order_date DESC
  ) AS row_num
FROM `project.analytics.orders`
QUALIFY row_num = 1;

STRUCT and ARRAY dot notation mistakes

BigQuery handles semi-structured data via STRUCT and ARRAY types. Calling a field directly on an array triggers 'Unrecognized name' because the array must be unnested first:

Accessing fields in nested BigQuery structures

-- Querying a single STRUCT field (Direct dot notation works)
SELECT user_info.address.city
FROM `project.analytics.users`;

-- Querying an ARRAY of STRUCTs (Must use UNNEST or FLATTEN)
SELECT
  u.user_id,
  item.product_name
FROM `project.analytics.users` u,
UNNEST(u.order_items) AS item;

Fix BigQuery "Unrecognized Name" Error: Scoping and Syntax Rules

Quick answer

FAQs

Why can't I use SELECT aliases in BigQuery WHERE clauses?

Does BigQuery GROUP BY allow aliases?

How does QUALIFY help with BigQuery alias errors?

Are column names in BigQuery case-sensitive?

SQLite "Datatype Mismatch" (Error 20): Type Affinity and Strict Tables

PostgreSQL statement_timeout (Error 57014): Causes and Prevention

SQL Server "String or Binary Data Would Be Truncated": Fix Msg 8152 & 2628

Key takeaways

The WHERE clause alias trap in GoogleSQL

Filtering window functions cleanly with QUALIFY

STRUCT and ARRAY dot notation mistakes

Official references

Quick answer

FAQs

Why can't I use SELECT aliases in BigQuery WHERE clauses?

Does BigQuery GROUP BY allow aliases?

How does QUALIFY help with BigQuery alias errors?

Are column names in BigQuery case-sensitive?

Keep reading

SQLite "Datatype Mismatch" (Error 20): Type Affinity and Strict Tables

PostgreSQL statement_timeout (Error 57014): Causes and Prevention

SQL Server "String or Binary Data Would Be Truncated": Fix Msg 8152 & 2628

Key takeaways

The WHERE clause alias trap in GoogleSQL

Filtering window functions cleanly with QUALIFY

STRUCT and ARRAY dot notation mistakes

Related SQL guides

Official references