title: How to pass dynamic parameterss in where condition in bq command line
body: <pre><code>FTIMESTAMP="2018-07-09 00:00:00"
  LTIMESTAMP="2018-07-09 08:00:00"
  echo $FTIMESTAMP
  echo $LTIMESTAMP
  bq query --nouse_legacy_sql 'insert `table1`(Time,UserId) 
    select Time,UserId from `table2` 
    WHERE _PARTITIONTIME &gt;= "$FTIMESTAMP" AND _PARTITIONTIME &lt; "$LTIMESTAMP"'
  </code></pre>
  
  <p>When I ran these commands in .sh script, it gave the following error:
  *Error in query string: Error processing job '************': Could not cast literal "$FTIMESTAMP" to type TIMESTAMP at [3:25].*</p>
  
  <p>I want to pass those parameters dynamically once this query is successful.</p>
  
  <p>Or is there any other way to extract the data for last 8 hours on the basis of partition time.</p>