title: Spark SQL - declaring and using variables in SQl Notebook
body: <p>In Azure data bricks i created SQL note book. I am trying to use the variables and use that across multiple SQL statements. e.g. declare fiscal year and use that across where criteria. Intent is to avoid hardcoding. </p>
  
  <p>It looks i have to use Python / Scala. Is there any way to achieve this using pure SQL statements?</p>
  
  <p>e.g.:</p>
  
  <p>var @fiscalYear = 2018;</p>
  
  <p>select * from table where fiscalyear = @fiscalyear</p>