I'm using the Data Connectors feature to bring info in from BigQuery to a sheet I'm working on. I have a sheet with thousands of entries; and I have a BigQuery-accessible database with hundreds of thousands of entries.
The BQ tables are too big to bring the entire thing into Sheets. But that's fine, I don't want all of it, I just want the relevant part. Specifically, I essentially want to do a join, and bring in the rows from BQ that match a key field in the rows already in sheet.
How can I filter the incoming BQ data, and only bring in rows that match data in the sheet? I can write a custom query that describes the incoming data, but AFAICT that query can't reference a column in the sheet, and the specific rows I want don't have anything in common that can be specifically predicted in isolation