Parametrize queries
Insert data from sheet into your queries with parametrized queries.
Parametrized reference
You can reference sheet data in SQL. Use {{}} notation for references. You can only reference single cells at a time.
SELECT * FROM {{A1}} WHERE salary > {{A4}}
Note in the following example where the query output changes based on what table is selected in cell B1.
Parametrize a reference from another sheet
select abc from def where ghi="{{'Sheet_name'!H3}}"

Last updated
Was this helpful?