Skip to main content
Cell references allow you to modify a value in a SQL query by simply typing into the referenced cell in your workbook. This enables anyone with edit access to your workbook to modify specific values in your SQL queries, without the need to open up access to your query or create multiple versions of the same query. You can set up cell references to toggle values like dates, products, locations, plan type, and more. To get started, set up a live datasource connection to a workbook. Once you have a connection set up, you can refer to cells in your workbook to filter your queries by inputting values into those cells. Note: to use this functionality, you must write your query using the SQL editor. To get started:
  1. Use the SQL editor to write a query that pulls data from a connected datasource.
  2. Set up the condition in your SQL query that you want to use with a cell reference.
  3. Click on “Insert Cell” in the SQL editor toolbar to insert a cell reference in your query.
  4. Select the cell in your workbook to reference (in this case, cell A1). Type a value to filter your query on into the referenced cell and click Run Query.
Joins Schema refreshes