Connecting Google Sheets to Big Query

[ambrandt2000]

I'm trying to connect to Big Query thru Google Sheets. I want to find the pkg_loc for this list of products in column trkg_id on my Google Sheets.

How could I look up these values without using select * from ____ where trkg_id IN('KOH ',) & then copying & pasting all the values?

I currently have SELECT trkg_id, pkg_stat_cde FROM logistics WHERE trkg_id IN('KOH1296383570', 'KOH1297282463', 'KOH1297449669', 'KOH1298100692')

My Big Query db has trkg_id and pkg_stat_cde included.

Is there a way to join or use a certain statement to easily get all these values in one query? https://docs.google.com/spreadsheets/d/1QyIfKOr_NmxYR0cu8E_6kqpPv5y9QVsc/edit#gid=1477839500

[kolban]

Unfortunately, we can't look into your explicit data files due to privacy concerns and policies.  These community forums are not so much about "here's what I want to achieve, help me code it" but rather about discussing the general use of Google Cloud products and services.  If you have a puzzle where you can describe a scenario that you think should work and is not working, that would be a great example of how the community can help.   Asking the community to look at a table of data and asking how to build a SELECT statement against your specific data is likely too large a stretch.  Consider describing a much simpler and generic puzzle and describe what you tried and what you found.