Bigquery command line tool to read long query string from a file

Question

I am using the Bigquery command line tool to query data from a Bigquery table.

My query statement is very long.

Is there a way to save the long query statement in a file and pass the file name to the Bigquery command line tool?

Thank you.

Answer 1

You can use this:

cat query.txt | bq query

Answer 2

Just use cat in tick marks. Switch the double quotes to single quotes if needed.

bq query "`cat query.txt`"