title: How do I pass parameters to spark.sql(""" """)?
body: <p>I'd like to pass a string to spark.sql</p>
  
  <p>Here is my query</p>
  
  <pre><code>mydf = spark.sql("SELECT * FROM MYTABLE WHERE TIMESTAMP BETWEEN '2020-04-01' AND '2020-04-08') 
  </code></pre>
  
  <p>I'd like to pass a string for the date.</p>
  
  <p>I tried this code</p>
  
  <pre><code>val = '2020-04-08'
  
  s"spark.sql("SELECT * FROM MYTABLE WHERE TIMESTAMP  BETWEEN $val  AND '2020-04-08'
  </code></pre>