hi all, does anyone have an idea how to rename Columns AS and AT (columns coming from a Google Sheet have no header names when loaded). AS as Column_X doesn’t work, unfortunately (error: Syntax error: Expected end of input but got string literal ‘AS’ at [1:1]) ‘AS’ as Column_X enters AS as values …

The BigQuery SQL language does have reserved keywords that you can’t use as identifiers unless they’re enclosed in backticks. The words “AS” and “AT” are both reserved keywords. If you have a BigQuery table with columns without names, such as when loading from Google Sheets, it assigns column names…

Renaming Columns AS or AT in BigQuery

Google Cloud Data Analytics

Alapinka May 25, 2023, 6:06am 3

Many thanks, this worked indeed! Another workound found by my colleague:

tab.AT as …
FROM … tab

Topic		Replies	Views
Alter column name of a GBQ table whose source is a google sheet Data Analytics bigquery	1	5	September 13, 2023
Unable to rename BigQuery Column with SQL data definition language (DDL) Data Analytics bigquery	1	85	February 26, 2024
How to use table name with same column name from BigQuery Data Analytics bigquery	2	14	July 10, 2025

Renaming Columns AS or AT in BigQuery

AI Suggested topics