BigQuery Parameters vs Variables: What's the Difference?

You can use query parameters in BigQuery hashtag#SQL (now in the console as well!) — but how are they different from variables, and when should you use each?

Both parameters and variables act as placeholders and have a defined data type. The difference is where their value comes from and how they’re used.

Parameters (like @corpus)
👉 Are not computed inside the query
👉 Are passed from the outside (Python, UI, API, etc.)

Variables (DECLARE, SET)
👉 Are defined and computed inside a SQL script or stored procedure
👉 Let you store a value and reuse it later in the same script

So what’s the real difference?
➡️ Variables are essential for Dynamic SQL (EXECUTE IMMEDIATE)
➡️ Parameters can filter data, but cannot control identifiers (e.g. table or column names)

🚨 Security
When values come from user input or external sources, parameters are the safer choice—they reduce the risk of SQL injection.

🚅 Performance
Parameters may allow the optimizer to reuse execution plans, while variables can sometimes prevent that.

Found it useful? Check out to my Analytics newsletter at notjustsql.com.

Parameters in BigQuery

Comments

Practical SQL

Table grain quick validation with SQL

More from this blog

pre_ and post_operations in Dataform

BigQuery Object Tables: A Practical Introduction

BigQuery BigLake Tables Explained: What They Are and When to Use Them

BigQuery Saves Your Query Results — Here's How to Find Them

Command Palette

Comments

Practical SQL

Table grain quick validation with SQL

More from this blog