title: How to use pipeline parameters in DF Data Flow, Dataset source options
body: <p>I've been at this for a day now, trying every variation possible and searching for others solutions. I have a DF pipeline with a few DataBricks notebooks with the end result being saved to blob storage, but needs to be joined with a SQL table in order to update some values. I am using dynamic folder names to pull the blob file which works fine, but when I try the same thing for my SQL query, it doesn't fail, but it doesn't seem to select any records. So how does one use pipeline parameters in a Data Flow SQL query?</p>
  <p>Overview of the pipeline:<a href="https://i.stack.imgur.com/88xvp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/88xvp.png" alt="enter image description here" /></a></p>
  <p>The failing source:<a href="https://i.stack.imgur.com/yf7d7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yf7d7.png" alt="enter image description here" /></a></p>
  <p>My query to use the variable:
  <a href="https://i.stack.imgur.com/Af4yj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Af4yj.png" alt="enter image description here" /></a></p>
  <p>Finally the results:
  <a href="https://i.stack.imgur.com/GnNnJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GnNnJ.png" alt="enter image description here" /></a></p>
  <p>Any help is greatly appreciated!</p>