How do you declare/modify Parameters in a query in Excel? [SQL]
select * from dcs.invoice_header ih where ih.sales_order_id = ?
After setting your query, Excel will prompt for a cell-reference as your parameter.
Once you have finalized this, typing anything into that field will re-run the query referencing the field as the ? in your SQL. In this example, I have used sales_order_id 'BE1439'
To edit this, you can follow the path: Data --> Properties --> Connection Properties (the little box next to name) --> Definition -- > Parameters...
From here you can edit your parameters, rules and cell references.